Query language based on business object model

• US 9,171,039 B2
• Filed: 09/29/2011
• Issued: 10/27/2015
• Est. Priority Date: 09/29/2011
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Teichmann, Jan, Gauweiler, Thomas, Hutzel, Daniel, Klein, Udo, Hermanns, Marcel, Weiler, Jens, Giebel, Dirk, Goldmann, Daniel, Brunswig, Frank, Steffen, Heiko, Tatzel, Steffen, Fitzer, Joachim
• Primary Examiner(s): KUDDUS, DANIEL A
• Application Number:
  US13/249,229
• Publication Number:
  US 20130086097A1
• Time in Patent Office: 1,489 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/24534 Query rewriting; Transformation

Abstract

Methods and apparatus, including computer program products, are provided for providing a query language based on a model. In one aspect, there is provided a computer-implemented method. The method may include receiving a first query; generating, based on a model including metadata representing a data structure, a second query specific to the data structure stored in a database; and sending the second query to the database. Related apparatus, systems, methods, and articles are also described.

Claims

1. A non-transitory computer-readable storage medium containing instructions to configure a processor to perform operations comprising:

receiving a first query;

generating, based on a model including metadata representing a data structure, a second query specific to the data structure stored in a database, the second query being a single direct query to the database and defining all nodes and associations, including a root node, nodes dependent on the root node, and associations between all nodes, needed to traverse at least one business object and nodes stored in the database to generate a result set without buffering of intermediate results; and

sending the second query to the database; and

executing the second query page by page basis at runtime based on a page being displayed on a user interface used for executing the second query and using data transported from the database and associated only with the page being displayed on the user interface, the data associated with the displayed page is searched in and obtained from data stored in the database, and by searching an unrestricted amount of data at the database at constant seek time as a prerequisite of paging.

2. The non-transitory computer-readable medium of claim 1, wherein the first query is configured in accordance with SQL and received from a user interface.

3. The non-transitory computer-readable medium of claim 1, wherein the generating further comprises:

accessing the metadata representing the data structure comprising at least one business object.

4. The non-transitory computer-readable medium of claim 1, wherein the generating further comprises:

generating the second query to include information to access at least one business object including at least one node and at least one association.

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

generating the second query in accordance with SQL.

6. The non-transitory computer-readable medium of claim 1, wherein the sending further comprises:

sending the second query to the database comprising a relational database implemented in memory database.

7. The non-transitory computer-readable medium of claim 1, wherein the sending further comprises:

sending the second query to the database comprising a relational database implemented as a column database.

8. A method comprising:

receiving, at a query generator, a first query;

generating, at the query generator, a second query specific to the data structure stored in a database, wherein the second query is generated based on a model including metadata representing a data structure, the second query being a single direct query to the database and defining all nodes and associations, including a root node, nodes dependent on the root node, and associations between all nodes, needed to traverse at least one business object and nodes stored in the database to generate a result set without buffering of intermediate results;

sending, from the query generator, the second query to the database; and

executing the second query page by page basis at runtime based on a page being displayed on a user interface used for executing the second query and using data transported from the database and associated only with the page being displayed on the user interface, the data associated with the displayed page is searched in and obtained from data stored in the database, and by searching an unrestricted amount of data at the database at constant seek time as a prerequisite of paging.

9. The method of claim 8, wherein the first query is configured in accordance with SQL and received from a user interface.

10. The method of claim 8, wherein the generating further comprises:

accessing the metadata representing the data structure comprising at least one business object.

11. The method of claim 8, wherein the generating further comprises:

generating the second query to include information to access at least one business object including at least one node and at least one association.

12. The method of claim 8, wherein the generating further comprises:

generating the second query in accordance with SQL.

13. The method of claim 8, wherein the sending further comprises:

sending the second query to the database comprising a relational database implemented in memory database.

14. The method of claim 8, wherein the sending further comprises:

sending the second query to the database comprising a relational database implemented as a column database.

15. A system comprising:

at least one processor; and

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

receiving a first query;

generating a second query specific to the data structure stored in a database, wherein the second query is generated based on a model including metadata representing a data structure, the second query being a single direct query to the database and defining all nodes and associations, including a root node, nodes dependent on the root node, and associations between all nodes, needed to traverse at least one business object and nodes stored in the database to generate a result set without buffering of intermediate results;

sending the second query to the database; and

executing the second query page by page basis at runtime based on a page being displayed on a user interface used for executing the second query and using data transported from the database and associated only with the page being displayed on the user interface, the data associated with the displayed page is searched in and obtained from data stored in the database, and by searching an unrestricted amount of data at the database at constant seek time as a prerequisite of paging.