Resources Contact Us Home
Efficient update methods for large volume data updates in data warehouses

Image Number 5 for United States Patent #8055609.

A system and method for ensuring large and frequent updates to a data warehouse. The process leverages a set of temporary staging tables to track the updates. A set of intermediate steps are performed to accomplish bulk deletions of the outdated changed records, and perform modifications to the map tables for models such as snowflake. Finally, bulk load operations load the updates and insert them into the final dimension tables. The process ensures performance comparable to insertion-only schemes with at most only slight performance degradation. Furthermore, a modified process is applied on the newfact data warehouse dimension model. The process can be readily adapted to handle star schema and other hierarchical data warehouse models.

  Recently Added Patents
Pixel structure of organic light emitting device
System and method to assess and report the health of landing gear related components
Front end for RF transmitting-receiving systems with implicit directional control and time-multiplexing method in submicron technology
Method of reducing acetaldehyde in polyesters, and polyesters therefrom
Electronic device, communication control method of electronic device, and information terminal device
Semiconductor IC including pulse generation logic circuit
Polymer-encapsulated colorant nanoparticles
  Randomly Featured Patents
Method for the freeze-pressure molding of metallic powders
Porous orbital implant structure
Cathode wire filament for x-ray tube applications
System and method for managing storage and retrieval of media data including dynamic linkage of media data files to clips of the media data
System and method for configuring a document
Geometrical object representation system and method for efficiently representing a geometrical object for use by a computer graphics system
Reactive axle and suspension for a vehicle
Semiconductor device and method of manufacturing same
Pharmaceutical compositions for the treatment of virus infection
Transmission electron microscope equipped with energy filter