Ariadne index page

 

Ariadne - Technical description

A800

Archive Current Competition

1. Description

When the competition is completed, the competition data can be archived. This concerns persons, kayak clubs, categories, run results and official roles.

The Ariadne archive database is self-containing, meaning that all data needed to relate to and interpret the run results is in the archive database. The figure below provides the datamodel of the archive.

(The yellow boxes are part of the archive database. The white boxes are part of the current competition database)

In order to be able to archive rundata, first the competion, the persons, the kayak clubs and the categories need be archived.

This page describes the archiving of:

  • persons
  • kayak clubs
  • categories
  • current competition data
  • run results
  • officals
  • ranking scale

The archiving functions are accessed via the F800-Archive-current-competition form.

2. F800-Archive-current-competition

F000-Menu  
F800-Archive-current-competition  
Q805-Archived-results  

Function structure

Form Control Subform, Action Query Table Attribute
F800-Archive-current-competition     Q100-Current-competiton T100-Current-competition  
  listbox
CurrentCompetition
  Q100-Current-competiton T100-Current-competition  
  button
buttonArchivePersons
see below:
Archiving persons
     
  button
buttonArchiveKayak Clubs
see below:
Archiving kayak clubs
     
  button
buttonArchiveCategories
see below:
Archiving categories
     
  button
buttonArchiveCompetition
see below:
Archiving competition
     
  button
buttonArchiveResults
see below:
Archiving results
     
  button
buttonArchiveOfficials
see below:
Archiving officials
     
  subform
rankingscale
F802-Set-ranking-scale
see below:
set ranking scale
    archived-competition-id
  button
buttonHelp
opens help page A800      
  button
buttonShowArchived Results
opens
Q805-Archived-results
Q805-Archived-results T100-Current-competition
T800-Archived-competition
T805-Archived-result
T830-Archived-kayak-club
T840-Archived-category
Q203-Person-select-F200
 
  button
buttonClose
closes the form      

Remark: One danger of the chosen method of archiving is thar in the current competition the name of a person, a kayak club or a category can be changed completely. In that case the data in the archive and in the current competition do not belong to the same person, club, category anymore. If you archive these current competition records the achived data is overwritten, and as a consequence results of a different person, club or category may be archived under the person, club or category of the most recent archived record. For this reason, you should never change in the current competition the name of a person, club or category to a completely diffent name.

3. Archiving persons

Persons in T200-Person, which have a archive counterpart record in T820-Archived-person (because they were already archived for an earlier competition), relate to the T820-Archived-person record via the T200!archived-person-id.

When archiving a person which has already an archive record, the attributes of the person in the current competition are written to the archive record, thereby overwriting the attributes in the archived record.(This has a risk that fault data of the current competition overwrites correct data in the archive).

Persons in the current competition that have no archived-person-id pointer to the archive, are considered to have no corresponding archived-person record. For these persons, an archived-person record is added in T820. The archived-person-id's of these new records are then written back to the related T200-Person records.

(Remark: there may exist multiple archived-person records in the T820-Archived-person table, for the same person. This can happen when a person is deleted in the current competition, and added later again.For the moment, there is no function to join together multiple archived person records of the same person.)

Form Control Subform, Action Query Table Attribute
F800-Archive-current-competition button
buttonArchivePersons
run Q822 Q822-Archived-person-update T200-Person
T820-Archived-person
 
    run Q824 Q824-Archive-new-persons T200-Person
T820-Archived-person
 
    update archived-person-id in T200   T200-Person
T820-Archived-person
 
    set T820![archived-person-id] to null   T820-Archived-person  

4. Archiving kayak clubs

Kayak clubs in T300-Kayak-club, which have a related T830-Archived-kayak-club record, have in the archived-kayak-club-id a pointer to the that record .

When archiving a kayak club which has already an archive record, the attributes of the kayak club in the current competition are written to the archive record, thereby overwriting the attributes in the archived record.(This has a risk that fault data of the current competition overwrites correct data in the archive).

kayak clubs in the current competition that have no archived-kayak-club-id pointer to the archive, are considered to have no corresponding archived-kayak-club record. For these kayak clubs, an archived-kayak-club record is added in T830. The archived-kayak-club-id's of these new records are then written back to the related T300-Kayak-club records.

(Remark: there may exist multiple archived-kayak-club records in the T820-Archived-kayak-club table, for the same kayak club. This can happen when a kayak club is deleted in the current competition, and added later again.For the moment, there is no function to join together multiple archived kayak club records of the same kayak club.)

Form Control Subform, Action Query Table Attribute
F800-Archive-current-competition button
buttonArchiveKayak Clubs
run Q828 Q828-Archived-kayak-clubs-update T300-Kayak-club
T830-Archived-kayak-club
 
    run Q830 Q830-Archive-new-kayak-clubs T300-Kayak-club
T830-Archived-kayak-club
 
    update archived-kayak-club-id in T300   T300-Kayak-club
T830-Archived-kayak-club
 
    set T830![archived-kayak-club-id] to null   T830-Archived-kayak-club  

5. Archiving categories

Categories in T040-Category, which have a archive counterpart record in T840-Archived-category (because they were already archived for an earlier competition), relate to the T820-Archived-category record via the T040!archived-category-id pointer.

When archiving a category which has already an archive record, the attributes of the category in the current competition are written to the archive record, thereby overwriting the attributes in the archived record.(This has a risk that fault data of the current competition overwrites correct data in the archive).

Categories in the current competition that have no archived-category-id pointer to the archive, are considered to have no corresponding archived-category record. For these categories, an archived-category record is added in T840. The archived-category-id's of these new records are then written back to the related T040-Category records.

(Remark: there may exist multiple archived-category records in the T840-Archived-category table, for the same category. This can happen when a category is deleted in the current competition, and added later again.For the moment, there is no function to join together multiple archived category records of the same category.)

Form Control Subform, Action Query Table Attribute
F800-Archive-current-competition button
buttonArchiveCategories
run Q834 Q834-Archived-categories-update T040-Category
T840-Archived-category
 
    run Q836 Q836-Archive-new-categories T040-Category
T840-Archived-category
 
    update archived-category-id in T300   T040-Category
T840-Archived-category
 
    set T840![archived-category-id] to null   T840-Archived-category  

6. Archiving the competition data.

The competition in T100-Current-competition, which has a archive counterpart record in T800-Archived-competition (because it was already archived before), relates to the T800-Archived-competition record via the T800!archived-competition-id pointer.

When archiving a current competition which has already an archive record, the attributes of the current competition are written to the archive record, thereby overwriting the attributes in the archived record.(This has a risk that fault data of the current competition overwrites correct data in the archive).

If the current competition has no archived-competition-id pointer to the archive, it is considered to have no corresponding archived-competition record. In this case, an archived-competition record is added in T800. The archived-competition-id of this new record is then written back to the related T100-Current-competition record.

(Remark 1: there may exist multiple archived-competition records in the T800-Archived-competitition table, for the same competition. This happens when the archived-competition-id in T100 is set to null, after which the current competition is archived again.)

(Remark 2: The archived-competition-id in the current competition is set to null, when the current competition is initialized, e.g. when all entries are deleted.)

Form Control Subform, Action Query Table Attribute
F800-Archive-current-competition button
buttonArchive Competition
run Q840 Q840-Archived-current-comptition-update T100-Current-competition
T800-Archived-competition
 
    run Q842 Q842-Archive-new-current-competition T100-Current-competition
T800-Archived-competition
 
    update archived-competition-id in T100   T100-Current-competition
T800-Archived-competition
 
    set T800![archived-competition-id] to null   T800-Archived-competition  

7. Archive results

Results can only be added to the archive, not updated. Results in T570-Saved-event-results, which have a archive counterpart record in T805-Archived-result (because they were already archived), relate to the T805-Archived-result record via the T805!archived-result-id pointer.

Results in the current competition that have no archived-result-id pointer to the archive, are considered to have no corresponding archived-result record. For these results, an archived-result record is added in T805. The archived-result-id's of these new records are then written back to the related T570-Saved-event-results records.

Only the results for the categories of which the indicator 'achive results' is set, are archived. And only the results which are complete for both runs are archived.

Beware: When after you archived the results, you generate the results anew, these results are considered as new results, not yet archived. You can archive these second set of results again, but then you have the competition results twice in the archive.

Form Control Subform, Action Query Table Attribute
F800-Archive-current-competition button
buttonArchive Results
run Q846 Q846-Archive-current-competition-results T570-Saved-event-results
T805-Archived-result
 
    update archived-result-id in T570   T570-Saved-event-results
T805-Archived-result
 
    set T805![archived-result-id] to null   T805-Archived-result  

8. Archive officials

Officials can only be added to the archive, not updated. Officials in T220-Official, which have a archive counterpart record in T810-Archived-official (because they were already archived), relate to the T810-Archived-offical record via the T810!archived-official-id pointer.

Officials in the current competition that have no archived-official-id pointer to the archive, are considered to have no corresponding archived-official record. For these officials, an archived-official record is added in T810. The archived-official-id's of these new records are then written back to the related T220-Official records.

Form Control Subform, Action Query Table Attribute
F800-Archive-current-competition button
buttonArchive Results
run Q848 Q848-Archive-new-officials T220-Official
T810-Archived-official
 
    update archived-official-id in T220   T220-Official
T810-Archived-official
 
    set T810![archived-official-id] to null   T810-Archived-official  

9. Set ranking scale

Ranking is the sorting of participants of a competition on basis of their event results. The ranking value is the mapping of a result on a ranking scale of 0 - 100.

The ranking scale is determined by chosing the 0-point result and the 100-point result from the event results. The 100-point of the scale is determined by the best result. Mostly this will be the K1 men seniors. The form F590-Fastests-per-category shows the best results per category. By selecting the best result of the competition, the 100-point is selected. (Remark: It appears that faster times are possible with boats which have not the reglementary slalom dimensions. For making the the normalized performances comparable with other competitions, the 100-point should be selected from slalom boat categories.)

The 0-point of the ranking scale is the least performance of the event. The least performance results can have a long tail. Therefore it is practical to set the least performance to 600 seconds. All normal participant complete the event within this time. (A more sophisticated method could be to select as 0-point the 1-sigma point of the bi-nominal distribution curve of the event results).

The calculation of the ranking of an event result whith the ranking scale goes as follows:

Ranking = (100-(100*([T520!event-result] -[T800!ranking-scale-100-point])/([T800!ranking-scale-0-point] - [T870!ranking-scale-100-point])))

As event results are archived in T805-Archived-result on category basis, a ranking can be calculated per person, per category, per competition.

Access path

F000-Menu  
F800-Archive-current-competition  
F802-Set-ranking-scale  
F805-Fastests-per-category  

 

Form Control Subform Query Table Attribute
F802-Set-ranking-scale     Q812-Ranking-scale T800-Archived-competition  
  button
ButtonSet100Point
connect to:
F805-Fastests-per-category
     

 

Form Control Subform, Action Query Table Attribute
F805-Fastests-per-category     Q815-Fastests-per-category Q816-Results-per-category  
      Q816-Results-per-category T100-Current-competition
T805-Archived-result
T840-Archived-category
 
  button
ButtonCancel
closes form without selection FirstOfCategory      
  button
ButtonOK
closes form with selection FirstOfCategory      

 

 


Change history

date Ariadne version change
07 Apr 2004 4.2.0 Elaborated and unified the archiving process
01-11-02 4.1.0 Ttext converted to html