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
Evaluating programmer efficiency in maintaining software systems
Light emitting device and light emitting device package
Transistor and display device
Discharge lamp lighting circuit
Elegant solutions for fingerprint image enhancement
Managing wear leveling and garbage collection operations in a solid-state memory using linked lists
Server chassis
  Randomly Featured Patents
Pneumatic buffering system
Vacuum interrupter and method of modifying a vacuum interrupter
Touch sensor with electrostatic immunity and sensing method thereof
Suction drainage device for surgical purposes
Injection moulding system and heating element for use in such a system
Method for effecting reverse shape memory phenomena in Cu-Zn-Si brass alloy
Pin socket with connecting portions
Method of playing single or multiple hand twenty-one card game
Light emitting diodes including transparent oxide layers
Compact portable kitchen