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
Autonomous downlink code selection for femto cells
Projection-type video-image display apparatus
Use of natriuretic peptide for treating heart failure
Solar energy converter with improved photovoltaic efficiency, frequency conversion and thermal management permitting super highly concentrated collection
Fuel cell stack including ejector and blower for anode recirculation and method for controlling the same
Image forming apparatus with enhanced display of guidance information
Data security for dynamic random access memory using body bias to clear data at power-up
  Randomly Featured Patents
Valve timing control system for internal combustion engine and method for assembling same
Luminaire-provided footwear
Headlight with a ventilated mask
Backable tow bar adapter, and method
Bioconversion process for the production of vanillin
Trioxyethylene gold nanoclusters functionalized with a single DNA
Variants of files in a file system
Systems, circuits and methods for filtering signals to compensate for channel effects
Random copolymer of propylene and 1-butene and process for its production
Silicone molded co-polymer composite lead body for pacing and defibrillation leads