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
Secure data entry device
Communication terminal device, communication system, and communication control method
Portable device for treating insect bites and the like
Redistribution layer (RDL) with variable offset bumps
Heterocyclic compounds as CCR2B antagonists
Method and device for managing devices in device management system
  Randomly Featured Patents
Semiconductor device having a bipolar transistor with emitter series resistances
Socket and connector therefor for connecting with an electrical component
Control of development of biofilms in industrial process water
Voltage-controlled capacitor circuit and related circuitry with diode and MOS varactors
Distributed doherty amplifiers
Chrysanthemum plant named `Amiko Bronze`
Interconnect methodology employing a low dielectric constant etch stop layer
Switched-mode power supply
Portland cement-making and municipal refuse conversion