Database Comparison of Sql Server 2000, Access, Mysql, Db2, and Oracle

1164 WordsJun 11, 20055 Pages
Introduction This paper will compare and contrast five different database management systems on six criteria. The database management systems (DBMS) that will be discussed are SQL Server 2000, Access, MySQL, DB2, and Oracle. The criteria that will be compared are the systems ' functionality, the requirements that must be met to run the DBMS, the expansion capabilities – if it is able to expand to handle more data over time, the types of companies that typically use each one, the normal usage of the DBMS, and the costs associated with implementing the DBMS. System functionality Microsoft Access is a database engine and development environment in one package. It is typically workstation-based, and designed to be easy to use, even for…show more content…
Typically, an Access application will be a single-user installation on a workstation. All of the other DBMS are suited to handle multi-user concurrency and offer a lot of features around transaction processing and record locking to prevent issues from arising. These databases can be found in client/server applications, as well as applications that utilize internet or intranet pages as a front end. Cost The cost for the different DBMS varies widely (in fact, from nothing, to millions of dollars). A standalone version of Access (without an upgrade), costs about $339. It is also included with the Office XP Professional and Developer Editions. MySQL is free – if the application you are developing is open-source. If the application is proprietary, then the cost will be $495 per database server, with no cost for client access licenses. The more database servers that are purchased, the lower the cost per server is, down to $175 per server if 250 or more are purchased. Now it gets a bit more complicated. DB2 Enterprise, in a server with a single processor, will cost $25,000. At the high end, it will cost $800,000 for a 32 processor version. If the company wants OLAP and Data Mining, those are additional, with prices up to $2,016,000 for a 32 processor implementation. SQL Server is a bit more reasonable – and OLAP and Data Mining are included in the

More about Database Comparison of Sql Server 2000, Access, Mysql, Db2, and Oracle

Open Document