Checking system for train control engineering data table and message data

Abstract

The invention belongs to the technical field of data management, and provides a train control engineering data table and message data-oriented checking system, which comprises a data uploading subsystem used for uploading a train control engineering data table and message data; the task creating subsystem is used for creating a task based on the train control engineering data table to obtain a first checking task and creating a task based on the train control engineering data table and the message data to obtain a second checking task; the data checking subsystem is used for carrying out data checking based on the first checking task to obtain a first checking result and carrying out data checking based on the second checking task to obtain a second checking result; and the result display subsystem is used for displaying the first checking result and the second checking result. According to the method, the labor cost and the time cost are effectively reduced, the data checking efficiency and the data checking accuracy are improved, and the safety is effectively guaranteed.

Description

Technical Field

[0001] The present invention belongs to the technical field of data management, and in particular relates to a verification system for train control engineering data tables and message data. Background Art

[0002] Currently, the manual verification of train control engineering data tables and message data by verification personnel has the following main shortcomings:

[0003] 1. Data verification accuracy is not high: In the current data verification process, all data are manually verified, resulting in low data accuracy and unsafe security.

[0004] 2. Low efficiency and high cost: The verification of train control engineering data tables and train control message data is mainly completed manually. During the verification, not only does the verification personnel need to be very familiar with the verification process, but also the verification personnel's concentration and ability to handle details are very high. This invisibly increases the verification personnel's working hours and work pressure, resulting in low production efficiency and extremely high labor costs.

[0005] 3. The existing message verification method cannot provide graphical verification results and is less intuitive.

[0006] Today, the Industrial Internet is a key competitive advantage in the future of manufacturing and a crucial component for companies applying advanced technologies to the industry. To build a leading railway industry and ensure the security of its supply chain, leveraging information technology to enhance the informatization of systems and platforms, and thereby improve the overall competitiveness of products, is a crucial challenge facing many in the railway industry. Therefore, the integration of train control engineering data tables and message data verification with computer control technology offers a fresh perspective on the railway signaling product business. Summary of the Invention

[0007] The present invention proposes a verification system for train control engineering data tables and message data, the system comprising:

[0008] Data upload subsystem, used to upload train control engineering data tables and message data;

[0009] a task creation subsystem, configured to create a task based on the train control engineering data table to obtain a first verification task, and to create a task based on the train control engineering data table and the message data to obtain a second verification task;

[0010] a data verification subsystem, configured to perform data verification based on the first verification task to obtain a first verification result, and to perform data verification based on the second verification task to obtain a second verification result;

[0011] The result display subsystem is used to display the first verification result and the second verification result.

[0012] Furthermore,

[0013] The data upload subsystem is used to upload multiple train control engineering data tables of different dimensions, and is also used to upload multiple message data of different dimensions, where the dimensions include: line, version and type.

[0014] Furthermore,

[0015] The task creation subsystem includes a first verification task creation module;

[0016] The first verification task creation module is used to select a specified line and a type of train control engineering data table with old and new versions from the multiple train control engineering data tables of different dimensions, create a multi-version train control engineering data table consistency verification task, and record the multi-version train control engineering data table consistency verification task as the first verification task.

[0017] Furthermore,

[0018] The first verification task creation module is further used to designate one or more columns from the multiple columns of the train control engineering data table as key columns.

[0019] Furthermore,

[0020] The task creation subsystem also includes a second verification task creation module;

[0021] The second verification task creation module is used to select a type of train control engineering data table of a specified line and a certain version from the multiple train control engineering data tables of different dimensions, select a piece of message data from the multiple pieces of message data of different dimensions, create a single-version train control engineering data table and message data consistency verification task, and record the single-version train control engineering data table and message data consistency verification task as the second verification task;

[0022] The message data corresponds to a type of train control engineering data table of a specified line and a specified version.

[0023] Furthermore,

[0024] The second verification task creation module is further used to draw a first simple line diagram based on the message data, and to draw a second simple line diagram based on a specified line and a specified version of a type of train control engineering data table.

[0025] Furthermore,

[0026] The data verification subsystem includes a first data verification module;

[0027] The first data verification module is used to verify the data of each row in the new and old versions of the train control engineering data table of the specified line based on the key columns.

[0028] For a row:

[0029] When the data in the key column and the data in the non-key column are consistent, the data in the row is determined to be consistent, and the verification result of the row is recorded as the first verification result of the row;

[0030] When the data in the key columns are consistent and the data in the non-key columns are not completely consistent, the data in the row is determined to be inconsistent, and the verification result of the row is recorded as the second verification result of the row;

[0031] When the data in the key columns are inconsistent, regardless of whether the data in the non-key columns are consistent, the data in the row is determined to be inconsistent, and the verification result of the row in the new version is recorded as the third verification result of the row, and the verification result of the row in the old version is recorded as the fourth verification result of the row;

[0032] The first verification result of a certain row, the second verification result of a certain row, the third verification result of a certain row, and the fourth verification result of a certain row are collectively defined as the first verification result.

[0033] Furthermore,

[0034] The data verification subsystem further includes a second data verification module;

[0035] The second data verification module provides an engineering data layer overlay function, and the second verification task is imported through the engineering data layer overlay function, and the first simple circuit diagram and the second simple circuit diagram are verified, and the parts that are consistent in the verification, the parts that are inconsistent in the verification, and the parts that are not overlapped are recorded. The parts that are consistent in the verification, the parts that are inconsistent in the verification, and the parts that are not overlapped are uniformly defined as the second verification result.

[0036] Furthermore,

[0037] The result display subsystem includes a first verification result display module;

[0038] The first verification result display module is used to use different predetermined colors to mark the first verification result of a certain row, the second verification result of a certain row, the third verification result of a certain row and the fourth verification result of a certain row respectively, obtain a first marking result, and display the first marking result on the visualization page.

[0039] Furthermore,

[0040] The result display subsystem also includes a second verification result display module;

[0041] The second verification result display module is used to use different predetermined colors to mark the parts that are consistent with the verification, the parts that are consistent with the verification, and the parts that are not overlapped with the verification, respectively, to obtain a second marking result, and display the second marking result on the visualization page.

[0042] Furthermore,

[0043] The second verification result display module is further configured to display a name corresponding to the first simple circuit diagram and a name corresponding to the second simple circuit diagram.

[0044] Compared with the prior art, the present invention has the following beneficial effects:

[0045] By studying the verification process of train control engineering data tables and message data, the present invention introduces the outstanding advantages of automation technology widely used in industrial production and Internet technology into the high-speed rail signal product verification business, thereby realizing the automated verification of train control engineering data tables and message data.

[0046] Visual data verification provides a more convenient and standardized verification method, reducing the workload of verifiers. It also intuitively displays data verification results, making it easier for verifiers to identify problems. This invention effectively reduces both labor and time costs, improves data verification efficiency and accuracy, and effectively ensures security. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the following is a brief introduction to the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0048] Figure 1 This is a schematic diagram of the structure of the verification system for train control engineering data tables and message data of the present invention;

[0049] Figure 2 Schematic diagram of the first and second simplified circuit patterns of the present invention;

[0050] Figure 3 This is a schematic representation of the slope of the line of the present invention;

[0051] Figure 4 This is a schematic diagram of the first verification result display page of the present invention;

[0052] Figure 5This is a schematic diagram of the second verification result display page of the present invention;

[0053] Description of reference numerals:

[0054] 10-Data upload subsystem, 20-Task creation subsystem, 30-Data verification subsystem, 40-Result display subsystem. DETAILED DESCRIPTION

[0055] To make the objectives, technical solutions, and advantages of the embodiments of the present invention more clear, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without making creative efforts shall fall within the scope of protection of the present invention.

[0056] Figure 1 It is a structural diagram of a verification system for train control engineering data tables and message data provided by an embodiment of the present invention.

[0057] like Figure 1 As shown, the verification system for train control engineering data tables and message data includes: a data uploading subsystem 10, a task creation subsystem 20, a data verification subsystem 30 and a result display subsystem 40.

[0058] 1. The data upload subsystem 10 is used to upload train control engineering data tables and message data.

[0059] During the actual engineering operation process, multiple train control engineering data tables will be generated. These multiple train control engineering data tables are divided according to the three dimensions of type, line, and version, resulting in multiple train control engineering data tables of different dimensions. The types include: station information table, signal data table, turnout information table, route information table, etc.

[0060] The data upload subsystem 10 is used to upload multiple train control engineering data tables of different dimensions and store the uploaded multiple train control engineering data tables of different dimensions. For example, it supports uploading and storing the 1.0 version of the switch information table of a specified line.

[0061] The data upload subsystem 10 is also used to upload multiple copies of message data of different dimensions and store the uploaded multiple copies of message data of different dimensions. The message data includes: balise messages, TCC messages, and LEU messages. Balise messages, TCC messages, and LEU messages are all generated using the train control engineering data table.

[0062] 2. The task creation subsystem 20 is used to create a task based on the train control engineering data table to obtain a first verification task, and to create a task based on the train control engineering data table and message data to obtain a second verification task.

[0063] The task creation subsystem 20 includes a first verification task creation module 201 and a second verification task creation module 202 .

[0064] 1. First verification task creation module 201.

[0065] This function is used to create a multi-version train control engineering data table consistency check task by selecting a specified line and two versions of a train control engineering data table from multiple train control engineering data tables of different dimensions. The multi-version train control engineering data table consistency check task is defined as the first check task.

[0066] The one with the earlier date is the old version, and the one with the later date is the new version. Both the old and new versions of the train control engineering data table contain multiple columns, and the number and attributes of the columns in each version are consistent. For example, the new version of the train control engineering data table contains 3 columns, and the attributes of the 3 columns are A, B, and C respectively. The old version of the train control engineering data table also contains 3 columns, and the attributes of the 3 columns are also A, B, and C respectively. When creating a consistency check task for multi-version train control engineering data tables, you can specify one or more columns among multiple columns as key columns, and other columns except key columns as non-key columns. For example, specify the "Station Name" column or the "Switch Number" column as the key column, or specify the "Station Name" column and the "Switch Number" column as key columns.

[0067] 2. The second verification task creation module 202.

[0068] It is used to select a specified line and version of a type of train control engineering data table from multiple train control engineering data tables of different dimensions, and select a piece of message data corresponding to the train control engineering data table from multiple message data of different dimensions to create a single-version train control engineering data table and message data consistency verification task. The single-version train control engineering data table and message data consistency verification task is defined as the second verification task.

[0069] It is also used to parse the selected train control engineering data table and message data and draw simple line diagrams respectively. The specific drawing process is described below.

[0070] 1) Parse the message data and draw a first simple circuit diagram.

[0071] The system supports parsing and drawing first simplified line diagrams for message data packets such as ETCS-27, ETCS-21, CTCS-1, ETCS-5, ETCS-68, and ECTS-72. The first simplified line diagrams drawn using different message data packets may have different shapes, including rectangles, line segments, signal lights, transponders, and insulation joints. However, the process (or drawing steps) for drawing the first simplified line diagram using different message data packets is the same. The following describes the drawing process for the first simplified line diagram using the ETCS-21 packet as an example.

[0072] The ETCS-21 package refers to the line slope package, which reflects the slope data change information at a certain distance ahead of the line.

[0073] like Figure 2 As shown, the second verification task creation module 202 is used to draw a route in each rectangular grid based on the slope characteristics of the route in different running directions and based on multiple rectangular grids.

[0074] Regarding the slope characteristics of the line in different running directions: when the balise is on the downline and the message is forward (i.e., the message generated when the train travels in the forward direction on the downline is forward), the slope characteristics of the line in different running directions are defined as "downline forward simplified slope"; when the balise is on the downline and the message is reverse (i.e., the message generated when the train travels in the reverse direction on the downline is reverse), the slope characteristics of the line in different running directions are defined as "downline reverse simplified slope"; when the balise is on the upline and the message is forward (i.e., the message generated when the train travels in the forward direction on the upline is forward), the slope characteristics of the line in different running directions are defined as "upline forward simplified slope"; when the balise is on the upline and the message is reverse (i.e., the message generated when the train travels in the reverse direction on the upline is reverse), the slope characteristics of the line in different running directions are defined as "upline reverse simplified slope". This example draws a line based on a scenario where the transponder is on the downlink and the message is in the forward direction (i.e., the downlink has a forward simplified slope).

[0075] The solid line in the rectangle represents the route; the value above the solid line represents the slope of the route (the "route slope" is referred to as "slope" for short). A positive slope indicates an uphill slope, a negative slope indicates a downhill slope, and a slope of 0 indicates a flat slope; the value below the solid line represents the length of the route (the "route length" is referred to as "length" for short); the value in the lower right corner of each rectangle represents the balise kilometer mark and the distance from the balise kilometer mark to the next slope change point. The balise kilometer mark and the distance from the balise kilometer mark to the next slope change point are uniformly defined as "slope change point mileage".

[0076] A plurality of rectangles, a solid line in each rectangle, values above and below each solid line, and a value at the lower right corner of each rectangle constitute a first simple circuit graph.

[0077] 2) Analyze the train control engineering data table and draw the second simple circuit diagram.

[0078] The second verification task creation module 202 is also used to select the corresponding train control engineering data table according to the type of message data packet. If the train control engineering data table includes a sub-table, it supports selecting the data in the sub-table, and parsing the data in the sub-table and drawing a simple line diagram to obtain a second simple line diagram; if the train control engineering data table does not include a sub-table, it supports selecting the data in the train control engineering data table, and parsing the data in the train control engineering data table and drawing a simple line diagram to obtain a second simple line diagram.

[0079] Regardless of selecting data from the subtable or from the train control engineering data table, the second verification task creation module 202 supports selecting the data required to generate the second simple line diagram based on the data attributes and data range of the data associated with the message data packet in the train control engineering data table.

[0080] Since the previous steps have introduced the process of drawing the first simple line diagram using the ETCS-21 package (line slope package) as an example, the line slope table in the train control engineering data table is selected accordingly, and the process of drawing the second simple line diagram is introduced using the line slope table as an example.

[0081] like Figure 3 As shown, the line slope table includes multiple sub-tables, namely: up line table, down line table, down line forward (take integration and merge) table, down line reverse (take integration and merge) table, up line forward (take integration and merge) table and up line reverse (take integration and merge) table.

[0082] Since the first simplified route diagram is drawn based on the scenario where the balise is on the downlink and the message is in the forward direction (i.e., the simplified slope in the forward direction of the downlink), the second simplified route diagram must be drawn based on the forward (integrated) table of the downlink. When drawing, the "slope change point mileage" data associated with the ETCS-21 package is first found in the forward (integrated) table of the downlink. The data range of the slope change point mileage in the ETCS-21 package is then obtained. The data range of the slope change point mileage includes: HNYJK6+776, HNYJK8+126, HNYJK9+376, and HNYJK10+626. Based on the data range of the slope change point mileage, the slope and length corresponding to this data range are selected from the forward (integrated) table of the downlink. Finally, the slope change point mileage, the selected slope and length, and the simplified route diagram are drawn, resulting in the second simplified route diagram.

[0083] The shape of the second simplified circuit pattern is identical to that of the first simplified circuit pattern.

[0084] 3. The data verification subsystem 30 is used to perform data verification based on the first verification task to obtain a first verification result, and to perform data verification based on the second verification task to obtain a second verification result.

[0085] The data checking subsystem 30 includes a first data checking module 301 and a second data checking module 302 .

[0086] 1. First data verification module 301.

[0087] The first data verification module 301 is used to verify the data in the new and old versions of the train control engineering data table of a specified line, row by row, based on the key columns in the first verification task. For a certain row: when the data in the key columns are consistent and the data in the non-key columns are completely consistent, the data in the certain row is determined to be consistent, and the verification result of the certain row is recorded as the first verification result of the certain row; when the data in the key columns are consistent and the data in the non-key columns are not completely consistent, the data in the certain row is determined to be inconsistent, and the verification result of the certain row is recorded as the second verification result of the certain row; when the data in the key columns are inconsistent, regardless of whether the data in the non-key columns are consistent, the data in the certain row is determined to be inconsistent, and the verification result of the certain row in the new version is recorded as the third verification result of the certain row, and the verification result of the certain row in the old version is recorded as the fourth verification result of the certain row. The first verification result of a certain row, the second verification result of a certain row, the third verification result of a certain row, and the fourth verification result of a certain row are collectively defined as the first verification result, and the first verification result is stored.

[0088] Preferably, the first check result of a row is "same", the second check result of a row is "modified", the third check result of a row is "added", and the fourth check result of a row is "deleted".

[0089] 2. Second data verification module 302.

[0090] The second data verification module 302 provides an engineering data layer overlay function, which imports the second verification task, overlaps the first simple line diagram and the second simple line diagram for verification, and records the parts that are consistent with the verification, the parts that are inconsistent with the verification, and the parts that are not overlapped and verified. The parts that are consistent with the verification, the parts that are inconsistent with the verification, and the parts that are not overlapped and verified are uniformly defined as the second verification results.

[0091] By checking the graphics, the consistency check of the single version train control engineering data and message data is completed.

[0092] 4. The result display subsystem 40 is used to display the first calibration result and the second calibration result.

[0093] The result display subsystem 40 includes a first verification result display module 401 and a second verification result display module 402 .

[0094] 1. First verification result display module 401.

[0095] like Figure 4 As shown, the first verification result display module 401 is used to display the first verification result on a visualization page. During the display, each row of the verification result in the first verification result is marked with a different color. The row recording the first verification result of a row is marked with a first predetermined color, the row recording the second verification result of a row is marked with a second predetermined color, the row recording the third verification result of a row is marked with a third predetermined color, and the row recording the fourth verification result of a row is marked with a fourth predetermined color. The first predetermined color, the second predetermined color, the third predetermined color, and the fourth predetermined color are collectively defined as the first marking result.

[0096] 2. Second verification result display module 402.

[0097] The second verification result display module 402 is used to display the second verification result on a visualization page. During the display, the inconsistent parts are marked with the fifth predetermined color, the consistent parts are marked with the sixth predetermined color, and the parts that have not undergone overlap verification are marked with the seventh predetermined color. The fifth predetermined color, the sixth predetermined color, and the seventh predetermined color are collectively defined as the second marking result.

[0098] Preferably, the fifth predetermined color is red, the sixth predetermined color is green, and the seventh predetermined color is blue.

[0099] like Figure 5 As shown, the fifth predetermined color represents the portion that is inconsistent with the verification, the sixth predetermined color represents the portion that is consistent with the verification, and the seventh predetermined color represents the portion that has not been overlapped.

[0100] In addition to displaying the second verification result, the second verification result display module 402 is also used to display the name corresponding to the first simple graphic and the name corresponding to the second simple graphic. The names corresponding to the first simple graphic and the second simple graphic are consistent and are specifically displayed on the side of the second verification result. The names corresponding to the first simple graphic generated based on different data packets are different. Correspondingly, the names corresponding to the second simple graphic generated based on different train control engineering data tables are also different. The following continues to use the ETCS-21 package and line grade table as examples to explain the name display scheme.

[0101] When displaying the name, the slope characteristics of the line in different directions of operation and the mileage of the slope change points are specifically shown. The slope characteristics of the line in different directions of operation vary depending on the specific drawing scenario. In this example, the first and second simplified line graphics are drawn based on the scenario where the transponder is on the downlink and the message is in the forward direction. Therefore, the slope characteristics of the line in different directions of operation are displayed as "downlink line forward simplified slope".

[0102] Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein; and these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A verification system for train control engineering data tables and message data, characterized by: include: Data upload subsystem, used to upload train control engineering data tables and message data; a task creation subsystem, configured to create a task based on the train control engineering data table to obtain a first verification task, and to create a task based on the train control engineering data table and the message data to obtain a second verification task; a data verification subsystem, configured to perform data verification based on the first verification task to obtain a first verification result, and to perform data verification based on the second verification task to obtain a second verification result; The result display subsystem is used to display the first verification result and the second verification result.

2. The system according to claim 1, wherein: The data upload subsystem is used to upload multiple train control engineering data tables of different dimensions, and is also used to upload multiple message data of different dimensions, where the dimensions include: line, version and type.

3. The system according to claim 2, characterized in that The task creation subsystem includes a first verification task creation module; The first verification task creation module is used to select a specified line and a type of train control engineering data table with old and new versions from the multiple train control engineering data tables of different dimensions, create a multi-version train control engineering data table consistency verification task, and define the multi-version train control engineering data table consistency verification task as the first verification task.

4. The system according to claim 3, characterized in that The first verification task creation module is further used to designate one or more columns from the multiple columns of the train control engineering data table as key columns, and other columns except the key columns as non-key columns.

5. The system according to claim 2, wherein: The task creation subsystem also includes a second verification task creation module; The second verification task creation module is used to select a type of train control engineering data table of a specified line and a specified version from the multiple train control engineering data tables of different dimensions, select a piece of message data from the multiple pieces of message data of different dimensions, create a single-version train control engineering data table and message data consistency verification task, and define the single-version train control engineering data table and message data consistency verification task as the second verification task; The message data corresponds to a type of train control engineering data table of a specified line and a specified version.

6. The system according to claim 5, characterized in that The second verification task creation module is further used to draw a first simple line diagram based on the message data, and to draw a second simple line diagram based on a specified line and a specified version of a type of train control engineering data table.

7. The system according to claim 4, wherein: The data verification subsystem includes a first data verification module; The first data verification module is used to verify the data of each row in the new and old versions of the train control engineering data table of the specified line based on the key columns. For a row: When the data in the key column and the data in the non-key column are consistent, the data in the row is determined to be consistent, and the verification result of the row is recorded as the first verification result of the row; When the data in the key columns are consistent and the data in the non-key columns are not completely consistent, the data in the row is determined to be inconsistent, and the verification result of the row is recorded as the second verification result of the row; When the data in the key columns are inconsistent, regardless of whether the data in the non-key columns are consistent, the data in the row is determined to be inconsistent, and the verification result of the row in the new version is recorded as the third verification result of the row, and the verification result of the row in the old version is recorded as the fourth verification result of the row; The first verification result of a certain row, the second verification result of a certain row, the third verification result of a certain row, and the fourth verification result of a certain row are collectively defined as the first verification result.

8. The system according to claim 6, characterized in that The data verification subsystem further includes a second data verification module; The second data verification module provides an engineering data layer overlay function, and the second verification task is imported through the engineering data layer overlay function, and the first simple circuit diagram and the second simple circuit diagram are verified, and the parts that are consistent in the verification, the parts that are inconsistent in the verification, and the parts that are not overlapped are recorded. The parts that are consistent in the verification, the parts that are inconsistent in the verification, and the parts that are not overlapped are uniformly defined as the second verification result.

9. The system according to claim 7, wherein: The result display subsystem includes a first verification result display module; The first verification result display module is used to use different predetermined colors to mark the first verification result of a certain row, the second verification result of a certain row, the third verification result of a certain row and the fourth verification result of a certain row respectively, obtain a first marking result, and display the first marking result on the visualization page.

10. The system according to claim 8, wherein: The result display subsystem also includes a second verification result display module; The second verification result display module is used to use different predetermined colors to mark the parts that are consistent with the verification, the parts that are consistent with the verification, and the parts that are not overlapped with the verification, respectively, to obtain a second marking result, and display the second marking result on the visualization page.

11. The system according to claim 10, wherein: The second verification result display module is further configured to display a name corresponding to the first simple circuit diagram and a name corresponding to the second simple circuit diagram.

Images