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
Motion blur reduction for LCD video/graphics processors
Load control device
Integrated testing circuitry for high-frequency receiver integrated circuits
Power converter for an LED assembly and lighting application
Method of forming a semiconductor package
Maize hybrid X08B748
Method and system for reciprocal mixing cancellation of wideband modulated blockers
  Randomly Featured Patents
Iontophoresis electrode structure
Power management unit for configurable receiver and transmitter and methods for use therewith
Method for the electrical testing of equipotential lines
Safety sharps bagging apparatus
Server enclosure and connection element thereof
Therapeutic coating for an intravascular implant
Automatically squeezable water collector of umbrella
Poly-v pulley
Optical fiber connector having V-shaped receiving grooves
Safety device for a rocker of sheaves supporting an overhead cable