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 free if you
register a new account!

Assisting Tutor

Related Homework Solutions

Data Normalization
Homework Solution
$98.00
SQL
Normalization
Computer
Science
Database
Development
Dependencies
Keys
Table
Primary
Foreign
SQL Server for Business Intelligence
Homework Solution
$23.00
SQL
Server
Business
Intelligence
SSAS
Data
Mining
MDX
DAX
Role
Named
Multidimensional
Model
Analysis
Services
Holdout
Set
Lift
Chart
Prediction
Query
Named
KPI
Calculated
Column
Measure
Tabular
Row
Filter
Context
BI
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