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
Compressing data using an encoding table
Fungal transcriptional activators useful in methods for producing a polypeptide
Co-rotating stacked rotor disks for improved hover performance
Substrate temperature regulation fixed apparatus
Emergency display for emergency personnel
Data cache controller, devices having the same, and method of operating the same
Arm support for light post
  Randomly Featured Patents
Semiconductor leadframes plated with thick nickel, minimum palladium, and pure tin
Systems and methods for securing multimedia transmissions over the internet
Cleaning liquid dispensing system for a hard floor surface cleaner
Scanned electron cyclotron resonance plasma source
Non-combustion type flavor suction article
Apparatus and method for event correlation and problem reporting
End cap for a battery pack
Blank for the production of a dental shaped body and method of producing said shaped body
Stackable adjustable musician's chair
Method of injecting fuel including delayed magnetic spill valve actuation