Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Most performant way to code client script.
Christian Tischler wrote:
> Hi,
> I need to code some tool to get data from an Oracle database. The data
> will then be processed with some mathematical algorithms and then
> analyzed. As this is my first time using a database for something other
> than mere data storage I have some questions. If this is not the right
> list for my questions I apologize.
> 1) I it possible to run mathematic functions (statistical analysis and
> stuff like that) directly on the oracle DB?
> 2) What is the most performant DLL/lib/etc. to access the DB. We plan to
> implement the algorithms in C or C#.
>
> I would be very thankful if you could post an answer, links and/or books.
>
> thanks in advance
>
> Christian Tischler
Follow Mortiz's advice or look at whether the functionality you need is already in the database; for example analytic functions. You can complile PL/SQL into C inside of Oracle using native compilation. To find out how search for "Native Compilation" at http://otn.oracle.com.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Sun Jul 17 2005 - 07:26:04 CDT