G-ROW

Specific banking Internet/Intranet system for advanced data analysis.

Brief project description

All data are stored in Oracle database. Tree applet on the left side is dynamically created on the grounds of the database content and shows the hierarchy of the company branches. The information about the selected branch is displayed on the right side. The data displayed are dynamically calculated with the use of some aggregation functions on the grounds of the database content. A special sign shows the current state of a particular parameter - green/red arrow corresponds to a good/extreme situation. You may select the sum display - in dollars or thousands dollars, you may also select the time span. By clicking on the button you may see the data as a Chart, by clicking on another button you may print out the table or all the tables for all sub-branches.

Tools and technologies used:

User Interface: HTML, DHTML, JavaScript and Java applets
Server-side: servlets, Jasper, JDBC
Web-servers: Netscape Enterprise Server 3.5, Apache 1.3, MS Internet Information Server 4.0, Lotus Domino Go Webserver is 4.6.1
Database: Oracle 8, Informix 7
OS: Windows NT 4.0, Linux SuSe, OS390