Executing user-defined function on a plurality of database tuples
A method for executing a user-defined function on a plurality of input database tuples. The method may include causing a processor to invoke the function once; and to compute results of the function for the plurality of database tuples.
1. A method for executing a user-defined function, the method comprising:
getting a single instance of run-length encoded data that represents multiple identical database tuples by indicating a particular tuple and a number of occurrences of that particular tuple;
invoking the user-defined function once for the multiple identical database tuples; and
computing results of the user-defined function for all of the multiple database tuples by:
computing a single output value using the particular tuple; and
annotating the single output value with the number of occurrences.
2. The method of claim 1 , wherein the user-defined function is a scalar function.
3. The method of claim 1 , wherein the user-defined function is a transform function.
4. The method of claim 1 , wherein the single instance of run-length encoded data is compressed, and wherein the results of the user-defined function are computed without decompressing the single instance of run-length encoded data.
5. A non-transitory computer readable medium having stored thereon instructions for executing a user-defined function, which when executed by a processor cause the processor to:
get a single instance of run-length encoded data that represents multiple identical database tuples by indicating a particular tuple and a number of occurrences of that particular tuple;
invoke the user-defined function once for the multiple identical database tuples; and
compute results of the user-defined function for all of the multiple database tuples by:
computing a single output value using the particular tuple; and
annotating the single output value with the number of occurrences.
6. The non-transitory computer readable medium of claim 5 , wherein the user-defined function is a scalar function.
7. The non-transitory computer readable medium of claim 5 , wherein the user-defined function is a transform function.
8. The non-transitory computer readable medium of claim 5 , wherein the single instance of run-length encoded data is compressed, and wherein the results of the user-defined function are computed without decompressing the single instance of run-length encoded data.
9. A system comprising:
a storage device that includes a database that stores run-length encoded data that represents multiple identical database tuples by indicating a particular tuple and a number of occurrences of that particular tuple;
a processor configurable to execute a user-defined function by:
getting a single instance of the run-length encoded data;
invoking the user-defined function once for the multiple identical database tuples; and
computing results of the user-defined function for all of the multiple database tuples by:
computing a single output value using the particular tuple; and
annotating the single output value with the number of occurrences.
10. The system of claim 9 , wherein the single instance of run-length encoded data is compressed, and wherein the results of the user-defined function are computed without decompressing the single instance of run-length encoded data.