PERFORMING COMPLEX OPERATIONS IN A DATABASE USING A SEMANTIC LAYER
First Claim
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 Assignments
0 Petitions
Accused Products
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.
-
Citations
20 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. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
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. - View Dependent Claims (11, 12, 13, 14, 15)
-
-
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. - View Dependent Claims (17, 18, 19, 20)
-
Specification