User Tools

Site Tools


configuration:database

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
configuration:database [2017/09/14 16:37]
yzan
configuration:database [2017/09/14 17:10]
yzan
Line 3: Line 3:
  
 ===Parameters=== ===Parameters===
-  * **name:​** ​The id.+  * **name:​** ​Unique name by which the configuration can be called from the command line.
   * **description:​** Human readable text note. Ignored by Predictor Factory.   * **description:​** Human readable text note. Ignored by Predictor Factory.
-  * **inputSchema:​** Comma delimited ​schema ​with the data. +  * **inputSchema:​** Comma delimited ​list of the schemas ​with the data. 
-  * **outputSchema:​** Schema to store the table with the features. Default: inputSchema. +  * **outputSchema:​** Schema to store the table with the features. Default: ​the first inputSchema. 
-  * **targetSchema:​** ​For the scenarios where the inputSchema does not contain ​the target table. Default: inputSchema.+  * **targetSchema:​** ​The schema with the target table. Default: ​the first inputSchema.
   * **targetTable:​** The name of the table with the label.   * **targetTable:​** The name of the table with the label.
-  * **targetId:​** ​The name of the column ​that identifies ​rows in the target table.  +  * **targetId:​** ​Comma delimited list of the columns ​that identify ​rows in the target table.  
-  * **targetColumn:​** ​The label name.+  * **targetColumn:​** ​Comma delimited list of the columns to predict.
   * **targetDate:​** The name of the column with the time of the desired prediction.   * **targetDate:​** The name of the column with the time of the desired prediction.
   * **unit:** The temporal unit used for temporal constraint. Default: "​year"​.   * **unit:** The temporal unit used for temporal constraint. Default: "​year"​.
Line 21: Line 21:
   * **useIdAttributes:​** Whether to use primary and foreign keys as an input for the features. Default: true   * **useIdAttributes:​** Whether to use primary and foreign keys as an input for the features. Default: true
   * **useTwoStages:​** Whether to first explore the data with a small sample count before running on all records in the target table. Default: true.   * **useTwoStages:​** Whether to first explore the data with a small sample count before running on all records in the target table. Default: true.
 +  * **ignoreDatabaseForeignConstraints:​** If the definition of the foreign key constraints in the database is spotty, it can be better to completely ignore the FKCs from the database and use FKC definition from DDL or XML file exclusively. Default: false.
   * **whiteListTable:​** If defined, use only the listed tables as the input. Otherwise use all the tables in the inputSchema.   * **whiteListTable:​** If defined, use only the listed tables as the input. Otherwise use all the tables in the inputSchema.
   * **blackListTable:​** ​ If defined, do not use the listed tables. Has priority over whiteListTable.   * **blackListTable:​** ​ If defined, do not use the listed tables. Has priority over whiteListTable.
Line 33: Line 34:
     <​database name="​GUI" ​     <​database name="​GUI" ​
               inputSchema="​financial" ​               inputSchema="​financial" ​
-              outputSchema="​predictor_factory" ​+              outputSchema="​predictor_factory"​
               targetTable="​loan" ​               targetTable="​loan" ​
               targetId="​account_id" ​               targetId="​account_id" ​