This paper provides a comparative overview of six widely used relational database management systems: Microsoft Access, MS SQL Server 2000, Oracle, DB2, and MySQL. For each system, the paper examines core architecture, supported platforms, key features, scripting languages, and notable corporate users. The discussion highlights how the systems differ in areas such as portability, cost, query capabilities, and suitability for small versus enterprise-scale applications. By placing these databases side by side, the paper helps readers understand which system may be best suited to a given organizational context or development environment.
The following sections compare six widely used relational database management systems: Microsoft Access, MS SQL Server 2000, Oracle, DB2, and MySQL. Each system is examined for its core features, supported platforms, scripting capabilities, and suitability for different organizational contexts.
Microsoft Office Access is a multi-user relational database management system designed to allow users to quickly assemble, display, and share data while protecting privacy and ensuring full control over how data is used and distributed. It makes use of visual design tools for queries, forms, and reports, and supports client-server database solutions. It offers an integrated development environment, incremental compilation, an interactive visual debugger, breakpoints, and single step-through execution.
Although the maximum database size is 1 GB, a database can include linked tables in other files, and its total size is limited only by available storage capacity. What distinguishes Microsoft Access from other database systems is its graphical user interface (GUI), which enables users to manage all information from a single database file. Within that file, users can employ:
Tables for storing data; Queries for finding and retrieving specific data; Forms for viewing, adding, and updating data within a table; Reports for analyzing or printing data; and Data Access Pages for viewing and updating database data remotely.
Microsoft SQL Server is a relational database management system that is portable, reliable, fast, and easy to use and manage. It was developed specifically to take advantage of the Microsoft Windows NT architecture and is optimized for the multithreaded, multiprocessing kernel of Windows NT. SQL Server offers many features and options for multiple users who need access to high volumes of data.
Many tools are included in the package; six of the most frequently used are: Enterprise Manager, Query Analyzer, SQL Profiler, Service Manager, Data Transformation Services (DTS), and Books Online. What sets SQL Server apart from other database management systems is its tight integration with the Windows NT platform. While other database management systems are written to be highly portable across operating systems — which limits their ability to exploit platform-specific performance enhancements — SQL Server leverages that integration to deliver greater power on Windows-based infrastructure.
SQL Server is oriented toward client/server applications. It is fast and offers good performance-tuning options and administrative tools that reduce the burdens of database development, administration, and maintenance. Companies using SQL Server include Albertson's Inc., ASB Bank, Black & Decker, Home Shopping Network (HSN.com), Minolta, Savings Bank of the Russian Federation, and the University of South Florida, among others. Compared with Oracle Database, the market shows that SQL Server is less expensive, and despite its lower price it offers satisfactory features including compatibility with Intel and other compatible platforms for ease of installation.
"Oracle Grid Computing, PL/SQL, and cost comparison"
"DB2 platforms, scripting languages, and optimizer advantage"
"MySQL open-source features, limitations, and use cases"
Each of the six database systems reviewed here serves a distinct niche. MySQL and Access are well suited to small business applications, while SQL Server, Oracle, and DB2 target enterprise-level performance and scalability. SQL Server offers a cost-effective solution tightly integrated with Windows environments, Oracle delivers exceptional power and distributed-system capabilities at a premium price, and DB2 provides competitive optimization and lower total cost of ownership for IBM-based environments. Selecting the right system depends on the scale of the application, the development environment, budget constraints, and the expertise of the database team.
You’re 45% through this paper. Sign up to read the remaining 3 sections.
Sign Up Now — Instant Access Already a member? Log inAlways verify citation format against your institution’s current style guide requirements.