An Extension of the DBMax for Data Warehouse Performance Administration


The KIPS Transactions:PartD, Vol. 10, No. 3, pp. 407-416, Jun. 2003
10.3745/KIPSTD.2003.10.3.407,   PDF Download:

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.


Statistics
Show / Hide Statistics

Statistics (Cumulative Counts from September 1st, 2017)
Multiple requests among the same browser session are counted as one view.
If you mouse over a chart, the values of data points will be shown.


Cite this article
[IEEE Style]
E. J. Kim, H. S. Young, S. W. Lee, "An Extension of the DBMax for Data Warehouse Performance Administration," The KIPS Transactions:PartD, vol. 10, no. 3, pp. 407-416, 2003. DOI: 10.3745/KIPSTD.2003.10.3.407.

[ACM Style]
Eun Ju Kim, Hwan Seung Young, and Sang Won Lee. 2003. An Extension of the DBMax for Data Warehouse Performance Administration. The KIPS Transactions:PartD, 10, 3, (2003), 407-416. DOI: 10.3745/KIPSTD.2003.10.3.407.