Pros and cons of concurrency:
If transactions are run one at a time then every transaction will see the consistent state left behind by its predecessor. However if several transactions are scheduled concurrently then the inputs of some transaction may be inconsistent even though every transaction in isolation is consistent.
Concurrency is introduced to get better system response as well as utilization.
a) It shouldn’t cause programs to malfunction.b) Concurrency control shouldn’t consume more resources than it “saves”.
If the database is read-only afterwards no concurrency control is needed. Nevertheless if transactions update shared data then their concurrent execution needs to be regulated so that they don’t update the same item at the same time.
If all transactions are simple as well as all data are in primary storage then there is no need for concurrency.
Nevertheless if any transaction runs for a long time or does I/O then concurrency perhaps needed to improve responsiveness and utilization of the system. If concurrency is authorized then long-running transactions will (usually) not delay short ones.
Concurrency should be regulated by some facility that regulates access to shared resources.
Data management systems usually use locks for this purpose.
The simplest lock protocol acquaintances a lock with each object. Whenever utilizing the object the transaction acquires the lock and holds it until the transaction is complete. The lock is a serialization mechanism that assures that only one transaction accesses the object at a time. It has the effect of alert others that the object is busy and of protecting the lock requestor from modifications of others.
This protocol varies from the in sequence reusable resource protocol common to most operating systems (and recently renamed monitors) in that the lock protocol holds locks to transaction commit. It will be discussed below that this is a critical difference.
Responsibility for requesting as well as releasing locks can either be assumed by the user or be delegated to the system. User controlled locking results in potentially less locks due to the user’s knowledge of the semantics of the data. Alternatively user controlled locking requires difficult and potentially unreliable application programming. Therefore the approach taken by most data base systems is to use automatic lock protocols which insure protection from inconsistency while still allowing the user to specify alternative lock protocols as an optimization.
Latest technology based Operating System Online Tutoring Assistance
Tutors, at the www.tutorsglobe.com, take pledge to provide full satisfaction and assurance in Operating System help via online tutoring. Students are getting 100% satisfaction by online tutors across the globe. Here you can get homework help for Operating System, project ideas and tutorials. We provide email based Operating System help. You can join us to ask queries 24x7 with live, experienced and qualified online tutors specialized in Operating System. Through Online Tutoring, you would be able to complete your homework or assignments at your home. Tutors at the TutorsGlobe are committed to provide the best quality online tutoring assistance for Operating System Homework help and assignment help services. They use their experience, as they have solved thousands of the Operating System assignments, which may help you to solve your complex issues of Operating System. TutorsGlobe assure for the best quality compliance to your homework. Compromise with quality is not in our dictionary. If we feel that we are not able to provide the homework help as per the deadline or given instruction by the student, we refund the money of the student without any delay.
Theory and lecture notes of Transistor Inverter Applications II, all along with the key concepts of Relay Driving Circuit, Steps for finding Relay driving and Assignment help. Tutorsglobe offers homework help, assignment help and tutor’s assistance on Transistor Inverter Applications II.
www.tutorsglobe.com offers answering questions to external diseconomies, types of external diseconomies, economics homework help - assignment help by live tutors.
www.tutorsglobe.com offers engineering homework help, engineering assignment help, engineering tutoring assistance, projects help with best qualified engineering tutors.
tutorsglobe.com leverage consequence on roe assignment help-homework help by online leverage tutors
tutorsglobe.com cloning of sheep assignment help-homework help by online cloning tutors
tutorsglobe.com types of tax assignment help-homework help by online definition of a tax tutors
tutorsglobe.com pathogenesis assignment help-homework help by online corynebacterium diphtheria tutors
fungi tutorial all along with the key concepts of structure of fungi, nutrition and growth of fungi, reproduction in fungi, fungi adaptation and economic significance of fungi
Theory and lecture notes of Production Cost in the Short-Run all along with the key concepts of production cost in the short-run, Assignment help, Homework help, Marginal Variable Cost, condition of minimum AVC. Tutorsglobe offers homework help, assignment help and tutor’s assistance on Production Cost in the Short-Run.
Theory and lecture notes of Price level and Inflation all along with the key concepts of Price level and inflation, Consumer Price Index, Inflation Rate, Paasche index and Laspeyres index. Tutorsglobe offers homework help, assignment help and tutor’s assistance on Price level and inflation.
Crystal classification tutorial all along with the key concepts of Fundamental types of lattices, Direction indices, Miller indices, Determination of Miller Indices, Principles of Miller Indices
History and Present Trends in Cell Biology tutorial all along with the key concepts of First Cells Seen in Cork, Formulation of the Cell Theory, Modern Cell Theory, Timeline of cell biology
www.tutorsglobe.com assignment help tutorial for general methods for solving operation research or models, which are analytic method, monte-carlo method, iterative method.
Aves tutorial all along with the key concepts of Introduction to Aves, External Features of Birds and Adaptive Features of Flight
tutorsglobe.com parathyroid gland assignment help-homework help by online co-ordination systems tutors
1935914
Questions Asked
3689
Tutors
1476000
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!