answersLogoWhite

0

Concurrency means use of database by many users at the same time.Concurrency control techniques (Different techniques) are used control multiple transactions interfere each other to produce wrong results.

therefore one of the main techniques used to control concurrent execution of transaction is based on the concept of locking of data item.

A lock is a variable associated with a data item in the database and describes the status of that item with respect to possible operation that can be applied to that item.

Generally there is a one lock for each data item in the database.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

Techniques of strategic control?

Different techniques


What are the tools and techniques used by RBI for monetary control?

techniques of monetary control of rbi


What are the Techniques used for control of labor cost?

how cost planning techniques are used to control the costs of a construction project


Which techniques are used to control data flow?

Buffering and windowing


What is a Lock in DBMS?

One major problem in databases is concurrency. Concurrency problems arise when multiple processes try to update or insert data into a database table at the same time. Such concurrent updates can cause data to become corrupt.Locking is a strategy that is used to prevent such concurrent updates to data.When a database system modifies data in one of its tables it first acquires a lock. When a table is locked, only the process the acquired the lock is allowed to modify the data in the table. Other processes will have to wait until the lock is released before they can make their changes. Now, this is a simple representation of how locking works. In reality databases can use different locking strategies.Depending on the database system, locks can be acquired on entire tables (table-level locking) or on individual rows (row-level locking).


What is data concurrency?

Data concurrency is used for organizing data sets. It helps keep the data sets for replicated and the official source of data uniform by using and updating multiple databases simultaneously.


How effective were the nazi techniques being used to maintain control?

The Nazi techniques were very effective in maintaining control, because people feared them. People had to obey the Nazi parties orders otherwise they would be punished.


Which Point Of Concurrency can be used to determine the type of Triangle?

its lame because I cant find this answer online either


What is a lock in?

One major problem in databases is concurrency. Concurrency problems arise when multiple processes try to update or insert data into a database table at the same time. Such concurrent updates can cause data to become corrupt.Locking is a strategy that is used to prevent such concurrent updates to data.When a database system modifies data in one of its tables it first acquires a lock. When a table is locked, only the process the acquired the lock is allowed to modify the data in the table. Other processes will have to wait until the lock is released before they can make their changes. Now, this is a simple representation of how locking works. In reality databases can use different locking strategies.Depending on the database system, locks can be acquired on entire tables (table-level locking) or on individual rows (row-level locking).


What biological and sociological techniques can be used to slow world population growth?

The biological techniques that can be used to slow world population growth include the various forms of birth control for both men and women. The sociological techniques include by law (as in China) or by religious declaration.


What techniques can be used to improve the sound quality and control of flute low notes?

To improve the sound quality and control of flute low notes, techniques such as proper breath support, embouchure control, and adjusting the angle of the flute can be used. Additionally, practicing long tones and scales in the low register can help develop a strong and consistent sound.


What are the different parallel modes used in computer programming?

In computer programming, the different parallel modes used are parallelism, concurrency, and distributed computing.