Hello all,
I have some questions about some design ideas regarding a particular type of
app that I have never tried to construct before so thought I would post them
here as there are a number of very intelligent application designers with
lots of experience integrating a number of technologies to come up with a
solution to a particular problem
What I am trying to construct is a system which analyzes and combines data
from a number of locations. . . .databases, flat files, etc. My questions
are in regards to a small subset of this total application, which is,
specifically, a set of real time data that needs to be displayed to a few
hundred users on a constant basis in a web page (probably using an applet).
My problem comes with how I can get this data from the source to the applet
utilizing minimal system resources (database connections, network traffic).
The system configuration is something like the following
3 basic machines
1. Application Server (orion)
2. Data Wherehouse (data stored in memory for 30 minutes prior to
writing to the db)
3. Database (Which requires a custom wrapper due to lack of jdbc
support. . .legacy system)
Ok, basically there are approximately 70 - 100 different reports that are
stored in memory on the second system. These reports are each updated every
second with new data. I wrote a tiny application which takes the data in
intervals (determined by an argument) from a single report, and performs an
action with the data (writes to a file, writes to a database, posts to a
jsp, etc). I can run 70 to 100 of these applications (with different
arguments) to transfer real time data between System 2 and System 1 (we are
going to ignore system 3 because that data is historical and I have already
written a fairly complete model 2 application to handle this reporting).
So, now I figure I can get the data from System 2 to the Application server
and do something with it (maybe use HypersonicSQL or some other "memory"
database to hold the data and allow each applet to connect to the "in
memory" data store and update the displayed information?)
The failure rate of 70 to 100 small applications would seem to be rather
high, so I am trying to figure out how to load and unload these applications
on demand so that when a new report becomes available, I can simply pass a
new set of arguments to the application which would begin running with the
others, and applications would be unloaded after 24 hours so that any
reports no longer used are removed (sort of).
Hopefully I have made a little sense here and someone can give me some
pointers about how to model this app. I have no idea where to begin
(specifically in regards to the dynamic loading and unloading of these
applications). Each of these reports is viewed around the clock by as much
as a 500 - 1000 people so minimization of resources is crucial (if I had
each of these reports spawn its own little application, I think my LAN guys
would hang me) :)
Thanks for any ideas any of you can provide.
Jeff
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
