Patent Number: 7,769,770

Title: Secondary index and indexed view maintenance for updates to complex types

Abstract: Pursuant to receipt of a data modification command or statement, such as an Update command, it is determined which fields in a data structure, such as a UDT, computed column, indexed view, or index, for example, will be changed as a result of the command. Only those fields that are affected by the command will be changed. Thus, changes are propagated to only to those dependent data structures whose content is being modified. Tree representations are used to facilitate the determination as to whether a subfield in a hierarchy is changed.

Inventors: Denuit; Bruno H. M. (Bellevue, WA), Stefani; Stefano (Seattle, WA)

Assignee: Microsoft Corporation

International Classification: G06F 17/30 (20060101)

Expiration Date: 8/03/12018