Development of a Tuning Aid for Database Systems 


Vol. 7,  No. 11, pp. 3311-3322, Nov.  2000
10.3745/KIPSTE.2000.7.11.3311


PDF
  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


  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.