Re: Best Front End for Oracle?

From: Stephen A. Rodgers <trodgers_at_mindspring.com>
Date: 1996/11/26
Message-ID: <01bbdbb5$6748ac00$d52979a8_at_trodgers.mindspring.com>#1/1


I don't know how anyone can advise you of "the best" front end for Oracle without knowing what your requirements are. The number of objects in your database really has little or no influence over the selection of a front end.

You need to weigh a number of factors in making this determination:

(1) Will the front end be easy to maintain? I.E., are there people who can come in and rescue you if your original developer(s) has left?

(2) Can you create complex controls and record manipulation easily with the front end tool?

(3) Does the front end tool interface with other tools and systems easily? Can it generate the bulk of code from a data/process model?

(4) Does the front end take advantage of Oracle's functionality? Consider buffering and automatic use of pl/sql packages and RPC. Also consider automatic rollbacks, two-phase commits, distributed processing. You DON'T want to have to write all this kind of code by hand!

There are a LOT of front end development products available which work well with Oracle, but I think you're first objective should be to determine what your application requirements will be, and then you can compare all these products to determine which ones can and will meet your needs.

Good luck to you

-- 
Stephen A. (Tony) Rodgers
Prominence Consulting, Inc.

Chris Dipple <chris_at_chin.demon.co.uk> wrote in article
<AcyH1QAhKblyEwo9_at_chin.demon.co.uk>...

> In article <56svfj$g6i_at_camel1.mindspring.com>, jfk
> <leads_at_mindspring.com> writes
> >Oracle Developers,
> >
> >Can anybody advise, what they would recommend as the best Front-End
> >Application Builder is for an Oracle7 database.
> >
> >The database consists of 100+ tables and about 500+ data elements, the
> >schema is also quite complicated.
> >
> >Any input would be greatly appreciated.
> >
> >Thanks in advance.
> >
> >Regards...JFK
> >
> Lets be controvercial. JAVA/JDBC client server, GUI interface on PC,
> database middleware on the server, possibly some PL/SQL code in packages
> for critical functionality. Should give good performance, no client
> licences for Oracle required.
> --
> Chris Dipple, Production DBA, Royal Bank of Scotland
>
Received on Tue Nov 26 1996 - 00:00:00 CET

Original text of this message