Method, system, and program for use of metadata to create multidimensional cubes in a relational database
First Claim
1. A method for query processing, comprising:
- storing metadata for a facts metadata object and one or more dimension metadata objects that are associated with the facts metadata object;
constructing a view with columns for one or more measures in the facts metadata object and one or more attributes in the one or more dimension metadata objects; and
generating additional metadata that describes roles of columns in the fact and dimension metadata objects.
1 Assignment
0 Petitions
Accused Products
Abstract
Disclosed is a method, system, and program for query processing. Metadata for a facts metadata object and one or more dimension metadata objects that are associated with the facts metadata object is stored. A view with columns for one or more measures in the facts metadata object and one or more attributes in the one or more dimension metadata objects is constructed. Additional metadata that describes roles of columns in the fact and dimension metadata objects is generated.
Also disclosed is a computer-readable medium for storing data for access by a program. A data structure stored in the computer-readable medium includes data for use by the program. The data includes a cube model metadata object that includes a facts metadata object, one or more dimension metadata objects, and one or more join metadata objects that describe how one or more tables in the facts metadata object and one or more tables in the one or more dimension metadata objects are joined. The data also includes a cube metadata object that represents a subset of the cube model metadata object and comprises a view with columns for one or more measures of one of the facts metadata objects and one or more attributes of one or more of the dimension metadata objects and a document that describes roles of columns in the facts metadata object and the one or more dimension metadata objects.
-
Citations
30 Claims
-
1. A method for query processing, comprising:
-
storing metadata for a facts metadata object and one or more dimension metadata objects that are associated with the facts metadata object;
constructing a view with columns for one or more measures in the facts metadata object and one or more attributes in the one or more dimension metadata objects; and
generating additional metadata that describes roles of columns in the fact and dimension metadata objects. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
-
-
13. A computer-readable medium for storing data for access by a program, comprising:
a data structure stored in the computer-readable medium, wherein the data structure includes data for use by the program and comprising;
a cube model metadata object that includes a facts metadata object, one or more dimension metadata objects, and one or more join metadata objects that describe how one or more tables in the facts metadata object and one or more tables in the one or more dimension metadata objects are joined; and
a cube metadata object that represents a subset of the cube model metadata object and comprises a view with columns for one or more measures of one of the facts metadata objects and one or more attributes of one or more of the dimension metadata objects and a document that describes roles of columns in the facts metadata object and the one or more dimension metadata objects. - View Dependent Claims (14, 15, 16, 17, 18)
-
19. A system for query processing, comprising:
a computer system having at least one program for;
(i) storing metadata for a facts metadata object and one or more dimension metadata objects that are associated with the facts metadata object;
(ii) constructing a view with columns for one or more measures in the facts metadata object and one or more attributes in the one or more dimension metadata objects; and
(iii) generating additional metadata that describes roles of columns in the fact and dimension metadata objects. - View Dependent Claims (20, 21, 22, 23, 24)
-
25. An article of manufacture including a program for query processing, wherein the program causes operations to be performed, the operations comprising:
-
storing metadata for a facts metadata object and one or more dimension metadata objects that are associated with the facts metadata object;
constructing a view with columns for one or more measures in the facts metadata object and one or more attributes in the one or more dimension metadata objects; and
generating additional metadata that describes roles of columns in the fact and dimension metadata objects. - View Dependent Claims (26, 27, 28, 29, 30)
-
Specification