Data change tracking and event notification

US8972459B2 · 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: Aug 9, 2011
• Grant date: Mar 3, 2015
• Expiry date: Aug 9, 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.