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, DB 2, 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 RD MBS, and it is server-based, as well as the rest of the DBMS that will be discussed. According to the my sql. 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. DB 2 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.
The Essay on Reading College System Management Database
Computer has always been the first choice for my career. I am interested in the systems analysis and design. I want to learn the prevailing concepts as well as enhance them to cop with the changing programming paradigm. I am very much interested in CASE tools, its construction and deployment to provide the software solution to end user as well the intermediate developers in easier and cost ...
Finally, Oracle offers much of the same functionality as DB 2, 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. DB 2 will run on Windows NT 4 and higher, Sun Solaris, HP-UX and Linux. Oracle will run on all of the platforms supported by DB 2, as well as AIX 4. 3.
3 or higher, and Compaq Tru 64 5. 1. Expansion Capabilities Access is considered to be a small DBMS, with a maximum database size of 1 GB; therefore, it has very limited expansion capabilities. MySQL does offer expansion, including clustering capability. MySQL also offers an enterprise-class DBMS through a joint venture with SAP. SQL Server, DB 2, and Oracle, since they are all considered to be enterprise-class DBMS, are highly expandable, with maximum database size into the terabytes (TB).
Truly, these databases are at a point where the limit is actually in the operating system, not the DBMS. Types of Companies There are different markets for the different classes of DBMS. Access databases and applications will be used company-wide in very small companies. These databases can be found in different departments of larger companies, but would not be used at a company level. MySQL, according to their website web has over 6 million installations, including companies like Yahoo and the Associated Press. I think MySQL would be a good fit for a mid-sized company that cannot afford the price of the higher-end DBMS, but need more functionality, security, and robustness than is offered by Access.
The Term Paper on Assignment: Leadership and Cost Company
COST Company tried their best to grasp the sophisticated technology, thus the COST Company used highly to training the professionals, like the geologists, geophysicists, and the engineers. The COST Company also trained the skilled and semiskilled labor that run the company’s field operations. On the other hand the professional labor and the skilled labor, the two groups always occurs the clashed. ...
Finally, the large DBMS systems like SQL Server, Oracle, and DB 2 are typically only utilized in large companies, because of the investment required to install and maintain these databases. Database Use Each of the databases is suited to particular classes of use. Although Access can be used in a multi-user environment, it is not a good choice when there will be multiple concurrent users, because Access does not have robust transaction process as the other DBMS do. 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. DB 2 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 Enterprise Edition. On the low end, SQL Server Standard with one processor will be $4, 999. At the high end, SQL Server Enterprise with 32 processors will cost $639, 968 (not as bad as those 2 million dollars).
Oracle is the most expensive.
At $40, 000 dollars for Enterprise Edition on a single processor, and over $2. 5 million dollars for 32 processors with OLAP and Data Mining, it tops the list. Conclusion This paper was written to show the similarities and differences in five different databases. It compared Access, MySQL, SQL Server, DB 2, and Oracle in six different areas. It found many similarities in functionality, but large diversity in pricing. ReferencesChigrik, Alexander, Oracle 9 i Database vs DB 2 v 8.
The Essay on Log Shipping Server Sql Standby
The concept of standby servers is not a new one. It has been around a long time and been used by many DBAs. Traditionally, using a standby server for failover has involved manually making database and log backups on the production server and then restoring them to the standby server on a regular basis. This way, should the production server fail, then users could access the standby server instead, ...
1 (n. d. ), retrieved April 6, 2005, from web vs db 2. htmChigrik, Alexander, SQL Server 2000 vs Access 2000 (n. d. ), retrieved April 6, 2005, from web server vs access.
htmChigrik, Alexander, SQL Server 2000 vs DB 2 v 8. 1 (n. d. ), retrieved April 6, 2005, from web server vs db 2. htm Chigrik, Alexander, SQL Server 2000 vs MySQL version 4. 1 (n.
d. ), retrieved April 6, 2005, from web server vs my sql. htm Chigrik, Alexander, SQL Server 2000 vs Oracle 9 i (n. d.
), retrieved April 6, 2005, from web server vs oracle. htm MySQL Licensing Policy (n. d. ), retrieved April 6, 2005, from the MySQL company website: web.
