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 system for simulating wireless networks
Mobile communication device
High performance strained source-drain structure and method of fabricating the same
Optical fixing device and image forming apparatus
Knife grip
Prevention and treatment of osteoarthritis
Synchronous rectifier network unit circuit and method
  Randomly Featured Patents
Multiprocessor system and a method of load balancing thereof
Apparatus for determining motion vectors and a reference picture index for a current block in a picture to be decoded
Systems and methods for streak detection in image array scanning
Automobile body
Fast curable epoxy compositions containing imidazole- and 1-(aminoalkyl) imidazole-isocyanate adducts
Vacuum cleaner-blower
N-pyrazolyl-1,2,4-triazolo[1,5-c]pyrimidine-2-sulfonamide herbicides
Staff holder
Method for determining packet data rate in wireless communication system