Hello. I need help in designing a database of the passenger rail transportation system. In this case, I stopped at the next question. I have the essence of "Station" and the essence of "Train" with its fields. You need to associate with them the essence of "Flight" or "Schedule." In order to be able to save the train schedules passing through the stations, do a search for a train passing from station A to station B. What are the most acceptable solutions to the task?

  • www.rzd.ru ask if they can give you api. - zb '
  • one
    Topology branches how to describe? Maybe each station has pointers to neighboring, and the distance to them? Or use graph database type neo4j. Flight - a set of station-time pairs of arbitrary length. You can expand to "time-plan" and "time-fact", the latter is filled as the train moves through control points - stations and, maybe, transfers. - Sergiks

0