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.
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
