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
Family of pain producing substances and methods to produce novel analgesic drugs
High brightness laser diode module
Efficient file system metadata scanning using scoped snapshots
Clothes hanger
Process for preparing soybean curd using micronized solution of soybean curd
Snapshot isolation support for distributed query processing in a shared disk database cluster
Focus adjustment unit and optical scanning microscope
  Randomly Featured Patents
Tractor and trailer braking control system to prevent trailer overrun
Method of improving texture of metal films in semiconductor integrated circuits
Hydrotherapy massage method and apparatus
Insertion-type liquid metal latching relay
Synchronous network
Method of transmitting packets and apparatus of transmitting packets
Stretchable band - type transducer particularly suited for use with respiration monitoring apparatus
Acceleration control for a gas turbine engine
Continuous welding machine for welding a pipe blank
Method of extracting hop pellets with liquified carbon dioxide