Browse > Article
http://dx.doi.org/10.3745/KIPSTD.2003.10D.3.407

An Extension of the DBMax for Data Warehouse Performance Administration  

Kim, Eun-Ju (삼성전자)
Young, Hwan-Seung (이화여자대학교 컴퓨터학과)
Lee, Sang-Won (성균관대학교 정보통신공학부)
Publication Information
The KIPS Transactions:PartD / v.10D, no.3, 2003 , pp. 407-416 More about this Journal
Abstract
As the usage of database systems dramatically increases and the amount of data pouring into them is massive, the performance administration techniques for using database systems effectively are getting more important. Especially in data warehouses, the performance management is much more significant mainly because of large volume of data and complex queries. The objectives and characteristics of data warehouses are different from those of other operational systems so adequate techniques for performance monitoring and tuning are needed. In this paper we extend functionalities of the DBMax, a performance administration tool for Oracle database systems, to apply it to data warehouse systems. First we analyze requirements based on summary management and ETL functions they are supported for data warehouse performance improvement in Oracle 9i. Then, we design architecture for extending DBMax functionalities and implement it. In specifics, we support SQL tuning by providing details of schema objects for summary management and ETL processes and statistics information. Also we provide new function that advises useful materialized views on workload extracted from DBMax log files and analyze usage of existing materialized views.
Keywords
Data Warehouse; Performance Administration; Performance Monitoring; Sql Tuning; Oracle9I; Summary Management; Materialized View;
Citations & Related Records
연도 인용수 순위
  • Reference
1 (주)엑셈, DBMax 사용자 매뉴얼, 2001
2 Surajit Chaudhuri, Umesh Dayal, An Overview of Data Warehousing and OLAP Technology, ACM SIGMOD Record, 1997   DOI   ScienceOn
3 William A. Giovinazzo, Objected-Oriented Data Warehouse Design, Prentice Hall PTR, 2000
4 Oracle Corp, Oracle 9i Data Warehousing Guide, June, 2001
5 Oracle white Paper, Oracle 9i Materialized Views, May, 2001
6 Oracle Corp, Oracle 9i SQL Reference, June, 2001
7 조종암, Technical Notes: Rapid Database Problem Identification, Oracle Korea Megazine, Vol.27, pp.93-98, 2001
8 Benoit Dageville, Mohamed Zait, SQL Memory management in Oracle 9i, VLDB 2002
9 (주)엑셈, http://www.ex-em.com/
10 조종암, 이상원, DBMax: 데이터베이스 성능 모니터링 도구, 한국데이터베이스학회 2001 발표논문집, 제17권 제2호, pp.287-294, 2001
11 Oracle Corp., Oracle Enterprise Manager Database Tuning Pack, June, 2001
12 Jonathan Coldstein, Per-Ake Larson, Optimizing Queries Using Materialized VIews: A Practical, Scalable Solution, ACM SIGMOD, 2001   DOI   ScienceOn
13 Oracle Corp, Oracle 9i Reference, June, 2001
14 Oracle Corp, Oracle 9i Supplied PL/SQL Pack-ages and Types Reference, June, 2001
15 (주)엑셈, BizMax User's Guide, 2002
16 Oracle white paper, ETL Processing within Oracle 9i, May, 2001
17 Agrawal, S., Chaudhuri, S., Narasayya, V., Automated Selection of Materialized Views and Indexes for SQL databases, VLDB 2000
18 Guy M. Lohman, Sam S. Lightstone, SMART: Making DB2(more) Automatic, VLDB 2002