Data model overview

This overview presents the main tables of Ariadne.

figuur 1: the main Ariadne tables

Competing units

The competing unit is the unit which competes in an event. The competing unit consists of one person in case of a K1 or C1, of two persons in case of K2 or C2, and of more persons in case of a team ( 3 persons with 3*K1 and 3*C1, 6 persons with 3*C2, and other numbers with fancy teams). A competing unit is submitted by a kayak club in an entry. A competing unit is assigned one start number.

A person can compete in more competing units (limited by the categories wherein a person can compete).

(Competing unit and entry are synomymous. Entry is an administrative procedure for submitting a competing unit for one category.)

Categories

In Ariadne a competing unit is not directly assigned to an event, but via a category. A category is a performance class on basis of gender (men, women), age ( senior, junior, master etc.), boat type (K1, C1, C2 etc.), and performance level (P1,P2,P3).

To an event one or more categories can be assigned. This is to be decided by the competition committee in relation to the number of entries for a category. If there are too few entries for a category, the entries for the category can be joined together with the entries of a adjacent category in one event.

The opposite can take place, when enough post entries are submitted to split an event with two categories into two events, each with one category. When assigning a category to an other event, all the entries for the category are automatically assigned to the other event.

This construction also gives the possibility to assign a category to more events. This is relevant for creating ' virtual events', in which subcategories of normal events are put together in one pool, and then re-ranked.

Events

An event is a performance comparison, in which the performances of competing units in one or some adjacent categories are measured and ranked. The competing unit whith the best performance is the winner of the event.

The performance of a competing unit in an event is normally measured in two runs. A run is the performance measurement of one competing unit. The event result of a competing unit is the addition of the two run results. In some cases an event has only one series of runs.

Runs are grouped into series. First the first series of runs is executed, then the second series.

In a series the competing units start in a start order. The start order is related to the performance ranking of the competing units (on basis of historical data), and whether the entry was a post entry. (Post entries sort at the beginning of the start list).

Program blocks

Events are grouped into program blocks. In a program block first the first series of the related events are executed, then the second series. A program block covers mostly a few hours. Between the program block, pauses can be scheduled, for lunches, for checking the course, for changing gate sections etc.

Clubs

An entry is always submitted by a kayak club. (Not necessarily for a person, as a team entry can be submitted by a club for which the persons are not always known in advance.) For entry confirmation, a contact person must be know from the kayak club. The entry fees are billed to the kayak club.

Persons

The minimum amount a data Ariadne needs to know of a person is name and gender. Additional data can be registered for age class and performance level. Persons can have the role of competitor and or official. In his/her role as competitor or official, a person is related to a kayak club. This construction makes it possible that the same person can be an official and competitor for more kayak clubs (as is the practical situation).

In Ariadne-archive the competitor and official history of persons is kept. This provides a historical view of the relation between persons and kayak clubs.