A beginner's guide to ACID and database transactions - Vlad Mihalcea
Imagine having a tool that can automatically detect JPA and Hibernate performance issues. Wouldn’t that be just awesome? Well, Hypersistence Optimizer is that tool! And it works with Spring Boot, Spring Framework, Jakarta EE, Java EE, Quarkus, or Play Framework. So, enjoy spending your time on the things you love rather than fixing performance issues in your production system on a Saturday night! Transactions are omnipresent in today’s enterprise systems, providing data integrity even in highly concurrent environments. So let’s get started by first defining the term and the context where you might usually employ it. A transaction is a collection of read/write operations succeeding only if all contained operations succeed. Inherently a transaction is characterized by four properties (commonly referred as ACID): In a relational database, every SQL statement must execute in the scope of a transaction. Without defining the transaction boundaries explicitly, the database is going to use an
A beginner's guide to ACID and database transactions - Vlad Mihalcea Vlad Mihalcea Leave a Comment Posted on January 5, 2014 by vladmihalcea A beginner’s guide to ACID and database transactions Last modified: Follow @vlad_mihalcea Are you struggling with performance issues in your Spring, Jakarta EE, or Java EE application? Imagine having a tool that could automatically detect performance issues in your JPA and Hibernate data access layer long before pushing a problematic change into production! With the widespread adoption of AI agents generating code in a heartbeat, having such a
related reading
- DBMS Musings: It’s Time to Move on from Two Phase Commitdbmsmusings.blogspot.com
- What's an ACID compliant database? | Retool Blogretool.com
- Snapshot isolation - Wikipediaen.wikipedia.org
- PostgreSQL: Documentation: 18: 13.2. Transaction Isolationpostgresql.org
- GitHub - jorzel/concurrency-control: In this repo I would like to show 4 strategies of concurrency control for writing data using Python SQLAlchemy ORM and PostgresSQL (however this examples could be easily transformed to plain SQL).github.com
- A Distributed Systems Reading Listferd.ca
- Database Fundamentalstontinton.com
- Distributed Systems Safety Researchjepsen.io
- 51 Database Terms You Need to Knowdzone.com
- Analysesjepsen.io
- https://pdos.csail.mit.edu/6.824/notes/l-spanner.txtpdos.csail.mit.edu
- An Overview of Distributed PostgreSQL... | Crunchy Data Blogcrunchydata.com