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
Flexible quantization
Managing multiple web services on a single device
Key management policies for cryptographic keys
Self-service channel marketplace
Electronic device and printed circuit board
Integrated circuit having a discrete capacitor mounted on a semiconductor die
Electronic device including predicted frequency error estimation of a voltage controlled oscillator and related methods
  Randomly Featured Patents
Pull tab for velcro backed marble grinding pad and method for removal
Disengageable rotary clutch
Armature assembly for electromagnetic door holder
Compositions useful as inhibitors of protein kinases
Electrophotographic image drum
Surgical instrument with detachable tool member
Poly(aryl ether sulfone) compositions having improved flow properties
Hand driven cutter having multiple wheels
Flip chip for electrical function test and manufacturing method thereof
Fire alarm system