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
Arithmetic processing unit and control method for cache hit check instruction execution
Stand mixer cover
Wireless communication system, wireless communication apparatus, and wireless communication method
Method for crystallizing (meth)acrylic acid and method for regulating content of polymerization inhibitor in product (meth)acrylic acid
1x and 1xEV-DO hybrid call setup
Systems, methods, and apparatus for detecting a pattern within a data packet
Liquid crystal display device, panel and panel manufacture method thereof
  Randomly Featured Patents
Composite range constraint propagation control
Process for the degradation of coal tar and its constituents by Phanerochaete chrysosporium
Catalytic oxidation of carbon monoxide
Semiconductor device fabrication process
Methods of using settable spotting compositions comprising cement kiln dust
Can with seal
Hammer block
Device for controlling an amount of light of a lighting unit for an endoscope
Burst gate keying and back porch clamp pulse generator
Room temperature coalescable aqueous fluoropolymer dispersions and method for their manufacture