Resources Contact Us Home
Secondary index and indexed view maintenance for updates to complex types

Image Number 4 for United States Patent #7933913.

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.

  Recently Added Patents
Semiconductor light emitting device
Radio frequency optical communication system
Render engine for spreadsheet
High voltage devices and methods of forming the high voltage devices
Method, apparatus, and system for maintaining status of bootstrap peer
Shaped-potato sandwich product
  Randomly Featured Patents
Pacing unit with catheter holder
Lock cover
Series inverter circuit with timing responsive to reflective current
Golf information and course mangement system
Gun stock
Compiler, compiler apparatus and compilation method
Amplifier apparatus for an output stage of a laser driver circuit
Catheter assembly
Developing apparatus
Self-telescoping storage enclosure