Day 5. Putting Business Logic in the Data Tier
Modern day relational database management systems (RDBMS) can do a great number of things, including applying business rules to your data. The ability to apply business rules at the DBMS level adds a great deal of efficiency and ensures that your data is consistent. However, as with anything, it is possible to do too much in the RDBMS and thus affect scalability, portability, and maintainability. Although there are no hard and fast rules, we will look at the factors that go into deciding where to place data validation rules. Business rules are the practices and policies that define a company's behavior. Examples of business rules are return policies, credit rules, and so on. SQL Server and most other ...
Get Sams Teach Yourself Microsoft® Windows® DNA Programming in 21 Days now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
