#databases

2 public notes

Why a database transaction groups several changes

A database transaction can make a group of changes succeed together or leave none of them applied. When moving a booking between rooms, deleting the old assignment without creating the new one would leave incomplete data. Atomic transactions prevent that particular partial result within the transaction's scope.

Technology♡ 0🔖 0

databases

How a database index avoids checking every row

A database index stores selected values in a structure designed for efficient lookup. Instead of examining every row to find a matching email address, the database may use the index to narrow the search. This can speed reads, but the extra structure consumes storage and must be maintained when relevant data changes.

Technology♡ 0🔖 0