 Dimension Data provided network and database monitoring services for global companies and needed a solid software tool for automating the monitoring and maintenance of Oracle databases.
While the database team built the back-end structure for the new DBAPlus* tool, I was tasked with designing and coding the Web-based user interface and controllers. Utilizing the latest J2EE interface components, I implemented numerous screens, interface controllers and JavaBeans that allowed the users to configure their database monitoring profiles, as well as view alarm conditions.
The resulting interface presented a real-time view of tiered database alarms for mulitple customer databases around the world. Users could graphically monitor numerous databases from one centralized console.
Architecture Overview: The DBA*Plus database monitoring system utilized a Java/J2EE architecture that resided on Oracle 9i Application Server and Oracle 9 database. A standard Model-View-Controller (MVC) front-end architecture was used to promote extendability and reliability. JavaServer Pages (JSPs) communicated with the Oracle stored procedure business tier via servlet controllers and JavaBeans.
Oracle Java Stored Procedures encompassed the majority of the business logic and resided in compiled form on the Oracle database server. |
|
