×

System, method, and data structure for automatically generating database queries which are data model independent and cardinality independent

  • US 9,135,296 B2
  • Filed: 07/29/2014
  • Issued: 09/15/2015
  • Est. Priority Date: 05/15/2012
  • Status: Active Grant
First Claim
Patent Images

1. A system, comprising:

  • a processor configured to perform operations that includereceiving an identification of data item components and an identification of associations between the data item components, wherein the data item components include measures and a category, and wherein the identified associations include at least two different associations from the associations comprising an indication that one measure is independent of other measures, an indication that one measure is dependent on another measure, and an indication that two or more measures are correlated;

    creating a database query for retrieving data item components, wherein the database query includes a first Uquery, wherein the first Uquery includes a Mx segment subquery and a U0 segment subquery, wherein the Mx segment subquery is operable to gather measures and is associated with an Mx segment table that contains the measures included in the data item components, columns for a calculated measure, or correlated measures, and wherein the U0 segment subquery is associated with a table that contains the category, a table that contains columns for a calculated category, a dependent measure table, or a dependent filter table, and wherein the U0 segment subquery further facilitates selecting a set of categories and join keys, the join keys of the set including join keys that join directly to the Mx segment subquery;

    executing each Mx segment subquery to generate Mx segment subquery results;

    executing each U0 segment subquery to generate U0 segment subquery results;

    joining Mx segment subquery results from each Uquery with the U0 segment subquery results from the same Uquery to generate Uquery results;

    generating a virtual results table by aggregating the Uquery results from one Uquery with Uquery results from another Uquery; and

    reporting the virtual results table.

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