Locomotive section operation data analysis system and analysis method

Abstract

The present invention belongs to the technical field of railway locomotive dispatching management, and relates to a locomotive interval operation data analysis system and analysis method, including a data source information module, an entity data module, a data generation module and a data processing module; extracting the real-time data and standard data required by the entity data module from the data source information module, and updating the analysis dimension table; matching the real-time data with the standard data, calculating the locomotive interval operation parameter data, updating the real-time data and the calculated locomotive interval operation parameter data to the locomotive interval operation fact table, thereby constructing a data analysis model; analyzing the locomotive interval operation status through the data processing module. The present invention has good data integrity, and the locomotive delay duration is obtained through the classification method of initial delay and associated delay, and the locomotive operation and delay information are provided efficiently and quickly, which improves the emergency response capability of the passenger transport department and provides guidance for directing production and transportation.

Description

Technical Field

[0001] The invention belongs to the technical field of railway locomotive dispatching management, and relates to a locomotive interval operation data analysis system and analysis method. Background Art

[0002] The railway bureau's dispatching office has information on the operation status and delays of all freight trains within its jurisdiction, but lacks an efficient and fast means to provide relevant information to the locomotive depots and other units within its jurisdiction.

[0003] Delay is a timetable deviation phenomenon that occurs when the train operation in the section is disturbed. In order to analyze and predict the occurrence of delays, related studies usually use delay propagation analysis and performance data statistics to improve the model output results. By building a "railway locomotive section operation data analysis system", it can provide a forecast and analysis summary of all delayed freight cars within the jurisdiction of the railway bureau. The railway bureau's passenger transportation department and relevant departments, stations, etc. can effectively grasp the train delay information and improve the emergency response capabilities of the transportation department; it can analyze and summarize the train delay situation and generate daily passenger car statistics reports, thereby effectively directing production and transportation.

[0004] Based on the existing analysis methods, a classification method for initial delays and associated delays was designed, the operation of trains in the dispatching section was converted into a directed graph, and the classification of delays and the determination of propagation paths were achieved by analyzing the planned time saturation within the directed arcs. Based on the data provided by the classification method, a delay prediction model was proposed, and a back-propagation neural network was used to predict the delay duration. Summary of the invention

[0005] In view of the problems existing in the existing locomotive data analysis in the background technology, the present invention provides a locomotive section operation data analysis system and analysis method, which have good data integrity and can obtain the locomotive delay duration through the classification method of initial delay and related delay. It can efficiently and quickly provide the freight car operation status to each locomotive depot, effectively grasp the locomotive delay information, improve the emergency response capability of the passenger transport department, and provide guidance for commanding production and transportation.

[0006] In order to achieve the above object, the technical solution adopted by the present invention is:

[0007] A locomotive section operation data analysis system includes a data source information module, an entity data module, a data generation module and a data processing module;

[0008] The data source information module is used to store all locomotive operation data of each railway section;

[0009] The entity data module is used to establish interrelated locomotive interval operation standard time database, locomotive interval operation entity information, locomotive interval operation fact table and analysis dimension table according to user needs; extract the standard data and real-time data of locomotive interval operation from the data source information module and fill them into the corresponding locomotive interval operation standard time database and locomotive interval operation entity information respectively;

[0010] Locomotive interval operation standard time database: records and displays the standard data and operation data of locomotive interval operation during locomotive operation;

[0011] Locomotive interval operation entity information: records and displays the real-time data of locomotive interval operation during locomotive operation;

[0012] Locomotive section operation fact table: a data table with analysis object as granularity established based on locomotive section operation entity information;

[0013] Analysis dimension table: a corresponding form established based on the locomotive section operation entity information with the analysis dimension as the object;

[0014] The data generation module is used to receive the standard data and real-time data sent by the entity data module, and update the analysis dimension table according to the real-time data; at the same time, the real-time data is matched with the standard data, and the locomotive section operation parameter data is calculated, and the real-time data and the calculated locomotive section operation parameter data are updated to the locomotive section operation fact table, so as to construct a data analysis model;

[0015] The data processing module is used to extract the data model to be analyzed from the data analysis model according to the user's analysis needs, and analyze the locomotive section operation status.

[0016] Furthermore, the locomotive interval operation standard time database includes the route number, departure station, arrival station, interval distance, additional start time, additional stop time and standard operation time.

[0017] Furthermore, the locomotive section operation entity information includes the start time, section, crew route, vehicle type, locomotive number, train number, departure station, arrival station, departure time, arrival time, parking time at the departure station and parking time at the arrival station.

[0018] Furthermore, the locomotive interval operation fact table includes the section key, start time key, locomotive model key, crew route key, vehicle type key, locomotive number, train number, departure station key, arrival station key, interval operation time, technical speed, and early and late time.

[0019] Furthermore, the analysis dimension table includes a segment dimension table, a departure time dimension table, a crew route dimension table, a vehicle type dimension table and a station dimension table.

[0020] Furthermore, the segment dimension table includes the segment key value, segment code and segment name; the departure time dimension table includes the departure time key value, year, month, day and hour; the crew route dimension table includes the crew route key value, crew route code and crew route name; the vehicle type dimension table includes the vehicle type key value, vehicle type code and vehicle type name; the station dimension table includes the station key value, station code and station name.

[0021] A locomotive section operation data analysis method comprises the following steps:

[0022] 1) Collect all locomotive interval operation data of each railway section and store them in the data source information module;

[0023] 2) Establish locomotive interval operation standard time database, locomotive interval operation entity information, locomotive interval operation fact table and analysis dimension table according to user needs; extract locomotive interval operation standard data and locomotive interval operation real-time data required by the user from the data source information module and fill them into the corresponding locomotive interval operation standard time database and locomotive interval operation entity information respectively;

[0024] 3) According to the extracted locomotive interval operation real-time data, the analysis dimension table is updated to obtain the analysis dimension model; the locomotive interval operation real-time data is matched with the locomotive interval operation standard data, the locomotive interval operation parameter data is calculated, the real-time data and the calculated locomotive interval operation parameter data are updated to the locomotive interval operation fact table to obtain the locomotive interval operation fact model, and the data analysis model is obtained by constructing the analysis dimension model and the locomotive interval operation fact model;

[0025] 4) According to the user's analysis needs, the data information to be analyzed is extracted from the data analysis model, the locomotive section operation data is analyzed, and the locomotive section operation status is obtained.

[0026] Furthermore, the specific process of step 3) is:

[0027] 3.1) De-duplicate the locomotive interval operation real-time data extracted in step 2) according to the start time, locomotive model, locomotive number and train number, and update the analysis dimension table according to the de-duplicate locomotive interval operation real-time data;

[0028] 3.2) matching the locomotive interval operation real-time data after deduplication in step 3.1) with the locomotive interval operation standard data extracted in step 2) according to the route number, departure station, and arrival station, and obtaining the interval distance, additional start time, additional stop time, and standard operation time information respectively;

[0029] 3.3) Calculating the interval operation time, technical speed and early and late time based on the real-time data of locomotive interval operation after deduplication in step 3.1) and the interval distance, additional start time, additional stop time and standard operation time information obtained in step 3.2) to obtain the interval operation time, technical speed and early and late time;

[0030] 3.4) updating and storing the locomotive interval operation real-time data after deduplication in step 3.1) and the interval operation time, technical speed and early and late time calculated in step 3.3) in the locomotive interval operation fact table;

[0031] 3.5) Combining the analysis dimension table updated in step 3.1) and the locomotive section operation fact table updated in step 3.4), a data analysis model is constructed.

[0032] Furthermore, the calculation formulas for the interval running time, technical speed and early and late time in step 3.3) are respectively:

[0033] The locomotive interval running time = arrival time - departure time;

[0034] The locomotive technical speed = interval distance / (arrival time - departure time);

[0035] The time of the locomotive being early or late = arrival time - departure time - additional time for starting - additional time for stopping - standard running time; if the stopping time at the departure station is > 0 and the stopping time at the arrival station is > 0;

[0036] The time of the locomotive being early or late = arrival time - departure time - additional time for departure - standard running time; if the parking time at the departure station is > 0 and the parking time at the arrival station is = 0;

[0037] The time of the locomotive being early or late = arrival time - departure time - additional parking time - standard running time; if the parking time at the departure station = 0 and the parking time at the arrival station > 0;

[0038] The time of the locomotive being early or late = arrival time - departure time - standard running time; if the parking time at the departure station = 0 and the parking time at the arrival station = 0.

[0039] The beneficial effects of the present invention are:

[0040] 1. The locomotive interval operation data extraction and analysis system provided by the present invention includes a data source information module, an entity data module, a data generation module and a data processing module; the data source information module is used to store all locomotive operation data of each railway section; the entity data module is used to establish a locomotive interval operation standard time-division library, locomotive interval operation entity information, locomotive interval operation fact table and analysis dimension table according to user needs; the standard data and real-time data of the locomotive interval operation are extracted from the data source information module and filled into the corresponding locomotive interval operation standard time-division library and locomotive interval operation entity information respectively, and the dimension table is updated at the same time; the data generation module is used to receive the standard data and real-time data sent by the entity data module, and update the analysis dimension table according to the real-time data; at the same time, the real-time data is matched with the standard data, the locomotive interval operation parameter data is calculated, and the real-time data and the calculated locomotive interval operation parameter data are updated to the locomotive interval operation fact table, so as to construct a data analysis model; the data processing module is used to extract the data information to be analyzed from the data analysis model according to the user's analysis needs, and analyze the locomotive interval operation situation. The analysis system provided by the present invention can collect data on locomotives within the scope of the railway bureau, has a wide coverage, ensures the accuracy and completeness of the analysis results, and can provide real-time delay forecast information for all delayed passenger trains and statistical summary information on delayed trains, so as to strengthen emergency response for the passenger transport department, and provide support for the dispatching office to analyze and summarize the passenger train delays, generate daily passenger train statistical reports, and effectively strengthen transportation production command.

[0041] 2. The locomotive interval operation data analysis method provided by the present invention comprises the following steps: 1) collecting all locomotive interval operation data of each railway section and storing them in a data source information module; 2) establishing a locomotive interval operation standard time-division library, locomotive interval operation entity information, locomotive interval operation fact table and analysis dimension table respectively according to user needs; extracting the locomotive interval operation standard data and locomotive interval operation real-time data required by the user from the data source information module and filling them into the corresponding locomotive interval operation standard time-division library and locomotive interval operation entity information respectively; 3) updating the analysis dimension table according to the extracted locomotive interval operation real-time data to obtain an analysis dimension model; and matching the locomotive interval operation real-time data with the locomotive interval operation standard data, calculating the locomotive interval operation parameter data, updating the real-time data and the calculated locomotive interval operation parameter data to the locomotive interval operation fact table to obtain the locomotive interval operation fact model, and constructing a data analysis model through the analysis dimension model and the locomotive interval operation fact model; 4) extracting the data information to be analyzed from the data analysis model according to the user's analysis needs, analyzing the locomotive interval operation data, and obtaining the locomotive interval operation status. By calculating the standard data and real-time data of the operation, updating the fact table and analysis dimension table, the constructed data analysis model analyzes the locomotive interval operation data and obtains the locomotive delay duration. It lays the foundation for the subsequent analysis of locomotive interval operation data and provides guidance for the management department; at the same time, considering the initial delay and the associated delay, it can comprehensively obtain the locomotive delay duration information, and can efficiently and quickly provide each locomotive section with the operation status of the freight cars and delay information, effectively grasp the locomotive delay information, improve the emergency response capabilities of the passenger transport department, and provide guidance for directing production and transportation.

[0042] 3. The calculation of the locomotive early and late time provided by the present invention is respectively: if the departure station parking time>0 and the arrival station parking time>0 in the locomotive interval operation information, the locomotive early and late time=arrival time-departure time-additional time for departure-additional time for parking-standard operation time; if the departure station parking time>0 and the arrival station parking time=0, the locomotive early and late time=arrival time-departure time-additional time for departure-standard operation time; if the departure station parking time=0 and the arrival station parking time>0; the locomotive early and late time=arrival time-departure time-additional time for parking-standard operation time; if the departure station parking time=0 and the arrival station parking time=0, the locomotive early and late time=arrival time-departure time-additional time for parking-standard operation time. The operation of the locomotive in the dispatching section is converted into a directed graph representation, and by analyzing the planned time saturation in the directed arc, the classification of delays and the determination of the propagation path are realized, and on the basis of the data provided by the classification method, a delay prediction model is proposed, and a back propagation neural network is used to predict the delay duration. The analysis result has good accuracy, and the analysis method is fast and efficient. BRIEF DESCRIPTION OF THE DRAWINGS

[0043] Figure 1 A schematic diagram of a locomotive section operation data analysis system provided by the present invention;

[0044] Figure 2 The locomotive section operation fact table and analysis dimension representation diagram provided by the present invention;

[0045] Figure 3 This is a schematic diagram of the calculation of the locomotive's early and late points according to the present invention. DETAILED DESCRIPTION

[0046] The present invention will now be described in detail with reference to the accompanying drawings and embodiments.

[0047] Example 1

[0048] See also Figure 1 The locomotive section operation data analysis system provided in this embodiment includes a data source information module, an entity data module, a data generation module and a data processing module.

[0049] The data source information module provided in this embodiment is used to store all locomotive operation data of each railway section.

[0050] The data source information provided in this embodiment includes all locomotive operation data, and the data comes from various railway sections, so the data type is diverse, including relational databases supporting Oracle, DB2, SQLServer, MySQL and Informix, file-type data supporting Excel, txt files and XML files, standard data supporting WebService and SOA, unstructured databases supporting MongoDB and HBASE, and distributed data sources supporting SAP, Hadoop, and Gemfire.

[0051] The locomotive section operation data analysis system provided in this embodiment is characterized in that: the locomotive section operation data analysis system includes a data source information module, an entity data module, a data generation module and a data processing module;

[0052] The data source information module provided in this embodiment is used to store all locomotive operation data of each railway section.

[0053] The entity data module provided in this embodiment is used to establish interrelated locomotive section operation standard time database, locomotive section operation entity information, locomotive section operation fact table and analysis dimension table according to user needs; extract the standard data and real-time data of locomotive section operation from the data source information module and fill them into the corresponding locomotive section operation standard time database and locomotive section operation entity information respectively.

[0054] In this embodiment, the locomotive section operation standard time database records and displays the standard data and operation data of the locomotive section operation during the locomotive operation process.

[0055] In this embodiment, the locomotive section operation entity information: records and displays the real-time data of the locomotive section operation during the locomotive operation process.

[0056] In this embodiment, the locomotive section operation fact table is a data table with the analysis object as the granularity established according to the locomotive section operation entity information.

[0057] In this embodiment, the analysis dimension table is a corresponding form established based on the locomotive section operation entity information with the analysis dimension as the object.

[0058] The data generation module provided in this embodiment is used to receive standard data and real-time data sent by the entity data module, and update the analysis dimension table according to the real-time data; at the same time, the real-time data is matched with the standard data, and the locomotive section operation parameter data is calculated, and the real-time data and the calculated locomotive section operation parameter data are updated to the locomotive section operation fact table, thereby constructing a data analysis model.

[0059] The data processing module provided in this embodiment is used to extract the data model to be analyzed from the data analysis model according to the user's analysis needs, and analyze the locomotive section operation status.

[0060] The locomotive interval operation standard time database provided in this embodiment includes the route number, departure station, arrival station, interval distance, additional start time, additional stop time and standard operation time.

[0061] The locomotive section operation entity information provided in this embodiment includes the start time, section, crew route, vehicle type, locomotive number, train number, departure station, arrival station, departure time, arrival time, parking time at the departure station and parking time at the arrival station.

[0062] See also Figure 2 The locomotive interval operation fact table provided in this embodiment includes the section key, departure time key, locomotive model key, crew route key, vehicle type key, locomotive number, train number, departure station key, arrival station key, interval operation time, technical speed, and early and late time.

[0063] See also Figure 2The analysis dimension table provided in this embodiment includes a segment dimension table, a departure time dimension table, a crew route dimension table, a vehicle type dimension table, and a station dimension table. The segment dimension table includes a segment key value, a segment code, and a segment name; the departure time dimension table includes a departure time key value, year, month, day, and hour; the crew route dimension table includes a crew route key value, a crew route code, and a crew route name; the vehicle type dimension table includes a vehicle type key value, a vehicle type code, and a vehicle type name; and the station dimension table includes a station key value, a station code, and a station name.

[0064] In this embodiment, the data source information includes driving information from various locomotive depots, locomotives, crew routes, etc. The data covers a wide range and can effectively manage the locomotive operation data; and the data source supports different types of data. During implementation, the data of different file types and formats in the data source can be converted and split according to the data format or file format requirements in the locomotive interval operation fact table to realize intelligent data processing, so that the data conforms to the data format requirements of the locomotive interval operation standard time database, locomotive interval operation entity information, locomotive interval operation fact table and analysis dimension table, thereby improving the efficiency of data processing during locomotive operation, and facilitating the processing of data in the constructed data model to ensure the integrity and accuracy of subsequent analysis results.

[0065] The locomotive interval data analysis system provided in this embodiment can collect locomotive data within the railway bureau, has a wide coverage, ensures the accuracy and completeness of the analysis results, and can provide real-time delay forecast information for all delayed passenger trains and statistical summary information on delayed trains, so as to strengthen emergency response for the passenger transport department, and provide support for the dispatching office to conduct analysis and summary of passenger train delays, generate daily passenger train statistical reports, and effectively strengthen transportation production command.

[0066] Example 2

[0067] The locomotive section operation data analysis method provided in this embodiment includes the following steps:

[0068] 1) Collect all locomotive interval operation data of each railway section and store them in the data source information module;

[0069] 2) Establish locomotive interval operation standard time database, locomotive interval operation entity information, locomotive interval operation fact table and analysis dimension table according to user needs; extract locomotive interval operation standard data and locomotive interval operation real-time data required by the user from the data source information module and fill them into the corresponding locomotive interval operation standard time database and locomotive interval operation entity information respectively;

[0070] 3) According to the extracted locomotive interval operation real-time data, the analysis dimension table is updated to obtain the analysis dimension model; the locomotive interval operation real-time data is matched with the locomotive interval operation standard data, the locomotive interval operation parameter data is calculated, the real-time data and the calculated locomotive interval operation parameter data are updated to the locomotive interval operation fact table to obtain the locomotive interval operation fact model, and the data analysis model is obtained by constructing the analysis dimension model and the locomotive interval operation fact model;

[0071] The specific process of step 3) is:

[0072] 3.1) De-duplicate the locomotive interval operation real-time data extracted in step 2) according to the start time, locomotive model, locomotive number and train number, and update the analysis dimension table according to the de-duplicate locomotive interval operation real-time data;

[0073] 3.2) matching the locomotive interval operation real-time data after deduplication in step 3.1) with the locomotive interval operation standard data extracted in step 2) according to the route number, departure station, and arrival station, and obtaining the interval distance, additional start time, additional stop time, and standard operation time information respectively;

[0074] In this embodiment, the locomotive section running time = arrival time - departure time.

[0075] In this embodiment, locomotive technical speed = section distance / (arrival time - departure time).

[0076] See also Figure 3 In this embodiment, the calculation formulas for the morning and evening hours are:

[0077] Locomotive early or late time = arrival time - departure time - additional time for starting - additional time for stopping - standard running time; if the stopping time at the departure station is > 0 and the stopping time at the arrival station is > 0;

[0078] Locomotive early or late time = arrival time - departure time - additional time for departure - standard running time; if the parking time at the departure station > 0 and the parking time at the arrival station = 0;

[0079] The time of locomotive early or late = arrival time - departure time - additional parking time - standard running time; if the parking time at the departure station = 0 and the parking time at the arrival station > 0;

[0080] Locomotive early or late time = arrival time - departure time - standard running time; if the departure station stop time = 0 and the arrival station stop time = 0;

[0081] 3.3) Calculating the interval operation time, technical speed and early and late time based on the real-time data of locomotive interval operation after deduplication in step 3.1) and the interval distance, additional start time, additional stop time and standard operation time information obtained in step 3.2) to obtain the interval operation time, technical speed and early and late time;

[0082] 3.4) updating and storing the locomotive interval operation real-time data after deduplication in step 3.1) and the interval operation time, technical speed and early and late time calculated in step 3.3) in the locomotive interval operation fact table;

[0083] 3.5) generating an analysis dimension model by combining the analysis dimension table updated in step 3.1) and the locomotive section operation fact table updated in step 3.4) to obtain a locomotive section operation fact model, and constructing a data analysis model;

[0084] 4) According to the user's analysis needs, the data information to be analyzed is extracted from the data analysis model, the locomotive section operation data is analyzed, and the locomotive section operation status is obtained.

[0085] In this embodiment, the data information to be analyzed can also be extracted from the data analysis model and provided to the business system or terminal call, so as to facilitate the control of the working conditions during the operation of the locomotive; for locomotives with malfunctions during operation, the causes can be analyzed by analyzing the data in the dimension table and the locomotive interval operation fact table, thereby providing direction for the management of the locomotive.

[0086] The present invention updates the analysis dimension table through the real-time data extracted from the data source information module; then obtains the parameter data of the locomotive operation by matching and calculating the real-time data and the standard data, and updates the locomotive interval operation fact table according to the calculated data and the real-time updated data; and constructs a data analysis model with the updated analysis dimension table and the updated locomotive interval operation fact table, so as to clearly know the various information data of the locomotive operation, specifically including the section to which the locomotive belongs, the driving time, the locomotive model, the crew route, the train number, the departure station, the arrival station, the interval operation time, the early and late time and the technical speed, and understand the locomotive interval operation situation in real time; at the same time, by analyzing the section dimension table, the driving time dimension table, the crew route dimension table, the car type dimension table and the station dimension table in the dimension table, the data information of the section to which the locomotive belongs, the crew route data information through which the locomotive runs, the locomotive driving time data information, the locomotive car type data information and the locomotive running station data information can be obtained, and by summarizing these data information, the reason for the delay of the locomotive during operation can be judged, which is beneficial to the control work of the railway management department.

Claims

1. A locomotive section operation data analysis system, characterized in that: The locomotive section operation data analysis system includes a data source information module, an entity data module, a data generation module and a data processing module; The data source information module is used to store all locomotive operation data of each railway locomotive depot; The entity data module is used to establish interrelated locomotive interval operation standard time-division database, locomotive interval operation entity information, locomotive interval operation fact table and analysis dimension table according to user needs; Extract the standard data and real-time data of locomotive interval operation from the data source information module and fill them into the corresponding locomotive interval operation standard time database and locomotive interval operation entity information respectively; the locomotive interval operation fact table includes the section key, start time key, locomotive model key, crew route key, vehicle type key, locomotive number, train number, departure station key, arrival station key, interval operation time, technical speed and early and late time; Locomotive interval operation standard time database: record and display the standard data form of locomotive interval operation during locomotive operation; Locomotive interval operation entity information: a real-time data form that records and displays the locomotive interval operation during the locomotive operation process; Locomotive section operation fact table: a data table with analysis object as granularity established based on locomotive section operation entity information; Analysis dimension table: a corresponding form established based on the locomotive section operation entity information with the analysis dimension as the object; The data generation module is used to receive the standard data and real-time data sent by the entity data module, and update the analysis dimension table according to the real-time data; the extracted locomotive interval operation real-time data is deduplicated according to the start time, locomotive model, locomotive number and train number, and the analysis dimension table is updated according to the deduplicated locomotive interval operation real-time data; at the same time, the real-time data is matched with the standard data, and the locomotive interval operation parameter data is calculated, and the real-time data and the calculated locomotive interval operation parameter data are updated to the locomotive interval operation fact table, so as to construct a data analysis model; the data analysis model analyzes the locomotive interval operation data to obtain the locomotive delay duration; The system provides real-time delay forecast information for all delayed buses; If the parking time at the departure station in the locomotive section operation information is > 0 and the parking time at the arrival station is > 0, the locomotive early or late time = arrival time - departure time - additional time for departure - additional time for parking - standard operating minutes; if the parking time at the departure station is > 0 and the parking time at the arrival station is = 0, the locomotive early or late time = arrival time - departure time - additional time for departure - standard operating minutes; if the parking time at the departure station is = 0 and the parking time at the arrival station is > 0; the locomotive early or late time = arrival time - departure time - additional time for parking - standard operating minutes; if the parking time at the departure station is = 0 and the parking time at the arrival station is = 0, the locomotive early or late time = arrival time - departure time - standard operating minutes; The locomotive operation in the dispatching section is converted into a directed graph representation, and the classification of delays and the determination of propagation paths are achieved by analyzing the planned time saturation within the directed arcs. Based on the data provided by the classification method, a delay prediction model is proposed, and the back propagation neural network is used to predict the delay duration. The data processing module is used to extract the data model to be analyzed from the data analysis model according to the user's analysis needs, and analyze the locomotive section operation status.

2. The locomotive section operation data analysis system according to claim 1, characterized in that: The locomotive interval operation standard time database includes the route number, departure station, arrival station, interval distance, additional start time, additional stop time and standard operation time.

3. The locomotive section operation data analysis system according to claim 2, characterized in that: The locomotive section operation entity information includes the start time, section, crew route, vehicle type, locomotive number, train number, departure station, arrival station, departure time, arrival time, parking time at the departure station and parking time at the arrival station.

4. The locomotive section operation data analysis system according to claim 3, characterized in that: The analysis dimension table includes a segment dimension table, a departure time dimension table, a crew route dimension table, a vehicle type dimension table and a station dimension table.

5. The locomotive section operation data analysis system according to claim 4, characterized in that: The segment dimension table includes the segment key value, segment code and segment name; the departure time dimension table includes the departure time key value, year, month, day and hour; the crew route dimension table includes the crew route key value, crew route code and crew route name; the vehicle type dimension table includes the vehicle type key value, vehicle type code and vehicle type name; the station dimension table includes the station key value, station code and station name.

6. An analysis method based on the locomotive section operation data analysis system according to claim 5, characterized in that: The analytical method comprises the following steps: 1) Collect all locomotive interval operation data of each railway section and store them in the data source information module; 2) Establish locomotive interval operation standard time database, locomotive interval operation entity information, locomotive interval operation fact table and analysis dimension table according to user needs; extract locomotive interval operation standard data and locomotive interval operation real-time data required by the user from the data source information module and fill them into the corresponding locomotive interval operation standard time database and locomotive interval operation entity information respectively; 3) According to the extracted locomotive interval operation real-time data, the analysis dimension table is updated to obtain the analysis dimension model; the locomotive interval operation real-time data is matched with the locomotive interval operation standard data, the locomotive interval operation parameter data is calculated, the real-time data and the calculated locomotive interval operation parameter data are updated to the locomotive interval operation fact table to obtain the locomotive interval operation fact model, and the data analysis model is obtained by constructing the analysis dimension model and the locomotive interval operation fact model; 4) According to the user's analysis needs, the data information to be analyzed is extracted from the data analysis model, and the locomotive section operation data is analyzed to obtain the locomotive section operation status; The specific process of step 3) is: 3.1) De-duplicate the locomotive interval operation real-time data extracted in step 2) according to the start time, locomotive model, locomotive number and train number, and update the analysis dimension table according to the de-duplicate locomotive interval operation real-time data; 3.2) matching the locomotive interval operation real-time data after deduplication in step 3.1) with the locomotive interval operation standard data extracted in step 2) according to the route number, departure station, and arrival station, and obtaining the interval distance, additional start time, additional stop time, and standard operation time information respectively; 3.3) Calculating the interval operation time, technical speed and early and late time based on the real-time data of locomotive interval operation after deduplication in step 3.1) and the interval distance, additional start time, additional stop time and standard operation time information obtained in step 3.2) to obtain the interval operation time, technical speed and early and late time; 3.4) updating and storing the locomotive interval operation real-time data after deduplication in step 3.1) and the interval operation time, technical speed and early and late time calculated in step 3.3) in the locomotive interval operation fact table; 3.5) Combining the analysis dimension table updated in step 3.1) and the locomotive section operation fact table updated in step 3.4), a data analysis model is constructed; The calculation formulas for interval running time, technical speed and early and late time in step 3.3) are respectively: The interval running time = arrival time - departure time; The technical speed = interval distance / (arrival time - departure time); The time of early or late departure = arrival time - departure time - additional time for departure - additional time for parking - standard running time; if the parking time at the departure station > 0 and the parking time at the arrival station > 0; The time of early or late departure = arrival time - departure time - additional time for departure - standard running time; if the parking time at the departure station > 0 and the parking time at the arrival station = 0; The time of early or late departure = arrival time - departure time - additional parking time - standard running time; if the parking time at the departure station = 0 and the parking time at the arrival station > 0; The early and late time = arrival time - departure time - standard running time; if the parking time at the departure station = 0 and the parking time at the arrival station = 0.

Images