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
Defected ground plane inductor
Apparatus for preventing overcharge of a battery
Electronic apparatus and manufacturing method of electronic apparatus
Large scale data storage system with fault tolerance
Polymeric structures comprising a siloxane
Platform for generating electricity from flowing fluid using generally prolate turbine
Session transfer method, application server, and communications system
  Randomly Featured Patents
Two dimensional shuttle rotary cleaning device
Hot plate oven for processing flat panel displays and large wafers
Vehicle power plug with a control switch
Method and apparatus for using non-symmetric speech coders to produce non-symmetric links in a wireless communication system
Integrated temperature-controlled container
MRI guidewire
Spatial heterodyne wide-field Coherent Anti-Stokes Raman spectromicroscopy
Hibiscus plant named `Desert Wind`
Diagnostic device
Battery coil construction