rdbms portal software & change management (was Re: Multiple specification of constraints)

"Tony" <andrewst_at_onetel.net.uk> wrote in message news:c0e3f26e.0403010301.48d3c24c_at_posting.google.com...
> "Dawn M. Wolthuis" <dwolt_at_tincat-group.com> wrote in message
news:<c1tt55$k12$1_at_news.netins.net>...
> > I would be thrilled to find out that I'm missing something here, but it
> > seems to me that it is absolutely bottom-line required to have a large
> > portion of the constraint information present when presenting an
interface
> > to the user (or to the web service for that matter, although I don't
mean to
> > muddy the waters any further with that point). That means that the
> > specifications of the constraints, the interpretation of the
constraints,
> > and the run-time environment in which to test out the constraints should
be
> > part of the UI environment, while today it looks to me like both .NET
and
> > J2EE developers REWRITE IT so there are (at least) two sets of data
typing
> > and other constraint information.
>
> Given that the DBMS and the UI are 2 different things, which of course
> they are, then it isn't feasible to have one single implementation of
> the constraints that serves both the database and the UI. The nearest
> you can currently get is to generate the UI constraints from the DBMS
> constraints. So you currently have 4 choices:
> 1) No constraints at all
> 2) DBMS constraints only
> 3) UI constraints only
> 4) Both DBMS and UI constraints

There exists one special class of software, which I have termed RDBMS portal software for want of a better name, or further information, which is a generic UI for RDBMS software.

The organisational sensitive content of the UI is actually defined within the RDBMS as a stored procedure, and application development is engineered exclusively by the creation and maintenance of RDBMS stored procedures.

In this manner, not only are all contraints defined within the RDBMS software, but so are all application software suites. The backup is of the data and the program development environment.

However more importantly to the industry, change management and all associated costs might now be obviated from the client environment.

Further articles related to this RDBMS portal software is located from the link below. I'd be interested in any feedback.

Best wishes,

Pete Brown
Winluck P/L
IT Managers & Engineers
Falls Creek,
Australia
www.mountainman.com.au/software Received on Wed Mar 03 2004 - 08:54:38 CET