Sql Server Enterprise With 32 Processors example essay topic
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. 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. 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.
Bibliography
Chigrik, Alexander, Oracle 9 i Database vs. DB 2 vs. 8.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 vs. 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.