Transaction Reordering and Grouping for Continuous Data Loading

With the increasing popularity of operational data warehousing, the ability to load data quickly and continuously into an RDBMS is becoming more and more important. However, in the presence of materialized join views, loading data concurrently into multiple base relations of the same materialized join view can cause a severe deadlock problem. To solve this problem, we propose reordering the data to be loaded so that at any time, for any materialized join view, data is only loaded into one of its base relations. Also, for load transactions on the relations that contain "aggregate" attributes, we propose using pre-aggregation to reduce the number of SQL statements in the load transactions. The advantages of our methods are demonstrated through experiments with a commercial parallel RDBMS.

• Type: Conference
• Year: 2006
• Where: BIRTE
• Authors: Gang Luo, Jeffrey F. Naughton, Curt J. Ellmann, Michael Watzke
• Keywords: Base Relations, BIRTE 2006, Business, Materialized Join View, Operational Data Warehousing