The solution of Metro Data management Information system in city level

The solution of Metro Data management Information system in city level
I. PURPOSE of CONSTRUCTION

A city-level Metro ticket Clearance division is an important hub of the entire management system of the Metro, is responsible for the line center and the Finance Department, marketing department and other departments of the daily work, convenient traffic statistics, income clearance reconciliation and maintenance management substation equipment.

Before, the city-level Metro use Crystal Report to develop, complete passenger flow and clearing settlement business, due to the production of Crystal Report complex functions to be programmed to achieve, not maintenance management, so the use of finereport this software-assisted development, Finereport report software for the complex format of the report data and the presentation of the Web report, through multi-source sharding, irregular grouping, bidirectional expansion to easily drag and drop the complex format of the report, from the complex SQL and expression, do not need programming, greatly improve the efficiency of the report production.

Second, business needs

1. Overall objectives

Here the city-level Metro two development of the report is mainly related to equipment maintenance, including the various sites of the TVM machine (sell one-way ticket), Gate Machine (swipe gate), and post machine (replacement temporary ticket), by the average daily use of frequency and the number of various types of machines to carry out targeted equipment maintenance.

2. Basic function Requirement

3. Other functional requirements

(1) How to divide the money at each site

According to enter the site and the actual use of the number of points in accordance with a certain rate of operation, but for the sake of simplicity, at this stage is the implementation of the way to confirm, that is, a site out of more people, the money is more.

(2) TVM Income reconciliation

Compared to the temporary ticket machine in the money and each line center submitted data, if found not the same, it is necessary to check (the line center will collect the data collected by the equipment, card companies will aggregate data, the two sides can not know the other side of the data, the ticket is cleared after the success of the Division to report the company's financial department).

Subway lines use a separate database, so check the comparison through the multi-source display, reduce the human factors involved, to avoid the repeated work and blunder can be multiplied.

Iii. general overview of system construction

1. General Ideas

Metro Management Information System relies on the network platform construction, is a complex, heterogeneous application system, at different levels of system integration, take effective strategies to achieve enterprise application integration, realize the different business application subsystem between the data, information exchange, reduce manual operation, improve efficiency.

2. System Framework

In order to implement the city-level Metro technology company to improve taste, practical, intelligent and efficient, economic and reasonable, simple and crisp information system construction policy, to ensure the continuity of business and security, so that the subway Ticket Clearance division to receive personalized services, as follows:

Iv. system functions

1. Business functions

System usage Process All site usage frequency ranking statistics

Through the statistics of all sites in the city, each gate, TVM machine Use frequency (gate statistics one pass, the number of use of a card, a card from the cards company issued, including internal cards and external cards, internal cards are mainly employee cards, external cards including adult cards, elderly cards, student cards, etc.) fall into the interval (0 to 10000 or more, span of 1000), for targeted maintenance, and to view the time, according to the People's habitual thinking (see what is needed), the maximum is ranked above, the actual use of the order. (as shown in report 1.1-1.2:)

Figure 1.1 The frequency of the gate used in the statistics

Figure 1.2 TVM machine usage frequency ranking statistics

Three lines so the site uses interval segment count

Statistics of three lines (line Line 1, Line Line 2, South Extension line) above all the various types of equipment used in the number of units in the use of interval, to assist in the analysis of the actual operation of each line maintenance situation, such as a line of equipment used in line with the Line 2 and South extension lines to be much larger, you need to strengthen the line of equipment maintenance (as shown in Report 1.3-1.4:)

Fig. 1.3 Statistics of each use interval segment of three line TVM machine

Fig. 1.4 Statistics of the number of interval sections of three line gate machines

Daily morning and evening peak usage frequency of each site

As we all know, daily from 7:30 to 9:30 and 17:30 to 19:30 in the commute time, this time period of large passenger traffic, various types of equipment use more, in order to better maintain the equipment of each site, Ticket Clearance division needs to count the frequency of each device used in each array and the frequency of the entire array in each of the two time periods, the average usage per hour (array refers to each station, the exit row of the gate, TVM machine, etc.), easy to know the actual use of each array, for targeted maintenance. (for example, Xinjiekou many exits, each exit has a row of gates, 1.5, shown in statements 1.6-1.7):

Figure 1.5 A site array construct

Figure 1.6 Average use of each array gate

Figure 1.7 Average use of each array TVM machine

Rate Test Case statistics

When taking the subway between different sites, the price is not the same, the ticket clearance division needs to monitor the actual use of no card, including the path, number of sites, rates (how much), actual card fees and the status of the card is now (more than 0:00 has not been outbound as a failure, the next time the card will be prompted), Easy to understand the actual usage of each card. (Personal experience once, the card did not pay attention to success when outbound, and then again when the card prompt failed, to the ticket to find no brush to fight) when the statistics in order to facilitate the selection of the corresponding site and card type, the customer wants to show in a hierarchical relationship, report 1.8 shows:

Figure 1.8 Rate Test Case statistics

Line and ACC Transaction Data Reconciliation Report

Compared to the temporary ticket machine in the money and each line center submitted data, if found not the same, it is necessary to check separately, the same audit success, to report, 1.9 shows:

Figure 1. 9 Line and ACC Transaction Data Reconciliation report

Monthly Report on operating income of line after clearing

Statistics of three lines (line Line 1, Line Line 2, South Extension line) operating income this month, but also according to different ticketing methods for statistics, such as one-pass and a card (including internal cards and external cards, internal cards are mainly employee cards, external cards including adult cards, elderly cards, student cards, etc.) use of statistics and summary, 1.10 is shown below:

Figure 1.10 Monthly operating income of the line after clearing

Network travel volume Structure analysis daily

According to different fares, the number of daily trips is counted, and the percentage of travel, daily income and daily passenger turnover are calculated as 1.11:

Figure 1.11 Network Travel volume structure analysis daily

Monthly report on usage statistics of card issuance

Subway gauge card is the subway every holiday or subway operation Day issued a certain value of the card, limited to a certain date before use, and each ride not divided by the length of the mileage is 2 yuan or 3 yuan, the following according to each time period of the statistics on the sale of the card, check each card expiry time, face value, issue number , number of releases, number of uses, etc., 1.12:

Figure 1.12 Monthly Report on the use of the card issue

2. Advantages and characteristics of the scheme

2.1 Integration of report presentation and data reporting

The use of Finereport Report Designer can be simple and quick to complete a variety of style complex reports, fill out the design of the report. The same table can be used to display data, as well as data editing and reporting.

2.2 Item Properties

In order to macro above the control line above the income situation, the actual data and theoretical data need to do a comparison, for example, a station in accordance with the previous weeks trend income should be about 25000, but the actual situation is only 20000 or 5000, the actual value and theoretical value gap exceeds the range of deviation, It is marked in red by the conditional attribute, and then the person is assigned to check it.

2.3 Rights Management

Although the subway management information system is relatively independent, but because the user table is stored in the database table, and the system is handed over to the end user, the user data needs to be unified with the user's existing permission system, so it is necessary to read the data table directly when establishing the system.

2.4 Timers

Metro Management Information system needs to be daily in the outage when the day's passenger flow, line revenue, equipment information are counted out, and then stored in the cost of the file for archiving, when you want to view the time directly from the server to remove files, lest the regeneration, can be timed to generate local files with the timer Excel on it.

2.5 Reporting Platform

Users as a result of building a system from scratch, it is necessary to quickly and easily manage the file, including user login, according to the rights to manage the corresponding page and other basic requirements. And can be conveniently configured to meet the user style requirements of the system style.

The solution of Metro Data management Information system in city level