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
Making transparent capacitor with multi-layer grid
Sensor interface engineering
Change management automation tool
Implant for performance enhancement of selected transistors in an integrated circuit
Passive millimeter wave differential interference contrast polarimetry
Masking method and apparatus
Maintenance tool of control systems
  Randomly Featured Patents
Halo active aromatic sulfonamide organic compounds and odor control uses therefor
Microwave quick connect/disconnect coaxial connectors
Magnified image projector apparatus
Absorbent article
Thin film transistor having N-type and P-type CIS thin films and method of manufacturing the same
Pneumatically controlled rigid core-former
Video coding device and decoding device
Illumination device for producing predetermined intensity patterns
Method and system for a multicast service initiation in a communication system
System for removing static background detail from medical image sequences