Explain the rules for creating a labelled precedence graph, Database Management System

Assignment Help:

Explain the rules for creating a labelled precedence graph for testing view serializability.          

 Ans: A schedule S is view serializable if it is view equivalent to a serial schedule 

  • Each conflict serializable schedule is also view serializable
  • A schedule that is view serializable but not conflict serializable:

Testing for Serializability 

  • Refer some schedule of a set of transactions T1, T2... Tn
  • Precedence graph is a direct graph in which the vertices denote the transactions
  • We illustrate an arc from Ti to Tj if the two transaction conflict and Ti accessed the data item earlier on which the conflict arose
  • We may label the arc through the item on which the conflict arose. A schedule is conflict serializable if and only if its precedence graph is acyclic
  • If precedence graph is acyclic, the serializability order can be acquired by a topological sorting of the graph.
  • The trouble of checking if a schedule is view serializable falls in the class of NP-complete problems
  • Though practical algorithms that just check few sufficient conditions for view serializability can still be employed.

Related Discussions:- Explain the rules for creating a labelled precedence graph

Sql, sql is relationally complete-justify

sql is relationally complete-justify

In e-r diagram how derived attribute are represented, In E-R Diagram how de...

In E-R Diagram how derived attribute are represented ? In E-R Diagram By Dashed ellipse derived attribute are represented.

Define database management system, Define database management system? D...

Define database management system? Database management system (DBMS) is a set of interrelated data and a combination of programs to access those data.

Define control files, Control Files : The redo and control files logs supp...

Control Files : The redo and control files logs support the rest of the architecture. Every database must have at least one control file, although you have more than one to guard

What are the comparison operator in sql, What are the comparison operator i...

What are the comparison operator in SQL?  Comparison operator in SQL are =, LIKE and BETWEEN

Explain hash file organization, Explain hash file organization? Hash fu...

Explain hash file organization? Hash functions a) The distribution is uniform Hash functions assign each bucket the similar number of search -key values from the set of a

Data dictionary, how to prepare a data dictionary for online examination sy...

how to prepare a data dictionary for online examination system for certified courses?

File Management Principles, What are the requirements to ensure the objecti...

What are the requirements to ensure the objectives of file management principle is realized?

What is a super key, What is a super key? A super key is a set of one o...

What is a super key? A super key is a set of one or more attributes that collectively permits us to recognize uniquely an entity in the entity set.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd