0
Serial schedules are the schedules during which all statements in a transaction are executed consecutively.
Serializable schedule is a schedule that is equivalent to a serial schedule
Wiki User
∙ 14y ago
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 the difference between conflict equivalence and view equivalence of dbms?
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.
What is View Serializable in DBMS?
View Serializable is a correctness criterion in database management systems that ensures that the final result of executing concurrent transactions is the same as if they were executed one after the other. This property helps maintain data consistency and ensures that the database remains in a consistent state despite concurrent transaction execution. Transactions are said to be view serializable if their interleaved execution produces the same results as if they were executed sequentially.
What are some of DBMS Types?
1. Following are the different types of dbmsMySQLMicrosoft SQL ServerMS AccessFoxproSAPdBASETibero 6
What is scheduling in dbms?
schedule is an interleaving of action from a set of transactions where the action of any transaction is in the original order.
How logical architecture of DBMS differs from physical architecture?
Architecture is the frame work of the Database Management System. They are simply classified into logical and physical.
What is concurrent schedule in dbms?
A concurrent schedule in DBMS refers to multiple transactions running concurrently without interfering with each other. This allows for improved performance and efficiency in handling multiple operations simultaneously. However, it requires careful management to ensure data consistency and avoid conflicts such as race conditions.
Explain the concepts of recoverable schedule in dbms?
Transactions commit only after all transactions whose changes they read, commit
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.
