Re: Myth of the database independent applications (Was: Are you using PL/SQL)

<zigzagdna_at_yahoo.com> wrote in message
news:1180295772.396806.315850_at_w5g2000hsg.googlegroups.com...
> On May 27, 12:38 pm, "Jonathan Lewis" <jonat..._at_jlcomp.demon.co.uk>
> wrote:
> You may choose to have as many layers of code as
>> you like to transform the data from one valid state to
>> another valid state; but if you rely on programs to
>> maintain data correctness, you don't have a database,
>> you have a bit-bucket.
>
> Not sure what do you mean by :"if you rely on programs to ....". PL/
> SQL is a programming language so are C++ and Java. So you are writing
> programs either way.

I was moving away from the rather trivial argument about choice of language to the more important point about how to handle data properly.

To clarify my point:

"If you rely on programs, irrespective of whether they are written in PL/SQL, Java, C++ , or whichever you consider to be the latest and greatest thing to stick on your C.V. (resume for American readers) then you do not have a database, you have a bit-bucket."

There are only two "tiers" - the data, and the presentation. Any other layers you put between those two are in principle only there to handle networking and queueing issues.

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html