Data Access Layer

An update is lost when a user overrides the current database state without realizing, that someone else changed it between the moment of data loading and the moment the update occurs. In this post, I will give detailed description of this phenomena and typical ways to prevent it.

Database Transaction represents a unit of work, that is atomic, consistent, isolated and durable (a.k.a. ACID).