Imran M Mohiuddin

US Patent:

20130006963, Jan 3, 2013

Filed:

Jun 30, 2011

Appl. No.:

13/172889

Inventors:

Kishore R. Chaliparambil - Snoqualmie WA, US
Chi Kit Chan - Bellevue WA, US
Imran Mohiuddin - Redmond WA, US
Bryan Dove - Seattle WA, US
Mehul Y. Shah - Redmond WA, US
Umesh Madan - Bellevue WA, US
Ali Emami - Seattle WA, US
Robert A. May - Redmond WA, US
Eric Gunnerson - Bellevue WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/30

US Classification:

707717, 707802, 707E17017

Abstract:

The described implementations relate to updating views in a database system. One implementation can identify an active view that retrieves records from a database and determine one or more physical tables in the database that are referenced by the active view. The implementation can track one or more columns in the physical tables that are used by the active view and identify a change to the physical tables in a transaction log of the database. If the change does not affect the one or more columns, the change can be treated as an ignorable change for the active view.

US Patent:

20130007069, Jan 3, 2013

Filed:

Aug 9, 2011

Appl. No.:

13/206316

Inventors:

Kishore R. Chaliparambil - Snoqualmie WA, US
Chi Kit Chan - Bellevue WA, US
Imran Mohiuddin - Redmond WA, US
Bryan Dove - Seattle WA, US
Mehul Y. Shah - Redmond WA, US
Umesh Madan - Bellevue WA, US
Ali Emami - Seattle WA, US
Robert A. May - Redmond WA, US
Eric Gunnerson - Bellevue WA, US

Assignee:

MICROSOFT CORPORATION - Redmond WA

International Classification:

G06F 17/30

US Classification:

707803, 707E17005, 707E17044

Abstract:

The described implementations relate to updating views in a database system. One implementation can identify an active view that retrieves records from a database and determine one or more physical tables in the database that are referenced by the active view. The implementation can track one or more columns in the physical tables that are used by the active view and identify a change to the physical tables in a transaction log of the database. If the change does not affect the one or more columns, the change can be treated as an ignorable change for the active view.

US Patent:

20110320433, Dec 29, 2011

Filed:

Jun 25, 2010

Appl. No.:

12/823145

Inventors:

Imran Mohiuddin - Redmond WA, US
Mahmood Gulam Qadir - Redmond WA, US
Yi Miao - Bellevue WA, US
Bryan Jason Dove - Seattle WA, US
Jonathan Alan Handler - Northbrook IL, US
Craig F. Feied - Kirkland WA, US
Mehul Y. Shah - Redmond WA, US

Assignee:

MICROSOFT CORPORATION - Redmond WA

International Classification:

G06F 17/30

US Classification:

707714, 707E17054

Abstract:

Described is associating metadata with different sources of data (e.g., database tables) that allows a single view of data from the sources to be created. An administrator creates baseviews corresponding to database tables and associates metadata with the baseviews, including primary key metadata for the baseviews and meta-tags for one or more of the columns of each baseview. A user selects fields (corresponding to table columns) from a starting baseview, along with fields from any other baseview that has metadata that matches the starting baseview's metadata. A join mechanism automatically creates the view if a metadata match is detected.