Define concurrency control with traction process ( BCA- 5 semester)

 Concurrency control:- 

Concurrency control is apply in a data base environment which insured the schedule produce by any user which implement the concurrent transaction process. It includes locking system, time base method schedule and multi- value technique. The locking technique insured the multiple condition access the data base in a system.

Locking for concurrency:-

A lock is a variable which associate with a data items which describes a status of any value which respect to possible operation apply in a complete data base.

Types of locking:-

1.) Binary locking:- A binary locking can have state of value one is lock[1] and other is unlock[0]. Then user transfer the request and define positive response.

2.) Share locking:- It is also known as read locks value beacuse all the data base apply to read and write operation beacuse a single transaction hold the lock value in the data base.

3.) Certify lock:- It improve the performance of data base through locking protocols.

Transaction process:- 

Transaction refers to collection of operations which performs single logical unit work at the data base user. It is unit of program which execute different operation such as update. It is SQL command. It includes following property when the user required transaction process in data base system.

a). Automatic

b). Consist

c). Hexible

d). Portable

e). Control