Re: Calculating NPV

On Dec 7, 9:23 am, "Ravion" <ravishan..._at_singnet.com.sg> wrote:
> 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" <mdeme..._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_mo...
> > Another one - spreadsheet techniques
> >http://download.oracle.com/docs/cd/B19306_01/server.102/b14223/sqlmod...
> > 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- Hide quoted text -
>
> - Show quoted text -

If you'll stop being defensive for a moment and objectively look at your original post it certainly appears to be worded in the manner of many classroom assignments, thus the erroneous presumption that you are a student.

David Fitzjarrell Received on Fri Dec 07 2007 - 11:16:34 CST