Question

- 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?

Answer 1

Answer 1.

Benefits of Optimistic concurrency:

• These are exceptionally adaptable.
• Sine the most extreme tasks in the data product house is just perused, along these lines the optimistic concurrency is the best for getting to the data from the data product house.
• On the off chance that every one of the activities in the transaction framework is perused activity, the framework will never go in stop or disappointment condition.

Benefits of Pessimistic concurrency:

• These are exceptionally dependable.
• Since it doesn't enable different clients to play out the activity simultaneously for a similar sort of the data in this way it is exceptionally trustful that the data recovery is similar which the client required.

Drawbacks of Optimistic concurrency:

• Absence of steady data.
• Optimistic concurrency doesn't bolt the variable before getting to them. In this manner, there is a likelihood that a client can misunderstand the document.

Drawbacks of Pessimistic concurrency:

• Getting to the speed of the data is exceptionally low.
• Since the pessimistic concurrency control doesn't enable other's clients to get to similar data simultaneously its presentation is exceptionally low.

Answer 2.

The scenario of Optimistic concurrency:

• For large hierarchical data like nation data optimistic concurrency is the best.

The Scenario of Pessimistic concurrency:

• For little hierarchical data like school data pessimistic concurrency is the best.

Answer 3.

Optimistic concurrency:

Effects of the accompanying kinds of clients on the decisions.

Computer program:

Compute program will take additional time.

Inward business client:

Business specialists will work fine in this situation.

Client on the web:

Customers on the web may lose his solicitation or his solicitation can go for interminable circle search.

Pessimistic concurrency:

Effects of the accompanying sorts of clients on the decisions.

Computer program:

Compute program will consistently get the right data.

Inner business client:

Business laborers will go moderate.

Client on the web:

Customers on the web will consistently get his solicitation. In this situation no compelling reason to hang tight for quite a while.