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
Snapshots in de-duplication
Protein purification
System for providing access to playable media
Hydrolases, nucleic acids encoding them and methods for making and using them
Modular authoring and visualization of rules using trees
Digital signal processing apparatus, liquid crystal display apparatus, digital signal processing method and computer program
O-space imaging: highly efficient parallel imaging using complementary nonlinear encoding gradient fields and receive coil geometries
  Randomly Featured Patents
Storage unit
Occupant protection device
Tetrahydrobetacarboline compounds
Gastrointestinal needle mechanism
Remotely managing a data processing system via a communications network
Pressure converter valve
Measuring the DC properties of a signal path between transmitter and receiver
Diagnostic process using sodium tyropanoate
Integrated optical lightguide device
Rod antenna for use in a portable transmitting / receiving apparatus