Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> the redundancy of the software layer running upon the RDBMS software layer

the redundancy of the software layer running upon the RDBMS software layer

From: mountain man <hobbit_at_southern_seaweed.com.op>
Date: Fri, 09 Feb 2007 03:53:35 GMT
Message-ID: <3fSyh.4930$sd2.634@news-server.bigpond.net.au>


We define for the practical exercise (as distinct from the theory) of the identification of practical near-solutions for truly RDBMS software, the big three (IBM, Oracle, MS) "RDBMS" vendors. ie: The "RDBMS software layer" I here define to be the currently available vendor products DB2, Oracle and SQL Server resp.

Upon this layer another layer of software is traditionally found, written in a variety of program development languages, and methodological tools, all of which hook into the database services provided at their foundation layer. (eg: an intellectual property management system running on SQL Server).

There has been a physical migration of code from this upper layer, into the environment provided for by the RDBMS layer in recent years (eg: 10 at most) by means of the use of RDBMS "stored procedures".

This migration of "intelligent code" from the software layer running upon the RDBMS software layer, to the environment of the RDBMS software layer itself, in the form of the increased use of stored procedures, is disinctive and real.

Analysis of this trend leads to a hypothetical question. Just how far can this migration of code proceed? Is it possible to move an entire set of code (representing any specific database app. software) in its entirety into the RDBMS environment?

Our research leads us to claim that this can be done. Using a special bit of "RDBMS Portal software" on the client workstation (or indeed server) to talk directly to the RDBMS services, it is possible to sit back and develop an entire suite of applications using only (SQL) stored procedures.

In this solution, the data is held in one database, while the equivalent suite of "programs" is held in another database, in the form of stored procedures.

Extrapolation of this solution to the current technological environment of IT management, implies that the entire host of software identified as "external" to the RDBMS software might be engineered, such that it becomes redundant.

Further information here:
http://www.mountainman.com.au/software/LittleSteps/ Received on Thu Feb 08 2007 - 21:53:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US