Virtual cubes

• US 6,477,536 B1
• Filed: 06/22/1999
• Issued: 11/05/2002
• Est. Priority Date: 06/22/1999
• Status: Expired due to Term

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Pasumansky, Mosha, Berger, Alexander, Netz, Amir
• Primary Examiner(s): RONES, CHARLES
• Application Number:
  US09/337,828
• Time in Patent Office: 1,232 Days
• Field of Search: 707/103, 707/2, 707/3, 707/4, 707/5, 707/101, 707/102
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2445 Data retrieval commands; View definitions
• CPC Class Codes: G06F 16/24552 Database cache management
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

Systems and methods for creating and maintaining virtual cubes are disclosed. A virtual cube is a logical representation of a subset of the dimensions and measures of at least one physical cube maintained by an OLAP server. Metadata defines the mappings from the dimensions and measures of the virtual cube to the dimensions and measures of the physical cube. Client applications can manipulate the virtual cube as if it were a physical cube.

Claims

1. A computerized system comprising:

a processor and a computer-readable medium;

an operating environment executing on the processor from the computer-readable medium; and

an OLAP server operative to maintain for each of a plurality of physical cubes a first data structure defining at least one physical cube dimension and at least one physical cube measure, and a second data structure defining a virtual cube, said second data structure including a mapping from the at least one physical cube dimension to a virtual cube dimension and a mapping from the at least one physical cube measure to a virtual cube measure.

2. The computerized system of claim 1, further comprising an administrative interface operative to select the at least one physical cube measure and the at least one physical cube dimension and to create the second data structure.

3. The computerized system of claim 1, further comprising a data store operative to store the first data structure and the second data structure.

4. The computerized system of claim 3, wherein the data store is a relational database system.

5. The computerized system of claim 1, further comprising a query processor component for use by a client application, said query processor component operative to perform the tasks of:

obtaining the second data structure from the OLAP server,

processing a query submitted by the client application, said query requiring a cell of the virtual cube,

mapping the cell of the virtual cube to a corresponding cell of the physical cube,

obtaining a value of the cell of the physical cube, and

returning the value of the cell of the physical cube to the client application.

6. The computerized system of claim 5, wherein the query processor is further operative to define a third data structure defining a virtual cube, said third data structure including a mapping from at least one physical cube dimension to a virtual cube dimension and a mapping from at least one physical cube measure to a virtual cube measure.

17. The computerized method of claim 1, further comprising creating a default member of the first dimension of the virtual cube and wherein the dimension of the first physical cube is not shared with the second physical cube.

18. The computerized method of claim 1, further comprising copying a set of cell data associated with the measure of the first cube to a measure associated with the virtual cube.

7. A computer-readable medium having computer-executable instructions for performing a method for creating a virtual cube, the method comprising:

selecting a first physical cube, a dimension of the first physical cube and a measure of the first physical cube;

creating a mapping from the dimension of the first physical cube to a first dimension of the virtual cube and a mapping from the measure of the first physical cube to a first measure of the virtual cube;

selecting a second physical cube, a dimension of the second physical cube and a measure of the second physical cube;

creating a mapping from the dimension of the second physical cube to a second dimension of the virtual cube and a mapping from the measure of the second physical cube to a second measure of the virtual cube;

wherein the mapping information for the virtual cube is maintained by an OLAP server and made accessible to client applications.

8. The computer-readable medium of claim 7, further comprising creating a default member of the first dimension of the virtual cube and wherein the dimension of the first physical cube is not shared with the second physical cube.

9. The computer-readable medium of claim 7, further comprising copying a set of cell data associated with the measure of the first cube to a measure associated with he virtual cube.

10. A computer-readable medium having computer-executable instructions for performing a method comprising;

identifying a cell of a virtual cube using an identifier comprising at least one member of a dimension and at least one measure;

determining a measure associated with a physical cube that is mapped to the measure of the virtual cube; and

if a dimension in the identifier has a member that is not a default member and the dimension is not associated with the physical cube then returning a special value for the cell of the virtual cube,

otherwise performing a set of tasks comprising;

retrieving a value for a cell of the measure of the physical cube, and

returning the value for the cell of the measure of the physical cube;

wherein data defining the virtual cube is maintained by the OLAP server and made available to be read by a client.

11. The computer-readable medium of claim 10, wherein the set of tasks further comprises:

determining if the physical cube is in a local cache; and

if the physical cube is in the local cache retrieving the value for the cell of the measure of the physical cube from the local cache.

12. The computerized methods of claim 10, wherein the special value is a null value for an OLAP server.

13. A computerized method comprising:

identifying a cell of a virtual cube using an identifier comprising at least one member of a dimension and at least one measure;

determining a measure associated with a physical cube that is mapped to the measure of the virtual cube; and

if a dimension in the identifier has a member that is not a default member and the dimension is not associated with the physical cube then returning a special value for the cell of the virtual cube,

otherwise performing a set of tasks comprising;

retrieving a value for a cell of the measure of the physical cube, and

returning the value for the cell of the measure of the physical cube;

wherein data defining the virtual cube is maintained by a server and made available to be read by a client.

14. The computerized method of claim 13, wherein the set of tasks further comprises:

determining if the physical cube is in a local cache; and

if the physical cube is in the local cache retrieving the value for the cell of the measure of the physical cube from the local cache.

15. The computerized of claim 13, wherein the special value is a null value for an OLAP server.

16. A computerized method for creating a virtual cube, the method comprising:

selecting a first physical cube, a dimension of the first physical cube and a measure of the first physical cube;

creating a mapping from the dimension of the first physical cube to a first dimension of the virtual cube and a mapping from the measure of the first physical cube to a first measure of the virtual cube;

selecting a second physical cube, a dimension of the second physical cube and a measure of the second physical cube;

creating a mapping from the dimension of the second physical cube to a second dimension of the virtual cube and a mapping from the measure of the second physical cube to a second measure of the virtual cube,

wherein the mapping information for the virtual cube is maintained by an OLAP server and made accessible to client applications.