Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Calculating NPV

Re: Calculating NPV

From: Ravion <ravishankar_at_singnet.com.sg>
Date: Fri, 7 Dec 2007 23:23:20 +0800
Message-ID: <fjbitf$t6f$1@reader01.singnet.com.sg>


Thanks.

By the by, I am not a student. I do work at Barclays as Senr Programmer. My field is CGI. Thats why I posted it. OK?

Warmest regards,
Ravion

"Maxim Demenko" <mdemenko_at_gmail.com> wrote in message news:47596371.2070105_at_gmail.com...
> Ravion schrieb:
>> Dear all,
>>
>> Assume that I am having large amont of data in DB. I want to calculate
>> npv (Net Present Value) like functions like a cron job kind of thing.
>> Whats the best architecture/design/strategy for this? Please consider
>> ProC, PL/SQL etc. How should I go about in the most efficient way
>> available? Kindly help..Thanks a lot for your time.
>>
>> Warmest regards,
>> Ravion
>
> The most simple way to calculate NPV is using Oracle provided builins.
> One possibility could be to use builtin OLAP functionality
> http://download.oracle.com/docs/cd/B19306_01/olap.102/b14346/dml_x_monitor022.htm#i79344
> Another one - spreadsheet techniques
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14223/sqlmodel.htm#sthref1943
> Of course, nobody should be constrained to implement own algorithm using
> pl sql or proc. The final implementation could be expressed as stored
> procedure or executable proc program or sql script, each of them could be
> invoked from the shellscriptlike wraper which could be put in the crontab
> to be scheduled periodically.
> Regarding efficiency - it is established good practice in Oracle
> technologies to estimate the most efficient solution by careful testing,
> so i am afraid, this topic is not exception.
> Hopefully, you'll manage alone to decide, what from said above is
> architecture/design/strategy/joke.
> If you get more often from your instructor similar tasks - i can highly
> recommend to read (to both of you)
> http://www.catb.org/~esr/faqs/smart-questions.html
>
> Best regards
>
> Maxim
Received on Fri Dec 07 2007 - 09:23:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US