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

Previous Q& A

  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.

  Identify and correct the errors

Identify and correct the erros in the following program. void nPrintln(string message, int n){int n=1;for (int i=0; i int main (){nPrintln(5, "Welcome to C++!");}

  Constructor that accepts a file name as its argument

Write a class with a constructor that accepts a file name as its argument. Assume the file contains a series of numbers, each written on a separate line. The class should read the contents of the file into an array, and then displays the following..

  Estimate the radius of the molecules

The critical constants of ethane are Pc = 48.20 atm, Vc = 148 (cm^3)/mol, and Tc = 305.4 K. Calculate the van der Waals parameters of the gas, and estimate the radius of the molecules.

  Method summarizesequences that takes a string as a parameter

Now implement the method summarizeSequences that takes a String as a parameter. This method should open the file named by this String, and read a sequence from that file into an array list using the getSequence method you wrote above

  Writing return statement in a value returning function

What would be wrong with not writing returnstatement in a value returing function? Can you have a returnstatement in a void function? Does the return statement in the following function cause syntax error?

  What are the data entities of this enterprise

Consider a student club or organization in which you are a member. What are the data entities of this enterprise? List and define each entity


Write a Review


Similar Q& A

  Write benefits of using dbms to manage data in program

Describe briefly what are the main benefits of using DBMS to manage data in program applications involving extensive data access.

  Prepare a set of non-functional requirements

Need a system that networks its 3 campuses in the US and one campus in Singapore. Transaction data for all campuses should be available to all locations. In addition, students should be able to use the Internet to view classes, enroll, register, and ..

  Create an e-r diagram

You have probably seen that already when you tried to create an E-R diagram. Visio uses notation and graphical shapes that are not the same as those in your text. If you look at some of the links to schemas, you will see a similar sort of thing.

  Recognize business processes evaluated-dw-bi application

Identify the business processes which would be evaluated and tracked with a DW/BI application and state your reasoning or justification for including these in the DW/BI.

  Create a context level dfd

Create a context level DFD. You should take your DFD to your tutorial for feedback before starting on the ER.

  Explaining valid host addresses of wan links

Start with LAN on RTA and proceed clockwise. Determine the number that how many total valid host addresses will be wasted on WAN links?

  Sales transaction in retail clothing

Examine different sales transactions. Design a context diagram and a level-0 diagram that represent the selling system at the store.

  Describe implement relationship between employees-projects

Describe how you would implement relationship between employees and projects in each of the given scenarios: Many employees can work on given project, but each employee can work on only single project.

  Database to keeps track of students in university

University XYZ needs a database that keeps track of students, what classes they taken and the grades for each of the classes.

  Drawing active directory hierarchy in terms of forests

Draw Active Directory hierarchy in terms of forests, trees, domains, organizational units, and sites which are most suitable for this company and their security concerns.

  Write program to ask user to enter last name of customer

Write a program that will ask the user to enter the last names of our candidates in a class officer's president election and the number of votes received each candidate.

  Explaining database security relate to data integrity

In talking about database security, some aspects to regard as are Data Integrity, Confidentiality, and Malicious Activity. Illustrate how does database security relate to data integrity?

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