Question

What factors which affect the selection of granularity size of data item?

Answer 1

Hii
Ur answer is

1.     A database record

 

2.     A field value of a database record

 

3.     A disk block

 

4.     A whole file

 

5.     The whole database

 

The granularity can affect the performance of concurrency control and recovery. In Section 22.5.1, we discuss some of the tradeoffs with regard to choosing the granularity level used for locking, and in Section 22.5.2 we discuss a multiple granularity locking scheme, where the granularity level (size of the data item) may be changed dynamically.

Thank You

Plz mark my brainlist