Development of a Tuning Aid for Database Systems


The Transactions of the Korea Information Processing Society (1994 ~ 2000), Vol. 7, No. 11, pp. 3311-3322, Nov. 2000
10.3745/KIPSTE.2000.7.11.3311,   PDF Download:

Abstract

As the usage of database systems increases, the importance of database tuning techniques, which enable users to use database systems effectively, is emerging. This paper proposes a tuning aid for relational and object-relational database systems. The objective of the tuning aid is to guide users and/or system administrators to identify system performance characteristics of relational database systems and object-relational systems effectively, so that database systems could be tuned adequately. The design philosophy, test database, and tuning queries of the tuning aid are presented. It offers sixty-five queries in ten different categories. It has been applied to a commercial database system and the experimental results are also reported.


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]
S. H. Lee, K. D. Ahn, J. S. Oh, "Development of a Tuning Aid for Database Systems," The Transactions of the Korea Information Processing Society (1994 ~ 2000), vol. 7, no. 11, pp. 3311-3322, 2000. DOI: 10.3745/KIPSTE.2000.7.11.3311.

[ACM Style]
Sang Ho Lee, Ki Duk Ahn, and Jeong Seok Oh. 2000. Development of a Tuning Aid for Database Systems. The Transactions of the Korea Information Processing Society (1994 ~ 2000), 7, 11, (2000), 3311-3322. DOI: 10.3745/KIPSTE.2000.7.11.3311.