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
Integrated circuit packaging system with coupling features and method of manufacture thereof
Manufacturing process for cellular screening substratum, resultant substratum, and method and apparatus for screening
Bias voltage generating circuit and switching power supply thereof
Methods of saccharification of polysaccharides in plants
Systems, devices, methods, and compositions including fluidized x-ray shielding compositions
Housekeeping cart
Disk drive
  Randomly Featured Patents
Convection/impingement oven for continuously cooking food
Device for assembling a circular stage of pivoting vanes
Process for preparing superconducting thin film formed of oxide superconductor material
Pixelated block puzzle
Method of mounting semiconductor chip
Engine exhaust temperature regulation
Switch contact arc suppressor
Bis-.beta.-hydroxyethyl terephthalate
Ratchet wrench