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 memory system having ECC circuit and controlling method thereof
Stepped delay control of integrated switches
Architectural panel with Tarwe and grass
Sub-resolution assist feature repair
Wireless communication system and wireless communication method
Method, system and computer program product for verifying floating point divide operation results
Systems and methods for arranging and labeling cardiac episodes
  Randomly Featured Patents
Method and apparatus for delivering IPP2T (IP-push-to-talk) wireless LAN mobile radio service
Gaming system and method for providing a community bonus event
Fiber optic sleeve for surgical instruments
Monitoring cleaning effectiveness of a cleaning system
Lactic acid excreting polylactide sheet for use in absorbent articles
Beach towel
Swivel lantern
Dummy plug
System and method for integrating process control and network management
Method for inspecting prestressed concrete pressure pipes based on remote field eddy current/transformer coupling and use of non-coaxial coils