Why is database integrity so impopular ?
Date: Sun, 5 Oct 2008 11:30:58 -0700 (PDT)
Message-ID: <2ecca0cf-6917-47a3-b95c-8e59e122bbd8@i76g2000hsf.googlegroups.com>
Hello,
When time comes to build transactional databases (as opposed to data wharehouses), I belong to the school that STRONGLY believe in normalizing data with high integrity mechanisms. I know all the performance cons but IMHO, pros largely overwhelme.
It amazes me, though, how many systems rely on the application to manage data integrity. I work as IT director for a large-size manufacturer and *none* of our applications use integrity. And I am talking here of ERP and other mission-critical systems.
In fact, I had rarely open a database properly normalized and inforced ... and I have been working with databases for over 10 years, mostly in sectors where lack of integrity can result in dramatic consequences.
What is wrong with modern DB design approaches? And what's the point of using a big relational DB without the benefits of integrity and normalization?
Thank you,
EBL
Received on Sun Oct 05 2008 - 13:30:58 CDT