Abstract
This chapter presents the database systems performance analysis. It evaluates industrial-grade software products used in many applications. This chapter discusses 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. 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. Based on the assumptions made to compare the four systems, it is clear that on a performance and cost level IBM's DB2 is the best choice. Of course, this is subject to interpretation. If one is not concerned with memory use on his/her system or do not care about configuring the system, then Microsoft SQL Server can be very appealing, since one can plug and play and be ready to go with it. Using IBM's DB2 requires more administration before the performance shown in this chapter is achieved. Ultimately, it depends on what one plans to do with the database that becomes the decision factor.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callMore From: Computer Systems Performance Evaluation and Prediction
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
