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
Compound containing a carbon or an oxygen isotope, preparation and use thereof, and composition comprising thereof
Lower set insert with a lower ball seat for a downhole plug
Method for manufacturing a substrate for a display device
Fabrication method of packaging substrate having through-holed interposer embedded therein
Providing multiple decode options for a system-on-chip (SoC) fabric
Method of stimulating tissue healing
Novelty snacks and method of manufacture of same
  Randomly Featured Patents
Variable wavelength ultraviolet lamp
Coupling system for power take-off shafts
Analog DC compensation
Lighting structure with multiple reflective surfaces
Removable rear truck window
Power supply device and method utilizable in electronic apparatus
Wall hanger
Backpack for a computer
Method of making a granular media water filter
Inspection apparatus for viewing both sides of a plurality of coins in successive fashion