Using active rules to maintain data consistency in data warehouse systems

Shi Ming Huang, John Tait, Chun Hao Su, Chih Fong Tsai

研究成果: 書貢獻/報告類型篇章同行評審


Data warehousing is a popular technology, which aims at improving decision-making ability. As the result of an increasingly competitive environment, many companies are adopting a "bottom-up" approach to construct a data warehouse, since it is more likely to be on time and within budget. However, multiple independent data marts/cubes can easily cause problematic data inconsistency for anomalous update transactions, which leads to biased decision-making. This research focuses on solving the data inconsistency problem and proposing a temporal-based data consistency mechanism (TDCM) to maintain data consistency. From a relative time perspective, we use an active rule (standard ECA rule) to monitor the user query event and use a metadata approach to record related information. This both builds relationships between the different data cubes, and allows a user to define a VIT (valid interval temporal) threshold to identify the validity of interval that is a threshold to maintain data consistency. Moreover, we propose a consistency update method to update inconsistent data cubes, which can ensure all pieces of information are temporally consistent.

主出版物標題Progressive Methods in Data Warehousing and Business Intelligence
主出版物子標題Concepts and Competitive Analytics
發行者IGI Global
出版狀態已出版 - 2009


深入研究「Using active rules to maintain data consistency in data warehouse systems」主題。共同形成了獨特的指紋。