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
Positioning vehicles to improve quality of observations at intersections
Photoelectric conversion module
Capacitance sensing
Imaging apparatus for calculating a histogram to adjust color balance
Display device and method of manufacturing the same
Load balancing in shortest-path-bridging networks
Flexible pouch
  Randomly Featured Patents
Electronic recording and communication of information
Deflection compensation for cartridge carriage with compliant walls
Method and apparatus for scaling intensity data in a mass spectrometer
Dual mode charge pump
System, for matching harnesses of conductors with apertures in connectors
Electromagnetic bandgap structure and printed circuit board
System and method for automatically deploying a network design
Balancer shaft supporting structure in engine
Decontamination of orthopaedic implants
Charger for batteries of different type