CLOUD COMPUTING
DATABASE MANAGEMENT
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Client Server
|
|
Network
|
|
Transaction
|
|
Optimistic locking
|
Detailed explanation-1: -Optimistic locking is a technique for SQL database applications that does not hold row locks between selecting and updating or deleting a row. The application is written to optimistically assume that unlocked rows are unlikely to change before the update or delete operation.
Detailed explanation-2: -There are two models for locking data in a database: Optimistic locking, where a record is locked only when changes are committed to the database. Pessimistic locking, where a record is locked while it is edited.
Detailed explanation-3: -Optimistic locking allows you to lower the isolation level that you use in an application so that fewer locks are placed on the database assets. It allows more applications to run concurrently against the database, and potentially increase the throughput of your applications.
Detailed explanation-4: -The DataSet object is designed to encourage the use of optimistic concurrency for long-running activities, such as remoting data and interacting with data. Pessimistic concurrency involves locking rows at the data source to prevent other users from modifying data in a way that affects the current user.