Invention Grant
US07933913B2 Secondary index and indexed view maintenance for updates to complex types
失效
辅助索引和索引视图维护以更新复杂类型
- Patent Title: Secondary index and indexed view maintenance for updates to complex types
- Patent Title (中): 辅助索引和索引视图维护以更新复杂类型
-
Application No.: US12836993Application Date: 2010-07-15
-
Publication No.: US07933913B2Publication Date: 2011-04-26
- Inventor: Bruno H. M. Denuit , Stefano Stefani
- Applicant: Bruno H. M. Denuit , Stefano Stefani
- Applicant Address: US WA Redmond
- Assignee: Microsoft Corporation
- Current Assignee: Microsoft Corporation
- Current Assignee Address: US WA Redmond
- Agency: Woodcock Washburn LLP
- Main IPC: G06F17/30
- IPC: G06F17/30

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.
Public/Granted literature
- US20100281018A1 SECONDARY INDEX AND INDEXED VIEW MAINTENANCE FOR UPDATES TO COMPLEX TYPES Public/Granted day:2010-11-04
Information query