The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Mar. 03, 2015
Filed:
Aug. 09, 2011
Kishore R. Chaliparambil, Snoqualmie, WA (US);
Chi Kit Chan, Bellevue, WA (US);
Imran Mohiuddin, Redmond, WA (US);
Bryan Dove, Seattle, WA (US);
Mehul Y. Shah, Redmond, WA (US);
Umesh Madan, Bellevue, WA (US);
Ali Emami, Seattle, WA (US);
Robert A. May, Redmond, WA (US);
Eric Gunnerson, Bellevue, WA (US);
Kishore R. Chaliparambil, Snoqualmie, WA (US);
Chi Kit Chan, Bellevue, WA (US);
Imran Mohiuddin, Redmond, WA (US);
Bryan Dove, Seattle, WA (US);
Mehul Y. Shah, Redmond, WA (US);
Umesh Madan, Bellevue, WA (US);
Ali Emami, Seattle, WA (US);
Robert A. May, Redmond, WA (US);
Eric Gunnerson, Bellevue, WA (US);
Microsoft Corporation, Redmond, WA (US);
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.