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
Potato cultivar F10
Display apparatus having a semi-penetration layer and a sealing unit
Method and apparatus to select a profile of a digital communication line
Projection screen and projection system having the same
Discharge lamp comprising coated electrode
Single-pass Barankin Estimation of scatterer height from SAR data
Error recovery storage along a memory string
  Randomly Featured Patents
Infrared imaging device
Blood syringe
Ceramic plug gas distribution device
Method for correcting skew in scanned documents
Method and apparatus for monitoring the position of the eye
Magnetically shielded conductor
Latching mechanism for combustion chamber plate of a fastener driving tool
Table assembly with circumferentially disposed retractable extension members
Semiconductor storage device capable of reduced current consumption using a charge reuse circuit
Glass bottle pulverizing apparatus