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
High power fiber amplifier with stable output
All-in-one information handling system
Method of targeting hydrophobic drugs to vascular lesions
Navigation device, navigation method, and navigation program
Method and system for detecting center pivot collision
Wireless communications apparatus and wireless communications method
Medical injector
  Randomly Featured Patents
Combustor dome assembly of a gas turbine engine having a contoured swirler
Pilot aided adaptive minimum mean square interference cancellation and detection
Collapsible antenna
System with lifting columns
Bandpass filter with plurality of wave-guide cavities
Wide band planar radiator
Automobile auxiliary light
Tuberculosis treatment using pleuromutilin derivatives
Methods and compositions for the production of stably transformed, fertile monocot plants and cells thereof
Steinernema sp. nematode for suppression of Helicoverpa zea and Spodoptera frugiperda