An Extension of the DBMax for Data Warehouse Performance Administration 


Vol. 10,  No. 3, pp. 407-416, Jun.  2003
10.3745/KIPSTD.2003.10.3.407


PDF
  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
  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.

Forms

Search
(IN TITLE, AUTHOR, ABSTRACT,KEYWORDS)

Advanced Search ▼

POPULAR KEYWORDS
(TOP 10 KEYWORDS)

Recent Publications
(LAST 3 YEARS)

Old Journals

Indexing

All publications of TKIPS is indexed in DOI, EBSCO, Google Scholar, Crossref, and CrossCheck.

TKIPS is also selected as the Journal for Accreditation by NRF (National Research Foundation of Korea).

Related Journals