Search notes:

ACID

ACID = Atomicity, Consistency, Isolation, Durability
(As per other sources, the A stands for Accuracy, the C for Completeness)
A transaction is a sequence of »unit of works« whose sum represents an »indivisible logical unit of work«. Transactions are fundamental to (distributed) applications.
Atomicity: all »units of work« or none.
Consistency: a transaction brings the system from one consistent (non contractional) state to another.
Isolation: Effects of »unit of work« are not visible outside the transaction until transaction is completed successfully (see also SQL: Isolation level[isolation level)
Durability: After completion, the transaction will survive system failures.

No track of data history

Note: The ACID properties have no notion of keeping track of data history.
However, such a history is often a requirement for DWHs: What was a customer's amount of open orders on the 7th of May 2014?.
Also, similar requirements for auditing: who deleted/updated which record.
Such requirements might be met with support for temporal data which entered the SQL standard in 2011.

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1740452404, '18.191.116.231', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/common/ACID(63): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78