A powerful database schema is one of the key components of an enterprise application.  Using the database to enforce business logic and ensure data integrity enables both flexibility and scalability in application design.  By coding business logic in both the database layer and application layer, the database has the flexibility to then also be used by other applications and processes without fear of corrupting data.  In addition, other systems can take advantage of stored procedures or views that make future development easier, instead of the platform lock-in created by storing all business logic in the application itself.
Continue reading →