申请试用
HOT
登录
注册
 
Transaction Reordering and Grouping for Continuous Data Loading

Transaction Reordering and Grouping for Continuous Data Loading

陈重丶
/
发布于
/
1796
人观看
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.
0点赞
0收藏
0下载
相关推荐
确认
3秒后跳转登录页面
去登陆