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

Topics: Database management system, Microsoft Windows, Microsoft Pages: 4 (1180 words) Published: June 26, 2005
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 users with no experience. However, it also provides advanced functionality for experienced users. MySQL is the largest open-source RDMBS, and it is server-based, as well as the rest of the DBMS that will be discussed. According to the website, it offers high reliability and performance, easy use and deployment, freedom from platform lock-in by providing ready access to source code, and cross-platform support. SQL Server is an enterprise class RDBMS from Microsoft. It is part of the Back Office Suite of products. Although it is always server-based in production, it can be client-based in development. DB2 is also an enterprise-class DBMS, produced by IBM. It offers some object-oriented functionality, as well as cross-platform compatibility, and is server-based. Finally, Oracle offers much of the same functionality as DB2, with cross-platform capability, and some object-oriented features. It, as well, is server-based. System Requirements

There is a correlation between the complexity of the DBMS and the system requirements. For instance, Access can be installed on any Windows-based operating system from Windows 95 and above. SQL Server, in the widely used Standard and Enterprise editions, is also strictly...

References: Chigrik, Alexander, Oracle 9i Database vs DB2 v8.1 (n.d.), retrieved April 6, 2005, from
Chigrik, Alexander, SQL Server 2000 vs Access 2000 (n.d.), retrieved April 6, 2005, from
Chigrik, Alexander, SQL Server 2000 vs DB2 v8.1 (n.d.), retrieved April 6, 2005, from
Chigrik, Alexander, SQL Server 2000 vs MySQL version 4.1 (n.d.), retrieved April 6, 2005, from
Chigrik, Alexander, SQL Server 2000 vs Oracle 9i (n.d.), retrieved April 6, 2005, from
MySQL Licensing Policy (n.d.), retrieved April 6, 2005, from the MySQL company website:
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • A Comparison of Oracle and MySQL for Searchers of Ideal DBMS Essay
  • SQL vs. Oracle Essay
  • Oracle Database: SQL Fundamentals Essay
  • Essay about DATABASE SQL
  • Sql Introduction to Database Essay
  • Ibm Db2 vs Oracle Essay
  •  Analyses and Compare the Physical Storage Structures and Types of Available Index of the Latest Versions of: 1. Oracle 2. Sql Server 3....
  • Database Sql Server Research Paper

Become a StudyMode Member

Sign Up - It's Free