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
Method and apparatus for detecting an intermittent path to a storage system
Semiconductor device having germanium active layer with underlying parasitic leakage barrier layer
Methods and apparatus for imaging in conjunction with radiotherapy
Defensin polynucleotides and methods of use
Visual indicator of online backup
Electronic component and reflected-wave cancelling method
Tailoring the band gap of solar cells made of liquid silane by adding germanium
  Randomly Featured Patents
Process for preparing a solid, polymeric electrolyte based on polyvinyl ethers
Resealable closure
LED apparatus with temperature control function
Crosshead apparatus for jacketing wire core
Optical disk unit capable of restraining changes in light quantity
Servomechanism with adjustable predictor filter
Gallery user interface controls
Arc-coating process with rotating cathodes
Wall mount crafter's desk