Re: Converting Oracle DDL to a standard

You can include Oracle as a run-time with your application for not a lot of money. The article I read is the cost is (your one time choice) 80% off list or 15% of your list. Those numbers vary by what version (enterprise vs standard), but it is pretty inexpensive. I wouldn't give up performance to be "database independent"; that would be very costly to your application. (performance goes down the tubes and people don't buy - very expensive) BTW, all stored procedure languages are proprietary. Jim
"Steven Garcia" <stevengarcia_at_yahoo.com> wrote in message news: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 Wed Aug 07 2002 - 02:09:30 CEST