System and method for analytically modeling data organized according to related attributes

• US 7,287,022 B2
• Filed: 07/19/2002
• Issued: 10/23/2007
• Est. Priority Date: 07/19/2002
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Pasumansky, Mosha, Sanders, Paul J., Petculescu, Cristian, Tkachuk, Richard R., Berger, Alexander, Netz, Amir
• Primary Examiner(s): Breene; John
• Assistant Examiner(s): To; Baoquoc N.
• Application Number:
  US10/199,913
• Publication Number:
  US 20040015507A1
• Time in Patent Office: 1,922 Days
• Field of Search: 707/3, 707/10, 707/1, 707/100, 707/103.Y
• US Class Current: 707/600
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/957 Multidimensional
• CPC Class Codes: Y10S 707/958 Data cubes
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure

Abstract

A system and method for analytically modeling data with related attributes is disclosed. A single dimension is used to provide data according to each of the related attributes, and, thus, may be said to play the role of each related attribute depending on a received query. The measure of the analytical data model is tied to the dimension according to both data attributes to allow the measure to be analyzed by the dimension according to both attributes.

Claims

1. A computer readable medium having stored thereon computer-executable instructions for performing steps comprising:

generating a data cube that comprises at least three dimensions, one of the three dimensions being a first dimension that represents both a first data attribute and a second data attribute, the first data attribute not being a sub-set of the second data attribute;

receiving a first query that requests a first portion of data within the data cube, the first query requesting data according to the first attribute, the first query not requesting data according to the second attribute;

responsive to receiving the first query;

configuring the data inside the data cube to adapt to the first query such that the first dimension provides data according to the first attribute and not the second attribute;

processing the first query by retrieving data from the data cube; and

displaying results of the first query to a user;

receiving a second query that requests a second portion of data within the data cube, the second query requesting data according to the second attribute, the second query not requesting data according to the first attribute;

responsive to receiving the second query;

reconfiguring the data inside the data cube to adapt to the second query such that the first dimension provides data according to the second attribute and not the first attribute;

processing the second query using the data cube; and

displaying results of the second query to a user.

2. The computer readable medium of claim 1 having further computer-executable instructions for performing the step of:

retrieving data from a relational database with which to generate the data cube.

3. The computer readable medium of claim 1, wherein the data cube is formatted for online analytical processing.

4. A method for query processing using a data cube with a first dimension that represents multiple attributes, the method comprising:

generating the data cube that comprises at least three dimensions, one of the three dimensions being the first dimension that represents both a first data attribute and a second data attribute, the first data attribute not being a sub-set of the second data attribute;

receiving a first query that requests a first portion of data within the data cube, the first query requesting data according to the first attribute, the first query not requesting data according to the second attribute;

responsive to receiving the first query;

configuring the data inside the data cube to adapt to the first query such that the first dimension provides data according to the first attribute and not the second attribute;

processing the first query by retrieving data from the data cube and

displaying results of the first query to a user;

receiving a second query that requests a second portion of data within the data cube, the second query requesting data according to the second attribute, the second query not requesting data according to the first attribute;

responsive to receiving the second query;

reconfiguring the data inside the data cube to adapt to the second query such that the first dimension provides data according to the second attribute and not the first attribute;

processing the second query using the data cube; and

displaying results of the second query to a user.

5. The method of claim 4, further comprising:

retrieving data from a relational database with which to generate the data cube.

6. The method of claim 4, comprising generating the data cube formatted for online analytical processing.

7. A system for query processing using a data cube with a first dimension that represents multiple attributes, the system comprising:

a processor operative to execute computer-executable instructions; and

memory having stored therein computer-executable instructions for performing steps comprising;

generating the data cube that comprises at least three dimensions, one of the three dimensions being the first dimension that represents both a first data attribute and a second data attribute, the first data attribute not being a sub-set of the second data attribute;

receiving a first query that requests a first portion of data within the data cube, the first query requesting data according to the first attribute, the first query not requesting data according to the second attribute;

responsive to receiving the first query;

configuring the data inside the data cube to adapt to the first query such that the first dimension provides data according to the first attribute and not the second attribute;

processing the first query by retrieving data from the data cube; and

displaying results of the first query to a user;

receiving a second query that requests a second portion of data within the data cube, the second query requesting data according to the second attribute, the second query not requesting data according to the first attribute;

responsive to receiving the second query;

reconfiguring the data inside the data cube to adapt to the second query such that the first dimension provides data according to the second attribute and not the first attribute;

processing the second query using the data cube; and

displaying results of the second query to a user.

8. The system of claim 7, wherein the data cube is generated by retrieving data from a relational database.

9. The system of claim 7, wherein the data cube is formatted for online analytical processing.