Four Principles of Database Design

SQL - Four Principles of Database Design

When designing and implementing a database, keep in mind these four guidelines.

Atomicity:

Your coded statements flow without the constant need to update or "fix" your data.

Consistency:

Your statements are either executed 100% or fail 100%, do not implement code that partially works.

Isolation:

Keep data files and logs away from public eyes, and limit the number of users with administration access to your database.

Durability:

Maintain reliable servers with plenty of storage space and back-up systems that save transactions immediately.