Challenge Overview
Our client is looking to build a browser driven application for creating or editing PMML (predictive modeling markup language) files.
The application should allow users to create, modify and delete transformations.
It should allow users to import transformations from existing PMMLs file.
It should perform validation — does the current state of the translations match the data required by the model? If not, where and why not?
There should be the ability to Load/Save PMML files so that user’s work can be saved and reused later.
It should be able to emit SQL code that performs the transformations specified.
It should be able to Emit SQL code that scores the model. For the sake of this contest, you can assume that the only model present in the PMML file will be a “GeneralizedLinearModel’.
All of these requirements should presuppose that the user has no knowledge of PMML, SQL or other technologies. Code must be written in a .NET language and use ANSI SQL only. The application must only read from the database—no writes allowed.