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
Placental tissue grafts
Differential ring oscillator and method for calibrating the differential ring oscillator
Switch redundancy in systems with dual-star backplanes
Active gate drive circuit
Portable device for treating insect bites and the like
Method and apparatus for reducing cost of optical amplification in a network
Magnetic levitation motor used in lens module
  Randomly Featured Patents
Coal fired flue gas treatment and process
Telephone interface call processing system with call selectivity
Preparation of alternating olefin/carbon monoxide copolymers by means of a heterogeneous supported catalyst
Traversing apparatus for long and heavy article
Apparatus and method for managing flexible elongate elements
Electron gun for cathode ray tube
Even-slice pizza cutter
Fixing device for an extension tube of an exercise device
Thermal acoustic probe
Motor-vehicle convertible-top system, and a method for operating a motor-vehicle convertible-top system