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

Image Number 2 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
Case for electronic device
Fluid intake and content management system
Expression of dirigent gene EG261 and its orthologs and paralogs enhances pathogen resistance in plants
Automatic stop and restart device for an engine
Sensor chip, sensor cartridge, and analysis apparatus
One-dimensional metal nanostructures
Hand mixer
  Randomly Featured Patents
Centrifugation system having an interface detection surface
Method for thermal characterization under non-uniform heat load
Sheet media handling system
Process for dumping of particulate solid waste materials in underground salt enclosed cavitives
Computer assisted camera control system
Container assembly with flexible lid seal and releasing arrangement
Process for preparing mixtures of substituted-hexahydro-acetonaphthones
Coordinates detecting apparatus for independently correcting coordinates
Digital camera