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
Pill identification and counterfeit detection method
Reliable and accurate usage detection of a software application
Fishing apparatus
Laser protection polymeric materials
Digital microwave radio link with adaptive data rate
Cable exit trough with insert
Consistent retention and disposition of managed content and associated metadata
  Randomly Featured Patents
Methods for fast HTML rendering
Leveling assembly for work platforms on articulating booms
Variable angle connection assembly for a spinal implant system
Preparation of metal complexes of 1,3-diketones
Semiconductor laser, semiconductor optical amplifier, and production method thereof
Fishing reel
Slip processing system
Tuned broadband particulate vibration absorber
Dispensers with optional support or attachment means
Device for compressive molding stream of filler for tobacco rod