The heart and soul of any enterprise system is its database. It is the biggest asset of the system on any given day. It is also the most vulnerable part of the whole system in such an exercise. No wonder database architects can sound mean and intruding whenever you ask them to make even the smallest change. Their domain is defined by database tables and stored procedures.
The health of their domain is judged by the referential integrity and the time it takes to perform various transactions. I don't hold them guilty for overdoing it anymore. They have a reason for this—their past experiences. It's time to change that. Let me tell you, this won't be easy, as we will have to utilize a completely different approach to handle data integrity ...
