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
Semiconductor device
Method for programming non-volatile memory device and apparatuses performing the method
Visualization of information associated with applications in user interfaces
Using sets of OTDR receive fibers with different lengths of marker events to verify optical fiber connectivity
Radio frequency splitter
Squib control circuit
Buffer pool extension for database server
  Randomly Featured Patents
Process for producing multi-layer feminine hygienic pad
Endcap chip with conductive, monolithic L-connect for multichip stack
Coil winding apparatus
Utilities module for proactive maintenance application
Personal computer keyboard template for displaying operating instructions for software program
Plastic mailbox
Oil congealing composition
Remote controlled battery
Planar heterojunction avalanche photodiode