Smart Traffic Management with Real Time Analysis – Seoul Transportation Corporation

Who

Seoul Transportation Corporation is a public entity responsible for the city’s subway transit. The daily average number of subway transit passengers operated by the entity is 6.8 million vs. New York (5.6 million) & Paris (4.2 million). It has a total subway length of 300 km, making it the fourth longest in the world.

Problem

The corporation was in the process of overhauling its subway traffic system with a view to improving the safety and the ability to better act on emergency situations. The corporation looked for a database that could meet the following requirements:

• Since subway traffic facilities should not tolerate any system disruption/failure, they should be supported by databases with the highest degree of product stability
• 24/7 uninterrupted operation and 99.999% high availability
• Even in the event of the system going down abnormally, all data should be automatically saved and protected.
• Data should be collected and stored in real time so that prompt actions can be taken in case of system abnormalities/failures.
• The database should provide and adhere to strict technical SLAs.
• The database should have a track record of having been deployed for other mission critical applications.
• The database should be relational as all of the corporation’s systems are built on relational DBMSs.
• The database costs should be within its IT budget.

Solution

In 2018, the corporation chose Altibase after a series of BMTs of various databases.

• Altibase’s previous deployments in other subway traffic systems was a major appeal.
• Altibase’s in-memory capabilities allow for real time data collection and analysis.
• Using Altibase’s move technology, data is stored on disk when it becomes stale and historical.
• Database induced system downtime has been eliminated with Altibase’s HA and disaster recovery solutions that have features of in-memory based real time replication for synchronous/asynchronous data duplication and in-memory based real time backup and recovery.
• Altibase’s pricing met the corporation’s budget requirement.
• Altibase provides hybrid partitioned tables that can manage a large set of  data log while simultaneously ensuring high performance.

Results

• Altibase has a demonstrated history of providing glitch free operation in the past 10 years in the all subway traffic signal control systems it has served.

• Altibase’s active-active and active-standby replication function allows for stable and interruption-free operation through data duplication in the event of any system failure/outage. The corporation is now able to back up its data through Altibase’s checkpoint image file and redo log file.

• Data loss could be prevented via Altibase’s durability assurance even with abnormal DBMS shutdown.

• After nearly 20 years as a closed source database, Altibase is now open source, and that includes its state-of-the-art sharding.

Learn more about Altibase at https://youtu.be/pooexk0glK8, and download its open source database including sharding at http://altibase.com

Media Contact
Company Name: Seoul Transportation Corporation
Contact Person: Paul Nahm (Chairman)
Email: Send Email
Phone: 1-888-837-7333
Address:40 Wall Street, 28th Floor
City: New York
State: New York
Country: United States
Website: http://altibase.com