Unified relational database model for data mining

A system for managing data mining activities in a data mining environment, the data mining environment having data sets, a data mining tool, a data mining model, model training results stored in model training results files, and scoring output data stored in records in model scoring results tables, the system comprising:

• means for selecting a model scoring results table, wherein the means for selecting includes metadata in a model scoring results control table, the model scoring results control table being related to a data set control table including data set metadata;
• means for reading a scoring output data record from the selected model scoring results table;
• means for storing the scoring output data record in a managed representation table for scoring results;
• means for selecting a model training results file, wherein the means for selecting includes metadata in a mining model control table, the mining model control table being related to the data set control table and the model scoring results control table;
• means for reading training results data from the selected model training results file;
• and
• means for storing the training results data in at least one model training results table, the at least one model training results table comprising a relational representation of the training results data from the selected model training results file, one of the at least one model training results table referencing the mining model control table, the managed representation table for scoring results being related to the referencing model training results table, the data set control table, the mining model control table, and the model scoring results control table.

A computer program product for managing data mining activities in a data mining environment, the data mining environment having data sets, a data mining tool, a data mining model, model training results stored in model training results files, and scoring output data stored in records in model scoring results tables, the computer program product comprising:

• a recording medium;
• means, recorded on the recording medium, for selecting a model scoring results table, wherein the means for selecting includes metadata in a model scoring results control table, the model scoring results control table being related to a data set control table including data set metadata;
• means, recorded on the recording medium, for reading a scoring output data record from the selected model scoring results table;
• means, recorded on the recording medium, for storing the scoring output data record in a managed representation table for scoring results;
• means, recorded on the recording medium, for selecting a model training results file, wherein the means for selecting includes metadata in a mining model control table, the mining model control table being related to the data set control table and the model scoring results control table;
• means, recorded on the recording medium, for reading training results data from the selected model training results file;
• and
• means, recorded on the recording medium, for storing the training results data in at least one model training results table, the at least one model training results table comprising a relational representation of the training results data from the selected model training results file, one of the at least one model training results table referencing the mining model control table, the managed representation table for scoring results being related to the referencing model training results table, the data set control table, the mining model control table, and the model scoring results control table.