What are the design issues of Concurrency in programming? Briefly discuss.
Explanation:
There are the following design issues of Concurrency which are explained below
(i). Temporary Update Problem
(ii). Incorrect Summary Problem
(iii). Lost Update Problem
(iv). Unrepeatable Read Problem
(v). Phantom Read Problem
(i). Temporary Update Problem
A temporary update problem occurs when one transaction updates an item and fails. But the updated item is used by another
transaction before the item is changed or reverted back to its last value.
(ii). Incorrect Summary Problem
Consider a situation, where one transaction is applying the aggregate function on some records while another transaction is updating these records. The aggregate function may calculate some values before the values have been updated and others after they are updated.
(iii). Lost Update Problem
In the lost update problem, an update done to a data item by a transaction is lost as it is overwritten by the update done by another transaction.
(iv). Unrepeatable Read Problem
The unrepeatable problem occurs when two or more read operations of the same transaction read different values of the same
variable.
(v). Phantom Read Problem
The phantom read problem occurs when a transaction reads a variable once but when it tries to read that same variable again, an error occurs saying that the variable does not exist.
Discuss pros and cons of pessimistic concurrency in relation to optimistic concurrency. Discuss pros and cons of explicit transactions in relation to implicit transactions and vice versa.
Q6: To provide a high degree of transaction concurrency in DBMS and ensuring that all schedules are conflict, recoverable and cascadeless, we need some concurrency control mechanisms for that purpose. Briefly explain three concurrency control mechanisms with real-world application for each of those mechanism.
Discuss the deadlock avoidance, detection and resolution for database concurrency control?
ATTEMPT ALL QUESTIONS Compare and contrast Pessimistic and Optimistic Concurrency Control techniques. 5 marks Describe quorum-based protocol for distributed concurrency control. 5 marks Discuss how distributed systems are used in organizations 10 marks Discuss the techniques used to facilitate distributed query processing and Optimization. 10 marks
database of operating system Purpose: To help you know about the main concepts of concurrency control and recovery. Topic of Discussion: According to the conflicts and failure in transactions processing, the need of concurrency control and recovery appeared. Discuss the differences between concurrency control and recovery in terms of: · The purposes. · The algorithms. · The problems.
What are the parallelism and concurrency? What is the different between them?
Question 9 What design options are involved in a computer bus design? Clocking issues only for the control bus and packet issues in the data bus Data width and disk rotation rate Bus width and the number of bus masters Block size in data transfer and overall data amount
What are the key design issues for a microprocessor instruction set? Why do you consider the above design issues to be important?
Using scala concurrency programming with akka to solve the fallowing: Develop an actor program for computing Fibonacci numbers concurrently. Particularly, create an actor which receives a request for a particular Fibonacci number from a client actor. If it is one of the base cases, the actor replies with a message containing the answer; otherwise, it creates the two sub-problems you would normally create in a recursive implementation. It then creates two new (Fibonacci) actors, and sends one subproblem to each....
Materials and process selection are key issues in optimal design of industrial products. Process planning for parts is determined largely by the material out of which the part is made and the part design itself. Using a practical example, discuss in detail the two different materials which could be selected to fabricate a specific part and outline the the following: • A basic process • One or more secondary processes • Operations to enhance physical properties • Finishing operation That...