Re: theoretical question on the RDBMS (internalization of OI)

"JRStern" <JXSternChangeX2R_at_gte.net> wrote in message news:3d613426.13809006_at_news.verizon.net...
> On Fri, 9 Aug 2002 22:38:07 +1000, "mountain man"
> <prfbrown_at_magna.com.au> wrote:
> >Do you think the day will arive
> >when it will be possible to store
> >internal to the RDBMS not only
> >the database(s) but also 100% of
> >the application code?
>
> Why stop there?

The users will not fit in the new machines ;-) (At least the old boxes were big)

> >Is this feasible? Beyond technology?
> >Does it already exist?
>
> You mean, 100% of the application logic?

Yes, or if you want to call it by another name, 100% of the organisational intelligence (and this implies business rules, etc if your org is a business organisation).

> Well, here's the thing. In any computer system, there are all kinds
> of tradeoffs you can make between code and data. If you're willing to
> be sufficiently perverse, of course you can store 100% of the
> application-specific info in the database, and interpret it with a
> fixed program.
>
> Is this any kind of a trend? Hmmmmmm. Maybe, very long term, when
> the fixed program can be a full AI of some kind, and everything it
> learns about your accounts payable system, or whatever, it
> parameterizes and keeps in tables somewhere.
>
> I advise not holding one's breath until this happens, however.

I have the pleasure to formally announce that such a mechanism is indeed today possible. See below:

> Joshua Stern

Thank you Joshua,

And all other who have responded
in this thread. I am planning on
travelling from Australia to the US
at the end of next month in order to
pursue this very subject matter
and to surf.

My intention is to travel from Seattle
WA down the W coast and depart from
San Diego. I will be bringing my surfboard and hope to catch some waves on the
other side of the Pacific for a change.

I am planning by that time, to have published a generalised technical solution to this problem/issue which I am hopeful will
represent a new technology in RDBMS
application development methodology.

Can anyone suggest which journal or
authority or professional body might accept such a publication?

Also, by that time DEMO and FULL
versions of software enabling such development will be available.

The authority of Chris Date seems to be
widely recognised, and I have been searching through any available on-line material to see if he references this issue (internalization of both data and organisational intelligence) as any form of future trend, but alas cannot find any references.

My gut feeling as an experienced (ex) IT manager is that if there is a path whereby I could gradually internalise all the organisational intelligence into the RDBMS it would be
a very attractive path for many reasons:

1. no change management in the desktop apps
2. no change management costs re: desktop apps.
3. no application servers, etc. or their costs, etc
4. database backup implies program (OrgIntel) backup
5. it will empower those with DBA and SQL skills.
6. it will give rise to a new type of Apps Env.
7. it lends itself to InHouse R&D, Apps Devlopment.
8. other implications which are very broad.
9. its cost benefits are enormous

I am attempting to generate some interest in such a process here in Oz, but am finding there are very few who even understand the aim of the project.

And so, a final question ...

If it could be ascertained to the general satisfaction of interested parties that indeed I am able to demonstrate a process and method whereby it can be shown that 100% of any given database application software code can be "internalized" to the very RDBMS that houses its data, do you think there will be anyone there in the US interested to listen to me?

Best wishes,

Farmer Brown
Falls Creek,
Australia