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
Determining ill conditioning in square linear system of equations
Tungsten barrier and seed for copper filled TSV
Method and system for electronic assistance in dispensing pharmaceuticals
Adaptive known signal canceller
Rechargeable battery
Personal alarm device for headwear for proximity detection
  Randomly Featured Patents
Surface seeded fine aggregate concrete simulating quarried stone
Slide viewer
Hybrid electrolyte system
Camera back
Suction pick-up apparatus for electrical or electronic components
User-specific contact apparatus and method
Red phosphor and display device including the same
Video tape recorder
Aluminide coatings
Article of footwear with indented tip cleats