Time Series Data Management Optimized for Smart City Policy Decision

The European project URBANITE (Supporting the decision-making in URBAN transformation with the use of disruptive Technologies) aims to put in place a sustainable mobility with the support of disruptive and innovative technologies for the sector of urban mobility. Urban mobility and smart mobility contexts, but not only, now require more than ever the use of large amounts of historical data to carry out the necessary analyses for different use cases. A good management of time series data, able to use pagination concepts in an optimized way and providing the user with specifications functions, therefore become indispensable. This need emerged as a native implementation in MongoDB 5.0. With the release of this version, users have functionality to manage time series collections. This new solution has stimulated us to undertake a study on the methods of managing time series data and compare the solution proposed by MongoDB with our solution based on the advanced use of the bucket approach. The two solutions were tested in a real context and the results obtained are reported in the paper.