Optimistic concurrency control sets few locks on the data

Assignment Help Database Management System
Reference no: EM13166361

Optimistic concurrency control sets few locks on the data in the database, lowering the isolation level that you use in an application. This allows more applications to run concurrently and potentially increases the throughput of the applications. This strategy attempts to obtain locks on the required resources only when the transaction completes.
Pessimistic concurrency control implements a higher isolation level by placing locks on the database at the beginning of a transaction. In other words, pessimistic locking assumes there will be a collision in the database and takes precautions to prevent these collisions. A pessimistic locking strategy protects the integrity of the database by guaranteeing, from the beginning of the transaction, that no conflicting transaction can run concurrently.
The optimistic concurrency control strategy always allows a transaction to start but cannot guarantee that it will complete. The pessimistic locking strategy cannot guarantee that a transaction will be able to start, but it guarantees that, once started, any transaction can complete.
A data warehouse has many fetches, or SELECTs, and few DMLs, or UPDATEs, INSERTs, and DELETEs. An online transaction processing (OLTP) application usually has many DMLs and few SELECTs. Remember that rows selected from a partially complete transaction may not be consistent.
Discuss the following points:Identify one benefit and one drawback of each concurrency control strategy in an OLTP application. Explain.Identify one benefit and one drawback of each concurrency control strategy in a data warehouse. Explain.Suggest a scenario for a hypothetical OLTP business system where optimistic concurrency control is most appropriate and another scenario where pessimistic concurrency control is most appropriate.How would the type of user, such as a computer program, an internal business user, or a customer on the web, affect your choices? 

Reference no: EM13166361

Questions Cloud

Describe the law and environmental law : As an environmentalist, you are very interested in how economics plays a role in determining how many and what type of environmental laws are passed. There are many environmental laws that are determined by economic conditions.
Calculate the mass percentage of nitrogen in the sample : If 86.0 mL of .150 M HCL is needed to neutralize all the NH3 from a 2.25-g sample of organic material, calculate the mass percentage of nitrogen in the sample.
Add an embedded style sheet : Add an embedded style sheet to set the following: a. links class (no pseudoclasses): position of the text should be absolute and 150 pixels from the top; the text should display in a block, center-aligned in bold with 1em sans-serif; padding of te..
What would coefficent of al(no3)3 be in balanced equation : what would the coefficent of Al(NO3)3 be in the balanced equation?
Optimistic concurrency control sets few locks on the data : Optimistic concurrency control sets few locks on the data in the database, lowering the isolation level that you use in an application. This allows more applications to run concurrently and potentially increases the throughput of the applications. Th..
Calculate the ratio of the concentration of carbonic acid : The pH of a bicarbonate-carbonic acid buffer is 8.00. Calculate the ratio of the concentration of carbonic acid (H2CO3) to that of the bicarbonate ion (HCO3-).
Calculate its molar heat of vaporization : The vapor pressure of dichloromethane,CH2Cl2, at 0 C is 134 mmHg. The normal boiling point of dichloromethane is 40 C. Calculate its molar heat of vaporization.
Equal rental payments are due on january : The term of the noncancelable lease is6years, with no renewal option. The equipment reverts to the lessor at the termination of the lease and equal rental payments are due on January 1 of each year, beginning in 2012.
Calculate the heat of combustion of propane : burning 480 cm3 of propane measured at r.t.p,caused the temperture of 250 cm3 of water to increase by 42.5 celsius. calculate the heat of combustion of propane.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Code an oracle database trigger

Code an Oracle Database trigger to enforce the constraint that an employee can never change his or her department.

  Graph the bond yield to maturity

Identify two possibly mispriced bond issues, one overpriced and one underpriced. and graph the bond yield to maturity (YTM) on the y-axis of an XY-scatter plot, with the bond to maturity in years on the x-axis.

  What do you mean by data base scheme

Database Questions:  What do you mean by data base scheme?  What do you mean by cardinality ratio?   What do you mean by degree of relation?

  Dba denormalized products database to enhance performance

The DBA denormalized some of the data in Premiere Products database to enhance performance, and one of the resulting tables is following.

  Design a database schema

Design a Database schema

  Explain denormalized table in normal form

The DBA denormalized some of the data in the Premiere Products database to improve performance. Which field or fields cause the table to no longer be in third normal form? In which normal form is the denormalized table?

  Design database for company organized into departments

Database designers stated following dimension of "miniworld"- to be represented in Company Supplier-Part database: company is organized into departments. Each department has unique name, unique number.

  Explaining emp table does not have assigned primary key

Developers have noticed that EMP table doesn't have an assigned primary key. EMP_ID column has been selected to be the primary key.

  Relations of airline flight information

The relations given below keep track of airline flight information:Flights(flno: integer, from: string, to: string, distance:integer, departs: time, arrives: time, price: real)Aircraft(aid: integer, aflame: string, cruisingrange: integer)

  Write long term problems when constraints are implemented

Why are these so significant yet so frequently ignored by developers? Write the long term problems when these constraints are not implemented? "

  Evaluate the functional dependencies

What are the functional dependencies among the data represented in this first normal form relation?

  What are the main activities that the business undertakes

What are the main activities that the business undertakes and where in the business are the crucial decisions made?

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