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

Multi-user database - Essay Example In addition, the concurrency control is significant for the reason that the concurrent execution of multi-user database transactions those are performed in a collective 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 assurance 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 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 users’s operations trying to access the databases. In addition, transactions have to be as w ell divided into subordinate-transactions; since every subordinate-transaction can affect the single database system.