Ariadne index page

The Ariadne Data Model

 

 
Contents
1. Introduction
2. Object definition model
3. Conceptual data model
4. Table model
5. Database model
6. Database table descriptions
 

2. The Object Definition model

The Object Definition Model is an ontological model. It specifies definitions of the relevant object types. Relations in an Object definition model between object types are necessary, that is, always apply (because defined so, but only so in the context of a (canoe/kayak) competition).

2.1. The meaning of the UML aggregation in the Object Definitions Model

The UML knows two types of the aggregation symbols:

means in UML an aggregation, where the part can exist independent of the whole.
means a composition, where the parts can not exist independent of the whole, e.g. when you delete the whole, the parts are also deleted.

In the Object Definition Model, only the aggregation type is used. If you see then a modeling like this:

this does mean that a disqualification is an aggregation of an official, that is, that you must have an official who decided the disqualification. Without such a decision of an official, there is no disqualification. In some sense you can say that the disqualification 'contains' an official who made the decision so.

2.2 The Object definition model for the (canoe/kayak) competition

2.2.1 Object definitions

(superscripts (*) refer tot modeling decisions.)

Object type Definition
AGE CLASS is a classification of COMPETITOR based on age.
BIB Visual identification to be assigned to COMPETING UNIT
BOAT TYPE is a classification of canoe/kayak on basis of form, number of seats and paddle type. In general this object type cal be called Vehicle.
CHAMPION is an COMPETING UNIT which has a top RANKING.
CATEGORY (1) a classification of COMPETING UNIT based on a GENDER, AGE CLASS AND BOAT TYPE.
CHIEF JUDGE is a ROLE that expresses the authority the provide final judgements on the correct conducting of the competition in accordance with the rules.
CLASS (4) is a grouping of CATEGORY.
CLUB CONTACT is a ROLE by which authorisation is assigned by a CLUB to submit entries for a COMPETITION
COMPETITION is an organized event for measuring sports performances.
COMPETITOR is a ROLE to which a person is eligible to compete in a COMPETITION.(Dutch: DEELNEMER)
COMPETING UNIT one or more COMPETITORs, forming one unit for which performance is measured for a CATEGORY.
COURSE is the circuit on which the sports performance is measured in a COMPETITION..
DISQUALIFICATION is a decision of a OFFICIAL to de-valuate rights or results in relation to a COMPETITION because of non-compliancy to the rules.
FINISH JUDGE is the ROLE that gives the authority to judge and register FINISHes.
FINISH is the passing of the FINISH LINE by an COMPETING UNIT, as registered by the FINISHER.
FINISH LINE is a demarcation which marks the end of the COURSE.
GATE is a obstacle as part of the COURSE, which has to be passed in the correct way.
GATE JUDGE is a ROLE that expresses the authority to judge and register the negotiation of gates.
GATE NEGOTIATION is the passing of a GATE by an COMPETING UNIT, as registered by the GATE JUDGE.
GENDER is a classification of PERSON according to sexe.
INVOICE is a bill which states the required entry fees for participating in the COMPETITION.
CLUB is an organisation of persons to compete in a COMPETITION. (ICF rules talk of 'Federation')
OFFICIAL is a ROLE to which authority is assigned to decide on COMPETITION relevant decisions.
PERSON is a natural person.
RACE (3) is a process of measuring the performance of COMPETING UNITs in a CLASS.(Dutch: WEDSTRIJD)
RANKING is the ordering of (combined) RUN results in one or more SERIES. (Dutch: UITSLAG)
ROLE an attribute of a PERSON which state duties, rights or responsibilities, the person has in the context of a COMPETITION
RUN (2) is the measurement of a performance of a COMPETING UNIT.
SERIES (2) is a set of RUNs in a RACE to deliver a (intermediate) ranking.
SINGLE is a COMPETING UNIT consisting of one COMPETITOR.
START JUDGE is the ROLE that gives the authority to judge and register STARTs.
START is the moment in time of passing of the START LINE by an COMPETING UNIT, as registered by the STARTER
START LINE is a demarcation which marks the begin of the COURSE
START NUMBER is een attribute with an unique identification. (Being used tot identify a competing unit uniquely).
TANDEM is a COMPETING UNIT consisting of two COMPETITORs in one canoe/kayak.
TEAM is a COMPETING UNIT consisting of three PARTICIPANTs in three canoe/kayaks of the same CLASS.(Dutch: PLOEG)
   


2.2.2 Object type Definition Model - Modeling decisions

(1) - The ICF Slalom rules mention the next basic categories: K1-men, K1-women, C1-men, C2-men, 3xK1-women, 3xK1-men, 3xC1-men, 3xC2-men. In the official rules, boat type and gender is already conflated. The Ariadne data model bases the category on Gender, Boat type and Age class. This fits better for domestic competitions.

(2) - In the ICF rules, RUN is not an individual run of a competitor, but a series of runs in a RACE. In the Ariadne model, RUN is used for an individual run of a COMPETING UNIT. SERIES is used for a series of RUNs in a RACE.

(3) - The terms RACE and EVENT are not defined in the ICF rules. The terms are some times mixed up. Event tend to be used to mean the Competition, Race tend to be used to mean a series of runs resulting in a ranking. The Ariadne model uses Race in this last meaning.

(4) - Class is not defined in the ICF rules. Class tend to be used in the meaning of Race. This to cope with heats and x-finals, in the Ariadne model Class can have more Races. The heats and x-finals stages are separate Races within the same Class.

(5) - The term 'Entry' from the ICF rules is in the Ariadne model replaced by 'Competing unit'. An Entry is an administrative projection of the competing unit on the course: the K1-competitor, C1-competitor, but also the C2-competitors and the 3xK1-competitors, which each form a competing unit.

Change history

Date Ariadne Version Change
Jan2016 5.3 Reviewed and updated
Jun2007 4.5 Reviewed and updated
Sep2002 1.5 migrated to html
Jan2000 0.1 First Draft