IP Library Granted Patent US 7,313,561
Granted Patent B2
US 7,313,561 · App. 10/727,176 · Granted Dec 25, 2007

Model definition schema

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 7,313,561
App. No.
10/727,176
Granted
Dec 25, 2007
Kind
B2
Abstract

A tagged format data schema is disclosed. The schema enables an object-relational model to be specified and decorated with metadata so that a dimensional model can be inferred therefrom. In accordance with one embodiment, based on information specified in the schema, a processing engine is able to autonomously generate a dimensional model.

Claims (46)

1. A data processing system including a processor, the system comprising:

a standardized data representation that is encoded on a computer-readable storage medium and that represents an object-relational data model;

a model generator that processes the standardized data representation and automatically derives, based on descriptions of objects and an indication of a collection of object-relational mappings in the standardized data representation to generate a dimensional model that corresponds to the object-relational data model, the standardized data representation includes:

a description of the objects and object relationships reflected in the object-relational data model;

a description of persistent data store mappings associated with the object-relational data model;

the indication of a collection of object-relational mappings that specify how a data member associated with a class in the object-relational data model can be filled with data retrieved from at least one table in a relational database;

a description of at least one user-designated focal point that represents a point of analysis indicated in association with data in the object-relational data model; and

a description of at least one data element selected from a group consisting of a class from the object-relational data model, a data member associated with a class from the object-relational data model, a collection of object-relational mappings that specify how data is retrieved from a relational database, a field that uniquely identifies a class from the object-relational data model, an association relationship indicator that identifies a relationship among classes in the object-relational data model, a composition relationship indicator that identifies a relationship among classes in the object-relational data model, and a measure that identifies an interesting numerical value used for generation of the dimensional model.

2. The system of claim 1 , wherein the standardized data representation is a specification of the object-relational data model decorated with metadata so as to support the derivation of the dimensional model.

3. The system of claim 1 , wherein the standardized data representation includes a description of at least one focal point that represents a point of analysis indicated in association with data in the object-relational data model.

4. A data processing system including a processor, the system comprising:

a tagged format data schema that is encoded on a computer-readable storage medium and that represents an object-relational data model;

a model generator that processes the tagged format data schema and automatically derives, based on descriptions of objects and an indication of a collection of object-relational mappings in the tagged format data schema to generate a dimensional model that corresponds to the object-relational data model,

the tagged format data schema includes:

a description of objects and object relationships reflected in the object-relational data model;

a description of persistent data store mappings associated with the object-relational data model;

the indication of a collection of object-relational mappings that specify how a data member associated with a class in the object-relational data model can be filled with data retrieved from at least one table in a relational database;

a description of at least one user-designated focal point that represents a point of analysis indicated in association with data in the object-relational data model; and

a description of at least one data element selected from a group consisting of a class from the object-relational data model, a data member associated with a class from the object-relational data model, a collection of object-relational mappings that specify how data is retrieved from a relational database, a field that uniquely identifies a class from the object-relational data model, an association relationship indicator that identifies a relationship among classes in the object-relational data model, a composition relationship indicator that identifies a relationship among classes in the object-relational data model, and a measure that identifies an interesting numerical value used for generation of the dimensional model.

5. The system of claim 4 , wherein the schema includes a tag used to indicate a class in the object-relational data model.

6. The system of claim 4 , wherein the schema includes a tag for indicating a data member associated with a class in the object-relational data model.

7. The system of claim 4 , wherein the schema includes a tag for indicating a key field that uniquely identifies a class included in the object-relational data model.

8. The system of claim 4 , wherein the schema includes a tag for indicating a name field that uniquely identifies an instance of a class included in the object-relational data model.

9. The system of claim 4 , wherein the schema includes a tag for indicating an association relationship among multiple classes in the object-relational data model.

10. The system of claim 4 , wherein the schema includes a tag for indicating a composition relationship among multiple classes in the object-relational data model.

11. The system of claim 4 , wherein the schema includes a tag for indicating a measure, a measure being an interesting numerical value used for generation of the dimensional model.

12. The system of claim 4 , wherein the schema enables the object-relational data model to be specified and decorated with metadata so as to support the derivation of the dimensional model.

13. The system of claim 4 , wherein the schema is configured to be processed by a processing engine that is adapted to autonomously derive the dimensional model.

14. The system of claim 4 , wherein the schema includes a description of at least one focal point that represents a point of analysis indicated in association with data in the object-relational data model.

15. A data processing system including a processor, the system comprising:

a Extensible Markup Language (XML) data schema that is encoded on a computer-readable storage medium and that represents an object-relational data model;

a model generator that processes the data schema and automatically derives, based on descriptions of objects and an indication of a collection of object-relational mappings in the data schema to generate a dimensional model that corresponds to the object-relational data model,

the data schema includes:

a description of objects and object relationships reflected in the object-relational data model;

a description of persistent data store mappings associated with the object-relational data model;

a description of at least one user-designated focal point that represents a point of analysis indicated in association with data in the object-relational data model;

the indication of a collection of object-relational mappings that specify how a data member associated with a class in the object-relational data model can be filled with data retrieved from at least one table in a relational database; and

a description of at least one data element selected from a group consisting of a class from the object-relational data model, a data member associated with a class from the object-relational data model, a collection of object-relational mappings that specify how data is retrieved from a relational database, a field that uniquely identifies a class from the object-relational data model, an association relationship indicator that identifies a relationship among classes in the object-relational data model, a composition relationship indicator that identifies a relationship among classes in the object-relational data model, and a measure that identifies an interesting numerical value used for generation of the dimensional model.

16. The system of claim 15 , wherein the schema includes a tag used to indicate a class in the object-relational data model.

17. The system of claim 15 , wherein the schema includes a tag for indicating a data member associated with a class in the object-relational data model.

18. The system of claim 15 , wherein the schema includes a tag for indicating a key field that uniquely identifies a class included in the object-relational data model.

19. The system of claim 15 , wherein the schema includes a tag for indicating a name field that uniquely identifies an instance of a class included in the object-relational data model.

20. The system of claim 15 , wherein the schema includes a tag for indicating an association relationship among multiple classes in the object-relational data model.

21. The system of claim 15 , wherein the schema includes a tag for indicating a composition relationship among multiple classes in the object-relational data model.

22. The system of claim 15 , wherein the schema includes a tag for indicating a measure, a measure being an interesting numerical value used for generation of the dimensional model.

23. The system of claim 15 , wherein the schema enables the object-relational data model to be specified and decorated with metadata so as to support the derivation of the dimensional model.

Assignments (4)
CORRECTIVE ASSIGNMENT TO CORRECT THE RECORDAL TO REMOVE INADVERTENTLY RECOREDED PROPERTIES SHOWN IN ATTACHED SHEET PREVIOUSLY RECORDED AT REEL: 047681 FRAME: 0916. ASSIGNOR(S) HEREBY CONFIRMS THE ASSIGNMENT. Recorded Jul 18, 2019
From: MICROSOFT TECHNOLOGY LICENSING, LLC
To: SERVICENOW, INC.
Reel/Frame 049797/0119 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 29, 2018
From: MICROSOFT TECHNOLOGY LICENSING, LLC
To: SERVICENOW, INC.
Reel/Frame 047681/0916 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 9, 2014
From: MICROSOFT CORPORATION
To: MICROSOFT TECHNOLOGY LICENSING, LLC
Reel/Frame 034541/0477 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 3, 2003
From: LO, ALVIN; YEH, ADAM
To: MICROSOFT CORPORATION
Reel/Frame 014768/0580 →