Take the tour ×  I have about 12 Oracle tables that represent
data that's being integrated from an external system into my web
application. This data is going to be used in an informational
and comparative manner for the clients using my web application.
On one particular page of my web application, I need to combine
data from 3 - 5 Oracle tables for display as an HTML table on
the page.  We are NOT currently using a framework (Apache Struts
for instance) and we're not in a position to move this Java web
application into one at this moment (I'm trying to get us
there...).  I am certainly not an architect, but I see one of
two ways that I can effectively build this page (I know there
are other ways, but these seem like they would be good ones...):
1. Create an Oracle Materialized View that represents what the
HTML table should look like and then create a POJO based on the
View that I can then integrate into my JSP. 2. Create POJOs that
represent the Oracle tables themselves and then create another
POJO that i