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
Film, polarizing plate and display device, and method of manufacturing film
System for wireless local area network (WLAN) transmission and for coexistence of WLAN and another type of wireless transmission and methods thereof
Granulated sweetening composition
Systems and methods for detailed error reporting in data storage systems
System and method for deriving cell global identity information
Light emitting element, method for manufacturing the light emitting element, optical element and method for manufacturing the optical element
Power or voltage oscillation damping in a power transmission system
  Randomly Featured Patents
Data driving apparatus and display device comprising the same
Vertical conformance steam drive oil recovery method
System for modifying the output of a component of a safety restraint system
Fiberoptic line-of-light illuminating device
Antibody reagents that specifically bind to the carboxyl-terminal decaptide of specific GTP-binding proteins
Beverage container with heating or cooling material
Typewriter with an erasing apparatus
Structure for reducing overlap capacitance in field effect transistors
Vacuum cleaner with a cover release element
Apparatus and method for a smooth powerup of a reference signal