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
Controller for soldering iron
Wireless communication system, wireless communication device, wireless communication method, and program
Selective thermal treatment of medical instrument portions with thermal treatment system instrument holder
Systems and methods for updating a data store using a transaction store
Liquid-filled protein-phosphatidic acid capsule dispersions
Conductor for transmitting electrical power
Pausing a VoiceXML dialog of a multimodal application
  Randomly Featured Patents
Threaded bolt tool
Data processing device
Unirradiated nuclear fuel component transport system
System of reverse call branch off-load
Electronic assembly including integrated circuit package and liquid crystal display panel
Variable valve timing arrangement for internal combustion engine
Synthesis, structure, and antitumor activity of 5,6-dihydro-5-azacytidine
Monoclonal antibody and use thereof
Proteins for use as pitch and stickies control agents in pulp and papermaking processes