DESIGNING A DATABASE OF TRIPS OF PUBLIC TRANSPORT USERS WITH ELEMENTS OF DATA WAREHOUSE TECHNOLOGY

Abstract

The use of databases to record travel in city transport is a widespread and effective practice. Databases allow you to organize the storage, management and processing of information about passenger journeys, timetables, tariffs and other related data.

The main methods of using databases to record journeys in urban transport include, for example, storing information about journeys when the database can contain information about each journey of a passenger, including time, date, place of boarding and disembarking, route number and other details. This allows you to track and analyze travel data to improve planning and optimization of transport services. The next example of using databases is managing timetables and routes, since the database can contain information about public transport timetables, routes and stops. This allows you to automate the processes of planning and updating timetables, as well as providing passengers with up-to-date information about available routes and the time of arrival of transport. Databases in transport systems can also be used to record fares, that is, to record passenger payments and manage various tariff zones or payment systems, such as electronic tickets or contactless cards. Information about passenger payments can be recorded and processed in the database for subsequent analysis and reporting, which allows analysis of data on travel, payment, passenger traffic and other parameters to identify trends, resource planning and management decisions. You can create reports and dashboards that provide information about route congestion, the popularity of certain stops, and other useful metrics. Ultimately, the database can be integrated with other traffic management systems, such as traffic flow monitoring systems, traffic light control systems, or passenger information systems. This allows you to create a complex solution that optimizes traffic and improves the experience of passengers.

The use of databases to record travel in city transport contributes to a more efficient organization and management of transport services, and also allows analyzing data to improve the public transport system as a whole.

The purpose of this research is to formulate the requirements and determine the shape of the data base of the fare payment system in urban transport, which would take into account the fares of all categories of citizens and would allow receiving complete and timely information for managing traffic flows, tariffs and effective spending of budget funds directed to compensation for the fares of privileged categories of citizens.