System and method for analytically modeling data organized according to related attributes
View Patent ↗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.
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.