Database

Decoding Pessimistic Locking: Ensuring Data Integrity in Concurrent Applications

The previous post discussed the “Optimistic Logic” and how Hibernate implements it. This new post will discuss the “Pessimistic Logic” technique and how to implement it using Hibernate. What is the Pessimistic Locking? Locking is a critical concept in the world of databases and transaction management. As the name suggests, Pessimistic Locking takes a conservative … Read moreDecoding Pessimistic Locking: Ensuring Data Integrity in Concurrent Applications

Optimistic Locking – How Hibernate implements it

In the previous post, we discussed the theory behind the indexes used in a DBMS to improve the data searching on a database table. This new post will discuss the “Optimistic Logic” technique and how to implement it using Hibernate. What is the Optimistic Locking? Optimistic Locking is a technique used in computer science to … Read moreOptimistic Locking – How Hibernate implements it

Database – Indexes, data sorting and searching improvement

In the previous post, we discussed data concurrency/consistency and figured out how to properly set the isolation level of an explicit DBMS transaction. In this new post, we will discuss the theory behind the indexes used in a DBMS to improve the data searching on a database table. Types of indexes Indexes in a database … Read moreDatabase – Indexes, data sorting and searching improvement

© 2024 The IT Consultant • Powered by