Challenge Overview
Project Overview
The entire system is a tool suite that
- Collects data as answers to questions (grouped into surveys),
- Evaluates metrics for respondents based on submitted data/answers,
- Categorizes respondents into peer groups based on submitted data or computed metric values,
- Computes statistical data and
- Generates various reports (in MS Excel and PowerPoint).
The main component is a Visual Basic 6 application that controls the data processing and reporting part. It also provides direct data import from MS Excel files into DB2.
The scope of this project is to re-implement this data processing and reporting (DPR) component using Java based technologies.
This assembly will integrate the core module and survey import module and fix some existing bugs.
Competition Task Overview
Component/Assembly Fixes
We need to fix some issues in some components:
- The DAO components currently have threading issues and don't work well with the EJBs, we need to fix the issue so that the DAOs are thread safe. Please note the DAOs should not manage transactions themselves instead the calling services should manage transactions (i.e. this part should remain the same). We had some discussion for a possible solution, you can refer to contest forum for details (we attached a screenshot of the discussion). You're not restricted to follow that approach, feel free to suggest other approaches as long as the requirements are met.
- The survey import page doesn't work properly in IE but this is a UI Prototype issue. The new Scripts.js is provided in contest forum, you need to apply this fix to the current survey import page, it should be a very straightforward fix.
- Changes documented in previous assemblies need to be done in this contest if there are any.
- If there are other unknow issues that affect functionality this assembly should take care of them.
- Make sure the unit tests are still valid.
Integration
We expect the 2 assemblies to be integrated into a single submission with unified structure.
Solution Structure
Please follow the structure of the provided assemblies, but by the end of this contest we expect only ONE solution with everything in it.
VM
Winner will very likely be asked to deploy the final submission on a VM.
Technology Overview
The working environment requirement details for this application are outlined in the architecture. An overview of the environment requirements are listed below:
- SUSE Linux Enterprise Server 10
- WebSphere Application Server 8
- DB2 9.5
- Java 1.6
- J2EE 1.6
- EJB 3.1
- JDBC 4.0
- Spring 3.1
- Struts 2.2.3
- jQuery 1.7.2
Documentation Provided
Documents can be downloaded in contest forum.
Final Submission Guidelines
Submission Deliverables
A complete list of deliverables can be viewed in the TopCoder Assembly competition Tutorial at: http://apps.topcoder.com/wiki/display/tc/Assembly+Competition+Tutorial
Final Submission
For each member, the final submission should be uploaded to the Online Review Tool.