Can you explain the principle of atomic operations in databases or computing systems?

An atomic operation is an operation that is executed completely or not at all, without intermediate states. In databases, this is a key principle of transactions: either all changes within a transaction are applied, or none are, ensuring data integrity.

In computing systems, atomicity means that an operation cannot be interrupted and is only visible to other threads in its final state — this is important for the correct operation of multithreaded programs.

Example in Java using an atomic operation:

import java.util.concurrent.atomic.AtomicInteger;

public class AtomicExample {
    private AtomicInteger counter = new AtomicInteger(0);

    public void increment() {
        counter.incrementAndGet(); // atomic increment of the value
    }

    public int getCounter() {
        return counter.get();
    }
}

Here, the method incrementAndGet() guarantees that the counter increment will occur as an indivisible operation, without race conditions between threads.