Multi-user database Essay Example | Topics and Well Written Essays - 250 words

Multi-user database - Essay ExampleIn addition, the concurrency control is significant for the reason that the concurrent execution of multi-user database transactions those are performed in a incorporated database arrangement can provide basis for some of the reliability and integrity issues. In this regard, for the proper establishment of the concurrency control the method of the locking is used that involves the authorization regarding private utilization of a data item to a database operation. Normally, let if database transaction A1 holds a lock on a database data item, after that another(prenominal) operation A2 does not have right to use that data item (WordPress, 2010), (Wikia, 201) and (Hoffer, Prescott, & McFadden, 2007). In case of the transaction management we need to ensure that multi-user database transactions or operations are clear, means that every transaction should have preserved database integrity all through multiple userss operations trying to entranceway the databases. In addition, transactions have to be as well divided into subordinate-transactions since every subordinate-transaction can affect the single database system.