Alpha Geek

(8)

$10/per page/Negotiable

About Alpha Geek

Levels Tought:
University

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Environmental science,Essay writing,Programming,Social Science,Statistics Hide all
Teaching Since: Apr 2017
Last Sign in: 438 Weeks Ago, 6 Days Ago
Questions Answered: 9562
Tutorials Posted: 9559

Education

  • bachelor in business administration
    Polytechnic State University Sanluis
    Jan-2006 - Nov-2010

  • CPA
    Polytechnic State University
    Jan-2012 - Nov-2016

Experience

  • Professor
    Harvard Square Academy (HS2)
    Mar-2012 - Present

Category > Computer Science Posted 28 Apr 2017 My Price 5.00

Consider a database with objects X and Y

Consider a database with objects X and Y and assume that there are two transactions T1 and T2. Transaction T1 reads objects X and Y and then writes object X. Transaction T2 reads objects X and Y and then writes objects X and Y .

1. Give an example schedule with actions of transactions T1 and T2 on objects X and Y that results in a write-read conflict.

2. Give an example schedule with actions of transactions T1 and T2 on objects X and Y that results in a read-write conflict.

3. Give an example schedule with actions of transactions T1 and T2 on objects X and Y that results in a write-write conflict.

4. For each of the three schedules, show that Strict 2PL disallows the schedule.

 

 

Answers

Alpha Geek
(8)
Status NEW Posted 28 Apr 2017 11:04 AM My Price 5.00

-----------

Attachments

file 1493380230-Answer.docx preview (328 words )
C-----------ons-----------ide-----------r a----------- da-----------tab-----------ase----------- wi-----------th -----------obj-----------ect-----------s X----------- an-----------d Y----------- an-----------d a-----------ssu-----------me -----------tha-----------t t-----------her-----------e a-----------re -----------two----------- tr-----------ans-----------act-----------ion-----------s T-----------1 a-----------nd -----------T2.----------- Tr-----------ans-----------act-----------ion----------- T1----------- re-----------ads----------- ob-----------jec-----------ts -----------X a-----------nd -----------Y a-----------nd -----------the-----------n w-----------rit-----------es -----------obj-----------ect----------- X.----------- Tr-----------ans-----------act-----------ion----------- T2----------- re-----------ads----------- ob-----------jec-----------ts -----------X a-----------nd -----------Y a-----------nd -----------the-----------n w-----------rit-----------es -----------obj-----------ect-----------s X----------- an-----------d Y----------- .1-----------. G-----------ive----------- an----------- ex-----------amp-----------le -----------sch-----------edu-----------le -----------wit-----------h a-----------cti-----------ons----------- of----------- tr-----------ans-----------act-----------ion-----------s T-----------1 a-----------nd -----------T2 -----------on -----------obj-----------ect-----------s X----------- an-----------d Y----------- th-----------at -----------res-----------ult-----------s i-----------n a----------- wr-----------ite------------re-----------ad -----------con-----------fli-----------ct.----------- 2-----------. G-----------ive----------- an----------- ex-----------amp-----------le -----------sch-----------edu-----------le -----------wit-----------h a-----------cti-----------ons----------- of----------- tr-----------ans-----------act-----------ion-----------s T-----------1 a-----------nd -----------T2 -----------on -----------obj-----------ect-----------s
Not Rated(0)