Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.misc -> Re: Embedded SQL vs Stored Procedures

Re: Embedded SQL vs Stored Procedures

From: Greg Forestieri <>
Date: 8 Sep 2004 05:16:31 -0700
Message-ID: <>

Gama Franco <> wrote in message news:<>...
> Sybrand Bakker wrote:
> > On Tue, 07 Sep 2004 17:08:24 +0100, Gama Franco <>
> > wrote:
> >
> >
> >>Unfortunatelly I really have to.
> >
> >
> > You only think so. Also no real DBA would accept procedures are
> > creating tables on the fly. Allowing this would mean the db is out of
> > control.
> >
> >
> > --
> > Sybrand Bakker, Senior Oracle DBA
> Hi,
> Ok, here it goes.
> I'm programing a database based on a temporal extension

temporal in English means limited in some way, time, space, whatever. How is yours limited? In this setting it sounds like you are building your own RDBMS on top of Oracle. Unnecessary. Learn about Oracle and what it does for you in the way of contention (or lack of) then do it *right*.

Good luck 8^|

to the
> relational model. That means that I need to simulate the DBMS, and every
> table created by the user will be a temporal table (dealing with time
> intervals). The database will have tables to manage all the meta info,
> and temporal tables will be created on demand (just like the way that
> you create a table when you need in Oracle, but these one are temporal).
> This means that the program will need to manage and create new tables,
> and OCCI is a major requirement. It's CERN's official programming
> language...
> Because the system will be used by a large number of scientists, there
> will be no DBA. To manage all this chaos, an hierarchical model will
> handle the location of the tables (we simulate something like a file
> system on the top of the hierarchical model, and every table will be
> located at a leaf of the tree).
> This is just a brief introduction, and I would like to know if someone
> already made the performance tests on Embedded SQL vs Stored Procedures.
> If this is not the case, I will have to make the tests but I was looking
> for a shortcut.
> I'm not crazy or stupid. This system is already running using MySQL (I
> now what you're going to say) as the repository. It is already
> collecting data and the database is somewhat big. We need to create an
> implementation in Oracle and make some performance tests.
> If you have a lot of scientist running their own experiments with
> specific use cases, you need to figure out a clever way to give them
> freedom without throwing them into chaos.
> Best regards,
> Gama Franco
Received on Wed Sep 08 2004 - 07:16:31 CDT

Original text of this message