O'Reilly logo

Building the Agile Database: How to Build a Successful Application Using Agile Without Sacrificing Data Management by Larry Burns

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

One important issue that needs to be addressed during database implementation is the question of what functionality should go into the database, and what functionality should go into the application’s business layer or data layer. Here are some suggested guidelines:

Implement in the database:

·         Data integrity constraints, including entity integrity (primary key), referential integrity (foreign key), and domain integrity (check or rule) constraints. These constraints should always be enforced in the database, as close to the data as possible, rather than in the application. This helps ensure that data corruption will not occur if there is an error in application coding, or if updates are made to the data outside an ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required