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 Software
Comparing Microsoft Access, SQL, IBM DB2 and Oracle databases is presented in this analysis, taking into account the key features of ACID Compliance, Data partitioning, interface options, referential integrity, operating systems supported, and support for transactions and Unicode. Each of these factors is initially defined followed by a table comparing them across the database types.
Definition of Comparison Factors
At their most fundamental level, all databases have support for relational data models and the ability to index data through the use of a wide variety of taxonomies or organizational structures (Basumallick, Wong, 1996). Relational Database Management Systems (RDBMS) however all have the ability to manage transactions with the greatest efficiency given the design of these systems to support multiple transactions at once, running concurrently from each other. The characteristic of an operating system being able to manage thousands of concurrent transactions at the same time is often referred to as scalability (Politano, 2008).
The concepts of security and scalability are critical to the first comparison element in the matrix, which is the extent to which a given database is ACID-complaint. ACID compliance refers to the extent a given database has the attributes of data atomicity, consistency,...
All of these attributes taken together lead to a more scalable, secure and transaction-capable database over time. From Table 1, Comparing Microsoft Access, SQL, IBM DB2 and oracle databases, it is apparent that the enterprise-level databases have this attribute, while Microsoft Access does not. This can be attributed to the database design attributes of SQL, IBM DB2 and Oracle database technologies as each also supports data models with referential integrity and dedicated memory for each transaction (Basumallick, Wong, 1996).
The next factor in the analysis is partitioning. In database design there are three dominant forms of partitioning, including Range, List and Hash (Politano, 2008). Range partitioning takes a predetermined number of values and defines their values in the data dictionary to ensure that queries can be successfully completed on them once requested (Politano, 2008). List partitioning requires databases to have multiple forms of logic supported within them, including Boolean support for managing nested partitioning requests (Politano, 2008). Hash partitioning is a conditional attribute of a given data element or object which determines its membership in a given group or strata of the data (Basumallick, Wong, 1996). All of these aspects of data partitioning require multiple approaches to managing algorithms…
References
Basumallick, Swagato, & Wong, Johnny SK. (1996). Design and implementation of a distributed database system. The Journal of Systems and Software, 34(1), 21.
Tony Politano. (2008). Structured and Unstructured: The What, Why and How of Convergence. DM Review, 18(6), 20.
Stonebraker, M.. (2010). In Search of Database Consistency. Association for Computing Machinery. Communications of the ACM, 53(10), 8.
Oracle supports stored programs such as stored procedures and packages. This enables the developers to centralize application logic in the database. Oracle provides powerful functions and sub-queries in its SQL statements. Developers can distribute systems by database links, materialized views and distributed queries. This feature saves much cost for developing distributed systems and applications. And there's a lot of features integrated with Oracle, compare to other database it is
" "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
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
These factors further accelerate the value and TCO of databases over time. Describe the features, tools, and utilities of Structured Query Language (SQL). How can tasks be automated with SQL? SQL has specifically been designed with features, tools and utilities to enable programmers to support nth-tier data architectures in addition to legacy client-server computing scenarios. The development and continual improvement of the features, tools and utilities of SQL for automating tasks
Database Design for Spa/Hotel Booking System The WR (Woodlands Retreat) is a medium sized organization currently intending to build a database system to integrate modern IT (information systems) in its business operation to enhance its dynamic and innovative business operations. Although, the Woodlands Retreat has an IT system, however, the current systems are not capable of keeping book records as well as not capable of managing all data for the company
Selling enterprise software with channel partners requires Microsoft to create a separate department just for training, coordination of pricing and product requests, and also define entirely new delivery platforms for the applications as well. The Software-as-a-Service (SaaS) platform has been legitimized by Salesforce.com. Microsoft is reinventing itself to in this area so they can better sell with resellers and partners, and also better capitalize on the growing popularity of