Spring 2007

This web application developed to connect to some legacy systems and give answers to a VIP through a portal and a knowledge tree. Moreover if the VIP didn't find his questions in the knowledge tree, he can ask them in a form. The new questions will be saved until admin set their answer origin. The Admin selects whether information should be extracted from legacy databases from a new "connection string" or by forms. The forms will be filled by some knowledge workers in the enterprise (form fillers). So we can cover the information which are not in the legacy databases. Also to preserve metadata about these information we used a data warehouse and absolutely we create the knowledge tree from its dimensions. The figure shows an abstract view of the application architecture.

The application has been developed by Masoud Moshref Javadi, Ali DabirMoghaddam and Zoheir Montazery for Application Engineering course in Sharif University of Technology.

 Features:

• Extract VIP answers from legacy databases.
• Ability to add new questions to system.
• Update data warehouse using an ETL (Extraction, Transformation and Load) Tool.
• Manage services using portal (uPortal).
• Implemented as three portlets (can be used on other portals).
• Interactive knowledge tree using JApplet.
• Dynamic data extraction on knowledge tree using AJAX technology.
• Using three layer architecture.
• Persist metadata in data warehouse (PALO an open source implementation of OLAP).
• Used famous patterns and frameworks (Composite, Command Factory (MVC), Hibernate (OR mapping).
• Mail notify for form fillers and VIP using GMail.
• Analyzed and designed using Poseidon for UML software.

Screenshots:

VIP view:

Admin view:

FormFiller view: