0
What is two phase locking and how does it guarantee serializabilityin dbms?
Wiki User
∙ 11y agoWant this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
What do you mean by lossiess join in dbms?
what do u mean by lossiess join in dbms
What is mvd in dbms?
multivalued data
What is meant by data consistency in DBMS?
sdfsfas
What is difference between check point and save point in DBMS?
save point saves the dbms and check point simply check the database thats it simple
What is tuple variables in dbms?
TUPLE : Is the "ROW" in a table
What is two phase protocol in a dbms?
In two phase locking there are two phases. The first phase is known as Expanding Phase and locks are issued in this phase. No lock is released. Then after change all changes are committed and the second phase starts that is the Shrinking Phase in which all the changes are noted and the locks are released. No locks are issued in this phase
What is graph based protocol in DBMS?
g ProtocolTree locking protocol is used to employ exclusive lock and when the database is in the form of a tree of data items. Tree locking protocol is serializable.Advantages of Tree Locking ProtocolUnlocking of data item is earlier.Shorter waiting time, increase in concurrency.Disadvantages of Tree Locking ProtocolTransaction may have to unnecessary lock data items to access its child nodes.Huge number of locks and locking overhead.
Explain the strict two-phase locking protocal in dbms?
The strict two-phase locking (S2PL) class of schedules is the intersection of the 2PL class with the class of schedules possessing the Strictness property. To comply with the S2PL protocol a transaction needs to comply with 2PL, and release its write (exclusive) locks only after it has ended, i.e., being either committed or aborted. On the other hand, read (shared) locks are released regularly during phase 2. Implementing general S2PL requires explicit support of phase-1 end, separate from transaction end, and no such widely utilized product implementation is known. S2PL is a special case of 2PL, i.e., the S2PL class is a proper subclass of 2PL
What are highlights of DBMS?
NA_ what are highlights of advanced DBMS what are highlights of advanced DBMS what are highlights of advanced DBMS
Is java DBMS?
no, Java is not dbms.. Java is a programming language Dbms is database
Is SQL DBMS or RDBMS?
dbms
What are three types of dbms?
Three types of DBMS (Database Management Systems) include relational DBMS, object-oriented DBMS, and NoSQL DBMS. Relational DBMS organizes data into tables with rows and columns, object-oriented DBMS stores data as objects and classes, and NoSQL DBMS handles unstructured and semi-structured data with flexible schemas.
What are rows in dbms?
In DBMS the data is stored in the form of table . Each row in DBMS is known as tuple.
What are the importance of dbms in industrial environment?
importance of DBMS
What is the difference between DBMS and GIS?
gis and dbms
What is the purpose of dbms?
What is the purpose of dbms?DBMS is a software that organises the creation, storage and maintenance of Databases for end users.
What is the use of dbms?
DataBase Management System (DBMS)is a software package# it allows data to be effectively stored, retrieved and manipulatedand # the data stored in a DBMS packege can be accessed by multiple users and by multiple application programs like (SQL Server, Oracle, Ms-Access) .Types of DBMS# Hierarachical DBMS (HDBMS)# Network DBMS (NDBMS)# Relational DBMS (RDBMS)# Object Oriented DataBase(OODB)# Distributed DBMS (DDBMS)
