A Comparative Investigation and Evaluation of Oracle9i Release 2 (9.2.0.1.0) and Microsoft SQL Server 2000 Service Pack 3 with respect to Performance and Scalability
     
  INTRODUCTORY STATEMENT    
 
HOME
Project Proposal
1st Presentation
Literature Survey
My Dairy
2nd Presentation
September Paper
Project Poster
Final Presentation
Project Milstones
Final Thesis
 
 
 


Performance and Scalability are two important factors determining database availability and reliability. This is especially true for modern computer systems due to the inclusion of the Internet in Online Transaction Processing (OLTP) and E-commerce applications which use databases. This trend has been motivated by the need to accommodate many users simultaneously accessing the databases from many different networked locations. This evolution gave birth to an enduring need for high throughput, good response time, excellent data consistency and concurrency control. This project evaluated SQL Server 2000 and Oracle 9i with respect to performance and scalability. Initial performance tests showed that at low to medium workload both database systems behaved in a similar fashion in terms of throughput, response time and resource utilisation. At high load however Oracle 9i emerged superior in all cases.

The computer systems used for this evaluation both run Microsoft Windows Server 2003 Standard Edition. The Oracle 9i PC has an Intel(R) Xeon(TM) CPU 2.40 Hz with 1.00 GB of RAM while the SQL server is an Intel(R) Pentium(R) 4 CPU 2.80GHz with 1.00 GB of RAM....Sibanda P

........SUPERVIOR : MR JOHN EBDEN

 
CSC DEPARTMENT
     
       
 
Copyright 2005 Phathisile Sibanda. Rhodes University
All rights reserved.
07/11/05