Question

1.
Define these terms: transaction, atomicity, consistency, isolation, durability, schedule, dirty read, and serializable schedule.

2.
Describe Strict 2PL.

3.
Consider the following actions taken by transaction T1 on database objects X and Y: R(X), W(X), R(Y), W(Y).
a. Give an example of another transaction T2 that, if run concurrently to transaction T without some form of concurrency control, could interfere with T 1.
b. Explain how the use of Strict 2PL would prevent interference between the two transactions.
c. Strict 2PL is used in many database systems. Give two reasons for its popularity.

4.
The database management systems can be classified based on several criteria.
A. Based on data model: the relational data model; hierarchical data model; network data model; or object-oriented data models.
B. Based on the number of users: single user database system which supports one user at a time or multiuser systems which support multiple users concurrently.
C. Based on the ways database is distributed: Centralized Systems (the system is stored at a single site.); Distributed database system (Actual database and DBMS software are distributed in various sites connected by a computer network.) - Homogeneous distributed Database Systems or Heterogeneous distributed Database Systems. Choose three different types of the database management systems. Do your research on these DBMS, explain and discuss about these different systems. (the main features, applications, comparisons of advantages or disadvantages.) Please cite the references (books, website, etc...)

Solution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

1. The definitions given below are generally obtained by paraphrasing the definitions provided in the textbook.
A transaction is a sequence of operations (between “begin transaction” and “end transaction”) executed by a unit of a program for performing access and update to/of data items. The component operations are hidden to user and they appear as a single execution unit.
Atomicity represents the insurance that execution of a transaction is complete and the targeted effects are visible into the database. It means there are not left incomplete states for the transaction....

This is only a preview of the solution. Please use the purchase button to see the entire solution

$55.00

or $1 if you
register a new account!

Assisting Tutor

Related Homework Solutions

E-R Diagram
Homework Solution
$25.00
Computer
Science
E-R Diagram
Database
Development
Customer
Service
Installation
Transparent Data Encryption (2780 words)
Homework Solution
$100.00
TDE
Data
Transparent
Encryption
Database
Oracle
Technology
Tablespace
Two-tier
Architecture
Network
Authentication
Advanced
Security
Cryptographic
Overhead
Metric
PKCS
Standard
Compliance
Questions about Oracle 11g
Homework Solution
$18.00
Computer Science
Oracle 11g
Database
System Privilege
Block Size
SQL
Tunning
SYSAUX
PFILE
SPFILE
Creating Databases Using MS Access
Homework Solution
$20.00
Databases
MS Access
Business
Management
Employees
Department
Relationships
Primary Key
Foreign Key
Tables
UML Class Diagram
Get help from a qualified tutor
Live Chats