[Info-Ingres] String Manipulations

[Emiliano]

On 2007-03-19, martin.bowes at ctsu.ox.ac.uk <martin.bowes at ctsu.ox.ac.uk> wrote:
> --Alt-Boundary-24028.29339281
> Content-type: text/plain; charset=US-ASCII
> Content-transfer-encoding: 7BIT
> Content-description: Mail message body
>
> Hi Ian et al
>
> To my mind there seems to be some disagreement over exactly what 
> constitutes 'Business Logic'. For example you say:
>     don't confuse enforcing data relationships, constraints, 
>     domains, etc. with business logic.
>
> But in my experience, database RFPs, constraints have encapsulated a 
> significant quantity of the stuff I would consider 'business logic'. ie all 
> the 'don't allow this to occur, unless this has been done first stuff'.

That's pretty much what I have in mind.

> But how far does this go. For example, I have a requirement to have 
> encrypted network communication. So I tuned the installation to have 
> the ib/ob_encrypt_mode = required. Is that Business Logic? At what 
> point do we generalise the term so much as to make it meaningless?

OK, so what I specifically mean is enforcing BR that relate directly
to the data you're storing. I have no intention of enforcing Casual
Friday dresscodes in the DB (although I know a few people who'd gladly
give it a shot -- were it not for the fact that they're on
Super-Casual Eternity).

> Personally speaking, I load the database with as many RFPs and 
> constraints as I can think of installing...But people are quite right to 
> insist that this is only part of the story.

Of course. The DB is not the primary interface to the user, so it
should not be involved in the user interaction (not directly, at
least). It's the minder of the data. I prefer to let it do that to the
best of it's abilities. If the data doesn't need BL enforced, then
sure, why bother. But if it does, why would you allow any connecting
(version of an!) app decide on it's own what constitutes valid data at
that given point in time?

SOA was mentioned as the place to handle BL. And I do agree with that,
*in addition to* ground rules enforced by the DB.

-- 
Emiliano