%0 Journal Article
%T Consistency Algorithm for Data Warehouse On-line Maintenance
数据仓库联机维护中一致性问题的研究
%A LI Zi-mu
%A SUN Li-min
%A ZHOU Xing-ming
%A
李子木
%A 孙利民
%A 周兴铭
%J 软件学报
%D 1999
%I
%X A warehouse is a data repository containing integrated information for efficient querying and analysis, which data come from the databases or the other info-sources at different places. Materialized view is the primary information entity stored in the data warehouse. It must be refreshed when the corresponding data changed in the database. Consistency problem will be arisen during materialized views on-line maintenance because of the invention of OLAP query. In this paper, the authors introduce a new algorithm, MVCA (multiversion compensating algorithm), using multiversion and compensating techniques, along with acknowledgement mechanism to synchronize the maintenance process between the database and the data warehouse so as to ensure the data consistency. At the end of the paper, the authors illustrate the application of the algorithm by a typical example.
%K Data warehouse
%K materialized view
%K on-line maintenance
%K data consistency
%K MVCA(multiversion compensating algorithm)
数据仓库
%K 实体化视图
%K 联机维护
%K 数据一致性
%K MVCA(multiversion
%K compensating
%K algorithm).
%U http://www.alljournals.cn/get_abstract_url.aspx?pcid=5B3AB970F71A803DEACDC0559115BFCF0A068CD97DD29835&cid=8240383F08CE46C8B05036380D75B607&jid=7735F413D429542E610B3D6AC0D5EC59&aid=E4D73A269081C104&yid=B914830F5B1D1078&vid=F3090AE9B60B7ED1&iid=5D311CA918CA9A03&sid=525CF7714FCB18E2&eid=F2947E14627CD734&journal_id=1000-9825&journal_name=软件学报&referenced_num=5&reference_num=3