DEar all,
I have huge number of data coming to my application through a bacth
process
in main frame. Assuming that all this data are available in one table, I
have a PL/SQL procedure to manipulate the data and do some data massaging
and put into three tables.
There is a second procedure which processes the rows of these three
tables,
and while the processing is going on, there can be some updates coming to
these tables through an online application. ( Note that we are processing
the data got from a bacth. Now we have some rows which are coming to this
table directly from internet i.e online)
THere is a Java Rule Engine waiting to process the output of the above
batch. Now my question is how PL SQL can inform Java that the bacth
processing is complete. This is because Java program will never know when
PL
SQL batch completed its work, and while PL SQL is doing the batch, there
can
be some more rows coming for it to process through online.
My questions are:-
1) Since millions of rows are processed through the PL/SQL in less time,
is
it advisable to replace it by Java ?
2) If I use PL SQL, can it publish a message to queue, saying the Java
counterpart that the processing is complete by the PLSQL procedure?
3) WHat can be the alternates?
Best, Ravi
|
