blog




  • Essay / Transaction Management Essay - 698

    These are as follows:1. Pessimistic Locking: This control strategy must remain locked throughout its stay in database memory. One of the main drawbacks is that it limits or prevents people from modifying the locked data entity. Pessimistic locking attempts to ensure database changes are secure, but this is not always made possible by the increasing number of users and interactions with the database. Significantly slow down the operation within the database.2. Optimistic Locking: Optimistic locking does not attempt to prevent collisions from occurring, but it aims to detect when they are going to occur, then it attempts to thwart and resolve any issues that might arise, meaning that these instances can be avoided. Optimistic Lock On On the other hand, this may alleviate the problem of waiting for locks to unlock, but it will increase the possibility and potential of crashes and collisions occurring when trying to update the system.