Zhou, Jing (2003) Database performance analysis and tuning : a comparative study of TPC-H benchmark on Oracle and DB2. [Graduate Projects (Non-thesis)] (Unpublished)
Preview |
Text (application/pdf)
2MBMQ77729.pdf |
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 > Gina Cody School of Engineering and Computer Science > Computer Science and Software Engineering |
|---|---|
| Item Type: | Graduate Projects (Non-thesis) |
| Authors: | Zhou, Jing |
| Pagination: | x, 115 leaves : ill. ; 29 cm. |
| Institution: | Concordia University |
| Degree Name: | M. Comp. Sc. |
| Program: | Computer Science |
| Department (as was): | Department of Computer Science |
| Date: | 2003 |
| Thesis Supervisor(s): | Butler, Gregory |
| Identification Number: | QA 76 M26+ 2003 no.21 |
| ID Code: | 2113 |
| Deposited By: | Concordia University Library |
| Deposited On: | 27 Aug 2009 17:25 |
| Last Modified: | 20 Oct 2022 20:45 |
| Related URLs: |
Repository Staff Only: item control page
Download Statistics
Download Statistics