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
Switching device, switch control method, and storage system
Portable gaming device and gaming system combining both physical and virtual play elements
Charge pump and method of biasing deep N-well in charge pump
Nitrogen-doped carbon-supported cobalt-iron oxygen reduction catalyst
Nanofibers containing latent reactive groups
Wireless device with extendable antenna
Inhibitors of human immunodeficiency virus replication
  Randomly Featured Patents
Bidirectional different speed ratio driving device with bidirectional manpower input
Protective glove provider
Motion inducing reverse shoulder assembly
Catalyst and method for producing lower aliphatic alcohols
Process of confection of polyamide compounds with natural fibers and compounds of polyamides with natural fibers
Electrical connector having a rear shielding member shielding tail sections of contact elements of the connector
Guidewire with an intermediate variable stiffness section
Method and system for compressing data which allows access to data without full uncompression
Method and system to enable the transport of sysplex timer protocols over generic frame procedure networks
Board game