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
Use of a high-oleic and high-tocol diet in combination with a non-tocol antioxidant for improving animal meat quality
Method for specifying control curve parameters for controlling climatic environmental conditions of climate-controlled enclosed spaces
Systems and methods for advertising on content-screened web pages
Particle measurement process and apparatus
Power storage device and method for manufacturing the same
Tactile output device for computing device notifications
Registration and network access control
  Randomly Featured Patents
Hose box
Strong and elastic polyurethane polyurea polycrylates and electron beam-cured coatings containing the same
Temperature adjustable mixing valve
Propulsion system
Method and system to deliver an audiovisual presentation to a workstation using the telephone
Carriage for watercraft
Substituted azetidinone compounds useful as hypocholesterolemic agents
Reorienting navigation trees based on semantic grouping of repeating tree nodes
Track skipper for video disc player
Detecting component removal