SYSTEM AND METHOD FOR TRANSLATING AND EXECUTING QUERIES

• US 20090012948A1
• Filed: 06/08/2007
• Published: 01/08/2009
• Est. Priority Date: 06/08/2007
• Status: Abandoned Application

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Koch, Wolfgang, Liebich, Gunther, Wildhagen, Andreas, Karstens, Jan, Brendle, Rainer
• Application Number:
  US11/760,483
• Publication Number:
  US 20090012948A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2452 Query translation
• CPC Class Codes: G06F 16/289 Object oriented databases

Abstract

Methods and systems for converting standardized, structured queries into native business object queries are provided. The structured queries may be defined in a business object-specific structured query language (BQL). A BQL engine can translate the structured query into a query suited for use by the appropriate business object. In an embodiment, the BQL engine and the related query language provide the primary interface to backend applications and business objects. Embodiments may include a search infrastructure to create indexed views of business objects and a local client proxy to handle requests not handled by indexed views.

Claims

1. A method for executing a query in a business system, comprising:

receiving a first query specifying a business object, a node in the business object, and an operation to be performed with the business object, the first query defined in a structured query language;

extracting identifiers corresponding to the business object, the node, and the operation from the first query;

translating the extracted information into a second query, the second query defined in a native query format of the business object;

sending the second query to a backend application storing the business object;

receiving a query result from the backend application; and

presenting the query result from the backend operation.

2. The method of claim 1, wherein the first query comprises a projection clause, a from clause, and a where clause.

3. The method of claim 2, wherein the from clause specifies a business object node.

4. The method of claim 1, wherein the query result is presented in a flat result structure.

5. The method of claim 1, wherein the query result is presented in a structured result structure.

6. The method of claim 1, wherein the backend application is accessed via a client proxy.

7. The method of claim 1, wherein the first query comprises a restrictive condition to limit the business object nodes affected by the operation.

8. A method for executing a query in a business system comprising:

receiving a first query specifying a business object, a node in the business object, and an operation to be performed with the business object, the first query defined in a structured query language;

extracting the business object, the node, and the operation from the first query;

querying a search infrastructure to determine if an indexed view of data requested by the first query exists;

if an indexed view exists;

sending the first query to the search infrastructure; and

receiving a query result from the search infrastructure;

if no indexed view exists;

translating the extracted information into a second query, the second query defined in a native query language of the business object; and

sending the second query to a backend application storing the business object;

receiving a query result from the backend application; and

presenting the query result from the backend operation.

9. The method of claim 8 wherein, if no indexed view exists, the second query is sent to the backend application using a local client proxy.

10. The method of claim 8 wherein the first query comprises a restrictive condition to limit the business object nodes affected by the operation.

11. A method of accessing data from a backend application, comprising:

constructing a structured query referencing at least one business object, each business object having a plurality of nodes, the structured query specifying a restriction on at least one of the plurality of nodes;

using a portal interface, sending the structured query to a business system having a backend application storing the referenced business object; and

receiving a query result from the business system, the query result containing data corresponding to nodes filtered by the restriction.

12. The method of claim 11, wherein the query result contains data corresponding to nodes from multiple business objects.

13. The method of claim 11, wherein the query result is a structured result set.

14. The method of claim 11, wherein the query result is a flat result set.

15. An apparatus comprising:

an input to receive a structured query;

a parsing engine to extract a business object operation referenced by the structured query;

a decider module to determine whether an indexed view of data requested by the structured query exists;

a native query engine to construct a new query in a language native to the backend application; and

an output to send the new query to the backend application.

16. The apparatus of claim 15, comprising a fast search infrastructure to index data stored in the backend application and provide indexed views of the data to at least one of the parsing engine and the decider module.

17. The apparatus of claim 16, comprising a local client proxy to execute queries referencing a business object not indexed by the search infrastructure.

18. The apparatus of claim 15, wherein the structured query comprises a projection clause, a from clause, and a where clause.

19. The apparatus of claim 15, wherein the input is in communication with a client application displayed in a portal user interface, the client application to create the structured query.