We have oracle Server with some Tables I am populating. I want to know what does it take to achieve the following:
Any user should be able to view the tables by just pointing his browser to a HTTP address.
The tables must be presentable in one or more formats (such as plain text , graphs (histograms/pie charts , if applicable) etc
The User should be able to set filters at the browser (the form for filters should be presented to user)
The content should be updated if the tables are updated based upon Time.

I know that Application Server/ DB Server architecture is one way of doing this . Am I correct ? The DB Server is on a Unix (solaris) Can anyone suggest a typical architecture