Database Configuration

In order to use data stored in a database, it is necessary to tell the Learning Wizard two things:

Specifying Tables

The user will initially be presented with a list of all the tables, which the Learning Wizard has found in the database.

The user must then remove all the tables that are not to be used in the learning process. This is done by selecting one or more of the tables in the list and pressing the "Remove"-button.

If the database contains tables which is to be used for learning, but which are not in the list, the user can add these to the list. This is done by writing the fully qualified name of the table in the text field below the table list, and pressing the "Add"-button.

Connecting Tables

Once the tables to use for the learning have been specified, the user must connect these tables. This is done by defining joins between the tables, until all tables are interconnected.

Joins are removed again by pressing the "Remove"-button after selecting a join in the table. When a join is selected, the definition of the join is written in the text field below the join table. It is also possible to edit an existing join by pressing the "Edit"-button. This will bring up the join definition window again, which will contain the definition of the existing join.

Defining Joins

Joins are defined py pressing the "Define" button. This brings up a window which assists the user in the definition of the join.

In this window, the user is presented with two identical lists of the chosen tables. The first lists is for specifying the first table in the join, and the second is for the second table in the join.

Once a table is selected (in either list), the variables of that table are displayed in a list to the right of the table list. This is for specifying the actual variable which are used for the join. A variable must be specified in both lists.

When two TABLE.VARIABLE pairs are chosen, the user can press the "Add" button, to create the join. If more than one variable is needed in order to specify the join, the user should press the "And" button after pressing the "Add" button. This will give the user the ability to choose yet another pair of TABLE.VARIABLE pairs, which are added to by the "Add" button.

This process can be repeated for as many times as is necessary. Once the join is fully specified, the user can press the "OK" button to return to the Database Configuration. Important: Note, that if a join is specified on a key in the tables, it means that the variable will contain only unique values. I.e., not two values will be the same. This makes that variable useless in the learning process, and it should be excluded in the preprocessing phase.