Enhanced ConfigGen Price Generator

Register
Submit a solution
The challenge is finished.

Challenge Overview

ConfigGen is a tool which pulls product and price data out of a DB/2 database and writes it into two flat text files for use in a standalone configurator application.

The two flat text files are:

  1. configurator.txt (product data)
  2. prices.txt (price data)

Recently, a major incident was reported which noted our configurator application was missing prices for some products.  Analysis of this incident revealed the missing prices were occurring because the price data, as it is currently being stored in the underlying database columns of ConfigGen, was being truncated. 

The objective of this module is to deliver re-designed ConfigGen price generator sub-components which will:

  1. provide re-designed database table(s) that will define an improved approach for storing the price data in a way that will prevent the truncation issue noted above
  2. provide enhancements to the existing ConfigGen stored procedures and processing logic, so they are adapted to use the newly designed database table(s)


Final Submission Guidelines

See Requirements Specification

ELIGIBLE EVENTS:

2013 TopCoder(R) Open

Review style

Final Review

Community Review Board

Approval

User Sign-Off

ID: 30031252