Oracle-L: Re:White papers on industry trends

From: <dgoulet_at_vicr.com>
Date: Mon, 22 Apr 2002 06:33:24 -0800
Message-ID: <F001.0044ADB7.20020422063324@fatcity.com>

Valerie,

C is still a very heavily used language, although for a complete application I'd probably want to use a C++ variant since they come with screen painter tools. Migrating from C to Forms/Reports would not be unthinkable, but don't underestimate the learning curve. As far as eliminating the external procedure call, if that's the way the application is written, then your stuck and no it will not be eliminated. What may then be more efficient is to take that C code & break it up into what is database only and what is C only. Then re-code the application as PL/SQL (or stored Java if your so inclined) keeping in pure C only that which cannot be done otherwise.

The industry trend I would have to say is headed towards thin clients and three tier applications which serve internal and external customers and Java. While I agree with the trend in many cases there are too many times that the trend does not really fit the needs. In many a case we end up just moving the bottle neck from one place to the other & sometimes making it worse. Case in point is PeopleSoft. There is a panel in the stock room maintenance that updates several tables and rows. Now that is a two tier problem since a lot of data is moving from the server to the client, being processed, and then sent back. But we can id the bottleneck here in that the end user NEEDS a beefy PC. Now you move that into a three tier mess & the bottle neck gets harder to find since data moves from the database to the app server, to the client, gets processed & sent back to the apps server which does more processing, and then back to the database. Result, you still need the beefy PC on the client side, but you almost need a one to one setup on the app server as well. So then each client actually needs two beefy PC's to do the job in a reasonable manner. YUCK!! Who said thin client was easier & cheaper? Must have been some ignorant sales droid at the app server vendor.

I note that your address is with the IRS, has the idea of doing Ada cropped up yet? OH, bad joke, it's suppose to be the government's "standard programing language" as declared by Congress back in the 80's. Then, PL/SQL is the Son of Ada!!

Dick Goulet

____________________Reply Separator____________________
Author: Webber Valerie H <Valerie.H.Webber_at_irs.gov>
Date:       4/22/2002 5:28 AM

Are there any white papers on industry trends for architecture including programming languages. I'm working on a project that is in the early stages of a redesign. The current application uses C code entirely including user interface. The client is sold on Oracle Forms/Reports but is reluctant to trash the C code and start from scratch. This is the first such redesign in 17 years.

Does a 3 tier architecture using iAS minimize or eliminate the cost in performance of the external procedure call to the C program from a stored procedure?

Any information will be helpful...
Thank in advance,
Val

Valerie H. Webber
Management Systems Designers, Inc
Database Administrator
valerie.h.webber_at_irs.gov
704-566-5321

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>White papers on industry trends</TITLE>
</HEAD>
<BODY>

Are there any white papers on
industry trends for architecture including programming languages. I'm working on a project that is in the early stages of a redesign. The current application uses C code entirely including user interface. The client is sold on Oracle Forms/Reports but is reluctant to trash the C code and start from scratch. This is the first such redesign in 17 years.

Does a 3 tier architecture using
iAS minimize or eliminate the cost in performance of the external procedure call to the C program from a stored procedure?

Any information will be
helpful...
 Thank in advance,
 Val


Valerie H. Webber 
Management Systems Designers, Inc
 Database Administrator 
valerie.h.webber_at_irs.gov 
704-566-5321 

 

</BODY>
</HTML>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Apr 22 2002 - 09:33:24 CDT