Browse > Article

View Maintenance Policy for considering MIN/MAX query in Data warehousing  

김근형 (제주대학교 경영정보학과)
김두경 (제주대학교 경영정보학과)
Publication Information
Journal of the Korea Institute of Information and Communication Engineering / v.6, no.8, 2002 , pp. 1336-1345 More about this Journal
Abstract
Materialized views in data warehouse play important roles in rapidly answering to users's requests for information Processing. More views in data warehouse, can respond to the users more rapidly because the user's requests may be processed by using only the materialized views with higher probabilities rather than accessing base relations. The limited duration, during which the materialized views are updated due to base relations's changes, limits the number of materialized views in data warehouse. In this paper, we propose efficient policy for updating the materialized views, which can save the update duration of views although MIN/MAX values frequently change in base relation. The policy updates the materialized views by distinguishing whether MIN/MAX values's changes in the base relation are insert value or delete value. Then, the number of accesses to the base relation is descreased when updating the MIN/MAX values in the materialized views.
Keywords
Citations & Related Records
연도 인용수 순위
  • Reference
1 김민정, 정연돈, 박웅제, 김명호, '데이터 큐브에서 세분화된 뷰실체화 기법', 정보과학회논문지, VOL.28, NO.4, pp.587-595, 2001
2 Y. Kotidis, N. Roussopoulos,, ‘A Case for Dynamic View Management’, ACM Transactions on Database Systems, Vol.26, No.4, pp.388- 423, December 2001   DOI   ScienceOn
3 조재희, '데이터웨어하우징 기술을 이용한 DB 마케팅 전략에 관한 연구', 정보기술과 데이터베이스 저널, 제 6권, 제1호, pp.104-113, 1998
4 D. Theodoratos, M. Mouzeghoub,' A General Framework for the View Selection Problem for Data Warehouse Design and Evolution', In proceedings of ACM SIGMOD Conference, pp.1-8, 2000
5 이기용, 김명호, '데이타웨어하우스에서 효과적인 점진적 뷰 관리', 정보과학회논문지, VOL. 27 NO. 02, pp. 175-184, 2000
6 윤원식, 신동천, '데이타웨어하우스 환경에서 조인비용을 기반으로 한 실체뷰 선택알고리즘', VOL.28, NO.1, 03, pp.31-41, 2001
7 정희정, 김동욱, 김종수, 이윤준, 김명호, 'OLAP에서 MAX-of-SUM 질의의 효율적인 처리기법', 정보과학회논문지, VOL. 27, NO. 02, pp. 165-174, 2000
8 L.S. Colby, A. Kawaguchi, D.F. Lieuwen, I.S. Mumick, 'Supporting Multiple View Maintenance Policies', In proceedings of ACM SIGMOD Conference, pp.405-416, 1997
9 D. Agrawal, A.El Abbadi, A. Singh, T. Yurek, 'Efficient View Maintenence at Data Warehouse', In proceedings of ACM SIGMOD Conference, pp.417-427, 1997
10 양우석, 김명호, 'OLAP 환경에서 다중점 MAX/MIN 질의의 효율적인 처리기법', 정보과학회논문지, VOL.27 NO.1, pp. 13-21, 2000
11 I.S. Mumick, D. Quass, B.S. Mumick, 'Maintenance of Data Cubes and Summary Tables in a Warehouse', In proceedings of ACM SIGMOD Conference, pp.100-111, 1997
12 Y. Kotidis, N. Roussopoulos,' DynaMat: A Dynamic View Management System for Data Warehouses', In proceedings of ACM SIGMOD Conference, pp.371-382, 1999
13 Y. Zhuge, H. Garcia-Molina, J. Hammer, J. Wodim, 'View Maintenance in a Warehousing Environment', In proceedings of ACM SIGMOD Conference, pp.316-327, 1995