Unified concurrent changes to data, schema, and application

US8768902B2 · kind B2 · utility

Assignee

• Microsoft Corporation · US

Inventors

• William Emeric Aitken · Mercer Island, US
• Noaa Avital · Bellevue, US
• Quetzal Bradley · Monroe, US
• Bradford H. Lovering · Seattle, US
• Stephen J. Millet · Edmonds, US
• Brad Olenick · Kirkland, US
• Pedram Faghihi Rezaei · Seattle, US
• Simon David Kent · Redmond, US
• Haroon Ahmed · Bellevue, US

Key dates

• Filing date: Jun 11, 2010
• Grant date: Jul 1, 2014
• Expiry date: Dec 10, 2031

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F17/00
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

Changes are managed in a multi-user database application environment. Proposed changes are collected, including changes to data, schema, and/or application descriptions. A user may specify foreign key relationships between items belonging to one or more of these categories. A view is produced showing the impact proposed changes would have on the environment if successfully committed. The user's proposed changes are ordered according to their dependencies, and submitted for committal together in a single transaction, subject to optimistic concurrency and consistency checks. For example, a proposed change to a data value may be inconsistent with a change which removed a data element containing the data value. The commitment operation may return identifiers and other return values, in addition to indicating whether the commitment was successful.