0
What is the difference between conflict equivalence and view equivalence of dbms?
Wiki User
∙ 11y ago
Conflict equivalence- Two schedules are conflict equivalent if the order of any two conflicting operations is same in both the two schedules.
View equivalence- Two schedules are view equivalent if -
1) Both the schedules have same set of transactions.
2) If in a schedule a read operation r1[X] of transaction T1 reads the value of X written by a write operation w2[x] of transaction T2 or reads the original value of x,then this must also be the case in the other schedule.
3)If operation w3[Y] of a transaction is the last operation to write the value of Y in schedule S then it must also be the last transaction in the other schedule to do so.
All conflict serializable schedules are view serializable.
But all view serializable schedules are not conflict serializable.
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
Difference between traditional and latest DBMS package?
Traditional FPS and DBMS both are different from each other. In DBMS there is security of data as well as integrated data while this is not in FPS.
What are the difference between static and dynamic hashing in DBMS?
Search operation in static hashing is time consuming, but in dynamic hashing it is not.
What is the component of database that serve as the intermediary between the user and the database?
dbms
WHAT TASKS does dbms do?
A Database Management System or DBMS provides the interface between users and a database. Some of its tasks include: data integrity, security, recovery of data, support concurrent updates and update data.
Concept of file handling in DBMS?
if we need a modifying ,sreach,delete a file so we need a DBMS
What is the difference between DBMS and GIS?
gis and dbms
What is the major difference between rdbms and dbms?
The 'r'
What is the difference between a desktop DBMS and a general DBMS?
I'm Looking for the Same awnser. anyone? Thank
Major difference between dbms vs rdbms?
A DBMS (Database Management System) is a software that manages databases and provides functionalities to store, retrieve, and update data. An RDBMS (Relational Database Management System) is a type of DBMS that stores data in a structured way using tables with relationships between them. RDBMS enforces the relational model, which allows for data integrity through constraints and supports SQL for querying data.
What is the difference between flat file and DBMS?
A flat file is a simple file containing data without any structured format, while a Database Management System (DBMS) is a software system that manages databases by organizing, storing, and retrieving data. A DBMS allows for more organized and efficient data management, supports relationships between data, and provides features like security and data integrity that are not available with flat files.
What iis difference between dbms and tfs?
database approach
What is the Difference between relation schema and relation instance?
difference between relation sehema and relation instance in dbms
What is difference between network model and hierachical model of dbms in points?
uj
Difference between traditional and latest DBMS package?
Traditional FPS and DBMS both are different from each other. In DBMS there is security of data as well as integrated data while this is not in FPS.
What is the difference between homogeneous database and heterogeneous database?
A Homogeneous database will have only one DBMS, while heterogeneous databases have multiple DBMS's
What is the difference between database application and dbms?
A DBMS is a database management system. A database application would be something inside the DBMS such as: ~a way to search files ~a way to pull certain information
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
