Resources Contact Us Home
Restructuring view maintenance system and method

Image Number 10 for United States Patent #6915305.

A database maintenance system and method are particularly suitable for maintaining a consistency of data between two or more database tables having schemas that may be heterogeneous (e.g., restructuring views of each other). Typically, one table is a base table and a second table is a restructuring view of the base table and may have been generated for faster query response, research, or the like. The restructuring view may have occurred naturally, or the base table may have been converted to the restructuring view using a series of operators and optionally, a middleware schema. The restructuring view maintenance system is preferably configured to monitor changes to the base table, including changes to data and to metadata. The maintenance system is configured to receive notification of a modification to a base table, investigate the modifications, and determine which operator(s) have been used to convert the base table to the restructuring view. For each modification to the base table, the system then determines, according to the type of modification and the type of transformation used, which of a selected group of actions to take to map the modification onto the restructuring view. The selected group of actions may include variously: insert, update, delete, rename relation, drop table, and rename column, according to the type of modification and the mapping of the relationship between the base table and the target table.

  Recently Added Patents
Digital image processing device and processing method thereof
Systems and methods for arranging and labeling cardiac episodes
Compositions, organisms, systems, and methods for expressing a gene product in plants using SCBV expression control sequences operable in monocots and dicots
Solid state lighting devices and associated methods of manufacturing
Luminescent substrate for liciferase
Regulating a supply voltage provided to a load circuit
Method for manufacturing light emitting diodes
  Randomly Featured Patents
Human cytomegalovirus (HCMV) cytotoxic T cell epitopes, polyepitopes compositions comprising same and diagnostic and prophylactic and therapeutic uses therefor
Method and apparatus for determining the positioning of volumetric sensor array lines
Method and system for predicting corrosion rates using mechanistic models
Drive attachment device, particularly for a paint brush
Gas filter
Equipment security mount
Slide projector with stationary slide magazines and automatic slide changer
Adaptive transform acoustic coding circuit formed in a single application specific integrated circuit of a mini disk system
Management of the file-modification time attribute in a multi-processor file server system
Imaging optical system and range finder