Data domains in multidimensional databases
Systems and method for creating multidimensional data cubes containing data domains for analyzing large amounts of data are provided. Data domains may be included in the major object of a multidimensional data cube. Further embodiments of the present invention provide methods for querying multidimensional data cubes having data domains. Embodiments of the present invention provide for defining data domains by any object in the major object model and for defining parent and child data domains.
1. One or more computer-readable media having computer-executable instructions embodied thereon for performing a method for generating a multidimensional data cube, the method comprising:
receiving data from a data source;
receiving a definition of at least one measure for indicating one or more facts in the data source;
receiving a definition of at least one dimension, wherein the at least one dimension includes one or more attributes;
receiving a definition of at least one data domain, wherein the at least one data domain comprises at least one parameter for structuring the data;
structuring the data according to the at least one measure, the at least one dimension, and the at least one data domain, wherein the structured data is a multidimensional data cube such that a particular measure of the at least one measure imparts knowledge of the at least one dimension and the one or more attributes that pertain to that particular measure; and
storing the structured data on a computing device.
2. The one or more computer-readable media of claim 1 , wherein receiving a definition of at least one data domain further comprises receiving a new definition of the at least one data domain after structuring the data.
3. The one or more computer-readable media of claim 1 , wherein receiving a definition of at least one data domain comprises receiving a definition of the at least one data domain by at least one of a measure, a measure group, and a dimension.
4. The one or more computer-readable media of claim 1 , wherein receiving a definition of at least one data domain comprises receiving a definition of the at least one data domain by at least one of a database, a data cube and a partition.
5. The one or more computer-readable media of claim 3 , further comprising receiving a definition of at least one parent data domain and at least one child data domain, wherein the at least one child data domain is a sub-domain of the at least one parent domain.
6. The one or more computer-readable media of claim 4 , further comprising receiving a definition of at least one parent data domain and at least one child data domain, wherein the at least one child data domain is a sub-domain of the at least one parent data domain.
7. The one or more computer-readable media of claim 1 , wherein receiving a definition of at least one data domain comprises receiving a definition of the at least one data domain by at least one partition, further wherein the at least one partition is revised.
8. One or more computer-readable media having computer-executable instructions embodied thereon for performing a method for analyzing multidimensional data using data domains, the method comprising:
receiving multidimensional data from at least one data source;
receiving a definition of at least one data domain, wherein the at least one data domain comprises at least one variable parameter for organizing the multidimensional data;
creating at least one multidimensional data cube to represent the multidimensional data such that a particular item of data in the multidimensional data associated with a particular parameter of the at least one variable parameter imparts knowledge of another parameter of the at least one variable parameter that pertains to that particular item of data, wherein the at least one multidimensional data cube comprises the at least one data domain;
receiving at least one query instruction;
applying the at least one query instruction to the multidimensional data cube to retrieve at least one query result that satisfies the at least one query instruction; and
displaying the at least one query result.
9. The one or more computer-readable media of claim 8 , wherein the at least one query result comprises at least one of an aggregation, a partition, and a cache.
10. The one or more computer-readable media of claim 9 , wherein the at least one of an aggregation, a partition, and a cache comprises at least one data domain.
11. The one or more computer-readable media of claim 8 , wherein the at least one query result comprises at least one partition, further wherein the at least one partition is updated.
12. The one or more computer-readable media of claim 11 , wherein the at least one partition comprises at least one data domain.