Wait a second!
More handpicked essays just for you.
More handpicked essays just for you.
Pros and cons of the different types of databases
Don’t take our word for it - see why 10 million students trust us with their essay needs.
Recommended: Pros and cons of the different types of databases
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 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.
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 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 ...
...n
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.
References
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/
The common element of the open source databases is the use of share data of student information. The common features used by the databases are their operating systems UNIX or Windows, as well as MYSQL database. The database used b...
In the past number of years data has grown exponentially. This growth in data has created problems that and a race to better monitor, monetize, and organize it. Oracle is in the forefront of helping companies from different industries better handle this growing concern with data. Oracle provides analytical platforms and an architectural platform to provide solutions to companies. Furthermore, Oracle has provided software such as Oracle Business Intelligence Suite and Oracle Exalytics that have been instrumental in organizing and analyzing the phenomenon known as Big Data.
Oracle ThinkQuest. Oracle Education Foundation, 04 Jun 2010. Web.
SQL Server 2000 vs Oracle 9i. Retrieved December 1, 2007, from MSSQLCity.Com Web site: http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm
Databases and Y2K Introduction: Tremendous problems loom just around the corner for organizations that use two-digit years (i.e. 1-9-97). How tough could it be to change the year from 1999 to 2000? The "Year 2000 Problem" cannot be fixed by simply resetting a computer's internal clock on January 1, 2000. Computers may be smart, but their programmers weren't very farsighted.
A database management system, or DBMS, gives the user access to their data and helps them transform the data into information. Such database management systems include dBase, Paradox, IMS, and Oracle. These systems allow users to create, update, and extract information from their databases. Compared to a manual filing system, the biggest advantages to a computerized database system are speed, accuracy, and accessibility.
Database management system is a group of programs, which enables a user to modify, extract, and store information/data from a database. The system is designed in such a manner that user can be able to access the information they need. The company will uses a soft ware known as database management system, which will be responsible for controlling the data storage, data organization, and data retrieval. In addition, a DBMS will help in reducing data redundancy and inconsistence of the data, and provide the necessary security required to protect the data from being accessed by unauthorized person (Harrington, 2002). Additionally DBMS has a recovery mechanism thus data deleted by mistakes or lost will easily be recovered.
In 1983, Oracle decided to make the Relational Database Management System (RDBMS) portable. They then introduce V3, the first portable database to run on Personal Computers, minicomputers and mainframes.
Mistry, R. & Misner, S. (2012). Introducing Microsoft SQL Server 2012. Redmond Washington. Microsoft Press.
For this coursework two kinds of data models can be used. The object oriented data model, Object Oriented Database Management System(OODBMS), or the relational data model, Relational Database Management System(RDBMS). The differences between these two models and the data model to be used are described in this chapter.
At the end of the day both MYSQL and Microsoft server 2008 are great database systems. However, they operate very different from each other. They both use different utilities with the data that is placed on to them. Also, both come with varying price ranges. MYSQL has a free version and is open source, and Microsoft server is not free and must be purchased. One more thing to note is both systems use entirely different ways of interacting with the data. For instance, one code to operate on the data in MYSQL cannot be used to operate on the data in Microsoft server. When making your choice about which one to use I would suggest using a list of needs for whatever you’re using the database system for, and then comparing that to the functionality, ease of use, security, and pricing of the individual systems.
[7] Elmasri & Navathe. Fundamentals of database systems, 4th edition. Addison-Wesley, Redwood City, CA. 2004.
Since it’s an Oracle unique feature, there are many documentations and support available for every steps of the implementation in an Oracle database
Databases and also the internet have enabled worldwide collaboration and data sharing by extending the reach of database applications throughout organizations and communities. This reach emphasizes the importance of high accessibility in information management solutions. Each tiny businesses and world enterprises have users everywhere the world that needs access to information 24 hours each day. While not this information access, operations will s...
In our world, people rely heavily on the power of technology every day. Kids are learning how to operate an iPad before they can even say their first word. School assignments have become virtual, making it possible to do anywhere in the world. We can receive information from across the world in less than a second with the touch of a button. Technology is a big part of our lives, and without it life just becomes a lot harder. Just like our phones have such an importance to us in our daily lives, database management systems are the same for businesses. Without this important software, it would be almost impossible for companies to complete simple daily tasks with such ease.