Proposição de um sistema de banco de dados dinâmico para auxílio analítico e espacial à operação do transporte público

Abstract

The use of Information Technology Systems (ITS) data has developed rapidly and consistently over the past few years, with various sources of such data being observed, such as social networks, online search engines, and embedded systems applied to public transport vehicles. The latter are the focus of this work, from the automated fare collection (AFC) and automated vehicle location (AVL). Because they have distinct origins and purposes, the challenge lies in the need to associate such data in an integrated way with unique identifiers (keys). Thus, big data techniques are used in this type of analysis because they can treat a high volume of information in a high frequency of observations and with possibility of variability in these data. In this way, the particularities of the systems used need to be treated in a specific way to make feasible the proposed methodology. The goal is to develop a dynamic, georeferenced system that aggregates different databases that have interfaces between them and that allows the study of data for value aggregation, one of the other concepts involved with big data. In this way, the opportunities for planning Public Passenger Transport Systems (STPP) come from the possibility of performing a comparative analysis, studying historical series to estimate and evaluate future scenarios, and descriptive, to understand the behavior of some variable in study. In addition, the gain in information visualization makes decision making more assertive for STPP managers and operators, resulting in a benefit both for public authorities and for private companies and for users of the system.