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
Light emitting device and light emitting device package
Mesa-shaped piezoelectric resonator element
Parameter decoding apparatus and parameter decoding method
Anti-FGFR3 antibodies and methods using same
Thin film switch and press key/keyboard using the same
Antenna arrangement and antenna housing
Data communication apparatus, method of controlling the same, program, and storage medium
  Randomly Featured Patents
Lubricant compositions
Self learning performance optimized data transfer via one or several communication channels between systems
Ink jet printer in which a best test pattern printed in a recording medium is automatically selected
Pin striped thin film solar module for cluster lamp
Forming leveller
Integrated content guide for interactive selection of content and services on personal computer systems with multiple sources and multiple media presentation
Photoprotection compositions having improved substantivity
Method and system to mitigate low rate denial of service (DoS) attacks
Pet amusement device
Separation of butyraldehyde from ethanol by extractive distillation