Microsoft Technology Licensing, LLC

Alvin Lo

Adam Yeh

Jonathan Tang

The present invention provides an architecture for obtaining an analytical view of data. The invention includes a model service component for receiving an indication of a first object model and generating a dimensional model and a second object model from the first object model. The second object model is analytical in that it preserves relationships identified in the dimensional model, but allows the user to obtain information in terms of objects instead of specifying the data in terms of the dimensional model. The architecture also includes a navigational component that allows a user to navigate from the second object model to underlying data represented by the first object model.

Architecture for automating analytical view of business applications

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.

Model definition schema

The present invention automatically generates a dimensional model from an object model. The relationships in the object model are used to infer foreign key relationships in the dimensional model.

Growing community of inventors

Bellevue, WA, United States of America

Alvin Lo