CONVERTING A DATABASE QUERY TO A MULTI-DIMENSIONAL EXPRESSION QUERY

• US 20100121868A1
• Filed: 11/07/2008
• Published: 05/13/2010
• Est. Priority Date: 11/07/2008
• Status: Abandoned Application

• Current Assignee: SAP France SA (SAP SE)
• Original Assignee: SAP France SA (SAP SE)
• Inventors: Gouthiere, Eric, Biannic, Yann Le
• Application Number:
  US12/266,570
• Publication Number:
  US 20100121868A1
• Time in Patent Office: Days
• US Class Current: 707/759
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: G06F 16/90324 using system suggestions

Abstract

Disclosed is a method and system for receiving a query in a first format, parsing the query to determine a result object, a data source and a filter condition in the query. The filter condition is converted to a normalized filter condition by analyzing a semantic context of one or more member sets in the filter condition, converting the one or more member sets into a normal form and replacing logical operators between the one or more member sets with normalized operators. The normalized filter condition along with the result object and the data source is then translated to a multi-dimensional database query in a second format.

Claims

1. An article of manufacture, comprising:

a machine readable medium having instructions which when executed by a machine cause the machine to perform operations comprising;

receiving a normalized query;

parsing the normalized query to determine a result object, a data source, and a normalized filter condition;

translating the result object to a first part of a multi-dimensional expression query;

translating the normalized filter condition to a second part of the multi-dimensional expression query by translating the normalized operators and predicates in the normalized filter condition based on multi-dimensional expression translation rules;

translating the data source to a third part of the multi-dimensional expression query; and

merging the first part, the second part and the third part to form the multi-dimensional expression query.

2. The article of manufacture in claim 1, wherein translating the result object, the normalized filter condition and the data source to the multi-dimensional expression query comprises translating to a multi-dimensional expression query language selected from a group consisting of Analysis Services 2000, Analysis Services 2005, Cubing Services, Netweaver BI 7 and MaxL.

3. The article of manufacture in claim 1, wherein the result object and the data source object are expressed in a query language selected from a group consisting of:

structured query language, another declarative query languages, and query created in a declarative way using a user interface.

4. The article of manufacture in claim 1, wherein a structure of the normalized filter condition is defined by a normalization graph.

5. The article of manufacture in claim 1, wherein the normalized filter condition comprises a filter condition of a database query in a disjunctive normal form.

6. The article of manufacture in claim 1, wherein translating the result object to a multi-dimensional expression query comprises converting the result object to a query axis in SELECT clause of the multi-dimensional expression query.

7. The article of manufacture in claim 1, wherein converting the normalized filter condition to the multi-dimensional expression query comprises converting the normalized filter condition to a slicer axis in the multi-dimensional expression query.

8. The article of manufacture in claim 1, wherein the multi-dimensional expression translation rules for converting the normalized filter condition to the multi-dimensional expression query comprises a rule selected from a group consisting of:

translating a CAND operator in the normalized filter condition to CROSSJOIN operator in the multi-dimensional expression query;

translating an IAND operator in the normalized filter condition to INTERSECT operator in the multi-dimensional expression query; and

translating an AND operator in the normalized filter condition to INTERSECT operator in the multi-dimensional expression query.

9. The article of manufacture in claim 1, wherein the multi-dimensional expression translation rules for converting the normalized filter condition to the multi-dimensional expression query comprises selected from a group consisting of:

translating an OR operator in the normalized filter condition to UNION operator in the multi-dimensional expression query; and

translating an UOR operator in the normalized filter condition to FROM SELECT UNION operator in the multi-dimensional expression query.

10. The article of manufacture in claim 1, wherein the multi-dimensional expression translation rules for converting the normalized filter condition to the multi-dimensional expression query comprises translating an AGGREGATIONFILTER operator in the normalized filter condition to FILTER operator in the multi-dimensional expression query.

11. A computer implemented method for translating a normalized query to a multi-dimensional database query, the method comprising:

receiving a normalized query;

parsing the normalized query to determine a result object, a data source, and a normalized filter condition in the normalized query;

translating the result object to a first part of a multi-dimensional expression query;

translating the normalized filter condition to a second part of the multi-dimensional expression query by translating the normalized operators and predicates in the normalized filter condition based on multi-dimensional expression translation rules;

translating the data source to a third part of the multi-dimensional expression query; and

merging the first part, the second part and the third part to form the multi-dimensional expression query.

12. The computer implemented method in claim 11, wherein the normalized filter condition comprises a filter condition in a disjunctive normal form.

13. The computer implemented method in claim 11, wherein the multi-dimensional expression translation rules for translating the normalized filter condition to the multi-dimensional expression query comprises selected from a group consisting of:

translating a CAND operator in the normalized filter condition to CROSSJOIN operator in the multi-dimensional expression specification;

translating an IAND operator in the normalized filter condition to INTERSECT operator in the multi-dimensional expression specification;

translating an AND operator in the normalized filter condition to INTERSECT operator in the multi-dimensional expression specification;

translating an OR operator in the normalized filter condition to UNION operator in the multi-dimensional expression specification; and

translating an UOR operator in the normalized filter condition to FROM SELECT UNION operator in the multi-dimensional expression specification.

14. The computer implemented method in claim 11, wherein a structure of the normalized filter condition is defined by a normalization graph.

15. The computer implemented method in claim 11, wherein the multi-dimensional expression translation rules for translating the normalized filter condition to the multi-dimensional expression query comprises translating an AGGREGATIONFILTER operator in the normalized filter condition to FILTER operator in the multi-dimensional expression specification.

16. The computer implemented method in claim 11, wherein translating the result object, the normalized filter condition and the data source to a multi-dimensional expression query comprises translating to a multi-dimensional expression query language selected from a group consisting of Analysis Service 2000, Analysis Service 2005, and MaxL.

17. A computer system including a processor and a memory, the memory comprising instructions that are executable by the processor, the instructions comprising:

a parser to retrieve a result object, and a data source from a query;

a multi-dimensional expression engine in communication with the parser to convert the result object, the data source and a normalized filter condition of the query to an intermediate multi-dimensional expression query based on the multi-dimensional expression rules; and

a translator in communication with the multi-dimensional expression engine to translate the intermediate multi-dimensional expression query to a multi-dimensional expression query based on syntax of a multi-dimensional expression query language.

18. The system in claim 17 further comprising a syntax file that provides syntax of a multi-dimensional query language to the translator.

19. The system in claim 17 further comprising a pattern matching tool in communication with the multi-dimensional expression engine to convert the result object, the data source and predicates in the normalized filter condition to a translation ready result object, translation ready data source and translation ready predicates that form a part of the intermediate multi-dimensional expression query.

20. The system in claim 17 further comprising a normalization engine in communication with a pattern matching tool to provide the normalized filter condition of the query.