Computers and Technology, 17.12.2019 01:31 karankhatri1946

1. what is concurrency control? state and explain the different issues that may arise in the absence of concurrency control.
2. what are the different techniques to achieve concurrency control? summarize each of these concurrency control techniques.

Answers: 1

Show answers

Answers

1. Concurrency control is the process of managing simultaneous execution of transactions in a multiprocessing database system without having them interfere with one another. The transactions could mean different operation like queries, updates, inserts, deletes and so on.

Issues that may arise in the absence of concurrency control are:

a) The Lost update problem

b) The Temporary update (or dirty read) problem

c) The Incorrect summary problem

d) The Unrepeatable read problem

The Lost update problem: This problem occurs when two transactions that access the same database items have their operations interleaved in a way that makes the value of some database items incorrect.

The Temporary update (or dirty read) problem: This problem occurs when one transaction updates a database item and then the transaction fails for some reason. Meanwhile, the updated item is accessed (read) by another transaction before it is changed back (or rolled back) to its original value. This problem is also known as the dirty read problem.

The Incorrect summary problem: This problem occur if one transaction is calculating an aggregate summary function on a number of database items while other transactions are updating some of these items, the aggregate function may calculate some values before they are updated and others after they are updated.

The Unrepeatable Read Problem. This problem occur where a transaction T reads the same item twice and the item is changed by another transaction T′ between the two reads. Hence, T receives different values for its two reads of the same item.

2. The different techniques to achieve concurrency control are categorized into:

a) Lock-based protocol

b) Timestamp-based protocol

Lock-based protocol: Those database systems that are prepared with the concept of lock-based protocols employ a mechanism where any transaction cannot read or write data until it gains a suitable lock on it.

Timestamp-based Protocol: It is the most frequently used concurrency protocol is the timestamp based protocol. This protocol uses either system time or logical counter as a timestamp.

Explanation:

Answer from: Quest

Answer b would be a good url

Answer from: Quest

I’d say platform as a service (paas) or application platform as a service (apaas) or platform base service is a category of cloud computing services that provides a platform allowing customers to develop, run, and manage applications without the complexity of building and maintaining the infrastructure typically associated with developing and launching an app.

Another question on Computers and Technology

Computers and Technology, 22.06.2019 11:00

Technician a says that the radiator usually cools better if the front air dam is removed. technician b says that when a condenser has a leak it can be repaired easily with epoxy. who is correct?

Answers: 1

Answer

Computers and Technology, 23.06.2019 07:00

Why were most movies from the late 1890s until the early 1930s only filmed in black and white? there were only a few people who could afford the technology to produce color motion pictures back then. audiences did not want color motion pictures until later. the film used to make color motion pictures often overheated, which was a safety hazard, so it was generally not allowed. color films had to be hand-colored, frame by frame.

Answers: 3

Answer

Computers and Technology, 23.06.2019 14:30

Select the correct answer. which step can possibly increase the severity of an incident? a. separating sensitive data from non-sensitive data b. immediately spreading the news about the incident response plan c. installing new hard disks d. increasing access controls

Answers: 2

Answer

Computers and Technology, 23.06.2019 23:30

What can you prevent issues related to downloading content form the internet

Answers: 1

Answer

You know the right answer?

1. what is concurrency control? state and explain the different issues that may arise in the absenc...

Questions