Question: Suppose the lock hierarchy for a database consists of database, relations, and tuples. a. If a transaction needs to read a lot of tuples from

Suppose the lock hierarchy for a database consists of database, relations, and tuples.

a. If a transaction needs to read a lot of tuples from a relation r, what locks should it acquire?

b. Now suppose the transaction wants to update a few of the tuples in r after reading a lot of tuples. What locks should it acquire?
c. If at run-time the transaction finds that it needs to actually update a very large number of tuples (after acquiring locks assuming only a few tuples would be updated). What problems would this cause to the lock table, and what could the database do to avoid the problem?

Step by Step Solution

★★★★★

3.37 Rating (166 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a The transaction would acquire read locks on the tuples that it needs to read from the relat... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Database System Concepts Questions!

A database consists of many tables. True or False

Now suppose that Firm B from Problem 15.16 decides to get a term loan for 10 years. How does this affect the companys borrowing cost?

After reading this chapter, it should be fairly obvious why an IS professional should be able to make a business case for a given system. Why, however, is it just as important for non-IS...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Consider a database DB with relations R1 and R2. The relation R1 contains tuples t1 and t2 and the relation R2 contains tuples t3, t4, and t5. Assume that the database DB, relations, and tuples form...

In this question assume that p and q are atomic formulae. (a) Compare and contrast path formulae and state formulae in temporal logic. [4 marks] (b) Describe and contrast the meanings of F(G p) and...

Portray in words what transforms you would have to make to your execution to some degree (a) to accomplish this and remark on the benefits and detriments of this thought.You are approached to compose...

Suppose that R(A, B, C) is a relational schema with functional dependencies F = {A, B C, C B}. (i) Is this schema in 3NF? Explain. [2 marks] (ii) Is this schema in BCNF? Explain. [2 marks] (b)...

Prolog You are approached to compose a Prolog program to work with twofold trees. Your code shouldn't depend on any library predicates and you ought to expect that the mediator is running without...

State what is meant by a directed graph and a strongly connected component. Illustrate your description by giving an example of such a graph with 8 vertices and 12 edges that has three strongly...

The accompanying table gives part of the supply schedule for personal computers in the United States. Price of computer Quantity of computers supplied $1,100. 12,000 900.. 8,000 a. Calculate the...

In order to finance his university studies Nedan ran a business buying and selling organic health products via mail order. However, he now has to concentrate on his final examinations so he decides...

StatementsAnswer 1 . Most _ _ _ _ _ _ _ _ _ _ represent obligations payable sometime during the succeeding period for services of a continuing nature received before the balance sheet date . 2 ....

What is the y-intercept a?

This exercise is intended to help you understand the relationship between forwarding, hazard detection, and ISA design. Problems in this exercise refer to the following sequence of instructions, and...

This exercise is intended to help you understand the relationship between delay slots, control hazards, and branch execution in a pipelined processor. In this exercise, we assume that the following...

The importance of having a good branch predictor depends on how oft en conditional branches are executed. Together with branch predictor accuracy, this will determine how much time is spent stalling...

Cooper Technologies Ltdis a company that provides geospatial services for national governments, states, provinces, counties, municipalities, and commercial organisations around the world. The...

In 2018, Caterpillar Inc. had about 650 million shares outstanding. Their book value was $25.0 per share, and the market price was $155.80 per share. The companys balance sheet shows that the company...

Growth Annuities Question 3 (1 point) A payment starts out as $0, but undergoes growth of $6.10 per month for a total lifetime of 28 months. Calculate the equivalent uniform payment amount if the...