Model Based Data Warehousing and Analytics

• US 20090299955A1
• Filed: 05/29/2008
• Published: 12/03/2009
• Est. Priority Date: 05/29/2008
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Phadke, Sandeep M., Roth, Michael Theodore, Aski, Vijaykumar K.
• Application Number:
  US12/129,667
• Publication Number:
  US 20090299955A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

Aspects of the subject matter described herein relate to data warehouses. In aspects, mapping information is received that maps elements of a data warehouse to types of a type system. A type system defines a hierarchy of data types of data in a data source from which the data warehouse obtains data. The mapping information also indicates whether subtypes of the data are mapped to the elements. Using this mapping information, the elements of the data warehouse may be automatically created, maintained, and populated. When the type system is changed, mapped elements in the data warehouse may be updated or created and code to extract and load the data from a data source associated with the type system may be created based on the mapping information. In addition, reports based on the mapped elements may continue to work without change.

Claims

1. A method implemented at least in part by a computer, the method comprising:

obtaining mapping information that includes a type system, a dimension, and a mapping that associates a type within the type system to the dimension, the type system associated with a data source that stores data as defined by the type system, the type system indicating a hierarchy of types, the dimension associated with a data warehouse, the mapping indicating at least whether data associated with subtypes of the type is to be copied from the data source to the data warehouse;

based at least on the mapping information, automatically maintaining the dimension and a system that extracts data from the data source and provides the data to the data warehouse.

2. The method of claim 1, wherein automatically maintaining the dimension and a system that extracts data from the data source and provides the data to the data warehouse comprises determining that a change associated with the type has occurred, and in response, updating the dimension and the system to accommodate the change.

3. The method of claim 2, wherein the change comprises an addition of a property to the type and wherein updating the dimension and the system to accommodate the change comprises changing the dimension to include a field corresponding to the property and changing the system to extract the property and provide the property to the dimension.

4. The method of claim 2, wherein the change comprises an addition of a subtype to the type and wherein updating the dimension and the system to accommodate the change comprises changing the dimension to include fields corresponding to properties of the subtype and changing the system to extract the properties and provide the properties to the dimension.

5. The method of claim 1, wherein automatically maintaining the dimension and a system that extracts data from the data source and provides the data to the data warehouse comprises generating code that creates the dimension based on properties of the type and subtypes of the type, if any.

6. The method of claim 1, wherein automatically maintaining the dimension and a system that extracts data from the data source and provides the data to the data warehouse comprises generating code that extracts data of the type and subtypes of the type from the data source.

7. The method of claim 1, wherein the dimension comprises a table with columns and wherein automatically maintaining the dimension and a system that extracts data from the data source and provides the data to the data warehouse comprises keeping the columns in sync with properties of the type and subtypes of the type, if any, such that each column of the dimension corresponds to a property of the type or one of the subtypes, if any.

8. The method of claim 1, wherein the mapping information further includes code usable to obtain a measure associated with a fact of the data warehouse, the fact associating two or more dimensions together.

9. The method of claim 1, further comprising based at least on the mapping information, automatically maintaining a fact that associates multiple dimensions of the data warehouse and automatically maintaining an outrigger associated with one or more types of the type system.

10. A computer storage medium having computer-executable instructions, which when executed perform actions, comprising:

receiving an indication of a change to a type system associated with a data source, the type system indicating a hierarchy of types of data;

based at least in part on a mapping, determining whether a data warehouse is affected by the change, the mapping associating a dimension in the data warehouse to at least one type of the type system, the mapping indicating whether data associated with subtypes, if any, of the at least one type is to be represented in the dimension; and

if the data warehouse is affected, updating the data warehouse to be capable to receive information associated with the change and updating a system that obtains the information from the data source and provides the information to the data warehouse.

11. The computer storage medium of claim 10, wherein the change comprises an addition, deletion, or modification of a subtype to the type.

12. The computer storage medium of claim 10, wherein the change comprises a modification to the type, the modification adding, renaming, or deleting properties included in the type.

13. The computer storage medium of claim 10, wherein the data warehouse is affected if the change changes the at least one type of the type system.

14. The computer storage medium of claim 10, wherein the data warehouse is affected if the change adds, deletes, or modifies a subtype of the at least one type and the mapping indicates that data associated with the subtypes is to be represented in the dimension.

15. The computer storage medium of claim 10, wherein updating the data warehouse to be capable to receive information associated with the change comprises adding one or more fields to the dimension, the one or more fields corresponding to properties added by the change.

16. The computer storage medium of claim 10, wherein updating a system that obtains the information from the data source and provides the information to the data warehouse comprises generating first code that obtains the information from the data source and second code that copies the information to the data warehouse, the first code extracting data from the type and subtypes, if any, if indicated by the mapping.

17. A method implemented at least in part by a computer, the method comprising:

receiving first input that indicates a type of a type system, the type system defining data stored on a data source

receiving second input that indicates a dimension of a warehouse that is to be associated with data of the type, the dimension to be stored on a data warehouse;

receiving third input that indicates whether data associated with subtypes, if any, of the type is to be copied from the data source to the data warehouse; and

storing data derived from the first, second, and third inputs in mapping information, the mapping information indicating the type, the dimension, and whether data associated with subtypes, if any, of the type is to be copied from the data source to the data warehouse.

18. The method of claim 17, further comprising:

receiving fourth input at a user interface of a component associated with the data source; and

in response to the fourth input, using at least the mapping information to provide a measure from a fact of the data warehouse, the measure indicating additional information about data included in the data source.

19. The method of claim 17, further comprising:

receiving fifth input that indicates a type of the type system that is to be associated with an outrigger of the data warehouse, the outrigger including tuples, each tuple including an identifier and a name associated with the identifier, the outrigger associated with one or more dimensions via identifiers in the tuples, and

storing data derived from the fifth input in the mapping information.

20. The method of claim 17, further comprising:

receiving fourth input from a user interface associated with the data warehouse, the fourth input requesting access to information from the data source; and

using at least the mapping information to access the information from the data source.