CoReDa

CoReDa = Commercial Responsibility Database is central freight wagons database, designed by RAILDATA on request and functional order from the UIC Wagon users Study group. This tool provides an important IT support for the European freight railway undertakings (RUs). Each RU operating a wagon needs to know not only who is the current keeper, but also who is commercially responsible for the wagon.

In the past it was enough to know the 12 digit wagon number written on each wagon. Currently wagon number doesn’t say anything about the wagon keeper and about the responsible body for the commercial use of the wagon. The RUs operating in freight business need to know who the keeper and the responsible of the wagons they are running are. The VKM (vehicle keeper marking) written on the wagon gives the information about the keeper. The keeper can delegate the responsibility for the commercial use to another RU and this can do the same to the next RU.

The target system covers the requirements of the user community:

  • Store the data concerning commercial responsibility for the wagon.
  • Store the data concerning keeper of the wagon including VKM (vehicle keeper marking).
  • Allow update the data by sending a file containing new values.
  • Allow particular data update via web user interface.
  • Make the data accessible via web service with defined parameters.
  • Distribute the complete database after initial load.
  • Distribute changes automatically with the given frequency.
  • Build a web application for data consulting, basic database operations and user administration.
  • Different access rights: read only, full access, railway administrator, system administrator.
  • Keep online history for two years.
  • Keep offline history for at least 10 years.

Centralized solution was chosen as the most efficient. The system is currently focused on RU requests. There are three basic components of the system:

Database

Related functionality:

  • Conflict management
  • Archiving

Web application (CoReDa Web Centre)

Related functionality:

  • Create, update and delete records for a wagon
  • Allow queries concerning current wagon situation, history of wagon keeper and commercial responsible, record update date is published
  • Authentication and user management

Communications

Related functionality:

  1. Web service:
    • Receive and process the insert, update and delete files.
    • Process the queries concerning the current situation of one or more wagons or the situation in timeframe given by parameters.
    • Process the query for general upload
    • Process the query for changes
  2. FTP / SFTP communication channel:
    • Receive and process the insert, update and delete files.
    • Send general download.
    • Send daily change report.

CoReDa version 2 is in production since January 2016. The main features of this version are:

  • Inserts and updates of data in the past are not possible any longer.
  • The responsible for a wagon is also responsible for the maintenance of his data. He can't change records of other responsibles.