Data change tracking and event notification

US8818944B2 · kind B2 · utility

Assignee

• Microsoft Corporation · US

Inventors

• Kishore Chaliparambil · Snoqualmie, US
• Chi Kit Chan · Bellevue, US
• Imran Mohiuddin · Redmond, US
• Bryan Dove · Seattle, US
• Mehul Y. Shah · Del Mar, US
• Umesh Madan · Bellevue, US
• Ali Emami · Seattle, US
• Robert A. May · Beeville, US
• Eric Gunnerson · Bellevue, US

Key dates

• Filing date: Jun 30, 2011
• Grant date: Aug 26, 2014
• Expiry date: Dec 4, 2031

Classification

• Technology area (CPC G): Physics
• CPC primary: G16H10/60
• WIPO field: Medical technology
• WIPO sector: Instruments

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.