×

Query optimization

  • US 9,418,101 B2
  • Filed: 09/12/2012
  • Issued: 08/16/2016
  • Est. Priority Date: 09/12/2012
  • Status: Expired due to Fees
First Claim
Patent Images

1. A method, comprising:

  • generating an On-Line Analytical Processing (OLAP) query having a first expression for retrieving report data and other report data from an OLAP cache and a second expression for retrieving additional report data from the OLAP cache;

    executing the first expression to retrieve the report data that is stored in the OLAP cache to respond to the first expression;

    for the other report data that is not stored in the OLAP cache to respond to the first expression,identifying the other report data to be retrieved for the first expression and the additional report data to be retrieved for the second expression that is not stored in the OLAP cache by;

    identifying OLAP objects referenced in the first expression and the second expression;

    mapping the OLAP objects to relational database tables in a relational database using a mapping stored in an OLAP database; and

    grouping OLAP objects from the first expression and the second expression that are mapped to a same relational database table from the relational database tables;

    generating a relational query to retrieve the other report data to be used to respond to the first expression and the additional report data to be used to respond to the second expression from the relational database;

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

    storing the other report data in the OLAP cache;

    using the other report data stored in the OLAP cache to respond to the first expression; and

    pre-loading the additional report data in the OLAP cache in anticipation of execution of the second expression; and

    subsequently executing the second expression by retrieving the additional report data to be used to respond to the second expression from the OLAP cache instead of from the relational database.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×