Invention Grant
- Patent Title: Data change tracking and event notification
- Patent Title (中): 数据更改跟踪和事件通知
-
Application No.: US13206316Application Date: 2011-08-09
-
Publication No.: US08972459B2Publication Date: 2015-03-03
- Inventor: Kishore R. Chaliparambil , Chi Kit Chan , Imran Mohiuddin , Bryan Dove , Mehul Y. Shah , Umesh Madan , Ali Emami , Robert A. May , Eric Gunnerson
- Applicant: Kishore R. Chaliparambil , Chi Kit Chan , Imran Mohiuddin , Bryan Dove , Mehul Y. Shah , Umesh Madan , Ali Emami , Robert A. May , Eric Gunnerson
- Applicant Address: US WA Redmond
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Current Assignee Address: US WA Redmond
- Agent Damon Rieth; Jim Ross; Micky Minhas
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06Q10/10 ; G06Q50/22

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.
Public/Granted literature
- US20130007069A1 Data Change Tracking and Event Notification Public/Granted day:2013-01-03
Information query