Re: Converting Oracle DDL to a standard

From: Steven Garcia <stevengarcia_at_yahoo.com>
Date: 6 Aug 2002 13:36:49 -0700
Message-ID: <7f430eb1.0208061236.79f6a9ac_at_posting.google.com>


That is understood. I am expecting that there will probably be a performance hit, especially with some of the advanced stored procedures that we have engineered using Oracle's PL/SQL API.

The task at hand for me (and my team) is one that we cannot avoid, we need to be able to pull out Oracle becuase of our product's COGS. So we need to re-architect our persistence-management modules. Basically the requirement is to be able to comply with any JDBC compliant drivers. I suppose that is the "platform" we are aiming to support.

Unfortunately, there will be performance problems we will have to contend with. A simple stored procedure that fetches x rows and operates on that data will be much slower if implemented in the business logic layer because of the network activity between the database host and the app host.

It looks like it will be a manual, laborous task, unless there are other ways of doing this???

"Christopher Boyle" <cboyle_at_hargray.dot.com> wrote in message news:<aiod5c$7l0f$1_at_news3.infoave.net>...
> Every RDBMS has built ins that will exploit it in various ways, by creating
> generic code you will by necessity not be able to take advantage of all the
> functionality of the database, possibly at the cost of performance. This
> could be a wonderful chance to re-engineer your existing code and take
> advantage of all the options of the new platform instead of making it
> transportable. Java, for example, runs everywhere but often very slowly.
> C++ that has been compiled for the platform can usually outperform it
> easily.
>
> "Steven Garcia" <stevengarcia_at_yahoo.com> wrote in message
> news:7f430eb1.0208052257.79622f59_at_posting.google.com...
> > I have a need to be able to "remove" Oracle from our application, and
> > instead use any RDBMS that supplies JDBC compliant drivers. Our
> > schema consists of 60 tables, 200 stored procedures, many sequences, a
> > few functions, stuff like that.
> >
> > Are there any tools that help a developer to do this? I'm most
> > concerned with the stored procedures. Several of them are simple
> > inserts, deletes, updates yet they are written in proprietary Oracle
> > PL/SQL. I will have to convert those procedures and put them in Java,
> > right?
> >
> > The more I think about this, I realize that there probably are not any
> > tools that exist to do this type of thing. I've searched the Internet
> > for several hours and have not found anything useful, yet. Anybody
> > have any comments on this?
> >
> > Thanks, Steve
Received on Tue Aug 06 2002 - 22:36:49 CEST

Original text of this message