Challenge Overview
Competition Task Overview
We have an existing data loader that loads data from tcs to dw, and now we want to create a new loader to load design (studio) contests to dw:
- We do NOT want to reuse the exisitng project_result table for this, so please design a new table specifically for design contests (project_result is only for software, and is inserted by OR, we don't want to update OR for a new result table for studio in tcs_catalog).
- The new table will be similar to project_result and the new loader will load that to dw, similar to what we do for project_result. Source data should come from submission/upload tables that store infor for studio challenges.
- project_result is one user per project, but for studio / design one user can have multiple submissions, thus can have multiple winnings. Your design for the new table and implementation for loader must properly address this.
Existing Code
The latest TCS data loader will be provided for reference (attached in forum)
You can also find existing TCS data loader from this link: https://coder.topcoder.com/internal/web_module/trunk/src/main/com/topcoder/utilities/dwload/TCLoadTCS.java
If you need to generate some test data, use this tool: https://coder.topcoder.com/internal/database/scripts/trunk/tools/TestDataTool/
If the tool doesn't generate enough data, you may need to manually insert some data.
SVN Access
If you don't have access to the SVN repositories, you should email support@topcoder.com to get access.
VM
VM will be assigned per request, please request for VM in the challenge forum.
Testing
You need to provide some test data and detailed deployment guide to test your solution.
You must also provide detailed svn revision if you make any changes to existing code (include database scripts).
Technology Overview
- Java
- Informix
- SQL
Final Submission Guidelines
Submission Deliverables
- New loader to load design contests
- Detailed deployment guide on how to deploy and test your solution (refer to the deployment guide in TCS Data Loader for example)
- Test data
Final Submission
For each member, the final submission should be uploaded to the Online Review Tool.