Title :
A maintainable model of materialized view based on data warehouse
Author :
Xueyu Huang ; Qisheng Chen
Author_Institution :
Coll. of Appl. Sci., JiangXi Univ. of Sci. & Technol., GanZhou, China
Abstract :
Based on operator SPJ (Select-Project-Join) and the technology of self-maintainable view, this paper proposes a new maintainable model of materialized view; the proposed model contains two processes: the monitoring process and maintenance process, the first process is used to monitor the changes of basic tables; while the second process will automatically update the materialized view by auxiliary view, the results show that it can make the materialized view self-maintainable and reduce the storage space.
Keywords :
data warehouses; data warehouse; maintenance process; materialized view; monitoring process; operator SPJ; select-project-join; self-maintainable view; storage space; Association rules; Computers; Data models; Data warehouses; Databases; Maintenance engineering; Monitoring; auxiliary view; data warehouse; materialized view; message queue;
Conference_Titel :
Mechatronic Science, Electric Engineering and Computer (MEC), 2011 International Conference on
Conference_Location :
Jilin
Print_ISBN :
978-1-61284-719-1
DOI :
10.1109/MEC.2011.6025875
