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
Receiver with feedback continuous-time delta-sigma modulator with current-mode input
System and method for internet based procurement of goods and services
Managing a packet service call within mobile communications user equipment
Inter vehicle communication system
Method and apparatus for radio antenna frequency tuning
Method of fabricating CIGS by selenization at high temperature
Methods for testing OData services
  Randomly Featured Patents
Tri-zone mattress overlay
Plant for processing surplus concrete
Semiconductor device structures for bipolar junction transistors
Thermoplastic polyurethane elastomer based on a hydroxyl terminated polyol, an aromatic chain extender and 1,5 naphthalene diisocyanate
Line guide for fishing rod
Air curtain device
Adjustable leg assembly
Apparatus for detecting faults in magnet wire insulation without thermally damaging the insulation and which does not respond to impedance indications above a predetermined threshold value
Attracting plate of an electrostatic chuck for semiconductor manufacturing
Flexible tip rheolytic thrombectomy catheter and method of constructing same