Shulou(Shulou.com)06/02 Report--

This article analyzes with you "how to solve the problem of offline railway ticketing system". The content is detailed and easy to understand. Friends who are interested in "how to solve the problem of off-line railway ticketing system" can follow the editor's train of thought to read it slowly and deeply. I hope it will be helpful to everyone after reading. Let's follow the editor to learn more about "how to solve the problem of offline railway ticketing system".

Project background

About the railway ticketing system. China's railway carries as many as 1356700000 passengers a year, which means an average of nearly 4000000 tickets are sold every day, and thousands of tickets are delivered every minute, even if they are sold 24 hours a day. This is a nationwide data-intensive application. With the support of Sybase technology, the railway ticket selling and booking system began to be popularized and implemented in 1996. Before the end of 1998, ticket sales in the intranet of the Railway Bureau was gradually realized. 22 regional ticket center systems and more than 1500 stations were built, and more than 7000 ticket windows were put into use. By 2003, all the regional center systems had been built, and the centralized ticketing within the regional center and the disaster backup system of the regional center had been realized. at present, the tickets sold by the computer ticketing system have accounted for more than 90% of the tickets on the road, and the revenue accounts for more than 96% of the ticket revenue. The successful implementation of the passenger ticket system has promoted the major changes in the railway passenger transport productivity and production relations, strengthened the market competitiveness, improved the work efficiency, reduced the labor intensity, facilitated the passenger ticket purchase, promoted the marketing reform, improved the management level, developed the productive forces, and promoted the reform of production relations, resulting in huge social and economic benefits.

Application requirements

The demand for continuous sale of passenger tickets. Because the railway ticket system is a data-and transaction-intensive production system, the requirement of system continuity is very high. Once there is a problem with the ticket system at each station, within half an hour, the passenger flow in the ticket hall of the station will be silted up, and the ticket buyers will be dissatisfied with it. The relevant departments of the railway hope to find a set of suitable solutions to ensure the business continuity of each station.

However, the overall layout of the railway ticket system is quite large and complex. The whole railway has a central database of the whole railway and 23 regional central databases, and each station also has its own database. The ticket system needs to enhance the reliability of the system from different levels in order to reduce the impact of downtime to *.

Solution

SQL Anywhere

MobiLink

Sybase's mobile database SQL Anywhere, which provides data management and enterprise synchronization technology, can realize the rapid development and submission of distributed e-commerce solutions. Through special optimization for workgroups, laptops, handheld devices and smart appliances, it can extend the enterprise's e-commerce information to wherever business transactions take place.

At present, the original architecture of the railway ticketing system is as follows:

In the existing railway ticket system, from the application database of the station to the central database of the ticketing center of the whole railway, the database is Sybase Adaptive Enterprise (ASE). All levels of databases rely on Sybase Replication Server (replication server) for data synchronization to ensure the real-time consistency of data.

SQL Anywhere will guarantee the business continuity of the ticketing system at the station system level. Add two servers to the original application database Sybase Adaptive Server Enterprise of each station system, on which the SQL Anywhere database is installed. Adaptive Server Enterprise alternately synchronizes data with two SQL Anywhere databases at 30-minute intervals through SQL Anywhere's even connection data synchronization solution MobiLink, so that each SQL Anywhere database is constantly consistent with the application database data of the station system (as shown in ① in the following figure).

When the online ticketing system at the station fails, each station will select the SQL Anywhere database server that has * data and distribute its data to each offline ticketing system database at the station. According to certain rules, the ticket number segment is assigned to each offline ticketing system. As a result, the desktop offline ticketing system, located on the computer in the ticket window, starts selling tickets immediately (as shown in the ② in the following figure).

When the online ticketing system is restored, the offline ticketing system will be stopped, and then switch to the online ticketing system to sell tickets. At this point, tickets that have been sold on the offline ticketing system will be synchronized to the station's application database by MobiLink. (as shown by ③ in the following figure)

At this point, the offline ticketing system will enter a cycle of alternately synchronizing with the station application database every 30 minutes.

Introduction to SQL Anywhere

SQL Anywhere is a high-performance, embeddable relational database management system (RDBMS) that is highly scalable and can support desktop and mobile applications ranging from server environments with thousands of users to large-scale deployment, zero-management environments. It is as small as a fingerprint, but it provides the functionality of an enterprise database; it provides rich features that can be used in resource-intensive and managed databases, including transaction processing, referential integrity, stored procedures and triggers, materialized views, hot failover, and automatic backup and recovery.

Introduction to MobiLink

MobiLink is a highly scalable and session-based synchronization technology for data exchange between relational databases and other non-relational data sources. Advanced synchronization logic can ensure the transaction consistency of the database in the event of loss of network connection, and provides a * strategy to resolve data update conflicts.

MobiLink supports two-way exchange of information between remote SQL Anywhere or UltraLite databases and a large number of enterprise data sources, including SQL Anywhere, Sybase Adaptive Server Enterprise, Oracle, Microsoft SQL Server, and IBM DB2. In addition to databases, MobiLink can synchronize with other data sources, such as application servers, ERP systems (such as SAP), Web services, XML files, or other third-party relational databases.

On how to solve the problem of off-line railway ticketing system is shared here, I hope that the above content can improve everyone. If you want to learn more knowledge, please pay more attention to the editor's updates. Thank you for following the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.