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.
Explain ER Relationship model? An entity-relationship model (ERM): An entity-relationship model (ERM) is an abstract theoretical illustration of structured data. Entity-relatio
we need example of 2phase locking
Which method is used to key transformation ? A hash method is used to key transformation.
Explain concurrency control? Concurrency control Oracles multiversion concurrency control varies from the concurrency mechanism used by some other data base vendors. Read
Increases efficiency : Data is stored close to most often used site, therefore retrieval would be faster. Also, data that is not required by local applications is not stored, there
What is Oracle Process? Explain any four processes started by Oracle. Oracle Process is as follows: SMON: The System Monitor carries out a crash recovery while a crashed in
Using a database design approach of your choice, produce a logical design for Pharma. 1) Your answer must consist of ONE the following: An entity-relationship (ER) diagra
Consider an information system designed for an online company which provides IT products and services. These include desktops, laptops, networking products, IT books, parts, and te
Many-to-many : Entities in A and B are related with any number of entities from each other. Example: Taught_by Relationship among course and faculty. One faculty member ca
What is a homogeneous distributed database? In homogeneous distributed databases, all sites have the same database management system software, are aware of one another, and agr
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