Consistency

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

Database – Data Concurrency, Data Consistency and Isolation Level

In the previous posts, we read about database transactions and how we can manage them in Java and PHP on different layers. In this post, we will read about data concurrency/consistency and figure out how to properly set the isolation level of an explicit DBMS transaction. We will see several examples using three distinct RDBMS: … Read moreDatabase – Data Concurrency, Data Consistency and Isolation Level

Transaction: ACID Properties and CAP Theorem

Transaction

Introduction In this reading, we will explain some principles on which database transactions are based: ACID Properties (don’t forget to read about Jim GRAY) and CAP Theorem. Transaction A transaction is a single logical unit of work that reads, and possibly changes, the contents of a database. Transactions are made up of one or more … Read moreTransaction: ACID Properties and CAP Theorem

© 2024 The IT Consultant • Powered by