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
Magnetic memory element, driving method for same, and nonvolatile storage device
Fuser member
Power device and method of packaging same
Electrode for a plasma torch
High conductive water-based silver ink
Processes for producing polyunsaturated fatty acids in transgenic organisms
Scale information for drawing annotations
  Randomly Featured Patents
Method of performing measurements on digital images
Thin film head having a magneto-restrictive read element
Stuffed figure chair
Connector fitting construction with side ribs and corresponding side rib-receiving portions
Methods of managing timberland
Hydraulically operated hammer drill
Yielding column
Remote control transmitter
Paper doll
Compound document page data compression