×

Translating a relational query to a multidimensional query

  • US 8,606,803 B2
  • Filed: 04/01/2008
  • Issued: 12/10/2013
  • Est. Priority Date: 04/01/2008
  • Status: Active Grant
First Claim
Patent Images

1. A method for translating a relational database query into a multidimensional expression language (MDX) database query comprising:

  • parsing a relational database query into one or more relational database query tokens;

    filtering zero or more of the one or more relational database query tokens based at least in part on business logic to create a set of filtered relational database query tokens, the filtering comprising;

    removing a relational database query token, from the one or more relational database query tokens, responsive to determining that the relational database query token corresponds to a field not supported by a multidimensional database and is associated with a return of a dataset that exceeds a threshold;

    identifying relevant metadata, from a metadata store, associated with metadata associated with the set of filtered relational database query tokens, the relevant metadata comprising current multidimensional metadata and trend related multidimensional metadata;

    translating at least some relational database query tokens of the set of filtered relational database query tokens into one or more work item query language (WIQL) tokens;

    retrieving a first group of one or more MDX tokens based at least in part on the relevant metadata;

    retrieving a second group of one or more MDX tokens based at least in part on the one or more WIQL tokens;

    arranging at least some of the one or more MDX tokens of the first group and at least some of the one or more MDX tokens of the second group based at least in part on the metadata associated with the set of filtered relational database query tokens; and

    generating one or more MDX database queries for trend related information and current information based at least in part on at least some of the arranged MDX tokens, at least some of the parsing, the filtering, the identifying, the translating, the retrieving a first group, the retrieving a second group, the arranging, and the generating implemented at least in part via a processing unit.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×