Why is database integrity so impopular ?
Date: Sun, 5 Oct 2008 11:30:58 -0700 (PDT)
Message-ID: <2ecca0cf-6917-47a3-b95c-8e59e122bbd8_at_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 - 20:30:58 CEST