PERFORMING COMPLEX OPERATIONS IN A DATABASE USING A SEMANTIC LAYER

• US 20120005190A1
• Filed: 12/27/2010
• Published: 01/05/2012
• Est. Priority Date: 05/14/2010
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Faerber, Franz, Baeumges, Daniel, Mindnich, Tobias, Weyerhaeuser, Christoph
• Granted Patent: US 8,954,418 B2
• Time in Patent Office: Days
• US Class Current: 707/718
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof
• CPC Class Codes: G06F 16/2433 Query languages
• CPC Class Codes: G06F 16/24524 Access plan code generation and invalidation; Reuse of access plans
• CPC Class Codes: G06F 16/24542 Plan optimisation
• CPC Class Codes: G06F 16/24547 Optimisations to support specific applications; Extensibility of optimisers

Abstract

The present invention includes a database with a semantic layer for performing standard SQL and complex operations custom to one or more application. In one embodiment the present invention includes receiving a data request from an application in a database, the data request specifying standard SQL operations and custom application operations to be performed for said application. The data request is processed in a semantic layer of the database. The semantic layer processes the standard SQL operations and the custom application operations and generates a logical execution plan comprising the standard SQL operations and the custom application operations. The logical execution plan is converted into a physical execution plan, which is executed by the database to generate a data result. The data result may be sent back to the application.

Claims

1. A computer-implemented method comprising:

receiving a data request from an application in a database executing on a computer system, the data request specifying standard SQL operations and custom application operations to be performed for said application;

processing, on the computer system, the data request in a semantic layer of the database, the semantic layer processing the standard SQL operations and the custom application operations, and wherein, in response to receiving the data request, the semantic layer generates a logical execution plan comprising said standard SQL operations and said custom application operations;

converting, on the computer system, the logical execution plan into a physical execution plan, wherein the physical execution plan comprises native executable database operations for performing the standard SQL operations and custom application operations;

executing the physical execution plan on the database, and in accordance therewith, generating a data result; and

sending the data result from the database to the application.

2. The method of claim 1 further comprising:

receiving, in the data request, a script specifying the custom application operations;

parsing the request; and

incorporating the custom application operations from the script into the logical execution plan.

3. The method of claim 2 wherein the script is incorporated into an acyclic graphical model comprising a plurality of nodes, each node representing an operation, wherein one or more nodes represent said custom application operations.

4. The method of claim 1 wherein the data request specifies a custom application planning operation.

5. The method of claim 4 wherein the planning operation is a disaggregation operation.

6. The method of claim 1 wherein the data request specifies a custom application MDX operation.

7. The method of claim 1 wherein the custom application operations are specified in a procedural programming language.

8. The method of claim 7 wherein the procedural programming language accesses prestored objects in the database to perform one or more data operations.

9. The method of claim 1 wherein the data request specifies a custom application statistical operation.

10. A non-transitory computer readable storage medium embodying a computer program for performing a method, said method comprising:

receiving a data request from an application in a database executing on a computer system, the data request specifying standard SQL operations and custom application operations to be performed for said application;

processing, on the computer system, the data request in a semantic layer of the database, the semantic layer processing the standard SQL operations and the custom application operations, and wherein, in response to receiving the data request, the semantic layer generates a logical execution plan comprising said standard SQL operations and said custom application operations;

converting, on the computer system, the logical execution plan into a physical execution plan, wherein the physical execution plan comprises native executable database operations for performing the standard SQL operations and custom application operations;

executing the physical execution plan on the database, and in accordance therewith, generating a data result; and

sending the data result from the database to the application.

11. The non-transitory computer readable storage medium of claim 10 further comprising:

receiving, in the data request, a script specifying the custom application operations;

parsing the request; and

incorporating the custom application operations from the script into the logical execution plan.

12. The non-transitory computer readable storage medium of claim 11 wherein the script is incorporated into an acyclic graphical model comprising a plurality of nodes, each node representing an operation, wherein one or more nodes represent said custom application operations.

13. The non-transitory computer readable storage medium of claim 10 wherein the data request specifies a custom application planning operation.

14. The non-transitory computer readable storage medium of claim 10 wherein the data request specifies a custom application MDX operation.

15. The non-transitory computer readable storage medium of claim 10 wherein the custom application operations are specified in a procedural programming language.

16. A system comprising:

one or more processors;

memory; and

one or more executable software components, executable by said processors to;

receive a data request from an application in a database executing on a computer system, the data request specifying standard SQL operations and custom application operations to be performed for said application;

process the data request in a semantic layer of the database, the semantic layer processing the standard SQL operations and the custom application operations, and wherein, in response to receiving the data request, the semantic layer generates a logical execution plan comprising said standard SQL operations and said custom application operations;

convert the logical execution plan into a physical execution plan, wherein the physical execution plan comprises native executable database operations for performing the standard SQL operations and custom application operations;

execute the physical execution plan on the database, and in accordance therewith, generating a data result; and

send the data result from the database to the application.

17. The system of claim 16 wherein the executable software components are further executable by said processors to:

receive, in the data request, a script specifying the custom application operations;

parse the request;

incorporate the custom application operations from the script into an acyclic graphical model comprising a plurality of nodes, each node representing an operation, wherein one or more nodes represent said custom application operations; and

incorporate the custom application operations from the script into the logical execution plan.

18. The system of claim 16 wherein the data request specifies a custom application planning operation.

19. The system of claim 16 wherein the data request specifies a custom application MDX operation.

20. The system of claim 16 wherein the custom application operations are specified in a procedural programming language.