QUERY LANGUAGE BASED ON BUSINESS OBJECT MODEL

• US 20130086097A1
• Filed: 09/29/2011
• Published: 04/04/2013
• Est. Priority Date: 09/29/2011
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: Jens Weiler
• Inventors: Teichmann, Jan, Gauweiler, Thomas, Hutzel, Daniel, Klein, Udo, Hermanns, Marcel, Weiler, Jens, Giebel, Dirk, Brunswig, Frank, Steffen, Heiko, Tatzel, Steffen, Fitzer, Joachim, Goldman, Daniel
• Granted Patent: US 9,171,039 B2
• Time in Patent Office: Days
• US Class Current: 707/759
• 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 computer-readable storage medium containing instructions to configure a processor to perform a 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; and

sending the second query to the database.

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

3. The 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 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 computer-readable medium of claim 1, wherein the generating further comprises:

generating the second query to include information to traverse a plurality of business object including nodes and associations without buffering intermediate results.

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

generating the second query in accordance with SQL.

7. The 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.

8. The 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.

9. 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; and

sending, from the query generator, the second query to the database.

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

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

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

12. The method of claim 9, 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.

13. The method of claim 9, wherein the generating further comprises:

generating the second query to include information to traverse a plurality of business object including nodes and associations without buffering intermediate results.

14. The method of claim 9, wherein the generating further comprises:

generating the second query in accordance with SQL.

15. The method of claim 9, wherein the sending further comprises:

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

16. The method of claim 9, wherein the sending further comprises:

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

17. 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; and

sending the second query to the database.