Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Define granularity, hierarchy of granularity of locks & multiple granularity locking. Explain the modified two phase locking along with multiple granularity locking.
Ans: The size of the data item selected as a unit of protection through a concurrency control protocol is granularity.
When the granularity is denoted in a hierarchical structure in which each node denotes data items of different sizes we acquire the hierarchy of granularity.
In multiple granularity locking there are three kinds of locks - shared, exclusive and intention lock.
Modified two-phase locking strategy
1) No lock can be granted once any node has been unlocked
2) No node might be locked till its parent has an intention lock
3) No node might be unlocked till all its descendants are unlocked.
What is B-Tree? A B-tree eliminates the redundant storage of search-key values .It permits search key values to appear only once.
Eliminate Redundant Data In the "Database Relation" above, the primary key is made up of the D-ID and the Emp-ID. The database-name relies only on the D-ID. The similar databas
object oriented database
Explain the Cascadeless Schedule A cascadeless schedule is one in which for every pair of transactions Ti and Tj like that Tj reads a data item before written by Ti, the commit
difference between MIS and DSS
Describe about Object oriented design Object oriented design is concerned with developing an object oriented model of a software system to implement known requirements. Many OO
What is an E-R model? Draw an E-R Diagram for the company database with following Descriptions? The company is organized within departments. Each department has a unique name a
List some instances of collection types? a) sets b) arrays c) multisets
Explain the concept of a data model ? Data Model - Model is an abstraction procedure which hides irrelevant details although highlighting details relevant to the application
What is a view? A view is a logical view on one or more tables. A view on one or more tables i.e., the data from a view is not actually physically kept instead being derived f
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!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd