Sign Up Now
Get instant access to over 1 million+ study documents
OR
Already registered? click here to login
By creating your account, you agree to our terms of service, privacy policy and student honor code.
Database Concepts
Compare and contrast Microsoft Access, Microsoft SQL Server, DB2, and Oracle database programs
Providers: Microsoft Corporation provides Microsoft Access and SQL Server, Oracle by Oracle Corporation and DB2 is a product of IBM.
Brief about each:
MS Access: Microsoft Access is a database, which comes bundled in Microsoft Office Products. Access is fully compatible with Active Server Pages (ASP) scripting. Database programs such as Access (sometimes called Relational Database Management systems or RDBMS) are used to store information, often large amounts of information. It can be used as a flat-file database (using a single table) or a relational database (using more than one table linked together). Access database applications can be produced for a large number of database situations including financial and scientific data - with excellent results. Access comes equipped with Wizards, which help the novice to create tables, forms, queries and reports. A complicated relational database design and implementation may need the advice and help of a technical consultant. Access has a Query Wizard to help you create the following types of query: Crosstab, Duplicate, Find Unmatched and Simple
Oracle: Oracle Corporation is the largest software company whose primary business is database products. Historically, Oracle has targeted high-end workstations and minicomputers as the server platforms to run its database systems. Its relational database was the first to support the SQL language, which has since become the industry standard. The standard query language SQL is used to interact with the database. Oracle is not recommended for small databases or for users without relational database experience.
DB2: Abbreviated name for IBM DB2 Universal Database developed as a relational database by IBM. It runs on non-IBM machines as well as IBM hardware and full-featured, robust, scalable and easy to use database.
SQL Server: It is a Relational Data Base Management System (RDBMS) from Sybase Corporation. SQL Server was designed for client/server use and is accessed by applications using SQL. It runs on OS/2, Windows NT, NetWare servers, VAXen, and UNIX workstations. When capitalized, the term generally refers to either of two database management products from Sybase and Microsoft. Both companies offer client-server DBMS products called SQL Server.
Comparative Study of...
Hardware requirements
Processor: Pentium 166 MHz or higher for SQL Server
Pentium 75 MHz or higher for Microsoft Access 2000
Pentium 166 MHz or higher for Oracle
Pentium or Pentium compatible CPU for DB2
B. Memory requirement:
Beside minimum 256 MB RAM, additional memory may be required for DB2 in a window-based platform.
SQL Server 2000, it varies from 32 MB to 128MB or more depending o whether it is on Desktop or some other editions.
Oracle requires minimum of 128 MB RAM (though 256 MB recommended) and it also require a virtual memory of 200MB in an Intel or compatible platforms.
For Microsoft Access it depends on the window version (Ex. 32MB RAM for Window NT)
C. Software requirements:
MS Access and SQL Server 2000 can work on any of the Window editions.
Oracle can run on SQL as well as Sun Solaris platform.
DB2 run on mainframe. It also support Java and XML
D. TPC tests:
The Transaction Processing Performance Council (TPC.Org) is an independent organization that specifies the typical transactions and measures the performance and price/performance of transaction processing systems. As an OLTP system benchmark, TPC-C simulates a complete environment where a population of terminal operators executes transactions against a database. The benchmark is centered on the principal activities (transactions) of an order-entry environment.
Oracle gives TPC-C Benchmark Result. DB2 gives TPC-C Benchmark Result. In fact IBM's DB2 has topped TPC Benchmark List. Server 2000 ranks number one on Windows in both TPC-C clustered and non-clustered benchmarks.
E. Platform comparison:
Both Oracle 9i Database and DB2 Universal Database version 8.1 support all known platforms, including Windows-based platforms, AIX-Based Systems, HP-UX systems, Linux Intel, Sun Solaris and so on.
SQL Server 2000 only works on Windows-based platforms, including Windows 9x, Windows NT, Windows 2000 and Windows CE.
Microsoft Access 2000 can be installed under the following operation systems: Microsoft Windows 95, Windows 98, Windows 98 Second Edition, Windows Millennium Edition (Windows Me), Windows NT 4.0 with Service Pack 6 (SP6),…
The longest SQL statement in Oracle is of 16,777,216 bytes, 65,536 bytes (Network packet size 4 KB, by default) in SQL Server, approximately 64,000 bytes in MS Access whereas in DB2 it is of 65535 bytes. Microsoft Access 2000 falls into the desktop category and works best for individuals and workgroups managing megabytes of data. In comparison with SQL Server 2000, Access uses file-server architecture, rather than client-server architecture. Access 2000 has many restrictions in comparison with SQL Server 2000 and cannot be used in the case you want to build stable and efficient system with many concurrent users
Conclusion:
It is very difficult to compare all the four on a same platform. It is not true that Oracle 9i Database is better than DB2 Universal Database v8.1 or vice versa. Both products can be used to make stable and proficient systems and the stability and effectiveness of your applications and databases depend rather upon the experience of the database developers and database administrator than the database's provider. It all depends on the use and requirements. If the need is to make a scalability, security, and robustness system, you should use SQL Server instead of Access. Because Access 2000 does not support atomic transactions, it does not guarantee that all changes performed within a transaction boundary are committed or rolled back. SQL Server is integrated with Windows NT security, but Access is not. Access 2000 databases cannot be restored to the point of failure, when SQL Server databases can be. This makes administering Access 2000 databases more expensive than administering SQL Server 2000 databases. So, you should use Access 2000 database, only when you need to store a small amount of data in a single user (or few users) environment, or when you have very low resources, such as memory or disk. In other case, use MSDE or SQL Server. Similarly we can't compare SQL Server 2000 with DB2 Universal Database v8.1 or vice versa. Both products can be used to build stable and efficient system and the stability and effectiveness of your applications and databases depend rather from the experience of the database developers and database administrator than from the database's provider. But SQL Server 2000 has some advantages in comparison with DB2 Universal Database v8.1 and vice versa.
companies such as credit card systems have their backend offices (databases) in India. What are the benefits and risks? The databasing industry in India is a growing and thriving IT market with credit care companies including Diners Club and Citibank storing their client and potential client information in Indian databases (Vandrevala 15). Clearly, there are extensive benefits from databasing this information offshore. The costs in India are much cheaper, to
Microsoft Access, Microsoft SQL Server, DB2, and Oracle are four of the most important and widely used database management systems (DBMS) in use in today's information technology field. This paper compares the four DBMS in terms of ten major factors: 1) price, 2) platform compatibility, 3) support services, 4) support for ERP and CRM high-end systems, 5) open or proprietary, 6) Ease of integrating information with other databases 7) support
Finally, the company uses Microsoft applications for expanding its business opportunities by providing quick information about customer requests. Right now, the company is growing and it finds itself overwhelmed with growing information needs from customers and their increasing transactions. The company is realizing that to meet the needs they will need to update their software to meet the future needs of the business. The company is also recognizing that presently the
" "STUDENT INFORMATION TABLE" ( "STUDENT ID" CHARACTER (4) NOT NULL, NAME CHARACTER (25) NOT NULL, "STREET NUMBER" CHARACTER (10) NOT NULL, "STREET NAME" CHARACTER (25) NOT NULL, CITY CHARACTER (25) NOT NULL, STATE CHARACTER (10) NOT NULL, EMAIL CHARACTER (25) NOT NULL, "PHONE NUMBER" CHARACTER (15) NOT NULL ); CONNECT RESET; SQL FOR Book_Information CONNECT TO LIBRARY; CREATE TABLE "USER"; CREATE TABLE BookInformation ( "BookISBN" CHARACTER (10) NOT NULL; "AUTHOR" CHARACTER (25) NOT NULL; "TITLE" CHARACTER (50) NOT NULL; "PRICE" CHARACTER (10) NOT NULL; CONNECT RESET; SQL STATEMENT FOR
Databases and Regulatory Compliance Challenges The advent of technology has increased the popularity of database usage in firms, yet the legislation regulating the field has yet to be finalized. The changing nature of the IT sector, coupled with the legislative traits, creates several situations in which the companies find it difficult to comply with the regulations. This paper recognizes some of those difficulties, and also proposes some solutions. Databases Regulatory challenges for databases No
Database Data Warehousing Design Data warehousing is a powerful tool that business organizations use to enhance competitive advantages. Data warehousing supports business decision by collecting, organizing and consolidating data for analysis and reporting using tools such as OLAP (online analytical processing ) and data mining. Typically, the relational database technology is generally being used to design a data warehousing and a relational database is a database having collection of tables, and