Guaranteeing Data Integrity with MySQL 5.0

December 1, 2005

[From MySQL AB]

The IT crown jewels of any organization lies in their database infrastructure. Obviously, well-designed front end applications play a leading role when it comes to ensuring that critical information is captured or reviewed, but the buck stops at the database when it comes to data retention and protection.

Because such things are the database's responsibility, it is important that the underlying engine act in ways that preserve the integrity and validity of the data. This means the RDBMS should stand guard and deny entry of any and all invalid data through the welcome gates of the actual database.

The article continues at http://dev.mysql.com/tech-resources/articles/mysql-data-integrity.html