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
Chemically resistant membranes, coatings and films and methods for their preparation
Method, system, and computer program product for scoring theoretical peptides
Method and apparatus for optimizing paging in a communication network
Metal colloidal particles, metal colloid and use of metal colloid
Far field telemetry operations between an external device and an implantable medical device during recharge of the implantable medical device via a proximity coupling
Preventative traffic congestion social networking improvement system within a community
  Randomly Featured Patents
Pump assembly
Measurement apparatus for measuring a biological substance within a fluid substrate
Rain sensor with bonded chips
Semiconductor intergrated circuit device
Method and software tools for intelligent service pack installation
Separator counter
Modular bridge section
Clamping device
Semiconductor memory device having a memory cell structure of reduced occupying area
Exposure control device for a camera