Writing your own queries

The easiest way to compose your own queries is to use the graphical query interface. It will give you a feeling of the structure of the database and how to write queries in SQL. Still, much more powerful queries can be written with a deeper understanding of the database structure:

Experiment

The core concept is that of an experiment: a run of a single algorithm, with specific parameter settings, on a specific dataset. We thus query the database for the outcomes of such experiments with specific learners, parameters or datasets, possibly including known properties of the algorithms and datasets. The experiment table, shown above, is therefore linked to the learning algorithm used, the dataset used, the evaluation method used, the outcome of the experiment (evaluations and predictions), the study the experiment belongs to and some admin data. Click on the tables to delve deeper.

Next: Learning algorithms