Method for checking LKJ basic data and train control basic data

Abstract

The invention aims to provide a method for checking LKJ basic data and train control basic data, which solves the problem of low manual checking efficiency due to multiple management contradictions caused by the same equipment and facility data, and comprises the following steps of: performing difference comparison of newly added and deleted data by taking a key field with an obvious identifier as a main key; and difference judgment is carried out according to the check code of the current comparison column with the same primary key, and difference comparison can be specifically carried out on the column. And after comparison checking is completed, outputting a checking difference summary result. According to the method, after data is imported, the line model is established according to the line number, the row type and the running direction, the front and side line signal machines are automatically obtained, the manual maintenance workload of basic data information is effectively reduced, and the working efficiency is improved. The train control data main line annunciator table is all listed according to track circuit sections, screening is carried out according to signal point types when data are imported, the distance between effective annunciators can be calculated, and therefore the accuracy of data checking is improved.

Description

TECHNICAL FIELD

[0001] The present application relates to train data processing, in particular to a method for checking LKJ basic data and train control basic data. BACKGROUND

[0002] LKJ (Train Operation Monitoring System) is a train operation safety monitoring device for general speed railway and part of early EMU. LKJ basic data refers to the basic line data of devices and facilities such as line, signal, catenary and station yard in the train working diagram technical data of railway bureau group company, as well as the basic operation organization data such as station departure and arrival track, opening car against distance special place, locomotive (EMU) section.

[0003] Train control basic data refers to the collection of line parameters, device status, operation permission and dynamic instructions related to train operation control, covering the whole process of data interaction from ground equipment to on-board equipment.

[0004] LKJ basic data is managed and applied according to "Train Operation Monitoring Device (LKJ) Operation Maintenance Management Method", and train control data is managed and applied according to "Train Control Data Management Method". Although there is an overlapping part of data on the railway line, they are independent of each other, forming a phenomenon of multi-head management of common data in the overlapping part. In practice, the attributes of the same device and facility data differ in different systems.

[0005] The multi-head management contradiction caused by the same device and facility data has the problem of low efficiency of manual checking. The existing technology relies on manual comparison of Excel tables, which is time-consuming and prone to errors, and cannot meet the real-time checking needs of large-scale data. Moreover, train control data lacks key line information (such as line number and line type), which needs to be supplemented by LKJ data, increasing the complexity of data correlation. In addition, the existing technology can only identify the existence of differences in data, but cannot locate the specific difference column (such as mileage deviation and speed limit value conflict), making it difficult to directly locate and compare data. SUMMARY

[0006] In view of the above problems, the purpose of the present application is to provide a method for checking LKJ basic data and train control basic data, which solves the problem of low efficiency of manual checking caused by multi-head management contradiction of the same device and facility data.

[0007] The technical scheme is to include LKJ basic data table and train control basic data table: STP1. For the LKJ basic data table structure data, regular expression is used to identify speed limit type information, and the main line signal data and side line signal data are split; STP2. For the train control basic data table, construct a line model by object modeling technology, and dynamically calculate the signal spacing according to the track circuit section; STP3. Define the joint primary key of the LKJ basic data and the train control basic data, and associate the LKJ basic data table and the train control basic data table; STP4. For the data with the same primary key, calculate the check code of the check column, and mark it as "modified" if the check code is inconsistent; for the data with the primary key not matching, classify it as "added" or "deleted"; for the continuous data, split it into "upstream" and "downstream" independent items according to the line type; STP5. The line allowable speed table in the LKJ basic data table and the train control basic data table is dynamically split into reference speed limit sections according to the section speed limit.

[0008] In the above or some embodiments, the LKJ basic data table includes a line allowable speed table and a signal distribution table, and regular expression is used to identify speed limit type information including line speed limit information and section speed limit information.

[0009] In the above or some embodiments, when performing the step STP2 operation, the train control basic data table can supplement the missing line information as needed, including but not limited to line number or line type information.

[0010] In the above or some embodiments, the LKJ basic data table and the train control basic data table use line number information + line type information + device unique identification information as the joint primary key to associate the LKJ basic data table and the train control basic data table.

[0011] In the above or some embodiments, the data comparison content of the LKJ basic data table and the train control basic data table includes ramp table data, bridge and tunnel table data, line allowable speed table data, signal and track circuit distribution table data, main line signal data, and transponder data comparison.

[0012] The method takes key fields with obvious identification as the primary key to perform difference comparison of added and deleted data; for the data with the same primary key, difference judgment is performed according to the calculation of the check code of the current comparison column, and the difference comparison can be specific to the column. After the comparison and verification are completed, the summary result of the verification difference is output. After the data is imported, the line model is established according to the line number, line type and running direction, the main and side line signals are automatically obtained, the manual maintenance workload of the basic data is effectively reduced, and the work efficiency is improved. The train control data main line signal table lists all the track circuit sections, and the effective distance between the signals can be calculated by screening according to the signal point type when the data is imported, thereby improving the accuracy of data verification. BRIEF DESCRIPTION OF DRAWINGS

[0013] Figure 1is the structural schematic diagram of the present application. DETAILED DESCRIPTION

[0014] Embodiments of the present application are described in detail below with reference to examples shown in the attached drawings, wherein the same or similar reference numerals represent the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by reference to the drawings are exemplary and are intended to explain the present application, and cannot be understood as a limitation of the present application.

[0015] In the description of the present application, the meaning of "a plurality of" is two or more, unless explicitly and specifically limited.

[0016] In the above or some embodiments, the present scheme can be implemented by relying on a computer, including an LKJ basic data and train control basic data checking system, including an LKJ basic data and train control basic data data import module, which realizes reading the LKJ basic data and train control basic data table structure from the file system.

[0017] The LKJ basic data mainly includes LKJ number-1 line name table, LKJ number-2 station name table, LKJ number-4 turnout table, LKJ number-5 line allowable speed table, LKJ number-6 ramp table, LKJ number-8 bridge table, LKJ number-9 tunnel table, LKJ number-11 line mileage chain break detail table, LKJ number-12 main line start and end mileage table, LKJ number-14 signal machine and track circuit distribution table, LKJ number-19 inter-level conversion table, and LKJ number-34 catenary data phase separation table.

[0018] The train control basic data table mainly includes train control data-1 station table, train control data-2 turnout table, train control data-3 line allowable speed table, train control data-4 gradient table, train control data-5 bridge table, train control data-6 tunnel table, train control data-7 line mileage chain break detail table, train control data-9 main line start and end mileage table, train control data-10 main line signal data table, train control data-12 catenary phase separation data table, and train control data transponder position table.

[0019] Before data import, the basic data import local data corresponding text relationship needs to be configured, for example, the station name, station number, line name, and line number in the LKJ number-1 line name table are imported into the corresponding fields in the local database, and the first column in Excel needs to be configured to correspond to the corresponding field in the database.

[0020] For the LKJ basic data table, after import, the parsing module parses the LKJ basic data table (such as the line allowable speed table and the signal machine distribution table), and uses regular expression to identify the speed limit type (line speed limit, section speed limit), and split the main line and side line signal machine data.

[0021] For the control of the basic data table, due to the lack of line number, line name, line information, import can supplement the missing line information (line number, line), and through the object modeling technology to build the line model, according to the track circuit section dynamic calculation signal spacing.

[0022] The joint primary key is "line number + line + equipment unique identifier" (such as signal number, transponder number). The LKJ basic data table and the train control basic data table are associated. For the data with the same primary key, the check code of the check column (such as mileage, slope, speed limit value) is calculated. If the check code is inconsistent, it is marked as "modified". For data with unmatched primary keys, it is classified as "added" or "deleted".

[0023] For continuous data in the basic data, such as ramp table data and bridge table data, the data is split into "up" and "down" independent items according to the line, to ensure consistent comparison granularity. The line speed table is dynamically split into reference speed interval according to the section speed limit, for example: the speed limit interval of LKJ number-5 table is split into multiple sub-intervals to realize segment-by-segment comparison.

[0024] A difference summary table is generated for the compared data, including "added", "deleted", "modified" three types of results, supporting filtering by line, station, and equipment type. The difference detail table marks the specific difference column (such as mileage deviation ±5m, speed limit value conflict).

[0025] In the above or some embodiments, the LKJ number-5 line speed table in the LKJ basic data table is imported as an example. The LKJ number-5 line speed table contains four kinds of speed limits in the table, namely line speed limit, long-term slow section speed limit, track speed limit, and turnout speed limit. Track speed limit and turnout speed limit do not participate in the check, and line speed limit and long-term slow section speed limit need to be obtained from the imported data. The first six columns in the table, namely line name, line, speed section and start and end mileage, line speed limit, straight station turnout speed, and lateral station turnout speed, are line speed limit information, and the last four columns are long-term slow speed limit including section speed limit, track speed limit, and turnout speed limit. The processing steps in the import process are as follows: ①The first six columns of the table are automatically identified as line speed limit, and the last four columns are identified as the corresponding long-term slow speed limit of the line speed limit.

[0026] ② Long-term slow speed limit Long-term slow speed limit in long-term slow speed limit, which meets the mileage interval format XXX.XXX-XXX.XXX, is a long-term slow speed section limit. The stock limit contains XX station X, Y lane, and the turnout limit contains XX station X#, Y# turnout. Regular expressions ([K, k]? [-] {0,2} [0-9] + [A, a]? [\+, \.]? [0-9] * - {1,1} [K, k]? [-] {0,2} [0-9] + [A, a]? [\+, \.]? [0-9] *) are used to screen out long-term slow speed section limits.

[0027] ③ Different data tables are written according to different speed limit types. The mileage range of the line speed limit is obtained by regular expressions according to the "speed section and starting and ending mileage". The starting mileage and ending mileage of the line speed limit are obtained according to the mileage range format. The starting position and ending position of the section speed limit are obtained according to the section speed limit location.

[0028] In the above or some embodiments, the column control data-4 slope table import in the column control basic data table is taken as an example. The slope table data only has the ending mileage and length, and the starting mileage is marked in the first data note column. The processing steps are as follows: ① When importing, the starting mileage in the note column of the first record needs to be extracted. Since the slope data has continuity, the ending mileage of the current record is the starting mileage of the next record.

[0029] ② Since the slope data of the LKJ basic data is sorted in ascending order of mileage, when importing, the size of the starting mileage and the ending mileage needs to be adjusted, and the data of the same line needs to be kept continuous.

[0030] Data comparison process, in the above or some embodiments, the slope table data comparison logic is as follows: ① Since the slope table data has continuity, the slope table data needs to be sorted before data comparison. The slope table is sorted by line number, line type, and starting mileage in ascending order.

[0031] ② The primary key of the slope table is set as the line number, line type, and starting mileage. The slope mileage error range is set, that is, the absolute value of the difference between the starting mileage of the LKJ basic data and the column control basic data of the same line number and line type * 1000 is within the error range, which is determined as the same slope data. The default parameter is 2 meters.

[0032] ③ According to the primary key, if the primary keys are the same, the CRC32 check code of the comparison column is calculated, if the check code of the comparison column of the LKJ basic data and the column control basic data is the same, it is determined that the two data are the same, if they are not the same, it is determined whether the error of the start point mileage, the end point mileage and the slope length is within the set error range, if it is within the range, it is determined whether the other comparison column is the same, if it is not the same, it is determined that there is a difference, and the data column with the difference is recorded. If the other columns are the same, it is determined that the two records are the same. If the primary keys are not the same, if the primary key of the LKJ basic data does not exist in the primary key of the column control basic data, the data is deleted when the current data is determined, and a flag is recorded, if the primary key of the column control data does not exist in the primary key of the LKJ basic data, it is determined that the current record is new data, and a flag is recorded.

[0033] Data comparison process, in the above or some embodiments, bridge, tunnel data comparison logic: ① Since the LKJ basic data bridge, tunnel table contains data with row type equal to "up and down / double", and the row type in the column control data is "up / down", the data with row type "up and down, double, single" in the LKJ basic data needs to be split into two data with "row type = up" and "row type = down". Since the LKJ basic data only provides the center mileage and length, the start point mileage and the end point mileage need to be calculated according to the length and center mileage of the bridge and tunnel. Start point mileage = (center mileage * 1000 - length / 2) / 1000, with three decimal places, end point mileage = (start point mileage * 1000 + full length) / 1000, with three decimal places. The column control data only provides the start point mileage, the end point mileage and the length, and the center mileage needs to be calculated, center mileage = (start point mileage * 1000 + length / 2) * 1000, with three decimal places.

[0034] ② Set the primary key of the bridge, tunnel data table as line number, row type, center mileage. Set the error range of the center mileage of the same bridge, tunnel. That is, the absolute value of the center mileage of the LKJ basic data and the column control basic data of the same line number, row type is within the error range, then it is determined that the two records are the same bridge or tunnel. The default parameter is 50 meters. Set the error range of the start and end point mileage of the bridge, tunnel and the error range of the full length. The default parameter is 2 meters. For example, the bridge line number in the LKJ data is 3005, the row type is up, and the center mileage is 234.450. The bridge line number in the column control data is 3005, the row type is up, and the center mileage is 234.480. The center mileage error range of these two bridges is 30 meters, and the system determines that they are the same bridge, but the comparison error is greater than 2 meters, and the output difference result is that the center mileage of these two bridges is different.

[0035] ③ According to the primary key, if the primary keys are the same, the CRC32 check code of the comparison column is calculated, if the check code of the comparison column of the LKJ basic data and the column control basic data is the same, it is determined that the two data are the same, if not, whether the error of the starting point mileage, the ending point mileage and the total length is within the set error range, if the error of the three items is within the range, whether the other comparison columns are the same, if the error of one or several of the three items is not within the range or the other comparison columns are not the same, it is determined that there is a difference, and the data column with the difference is recorded. If the other columns are the same, it is determined that the two records are the same. If the primary keys are not the same, if the primary key of the LKJ basic data does not exist in the primary key of the column control basic data, the data is deleted when the current data is determined, and a flag is recorded, if the primary key of the column control data does not exist in the primary key of the LKJ basic data, it is determined that the current record is new data, and a flag is recorded.

[0036] The method takes the key field with obvious identification as the primary key, and performs difference comparison of new data and deleted data; according to the calculation of the check code of the current comparison column, the difference is determined when the primary keys are the same, and the difference comparison can be specific to the column. After the comparison and verification are completed, the verification difference summary result is output. After the data is imported, the line model is established according to the line number, the line type and the running direction, the positive side signal machine is automatically obtained, the workload of manual maintenance of basic data is effectively reduced, and the work efficiency is improved. The column control data positive signal machine table lists all the track circuit sections, in the imported data, the signal point type is screened, the distance between the effective signal machines can be calculated, and the accuracy of data verification is improved.

Claims

1. A method for verifying LKJ basic data and train control basic data, comprising an LKJ basic data table and a train control basic data table, characterized in that: STP1. For the LKJ basic data table structure data, use regular expressions to identify speed limit type information and split the mainline signal data and siding signal data; STP2. For the train control basic data table, construct a line model using object modeling technology and dynamically calculate signal spacing based on track circuit sections; STP3. Define the joint primary key of LKJ basic data and train control basic data, and associate the LKJ basic data table with the train control basic data table. STP4. For data with the same primary key, calculate the checksum of the verification column. If the checksums do not match, mark it as "Modified." For data with mismatched primary keys, classify it as "Added" or "Deleted." For continuous data, split it into independent entries for "Upward" and "Downward" rows. STP5. The line allowable speed table in the LKJ basic data table and the train control basic data table is dynamically divided into reference speed limit intervals according to the section speed limit.

2. A method for verifying LKJ basic data and train control basic data according to claim 1, characterized in that: The LKJ basic data table includes a line allowable speed table and a signal distribution table, and uses regular expressions to identify speed limit type information including line speed limit information and section speed limit information.

3. The method for verifying LKJ basic data and train control basic data according to claim 2, characterized in that: When the train control basic data table is operated in step STP2, the missing line information, including but not limited to line number or row information, can be supplemented in the train control basic data table as needed.

4. The method for verifying LKJ basic data and train control basic data according to claim 3, characterized in that: The LKJ basic data table and the train control basic data table use line number information + row information + equipment unique identification information as a joint primary key to associate the LKJ basic data table with the train control basic data table.

5. The method for verifying LKJ basic data and train control basic data according to claim 4, characterized in that: The data comparison content of the LKJ basic data table and the train control basic data table includes ramp table data, bridge and tunnel table data, line allowable speed table data, signal and track circuit distribution table data, main line signal data, and transponder data comparison.

Images