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
Integrated bug tracking and testing
Hydroxylated amide skin moisturizer
Systems and methods for processing supplemental information associated with media programming
Campanula plant named `PKMM03`
Method of synchronization for low power idle
Triazole derivatives as ghrelin analogue ligands of growth hormone secretagogue receptors
Pressure-sensitive adhesive composition for optical films, pressure-sensitive adhesive optical film and image display
  Randomly Featured Patents
Image forming apparatus and image forming method using the same
Oil lamp
Combination collator folder
Crosslinking agent for a crosslinkable silicone composition with a low level of platinum based on a hydrogenated silicone oil comprising Si-H units at the chain end and in the chain
Polarized 3 pole electrical connector with protective ground
Method for obtaining a fuel injector for an internal-combustion engine, and an injector made according to said method
Video magnifier
Highly saturated nitrile rubber, process for producing same, vulcanizable rubber composition, aqueous emulsion and adhesive composition
Method for using an in situ particle sensor for monitoring particle performance in plasma deposition processes
Automobile protection system