Steven Charles Sheldon

US Patent:

7251653, Jul 31, 2007

Filed:

Jun 30, 2004

Appl. No.:

10/880888

Inventors:

Chih-Jen Huang - Kirkland WA, US
Steven Sheldon - San Diego CA, US
Robert Turner - Seattle WA, US
Patrick Conlan - Redmond WA, US

Assignee:

Microsoft Corporation - Redmond WA

International Classification:

G06F 17/30
G06F 7/00

US Classification:

707 6, 707100, 707203

Abstract:

The mapping system maps a physical table of a database to a logical table representing a logical view of the database that integrates standard columns and custom columns. The physical table includes a standard table with standard columns and a custom table with custom columns. The custom table may be implemented as a pivot table. The mapping system provides a map between standard and custom columns and logical columns. The physical table may include multiple standard tables. The mapping system allows for individual standard tables to be updated, rather than updating all the columns across all the standard tables for a row.