Browse > Article
http://dx.doi.org/10.3745/KIPSTD.2004.11D.5.1041

A Log Analyzer for Database Tuning  

Lee, Sang-Hyup (숭실대학교 대학원 컴퓨터학과)
Kim, Sung-Jin (숭실대학교 대학원 컴퓨터학과)
Lee, Sang-Ho (숭실대학교 컴퓨터학부)
Publication Information
The KIPS Transactions:PartD / v.11D, no.5, 2004 , pp. 1041-1048 More about this Journal
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 work-load 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.
Keywords
Database Log Analysis; Database Workload; Database Tuning;
Citations & Related Records
연도 인용수 순위
  • Reference
1 Log Explorer, ISoft Inc., http://www.logexplorer.co.kr/
2 Oracle Co., Oracle9i Lite SQL Reference Release 5.0.2, http://otn.oracle.coml documentation/oracle9i_arch_901.html
3 Microsoft Co., SQL Server 2000 Books Online, http://www.microsoft.com/downloads/
4 Transaction Processing Performance Council, http://www.tpc.orgl
5 Window NTManageIT Log Analyzer, Genesis, http://www.genesis.co.kr/
6 Cyrano WorkBench, (주) 3rdinfo Inc, http://www.3rdinfo.co.kr/
7 M. Mahoui and S. J Cunningham, 'A Comparative Transaction Log Analysis of Two Computing Collections,' European Conference on Digital Libraries, pp.418-423, 2000
8 D. E. Shasha, 'Database Tuning A Principles Approach,' Prentice Hall, 1992
9 D. E. Shasha, 'Tuning Databases for High Performance,' ACM Computing Surveys, Vol.28, No.1, pp.113-115, 1996   DOI
10 W. D. Smith, 'TPC-W: Benchmarking an Ecommerce Solution,' 2002. http://www.tpc.org/tpcw/TPC-W_Wh.pdf
11 Y. Somin and A. Rodriguez, 'Workload Characterization and Capacity Planning for DB2 Universal Database,' International Computer Measurement Group Conference, pp.567-576, 2002
12 P. S. Yu, M. S. Chen, H. U. Heiss and S. Lee, 'On Workload Characterization of Relational Database Environments,' IEEE Transactions on Software Engineering, Vol.18, No.4, pp.347-355, 1992   DOI   ScienceOn
13 Korea Computer Communications Ltd., UniSQL/X User's Manual Volumel, 2 Release 4.0, 1996
14 Korea Computer Communications Ltd., UniCAS user's manual release 4.5, 2001
15 S. Chaudhuri and R. Narasayya, 'AutoAdmin 'What-if' Index Analysis Utility,' ACM SIGMOD Conference, pp. 367-378, 1998
16 Korea Computer Communications Ltd., UniSQL/X administration guide release 4.0, 1996
17 LOG Analysis Tool,(주)한국비지네스서비스, http://www.kbscom.co.kr/