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.
tutorsglobe.com glycolysis assignment help-homework help by online respiration tutors
Xylem and Phloem tutorial all along with the key concepts of Anatomy of Xylem, Primary and secondary xylem, Phloem, Phloem Structure, Function of Phloem and Origin of the Phloem
tutorsglobe.com protein metabolism assignment help-homework help by online biochemistry tutors
Reproduction in Algae-Life Cycles tutorial all along with the key concepts of Chlamydomonas, Life Cycle of Chlamydomonas, Ulothrix, Life Cycle of Ulothrix, Ulva, Laminaria, Life Cycle in Laminaria, Fucus, Life Cycle of Fucus
Natural Radioactivity tutorial all along with the key concepts of Radioactivity: Natural and Artificial, Neutron-Proton Ratio and Nuclear Stability, Types of Radioactivity, Particles Emission and Position of Stable Region
Theory and lecture notes of Investment and the Real Interest Rate all along with the key concepts of Investment, Real Interest Rate, Exports and Autonomous Spending, Autonomous expenditure, Change in Exports. Tutorsglobe offers homework help, assignment help and tutor’s assistance on Investment and the Real Interest Rate.
tutorsglobe.com treatment of chlamydia assignment help-homework help by online chlamydia tutors
Theory and lecture notes of Complex Numbers all along with the key concepts of complex numbers, Imaginary number, Equality of Complex Numbers, Complex Conjugates and Graphing Complex Numbers. Tutorsglobe offers homework help, assignment help and tutor’s assistance on Complex Numbers.
tensed due to complex and time-consuming tasks? say goodbye to your woes with business economics assignment help!
tutorsglobe.com role of finance manager assignment help-homework help by online financial management tutors
www.tutorsglobe.com offers benzene & derivatives electrophilic substitution homework help, electrophilic substitution assignment help, online tutoring assistance, organic chemistry solutions by online qualified tutor's help.
Diversity of Disaccharides tutorial all along with the key concepts of Composition of Disaccharides, Sucrose, Lactose, Maltose, Trehalose, Cellobiose, Gentiobiose, Reducing and Non-reducing Disaccharides
tutorsglobe.com steps for computing npv assignment help-homework help by online net present value tutors
tutorsglobe.com significance of krebs cycle assignment help-homework help by online krebs cycle tutors
Tapeworms of man and other human cestode tutorial all along with the key concepts of Taenia spp, Morphology of Taenia spp, Pathology of Infection in Taenia spp, Diagnosis of Infection due to Taenia spp, Infection by Adult tapeworms and Infection by Larvae
1945767
Questions Asked
3689
Tutors
1440449
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!