Re: theoretical question on the RDBMS

"Lauri Pietarinen" <lauri.pietarinen_at_atbusiness.com> wrote in message news:e9d83568.0208141116.84a122e_at_posting.google.com...
> >
> > >1) Is the reality of getting 100% of the app code into the DB
> > > some form of recognizeable theoretical achievement, either
> > > in the academic sphere or in the engineering sphere.
> > > (And thanks elswhere on this thread for the pointer re Access)
> >
> > I'ld doubt anyone has written a paper proving that all 'app code'
> > (whatever that might be defined as) can be defined in the database. Such
a
> > thing would probably be regarded as 'too easy' or just straight obvious
by
> > the Theoreticians :-), so I'll have a go
> > 'App Code' = 1st Order Logic = relational database constraints.
> > QED
> >

>
> I would settle for 80%.  If we could at least get all the "stupid" code
> automated, that would be a great help.  Programmers could still work
> on the hard parts.

Automation is a separate issue, but a key issue. It is towards automation that all IT sites should gear.

From my perspective, the less outside the RDBMS the better and easier and simpler things are, therefore I seek the general solution to the problem in getting 100% of the code into the database.

One day it will be possible.

> > It's also does not seem to be a target for the industry at present. The
> > truly cynical (say F Pascal _at_ dbdebunk.com) would say that it's not in
the
> > industry interest to develop such a thing: complexity makes profit,
> > simplicity only helps your customers...

>
> It could be that it is the cultural gap between db-folks and programming
> folks that resides in the academy and elswhere.  You can take
> courses on both topics in (say) universities but they won't tell
> you how to stitch it together and you need both sides of the story
> to make an application.  That is also reflected in current products.
>
>


> > >2)  If so, has there been any dialogue on this matter, and where


> > >     might I seek it?

Interesting !! Thanks for the contributions everyone!!

> > > Many thanks for your response, BTW. For the record, one
> > > of my major clients has asked me the simple question:
> >
> > > "Shouldn't it be the main theoretical objective for a DBA
> > > to try to get their app code in the DB, wouldn't that then
> > > allow fool proof maintenance and upgrade/transportablility??
> >
> > >(NB: My client pays inordinate 3rd party DB apps support costs.
> > >not to me but to many other apps vendors)
> >
> > More a job for RDBMS designers than DBAs
> >

>
> And applicaton generator designers.
>
> Regards,
> Lauri Pietarinen

So we may take these comments to assume that there exists no product on the market at the moment to enable this theoretical migration of intelligence from the desktop (or indeed application servers :) to the RDBMS ? Thanks for your thoughts,

Farmer Brown
Falls Creek, OZ Received on Fri Aug 16 2002 - 04:36:11 CEST