Re: Oracle DK2000 Three-tier client/server?

guru_at_guru.nir (Bemused by Oracle) wrote-écrivait:

>Oracle claims that DK2000 can deliver 3-tier client/server systems. I
>believe that the only way that they can make this dubious claim is by stored
>procedures and their lame PL/c interface with stored procedures. Or is
>there something that I missing?
 

>Oracle is a two-tier, non-messaging middleware client/server tool. As long
>as you can stay within their environment, it's great. If you need
>architecture outside of Oracle -- bummer. Agree?

Yes you can be in one form of 3-tier by doing stored procedures and removing a lot of natural fonctionnality from FORMS like the base tables, lov.

One thing about it it's you losing the permenant connexion and you cannot lock rows has before but that is 3-tier architecture anyway.

This solution will work (we are doing it here - partially to take the better of 2-tier and 3-tier) but it seems more difficult to do it (read impossible) with REPORTS or GRAPHICS. Anyway with the user needing to access the DB for production of report (data warehouse) the 3-tier will never be able to support that needs.

Michel Lapierre
Concepteur Informatique
Hydro-Quebec

E-mail : milapier_at_ge.hydro.qc.ca
Phone : (514) 840-3860
Montreal, Quebec, Canada Received on Thu Sep 19 1996 - 00:00:00 CEST