[DUG] Stored procedures and business logic

[kurt]

Neven MacEwan wrote:
> All the constraint/ri ui code can a) be extracted out of the DB or b) be 
> autogenerated from metadata
> 
>  > Where does referential integrity end and business logic begin anyway?

  - a database is a collection of constraints
  - a business rule is a constraint

> firstly I make the distinction in the respect that a change in business 
> rules should not alter your ri, the difference is breaking ri would 
> result in "what the sh#t is this", breaking business rules results in 
> "should we be allowing this sh#t"


I don't see the difference : referential integrity is one
(the most common) way of implementing business rules.

"unique index on client ID" is a simple RI statement,
that enforces the rule that client ID's are unique within
that set of data, no?


> Its basically the same mismatch that exists between an OO system and a 
> Relational Database, it all goes away if you accept/assume that a row of 
> a table is a class instance persisted, the question is should you?

Nope. Class = Type ;)


Cheers, Kurt.