DocumentCode
3397125
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
fYear
2011
fDate
19-22 Aug. 2011
Firstpage
1974
Lastpage
1977
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;
fLanguage
English
Publisher
ieee
Conference_Titel
Mechatronic Science, Electric Engineering and Computer (MEC), 2011 International Conference on
Conference_Location
Jilin
Print_ISBN
978-1-61284-719-1
Type
conf
DOI
10.1109/MEC.2011.6025875
Filename
6025875
Link To Document