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.

http://manusqlinfo.blogspot.com/2007/08/four-principles-of-database-design.html

Leave a Reply

Your email address will not be published. Required fields are marked *