QUERY OPTIMIZATION

• US 20140074771A1
• Filed: 09/12/2012
• Published: 03/13/2014
• Est. Priority Date: 09/12/2012
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Petitclerc, Martin, He, Xiaowen, Luo, Lin
• Granted Patent: US 9,418,101 B2
• Time in Patent Office: Days
• US Class Current: 707/602
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

Provided are techniques for generating a relational query. Information is collected from a query specification and a model for an On-Line Analytical Processing (OLAP) query having at least a first expression and a second expression. The collected information is used to generate a relational query to retrieve report data to be used to satisfy the first expression and the second expression.

Claims

1. A method, comprising:

collecting information from a query specification and a model for an On-Line Analytical Processing (OLAP) query having at least a first expression and a second expression; and

using the collected information to generate a relational query to retrieve report data to be used to satisfy the first expression and the second expression.

2. The method of claim 1, wherein the model includes an OLAP model definition that defines an OLAP model, a relational model definition that defines a relational model, and a mapping between the OLAP model and the relational model.

3. The method of claim 1, further comprising:

executing the relational query to retrieve the report data from a relational database; and

storing the retrieved report data in an OLAP database.

4. The method of claim 3, further comprising:

in response to processing the second expression, using the stored, retrieved report data without accessing the relational database.

5. The method of claim 3, wherein the stored, retrieved report data is used to satisfy another OLAP query.

6. The method of claim 3, further comprising:

using the stored, retrieved report data to generate a report having a layout defined by a layout definition of a report specification.

7. The method of claim 1, wherein a Software as a Service (SaaS) is provided to perform the method.

8. A computer program product, the computer program product comprising:

a computer readable storage medium having computer readable program code embodied therewith, wherein, the computer readable program code, when executed by at least one processor of a computer, is configured to perform;

collecting information from a query specification and a model for an On-Line Analytical Processing (OLAP) query having at least a first expression and a second expression; and

using the collected information to generate a relational query to retrieve report data to be used to satisfy the first expression and the second expression.

9. The computer program product of claim 8, wherein the model includes an OLAP model definition that defines an OLAP model, a relational model definition that defines a relational model, and a mapping between the OLAP model and the relational model.

10. The computer program product of claim 8, wherein, the computer readable program code, when executed by the at least one processor of the computer, is configured to perform:

executing the relational query to retrieve the report data from a relational database; and

storing the retrieved report data in an OLAP database.

11. The computer program product of claim 10, wherein, the computer readable program code, when executed by the at least one processor of the computer, is configured to perform:

in response to processing the second expression, using the stored, retrieved report data without accessing the relational database.

12. The computer program product of claim 10, wherein the stored, retrieved report data is used to satisfy another OLAP query.

13. The computer program product of claim 10, wherein, the computer readable program code, when executed by the at least one processor of the computer, is configured to perform:

using the stored, retrieved report data to generate a report having a layout defined by a layout definition of a report specification.

14. The computer program product of claim 8, wherein a Software as a Service (SaaS) is configured to perform the computer program product operations.

15. A computer system for augmenting a relational query, comprising:

a processor; and

a storage device connected to the processor, wherein the storage device has stored thereon a program, and wherein the processor is configured to execute instructions of the program to perform operations, wherein the operations comprise;

collecting information from a query specification and a model for an On-Line Analytical Processing (OLAP) query having at least a first expression and a second expression; and

using the collected information to generate a relational query to retrieve report data to be used to satisfy the first expression and the second expression.

16. The computer system of claim 15, wherein the model includes an OLAP model definition that defines an OLAP model, a relational model definition that defines a relational model, and a mapping between the OLAP model and the relational model.

17. The computer system of claim 15, wherein the operations further comprise:

executing the relational query to retrieve the report data from a relational database; and

storing the retrieved report data in an OLAP database.

18. The computer system of claim 17, wherein the operations further comprise:

in response to processing the second expression, using the stored, retrieved report data without accessing the relational database.

19. The computer system of claim 17, wherein the stored, retrieved report data is used to satisfy another OLAP query.

20. The computer system of claim 17, wherein the operations further comprise:

using the stored, retrieved report data to generate a report having a layout defined by a layout definition of a report specification.

21. The computer system of claim 15, wherein a Software as a Service (SaaS) is provided to perform the system operations.