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
Toy projectile
Method of visualizing segmented MR images with absolute-scale values independent of MR scanner settings
Solar-powered toy car
Article including semiconductor nanocrystals
System and method for securely storing firmware
Device for the acceptance of coins
Method and system for dynamic font support on mobile devices
  Randomly Featured Patents
Core automated monitoring system
Steroid esters and amides, process for their production and their pharmaceutical use
Updating server-related data at a client
Alkaline metal cleaner comprising sulfonated-hydrophobically modified polyacrylate
Tamper proof latch for dispensers
Combination key holder, pen and flashlight
System and method for containing fluid leaks and overflows from appliances
Batch polymerization process