Asia pacific journal of information systems

The Korea Society of Management Information Systems (한국경영정보학회)
권호 표지

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

데이터웨어하우징에서 자립유지를 지향하는 실체뷰 관리 정책

  • 김근형 (제주대학교 경영정보학과)
  • Published : 2003.12.31
Download PDF
⟨ Previous Next ⟩

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

References

  1. 김민정, 정연돈, 박응제, 김명호, '데이터 큐브에서 세분화된 뷰실체화 기법,' 정보과학회논문지, Vol. 28, No.4, 2001, pp. 587-595
  2. 양우석, 김명호, 'OLAP 환경에서 다중점 MAX/MIN 질의의 효율적인 처리기법' 정보과학회논문지, Vol. 27, No.1, 2000, pp. 13-21
  3. 윤원식, 신동천, '데이타웨어하우스 환경에서 조인비용을 기반으로 한 실체뷰 선택알고리즘,' Vol. 28, No.1, 03, pp. 31-41, 2001
  4. 이기용, 김명호, '데이타웨어하우스에서 효과적인 점진적 뷰 관리' 정보과학회논문지, Vol. 27, No. 02, 2000, pp. 175-184
  5. 정희정, 김동욱, 김종수, 이윤준, 김명호, 'OL AP에서 MAX-of-SUM 질의의 효율적인 처리기법,' 정보과학회논문지, Vol. 27, No.2, 2000, pp. 165-174
  6. 조재희, '데이터웨어하우징 기술을 이용한 DB 마케팅 전략에 관한 연구,' 정보기술과 데이터베이스 저널, 제6권, 제1호, 1998, pp. 104-113
  7. 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
  8. 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
  9. Y. Kotidis, N. Roussopoulos, 'DynaMat: A Dynamic View Management System for Data Warehouses,' In proceedings of ACM SIGMOD Conference, 1999, pp. 371-382
  10. Y. Kotidis, N. Roussopoulos., 'A Case for Dynamic View Management,' ACM Transactions on Database Systems, Vol. 26, No.4, December 2001, pp. 388-423
  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, 1997, pp. 100-111
  12. 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
  13. 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