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
Ionic compound, anti-static pressure-sensitive adhesive and polarizer comprising the same
Retrievable outgoing audio messaging
Bezel-less electronic display
Transport of multiple asynchronous data streams using higher order modulation
UV exposure method for reducing residue in de-taping process
System for and method of providing single sign-on (SSO) capability in an application publishing environment
System and method to obtain signal acquisition assistance data
  Randomly Featured Patents
Warm air weathermask
Regulating power consumption
Electrolytic cell using small particle graphite
Multi-hop booster
Method to enhance boot time using redundant service processors
Biological treatment system for gaseous waste
Water box and expansion chamber device for a heat exchanger, in particular a radiator for a motor vehicle
Automobile seat belt tightener for use with child safety seats
Computer system and control method for the computer system
Silicone traction fluids