Re: Mirrored Server for real-time computations?

(Pete Cresswell) wrote:
> I'm on a project that's implementing a bond trading system: .Net front end,
> Oracle back end.
>
> A problem has arisen that began with reporting. Many of the reports are based
> on something the bond traders call "Quality" ratings. There's also something
> called "Baskets". Holdings of various securities are processed against various
> characteristics of securities and their underlying credit support.
>
> Briefly, computing all this is quite intensive, the data behind the computations
> can change from minute-to-minute, and the results are critical.
>
> For the reporting, they've decided to create tables to receive the computations.
> Run the computations once, then fire off a batch of 50 or so reports that uses
> same.
>
> However something else has now arisin: the idea of presenting that information
> real-time in a sort of dashboard presentation. For this, we'd have to
> re-compute the valuse very often - maybe every few minutes.....and the guys who
> know Oracle say this would bring the application to it's knees.
>
> Unencumbered as I am by any reall knowledge of Oracle, it occurs to me that one
> solution would be mirroring the DB's tables to another server/processor and
> having that computer's sole mission in life to be continually computing and
> re-computing those values and constantly refreshing the tables containing same.
>
> Does this make sense to anybody?
>
> Alternatives?

Jim may well be correct about RAC but my initial thoughts went in a different direction.

What you are talking about is highly CPU intensive computations so I'd be thinking about native compilation of my procedures so that they are in C rather than interpreted compilation in PL/SQL or move the calculation engine into Pro*C and may work in some Fortran.

Once I had this part optimized ... then I'd look at whether I could use RAC to increase scalability.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)