Browse > Article

Policy of Managing Materialized Views by Orienting toward Self-Maintenance in Data Warehousing  

Kim, Keun-Hyung (제주대학교 경영정보학과)
Publication Information
Asia pacific journal of information systems / v.13, no.4, 2003 , pp. 191-206 More about this Journal
Abstract
More views in data warehouse, can respond to the users more rapidly because the user's requests might be processed by accessing only the materialized views with higher probabilities rather than accessing base relations. But, the update duration for maintaining materialized views limits the number of materialized views in data warehouse. In this paper, we propose the algorithm for reducing update duration of materialized views, of which aggregation functions are maintained by self-maintenance. We also implement the proposed algorithm and evaluate the performance of the algorithm.
Keywords
Citations & Related Records
연도 인용수 순위
  • Reference
1 양우석, 김명호, 'OLAP 환경에서 다중점 MAX/MIN 질의의 효율적인 처리기법' 정보과학회논문지, Vol. 27, No.1, 2000, pp. 13-21
2 이기용, 김명호, '데이타웨어하우스에서 효과적인 점진적 뷰 관리' 정보과학회논문지, Vol. 27, No. 02, 2000, pp. 175-184
3 정희정, 김동욱, 김종수, 이윤준, 김명호, 'OL AP에서 MAX-of-SUM 질의의 효율적인 처리기법,' 정보과학회논문지, Vol. 27, No.2, 2000, pp. 165-174
4 I.S.Mumick, D.Quass, B.S.Mumick, 'Maintenance of Data Cubes and Summary Tables in a Warehouse,' In proceedings of ACM SIGMOD Conference, 1997, pp. 100-111
5 Y. Kotidis, N. Roussopoulos, 'DynaMat: A Dynamic View Management System for Data Warehouses,' In proceedings of ACM SIGMOD Conference, 1999, pp. 371-382
6 D. Theodoratos, M. Mouzeghoub, 'A General Framework for the View Selection Problem for Data Warehouse Design and Evolution,' In proceedings of ACM SIGMOD Conference, 2000, pp. 1-8
7 Y. Zhuge, H. Garcia-Molina, J. Hammer, J. Wodim, 'View Maintenance in a Warehousing Environment,' In proceedings of ACM SIGMOD Conference, 1995, pp. 316-327
8 Y. Kotidis, N. Roussopoulos., 'A Case for Dynamic View Management,' ACM Transactions on Database Systems, Vol. 26, No.4, December 2001, pp. 388-423
9 윤원식, 신동천, '데이타웨어하우스 환경에서 조인비용을 기반으로 한 실체뷰 선택알고리즘,' Vol. 28, No.1, 03, pp. 31-41, 2001
10 김민정, 정연돈, 박응제, 김명호, '데이터 큐브에서 세분화된 뷰실체화 기법,' 정보과학회논문지, Vol. 28, No.4, 2001, pp. 587-595
11 조재희, '데이터웨어하우징 기술을 이용한 DB 마케팅 전략에 관한 연구,' 정보기술과 데이터베이스 저널, 제6권, 제1호, 1998, pp. 104-113
12 L.S.Colby, A.Kawaguchi, D.F.Lieuwen, IS. Mumick, 'Supporting Multiple View Maintenance Policies,' In proceedings of ACM SIGMOD Conference, 1997, pp. 405-416
13 D. Agrawal, A EI Abbadi, A Singh, T. Yurek, 'Efficient View Maintenence at Da ta Warehouse,' In proceedings of ACM SIGMOD Conference, 1997, pp. 417-427