A Log Analyzer for Database Tuning 


Vol. 11,  No. 5, pp. 1041-1048, Oct.  2004
10.3745/KIPSTD.2004.11.5.1041


PDF
  Abstract

Database logs contain various information on database operations, but they are used to recover database systems from failures generally. This paper proposes a log analysis tool that provides useful information for database tuning. This tool provides users with information on workload organization, database schemas, and resources usages of queries. This paper describes the tool in views of its architecture, functions, implementation, and verification. The tool is verified by running the TPC-W benchmark, and representative analysis results are also presented.

  Statistics


  Cite this article

[IEEE Style]

S. H. Lee, S. J. Kim, S. H. Lee, "A Log Analyzer for Database Tuning," The KIPS Transactions:PartD, vol. 11, no. 5, pp. 1041-1048, 2004. DOI: 10.3745/KIPSTD.2004.11.5.1041.

[ACM Style]

Sang Hyup Lee, Sung Jin Kim, and Sang Ho Lee. 2004. A Log Analyzer for Database Tuning. The KIPS Transactions:PartD, 11, 5, (2004), 1041-1048. DOI: 10.3745/KIPSTD.2004.11.5.1041.