Database Comparison of SQL Server 2000, Access, MySQL,...

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†¦show more content†¦Expansion Capabilities nbsp;nbsp;nbsp;nbsp;nbsp;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, DB2, 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 nbsp;nbsp;nbsp;nbsp;nbsp;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 http://www.mysql.com, 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 DB2 are typically only utilized in large companies, because of the investment required to install and maintain these databases. Database Use nbsp;nbsp;nbsp;nbsp;nbsp;Each ofShow MoreRelatedDatabase Comparison of Sql Server 2000, Access, Mysql, Db2, and Oracle1164 Words   |  5 PagesIntroduction 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 ofRead MoreDbms Comparison2517 Words   |  11 PagesTOTAL NUMBER OF WORDS FOUND IN DOCUMENT = 1,891 DBMS Comparisons DBM502 Week 2 Individual Assignment Abstract This paper will discuss and make comparisons on the markets top Database Management Systems (DBMS) currently available. The paper includes a table for side-by-side comparisons of feature sets and other factors required when making decisions on which DBMS to purchase and implement in a business. While this may not be a complete list of all available DBMS systems it will includeRead MoreEssay about Will Linux replace Windows NT as the server OS of choice?3210 Words   |  13 PagesLinux VS NT / Will Linux replace Windows NT as the server OS of choice? Linux is ready, or at least poised, to take on Windows NT for market dominance of server operating systems, said T. W. Burger Owner, Thomas Wolfgang Burger Consulting June 2000. It is the competitive choice for the user wanting a cheap, versatile, scalable, and reliable server solution. This article examines how Linux is ready to meet or exceed all user requirements that NT provides and why Linux should be the preferredRead MorePharmacy Management6676 Words   |  27 PagesContents 1. INTRODUCTION Pharmacy Database Management System 2. PROJECT PLAN Feasibility study Operation Technical Cost/Benefit Analysis System Analysis System Requirement Data-Flow-Diagram Context DFD First Level DFD Second Level DFD System Design Coding details / Application System Testing 3. WHY? Visual Basic Microsoft Access CONCLUSION AND FUTURE SCOPE BIBLIOGRAPHY AND REFERENCES Chapter 1 INTRODUCTION Pharmacy Database Management System Introduction: TheRead MoreSurvey On Graph Databases : Graph Database3635 Words   |  15 PagesSurvey on graph databases XIAOTONG FU Informatics, University of Edinburgh Abstract. Graph databases, also called graph-oriented database, is a type of not only SQL (NoSQL) database based on graph theory that can store, map and query data relationships. Because this kind of database ensures its robust performance in processing graph-like data, it has been widely used in industry, for instance, Facebook and Twitter are using graph databases to store and analyze their user proles. This paper re- viewedRead MoreOnline Auction System8956 Words   |  36 Pagesthe construction of an auction website. The system has been designed to be highly-scalable and capable of supporting large numbers of bidders in an active auction. The online auction system lets you easily browse lots and place bids using a secure server. All cost of mailing lots will be paid by the buyer. The objective is to develop a user-friendly auctioning site where any kind of product can be auctioned and provide valueadded services to the bidders and the sellers. The products will be authenticatedRead MoreManaging Information Technology (7th Edition)239873 Words   |  960 PagesWeb Applications Database Management Systems CASE Tools 51 52 54 Communications Interface Software Utility Programs 54 54 The Changing Nature of Software 55 The Information Technology Industry 55 Review Questions 56 †¢ Discussion Questions 57 †¢ Bibliography 58 Chapter 3 Telecommunications and Networking The Need for Networking 61 Sharing of Technology Resources Sharing of Data 60 61 61 Distributed Data Processing and Client/Server Systems Enhanced Communications