All Products
Search
Document Center

AnalyticDB for MySQL:Intelligent urban public transportation system built based on AnalyticDB for MySQL

Last Updated:Dec 25, 2023

TusPass Beijing Technologies Co., Ltd. (hereinafter referred to as TusPass) uses AnalyticDB for MySQL in combination with PolarDB-X 1.0 to create commercial value out of data such as those of passengers, vehicles, transportation lines, and stations. This helps TusPass improve and innovate on their service and empower the development of "Internet+ urban public transportation".

Challenges

Established on June 26, 2018, TusPass is a leading solution provider and service operator of intelligent public transportation systems in the Chinese mainland. As its business grows, TusPass has encountered the following challenges:

  • High volume and highly concurrent transactions. TusPass operates the largest urban public transportation management system in Beijing, with the largest volume and variety of vehicles and the most complex billing system. The system handles data for tens of millions of passengers each day. During the rush hours, thousands of concurrent requests are processed per second.

  • Various data sources. Data sources include the GPS, vehicle telemetry devices, and IoT sensors on more than 20,000 buses.

  • Petabytes of data. On average, petabytes of data will be stored, computed, analyzed, and queried each year.

Solution

To process petabytes of data and meet the requirements of storage, computing, analysis, and query of IoT data, TusPass uses a combination of Alibaba Cloud database services to implement intelligent public transit in Beijing.

Description:

  • TusPass uses PolarDB-X 1.0 for all of its business systems. These systems can process large amounts of data and support high concurrency, availability, and scalability.

  • The ticket management system synchronizes user data to AnalyticDB for MySQL in real time. By using SQL, dispatchers can learn about real-time passenger flows based on the user data and perform analysis on the monitoring information uploaded by telemetry devices, so as to reactively schedule buses. For more information, see What is AnalyticDB for MySQL?

Benefits

The intelligent public transportation system built based on AnalyticDB for MySQL and PolarDB-X 1.0 provides the following benefits for TusPass:

  • New features are added to the Beijing Public Transport app. Passengers can view lines and stations to plan their routes, learn about bus wait times, and book custom trips.

  • An intelligent business analysis system is created for bus ticket personnel to obtain operations status, settlement reports, and monitoring and alerting information in a timely manner.

  • An intelligent real-time passenger flow system is developed. It automatically analyzes passenger flows, monitors the running status of more than 20,000 buses in Beijing, and generates scheduling schemes based on the running status of vehicles, machines, and onboard devices. This helps station dispatchers schedule buses.

  • A real-time big data analysis system is created to help management personnel make business decisions.