PL/SQL Procedure and Java
Hi All,
I am working on a Data Warehousing Product and generating Web Reports.
These Web Reports are JSPs.
The basic architechture used for this is :
1. Get the inputs required for Report Generation through a Web GUI
2. Validate and Process (If Valid) the inputs so that it can be applied on the Data in the DB to fetch appropriate information.
3. The Data from the DB is retreived in the form of PL/SQL Procedures, which take the Processed information from Step 2 as Input and give the Output in the form of REF CURSORS.
Note: There are a many PL/SQL Procedures that are being executed, based on the configuration the Client has set. This configuration enables the Client to set the columns he wants to see in the Web Reports. This configuration is set before the Reports are run.
4. A call is made from Java to Oracle, each time a PL/SQL Procedure need to be executed. The REF CURSOR received as an Output from the PL/SQL Procedure is processed.
5. The next PL/SQL Procedure is called (if existing), else the Processed Data (from REF CURSOR Output) is displayed in the JSP as Web Reports.
The issue with above architechture is thePERFORMANCE.
I would like to know:
- The various ways in which data can beEFFICIENTLY & QUICKLY retrieved from PL/SQL Procedure in Java.
- Are there any APIs that improve the Java-Oracle Data Fetch Efficiency
- Is there any Java Framework available that can be used to increase the spped of Web Report generation.
- Do you suggest any changes in the above mentioned architechture, that make this work a Sweet Sixeen Year olg guy! ;)
- In general, any input that can increase the Speed of Web Report Generation.
Kindly let me know if I have not been clear at any point, so that I can re-explain the same more clearly.
And the most important thing, kindly scrap down your thoughts about the same.
Thanks a lot in advance for yourVALUABLE INPUTS.
- Vikas
