What is Denormalization?

This is simply the process of combining smaller tables to make larger tables. This can be used to address problems with performance or scalability. This is usually caused by tables being stored in separate files on disks and when databases are being queried   there is a requirement for each several files to be accessed according […]

What is ACID ( Atomicity, Consistency, Isolation, Durability)?

Atomicity – this basically means the transaction works or doesn’t and is sometimes called the “all or nothing” rule. I always liken it to an Atomic bomb because they either work or fail. A failed transaction would then enter a state of rollback. Consistency – this means only valid data is  written to the database. […]