Chapter 14: Database Systems Performance Analysis

 < Free Open Study > 



14.1 Introduction

The previous chapter addressed the issue of operating systems evaluation. It focused on the use of testbeds and commercial-grade software to assess the relative performance of four operating systems. This chapter follows a similar path; we will be evaluating industrial-grade software products used in many applications. We will discuss database on-line transaction processing as the overall application domain. The main focus, however, is the assessment of four commercial-grade database systems running on a fixed set of testbed hardware and systems software (the operating system).

Four database systems currently compete for the top position in the database market, each claiming to be the fastest in the world. These databases are IBM DB2, Informix UDB, Microsoft SQL Server, and Oracle 8i. This chapter demonstrates which of these four database systems is the "best" not only in terms of speed but also cost.

This chapter is divided into three main sections. First, a description of the four systems that were used to test the databases is given. In the next section the results of a PC performance benchmark are shown to prove that all the PC hardware configurations were the same. The second portion details the procedures taken by each database evaluation team to run a standard benchmark on its test database. Finally, the results of the standard benchmark and a cost analysis show which database is the "best."



 < Free Open Study > 



Computer Systems Performance Evaluation and Prediction
Computer Systems Performance Evaluation and Prediction
ISBN: 1555582605
EAN: 2147483647
Year: 2002
Pages: 136

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net