Generic node including stored script

• US 9,026,525 B2
• Filed: 12/27/2010
• Issued: 05/05/2015
• Est. Priority Date: 12/27/2010
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Harren, Arne, Elfner, Tobias, Forstmann, Gerd, Kabala, Maciej, Binnig, Carsten, Kain, Stefan, Faerber, Franz, Westmann, Till
• Primary Examiner(s): Perveen, Rehana
• Assistant Examiner(s): Khong, Alexander
• Application Number:
  US12/979,182
• Publication Number:
  US 20120166422A1
• Time in Patent Office: 1,590 Days
• Field of Search: 707/718, 717/106
• US Class Current: 707/718
• CPC Class Codes: G06F 16/24542 Plan optimisation

Abstract

Methods and apparatus, including computer program products, are provided for providing for processing calculation plans. In one aspect, there is provided a computer-implemented method. The method may include generating a calculation plan including a plurality of nodes; determining whether at least one of the nodes includes a function node; and compiling the function node into executable code to enable execution of the plurality of nodes including the function node at the database. Related apparatus, systems, methods, and articles are also described.

Claims

1. A non-transitory computer-readable medium containing instructions to configure a processor to perform a method, the method comprising:

generating a calculation plan including a plurality of nodes;

determining whether at least one of the nodes includes a function node, the function node including at least one complex function for performing at least one calculation to access data stored in a table in a database based on a metadata contained in a common metadata catalog, the metadata determining whether a row store of the database is to be accessed or a column store of the database is to be accessed during execution of the at least one complex function; and

compiling the function node into an intermediate code representative of a virtual machine language, wherein the intermediate code is compiled into an executable code or a runtime object to enable execution of the plurality of nodes including the function node at the database and executed at the database, the function node performs the at least one complex function of the calculation plan inside the function node at the database without transferring data from the database to a client application querying the database, wherein the runtime object is cached for a subsequent reuse;

wherein a row store database engine is used to access the data stored in the row store and a column store database engine is used to access the data stored in the column store.

2. The non-transitory computer-readable medium of claim 1, wherein the calculation plan defines a process for accessing a relational database system including the row store and the column store.

3. The non-transitory computer-readable medium of claim 1, wherein the function node implements a function using at least one of a code and a script.

4. The non-transitory computer-readable medium of claim 1, wherein the execution of the plurality of nodes including the function node occurs at the database rather than at the client application querying the database.

5. The non-transitory computer-readable medium of claim 1, wherein compiling further comprises:

compiling at least one of a script and a code of the function node into another code executable at the database during execution of the calculation plan.

6. The non-transitory computer-readable medium of claim 5, wherein compiling further comprises:

compiling the at least one of the script and the code into at least one of a bytecode and a machine code.

7. A computer-implemented method comprising:

generating a calculation plan including a plurality of nodes;

determining whether at least one of the nodes includes a function node, the function node including at least one complex function for performing at least one calculation to access data stored in a table in a database based on a metadata contained in a common metadata catalog, the metadata determining whether a row store of the database is to be accessed or a column store of the database is to be accessed during execution of the at least one complex function; and

compiling the function node into an intermediate code representative of a virtual machine language, wherein the intermediate code is compiled into an executable code or a runtime object to enable execution of the plurality of nodes including the function node at the database and executed at the database, the function node performs the at least one complex function of the calculation plan inside the function node at the database without transferring data from the database to a client application querying the database, wherein the runtime object is cached for a subsequent reuse;

wherein a row store database engine is used to access the data stored in the row store and a column store database engine is used to access the data stored in the column store.

8. The computer-implemented method of claim 7, wherein the calculation plan defines a process for accessing a relational database system including the row store and the column store.

9. The computer-implemented method of claim 7, wherein the function node implements a function using at least one of a code and a script.

10. The computer-implemented method of claim 7, wherein the execution of the plurality of nodes including the function node occurs at the database rather than at the client application querying the database.

11. The computer-implemented method of claim 7, wherein compiling further comprises:

compiling at least one of a script and a code of the function node into another code executable at the database during execution of the calculation plan.

12. The computer-implemented method of claim 11, wherein compiling further comprises:

compiling the at least one of the script and the code into at least one of a bytecode and a machine code.

13. A system comprising:

at least one processor; and

at least one memory, wherein the at least one processor and the at least one memory provide operations comprising;

generating a calculation plan including a plurality of nodes;

determining whether at least one of the nodes includes a function node, the function node including at least one complex function for performing at least one calculation to access data stored in a table in a database based on a metadata contained in a common metadata catalog, the metadata determining whether a row store of the database is to be accessed or a column store of the database is to be accessed during execution of the at least one complex function; and

compiling the function node into an intermediate code representative of a virtual machine language, wherein the intermediate code is compiled into an executable code or a runtime object to enable execution of the plurality of nodes including the function node at the database and executed at the database, the function node performs the at least one complex function of the calculation plan inside the function node at the database without transferring data from the database to a client application querying the database, wherein the runtime object is cached for a subsequent reuse;

wherein a row store database engine is used to access the data stored in the row store and a column store database engine is used to access the data stored in the column store.

14. The system of claim 13, wherein the calculation plan defines a process for accessing a relational database system including the row store and the column store.

15. The system of claim 13, wherein the function node implements a function using at least one of a code and a script.

16. The system of claim 13, wherein the execution of the plurality of nodes including the function node occurs at the database rather than at the client application querying the database.

17. The system of claim 13, wherein compiling further comprises:

compiling at least one of a script and a code of the function node into another code executable at the database during execution of the calculation plan.

18. The system of claim 17, wherein compiling further comprises:

compiling the at least one of the script and the code into at least one of a bytecode and a machine code.