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
Laser processing method and apparatus
Anti-fake battery pack and identification system thereof
Reducing energy and increasing speed by an instruction substituting subsequent instructions with specific function instruction
Method for transferring inventory between virtual universes
Voltage detection apparatus and combination circuit
Anomalous data detection method
Pyroelectric detector, pyroelectric detection device, and electronic instrument
  Randomly Featured Patents
Dropout compensating apparatus using a digital delay circuit
Extended definition television transmission system
Method and system for placing a computer in a reduced power state
Polarity checking apparatus for multi-fiber connectors
System and method for detecting and using a replacement boot block during initialization by an original boot block
Performing impulse blanking based on blocker information
Container, usable as cash drawer
Method of making multi-density composite gaskets
Folding device for a stroller