Database Software Comparing Microsoft Access, SQL, IBM Essay

Open, View, and/or
Download this Document

Total Length: 794 words ( 3 double-spaced pages)

Total Sources: 3

Page 1 of 3

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, isolation, and durability.

Stuck Writing Your "Database Software Comparing Microsoft Access, SQL, IBM" Essay?

View All Our Example Database Software Comparing Microsoft Access, SQL, IBM Essay

Have A Custom Example Essay Written

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….....

Show More ⇣

     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"Database Software Comparing Microsoft Access SQL IBM" (2011, March 05) Retrieved June 7, 2026, from
https://www.aceyourpaper.com/essays/database-software-comparing-microsoft-access-49955

Latest MLA Format (8th edition)

Copy Reference
"Database Software Comparing Microsoft Access SQL IBM" 05 March 2011. Web.7 June. 2026. <
https://www.aceyourpaper.com/essays/database-software-comparing-microsoft-access-49955>

Latest Chicago Format (16th edition)

Copy Reference
"Database Software Comparing Microsoft Access SQL IBM", 05 March 2011, Accessed.7 June. 2026,
https://www.aceyourpaper.com/essays/database-software-comparing-microsoft-access-49955
   

Open, View, and/or
Download this Document
order custom essay example