Re: The Practical Benefits of the Relational Model

"Jan.Hidders" <hidders_at_hcoss.uia.ac.be> wrote in message news:3d6de600$1_at_news.uia.ac.be...
> In article <p7ib9.17835$g9.55546_at_newsfeeds.bigpond.com>,
> mountain man <prfbrown_at_magna.com.au> wrote:
> >
> >"Nathan Allan" <member_at_dbfoums.com> wrote in message
> >news:1748698.1030547357_at_dbforums.com...
> >>
> >> >> -Application logic can be centralized rather than scattered
throughout
> >> >> the application layers.
> >>
> >> >Centralised where?
> >>
> >> In the catalog of the RDBMS.
> >
> >You mean that some form of information index concerning the application
> >logic resident elsewhere (in the applications software environment on the
> >desktop or application server) is kept in the catalog?
> >
> >The logic is still "out there" in the Apps, is it not, at this moment in
> >history?
>
> That depends on what you defined as "the application logic". Some would
say
> it is the set of static and dynamic constraints that should hold for the
> data in the database. Others would say that it also includes that what
> happens when to what part of the data given certain new information and
user
> actions (think of triggers here). An even wider definition could include
> what the application does and shows (windoes, menus, buttons, et cetera)
to
> the user. I have the feeling this latter definition is what you use, but

No, my definition of this "application logic" is not restricted to the client
application screens, or the database contraints, triggers, sprocs, etc. My definition would have to include the concept of "organisational intelligence"
and if the organisation were busines oriented, then this would be called the "business intelligence" or "business rules".

Some of the organisational intelligence OI has been migrated from the Apps environmet into the RDBMS --- no argument about that, but in most apps the bulk remains in the app_code, on the client.

> Nathan is probably using it in the first and narrowest meaning since that
is
> how it is mostly used in a database context.
> -- Jan Hidders

I can see that there are probably expressly reserved terms in the theory of databases which connote specific meaning, in which case it is my misunderstanding of the academic side of the coin.

Best wishes

Farmer Brown
Falls Creek
OZ Received on Thu Aug 29 2002 - 13:03:36 CEST