Breadcrumb

 
 

Database performance analysis and tuning : a comparative study of TPC-H benchmark on Oracle and DB2

Title:

Database performance analysis and tuning : a comparative study of TPC-H benchmark on Oracle and DB2

Zhou, Jing (2003) Database performance analysis and tuning : a comparative study of TPC-H benchmark on Oracle and DB2. Other thesis, Concordia University.

[img]
Preview
PDF
2850Kb

Abstract

This project concentrates on the TPC-H benchmark on Oracle 9i Enterprise Edition (EE) and DB2 Universal Database Version 7.2 Enterprise Edition (EE) on Windows2000 operating system. The TPC-H benchmark is a decision-support benchmark, consisting of a set of queries and refresh functions in order to simulate a real environment. There are several size factors supported by TPC to represent the database size. In this project, we use 1GB and 10GB database size. Furthermore, the test results are used to compare the performance of Oracle and DB2 on the Windows2000 operating system. Performance tuning is still a major issue in the database applications. There are two levels of tuning: system level and application level. We just focus on the application level tuning and study different factors and their effects on the DBMS' performance.

Divisions:Concordia University > Faculty of Engineering and Computer Science > Computer Science and Software Engineering
Item Type:Thesis (Other)
Authors:Zhou, Jing
Pagination:x, 115 leaves : ill. ; 29 cm.
Institution:Concordia University
Degree Name:Major reports (M.Comp.Sc.)
Program:Computer Science and Software Engineering
Date:2003
Thesis Supervisor(s):Butler, Gregory
ID Code:2113
Deposited By:Concordia University Libraries
Deposited On:27 Aug 2009 13:25
Last Modified:08 Dec 2010 10:24
Related URLs:
All items in Spectrum are protected by copyright, with all rights reserved. The use of items is governed by Spectrum's terms of access.

Repository Staff Only: item control page

Document Downloads

More statistics for this item...

Concordia University - Footer