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.
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 mysql.com 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.
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 Windows-based, but must be run on Windows NT or 2000 Servers. The personal and development editions of SQL Server may be run on Windows NT Workstation, and Windows 2000 and XP Professional, in addition to the server platforms. MySQL has a wide variety of platforms, including the Windows platforms, Sun Solaris, FreeBSD, Mac OS X, and HP-UX, to list a few. DB2 will run on Windows NT 4 and higher, Sun Solaris, HP-UX and Linux....
... middle of paper ...
This paper was written to show the similarities and differences in five different databases. It compared Access, MySQL, SQL Server, DB2, and Oracle in six different areas. It found many similarities in functionality, but large diversity in pricing.
Chigrik, Alexander, Oracle 9i Database vs DB2 v8.1 (n.d.), retrieved April 6, 2005, from http://www.mssqlcity.com/Articles/Compare/oracle_vs_db2.htm
Chigrik, Alexander, SQL Server 2000 vs Access 2000 (n.d.), retrieved April 6, 2005, from http://www.mssqlcity.com/Articles/Compare/sql_server_vs_access.htm
Chigrik, Alexander, SQL Server 2000 vs DB2 v8.1 (n.d.), retrieved April 6, 2005, from http://www.mssqlcity.com/Articles/Compare/sql_server_vs_db2.htm
Chigrik, Alexander, SQL Server 2000 vs MySQL version 4.1 (n.d.), retrieved April 6, 2005, from http://www.mssqlcity.com/Articles/Compare/sql_server_vs_mysql.htm
Chigrik, Alexander, SQL Server 2000 vs Oracle 9i (n.d.), retrieved April 6, 2005, from http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm
MySQL Licensing Policy (n.d.), retrieved April 6, 2005, from the MySQL company website: http://www.mysql.com/company/legal/licensing/
Need Writing Help?
Get feedback on grammar, clarity, concision and logic instantly.Check your paper »
- Databases and Communications Today, data is the most important of our life. Different companies handle a large number of data. The success of this or that business strongly depends on database arrangement and communication means, Database arrangement and communication are in the high demand among all organizations. The database and communication technologies are closely interrelated. The accessibility of database depends on used communication technologies. For instance, the employees may access the database not only from their workplaces but also from different places and use different communication technologies, including mobile phones, the internet mailing programs, e... [tags: Data management, Database, Media technology]
931 words (2.7 pages)
- Comparison of features between MY SQL server 5.5 and MS SQL server 2014 There are many SQL (structured query language) servers which are also called DBMS ( database management systems ) out there in the market but the few of them are very famous and widely used, to name some of them are MS SQL, ORACLE and MY SQL.MY SQL is also owned by oracle corporation. Although there are many similarities between MS SQL and MY SQL there are also some key differences which set them apart from each other, which we will be going to discuss some of them.... [tags: SQL, Database management system, MySQL]
1190 words (3.4 pages)
- SQL server 2016 In-memory OLTP: In SQL Server 2014 Microsoft introduced a revolutionary tool called In-Memory OLTP. In SQL server 2016 this is even better. This feature allows users to keep data into memory resident tables(memory optimized) and user may not be aware that he/she is working with memory optimized tables rather than disk space tables . SQL server engine works in different way if data is stored in memory optimized tables. It is not needed to read the pages into cache from the disk when memory optimized data are accessed.... [tags: SQL, Relational model, Database]
819 words (2.3 pages)
- Industry Standard Relational Database Management Systems In nearly all business industries a database would be required as businesses always need to sort data as they are related to finances to estimate their profits, look at revenue margins, net profits, deducting taxes these are all processes that can be done by implementing a database. Databases conclude all the financial industries as they are correlated to businesses that involve transactions of money as all organisations exist to produce an income unless they are charity or public service and even those are affiliated with a relational database to classify employees or client record.... [tags: Database, SQL, Microsoft, Relational model]
1194 words (3.4 pages)
- Introduction to NoSQL For storing the data in organized manner we use the traditional relational databases and in these databases the information is stored in the form tables. NoSQL is an abbreviation or a short form for ‘Not only SQL’. Carlo Strozzi in 1998 for the first time used this name to refer their open source relational database, which didn’t exposed its SQL interface. As this was different from the relational databases so on later stage he suggested to name it NoRel (No Relational) instead of NoSQL (Not only SQL).... [tags: Database, SQL, ACID, Data management]
1298 words (3.7 pages)
- The nature of our business requires us to have a flexible sales force. Because of that detail we need to be receptive to the needs of our mobile workforce. The most critical tool involved in their success is the ability to reliably connect and access our company networks. These connections can be from employees using company issued laptops or personal computers used from home or on the road. For the most part we have addresses the needs of our sales force on a case by case basis but going forward we really need to ensure we have a defined policy to streamline remote access.... [tags: windows server, network access]
1136 words (3.2 pages)
- Chapter three: Case Study In the previous chapter we generally mentioned Graph databases together with other types of NoSQL database; however, since one of the main goals of this thesis is giving a simple analysis for two systems, it is necessary to understand what main features and what these systems have. Consequently, in this chapter we will find what are the most Databases that have the best availability and scalability. First of all, we will choose a simplest type of the relational database and describe it which is MySQL.... [tags: SQL, Database, MySQL, Databases]
3366 words (9.6 pages)
- Over the last thirty plus years, in which computer software applications have been vital to business operations, the concept of client/server applications has evolved. In the early 1980’s the term, Client/Server, primarily referenced capabilities of new powerful centralized hardware. The computer world is different today and the concept is better defined as a system where the different logical components are separated from each other. The first of the three basic logical components is the Presentation Logic.... [tags: Information Technology]
991 words (2.8 pages)
- Comparison between Mandatory Access Control (MAC), Discretionary Access Control (DAC) and Role Based Access Control (RBAC) Models in Database Management Systems Abstract This paper includes the comparison between access control models Mandatory Access Control (MAC), Discretionary Access Control (DAC) and Role Based Access Control (RBAC) and explores the advantages and disadvantages of implementing the subjected models. They provides the fundamental policy and rules for the system level access control.... [tags: Access control, Mandatory access control, XACML]
3144 words (9 pages)
- Executive Summary The amount of deployed instances of Microsoft SQL Server in the enterprise is on the rise as a database management system. Microsoft set out to provide an effective database management system that meets multiple goals for information technology organizations. SQL Server, a Microsoft product, is designed to deliver scalable solutions while offering ease of use and deployment, self maintenance and tuning, low resource overhead, and low administrator skill set requirements. The seeming rise in popularity of SQL Server has resulted in an upsurge of installations in the corporate environment.... [tags: Database SQL Server]
974 words (2.8 pages)