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
Oil extractor and the preparation method thereof
Surfcraft fin
Buffer pool extension for database server
Emulsions containing arylboronic acids and medical articles made therefrom
Interconnecting virtual domains
Crystalline form of (R)-7-chloro-N-(quinuclidin-3-yl)benzo[b]thiophene-2-carboxamide hydrochloride monohydrate
DFPase enzymes from Aplysia californica
  Randomly Featured Patents
Colon cleansing compositions and methods
Method and system for adaptive maximum intensity projection ray casting
NiAl-based approach for rocket combustion chambers
High purity titanium production process
Recording apparatus
Ion beam system and machining method
Drill guide for surgical pins
System and method for analyzing reliability of electronic device
Machine for repairing and sealing conduits
Mixing bottle and closure