Optimizing Multi-Modal Transportation in Smart Cities: A Graph-Oriented Database Approach

This paper presents an innovative approach to enhancing urban transportation efficiency through the integration of multimodal transportation networks using graph databases, specifically OrientDB. Addressing the inefficiencies in traditional segregated passenger and freight movements, the study explores the potential of graph databases to effectively manage and optimize complex, interconnected urban transportation systems. Utilizing a practical implementation in Cluj-Napoca, Romania, the research demonstrates how this model can improve operational efficiency and resource allocation. The paper proposes a graph-oriented data model designed to store several types of transportation nodes and links effectively. Additionally, we explore a range of queries to demonstrate the practical usability and functionality of this data model.