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
LED driving circuit, LED illumination appliance, LED illuminator, and LED illumination system
Access control method, information display device using the same, and information display system
Policy based cryptographic application programming interface in secure memory
Apparatus and method for scrolling a screen of a portable terminal having a touch screen
Non-transitory computer readable recording medium storing print management program, print management device, print management method, and print system
Topical antibiotic composition for the prevention of Lyme disease
Compositions and methods for inhibition of MMP13:MMP-substrate interactions
  Randomly Featured Patents
Vehicle position indicator with selectable position alarm means
Quenching arrangement for a furnace
Device and method for determining the orientation of an eye
Industrial robot
Reading data from a smart card
Mechanical interlock for contactor banks
Water soluble laser dyes
Polysaccharide agglomerate and method of preparation
Air spring suspension with angular torque beam, U-joint mount therefor, and lateral guides