CN108170727A - A kind of automatic processing method and device for interlocking data - Google Patents
A kind of automatic processing method and device for interlocking data Download PDFInfo
- Publication number
- CN108170727A CN108170727A CN201711321510.9A CN201711321510A CN108170727A CN 108170727 A CN108170727 A CN 108170727A CN 201711321510 A CN201711321510 A CN 201711321510A CN 108170727 A CN108170727 A CN 108170727A
- Authority
- CN
- China
- Prior art keywords
- data
- interlocking
- target
- interlocking data
- configuration parameters
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 15
- 238000004458 analytical method Methods 0.000 claims abstract description 66
- 238000000034 method Methods 0.000 claims abstract description 62
- 238000012545 processing Methods 0.000 claims description 18
- 230000008569 process Effects 0.000 claims description 16
- 238000007405 data analysis Methods 0.000 abstract description 15
- 238000012360 testing method Methods 0.000 abstract description 10
- 230000007547 defect Effects 0.000 abstract description 9
- 238000010586 diagram Methods 0.000 description 7
- 230000008676 import Effects 0.000 description 6
- 238000004891 communication Methods 0.000 description 4
- 230000003993 interaction Effects 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000012216 screening Methods 0.000 description 2
- 238000012300 Sequence Analysis Methods 0.000 description 1
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000009432 framing Methods 0.000 description 1
- 238000004573 interface analysis Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 230000000717 retained effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/17—Details of further file system functions
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/11—File system administration, e.g. details of archiving or snapshots
- G06F16/116—Details of conversion of file system types or formats
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
- G06F16/168—Details of user interfaces specifically adapted to file systems, e.g. browsing and visualisation, 2d or 3d GUIs
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Debugging And Monitoring (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Embodiment of the invention discloses that a kind of automatic processing method and device for interlocking data, this method is classified data are interlocked according to data class, after sorted data configuration is configured parameter accordingly, is stored in presetting database.When user needs to inquire a certain interlocking data, only need the data class according to the interlocking data, coordinate specific inquiry instruction that can quickly navigate to the interlocking data, realize the automation of interlocking data analysis, improve the accuracy of analysis efficiency and analysis, it ensure that the normal operation with interlocking relevant other systems, improve the efficiency of operation of entire traffic system.This method avoid the defects of manual analysis, the staff for analysis interlocking data improves the efficiency solved the problems, such as, also improves the efficiency of whole system debugging, test.
Description
Technical Field
The embodiment of the invention relates to the technical field of traffic data management, in particular to an automatic processing method and device of interlocking data.
Background
The main function of the interlock is to ensure the correct logic relation between the route, the turnout and the signal machine, and the interlock realizes the processing of the interlock logic according to the interlock table. The interlocking table represents the main interlocking relationship of the station signal equipment, including almost all signal equipment data. In addition, the interlock interface is also complex and diverse, and needs to perform data interaction with a plurality of external devices. Various problems are inevitably encountered in the debugging and testing process of the interlocking system, and the only way to solve the problems is to check the cause of the problems according to the interlocking log data. However, the actual time generated by the interlocking problem has errors and the interlocking log data is large, so that an analyst cannot quickly position the interlocking log data, and needs a large amount of time to analyze the interlocking data so as to search the problem and position the problem. This method of manual analysis is time consuming, labor intensive, less accurate and very inefficient in dealing with problems. In view of the importance of the interlocking data analysis method, it is of great significance to research the automatic data analysis method and device and improve the problem solving efficiency.
The traditional analysis method of the interlocking data has the following defects: the data analysis process depends on manual analysis, errors are easy to occur during analysis due to human subjective factors or external factors, and problems cannot be found out and solved; because one frame of data is large and the format of the data frame is complex, byte-by-byte analysis is needed during manual analysis, data framing interception is needed, an analyst needs to be familiar with the data transmission format of the interlocking interface, and the requirement on the capability of the analyst is very high; the interlocked data logs are recorded once every period (300 milliseconds), the time when the problem occurs cannot be accurately positioned, and therefore the specific time when the problem occurs needs to be checked and analyzed manually, so that the data volume of manual analysis is very large, and manpower and time are greatly wasted; when the data is analyzed manually, errors are easy to generate due to the complex data, and the frame data has to be analyzed again, so that the time is greatly wasted, and the efficiency of processing and solving problems is very low; the traditional method for manually analyzing the interlocking data has very low efficiency, and the problem which needs to be solved urgently cannot be solved in time, so that the debugging and the testing of the interlocking and other systems are influenced.
In the process of implementing the embodiment of the invention, the inventor finds that the existing analysis of the interlocking data mainly depends on manual work, has low efficiency and is easy to make mistakes, the accuracy and the effectiveness of the analysis of the interlocking data cannot be ensured, and the low-efficiency management mode of the interlocking data may influence the operation of other systems related to interlocking.
Disclosure of Invention
The invention aims to solve the technical problem of how to solve the problems that the existing analysis of the interlocking data mainly depends on manpower, the efficiency is low, the error is easy to occur, the accuracy and the effectiveness of the analysis of the interlocking data cannot be ensured, and the operation of other systems related to interlocking can be influenced by the low-efficiency management mode of the interlocking data.
In view of the above technical problems, an embodiment of the present invention provides an automated processing method for interlocking data, including:
acquiring interlocking data generated in the operation process of an interlocking system, and classifying the interlocking data according to the preset data type; the data types comprise signal machine data, turnout data, relay data and route data;
setting configuration parameters of target interlocking data aiming at the target interlocking data corresponding to each data type; the configuration parameters comprise a log path, an interlocking number, a log version and an analysis format;
and importing the target interlocking data into a preset database according to the data type and the configuration parameters corresponding to the target interlocking data.
Optionally, the importing the target interlocking data into a preset database according to the data type and the configuration parameters corresponding to the target interlocking data includes:
analyzing the target interlocking data into a target csv file according to the configuration parameters, and importing the target csv file into a target storage position of the preset database according to a log path in the configuration parameters;
the target storage position is used for storing interlocking data with the same data type as the data type corresponding to the target interlocking data.
Optionally, the analyzing the target interlocking data into a target csv file according to the configuration parameters, and importing the target csv file into a target storage location of the preset database according to a log path in the configuration parameters includes:
analyzing the target interlocking data into the target csv file according to the configuration parameters, selecting the target storage position under a log path in the configuration parameters, setting and deleting original data stored in the target storage position, and importing the target csv file into the target storage position after deleting the original data;
or,
and analyzing the target interlocking data into the target csv file according to the configuration parameters, selecting the target storage position under a log path in the configuration parameters, setting and reserving original data stored in the target storage position, and importing the target csv file into the target storage position.
Optionally, if the target interlocking data is interlocking data continuously generated over time, a time interval during which no interlocking data is generated is recorded in the target interlocking data.
Optionally, in the target csv file, the target interlocking data are arranged according to a time sequence generated by the target interlocking data.
Optionally, the method further comprises:
after receiving an instruction of inquiring interlocking data of a preset data type, acquiring a storage position for storing the interlocking data of the preset data type from the preset database to obtain a storage position to be searched, searching first interlocking data corresponding to the preset data type from the storage position to be searched, and displaying the first interlocking data;
and if a query command which is input by a user and is queried according to the first interlocking data is received, acquiring second interlocking data corresponding to the query command from the first interlocking data, and displaying the second interlocking data.
Optionally, if a query command for querying according to the first interlocking data, which is input by a user, is received, acquiring second interlocking data corresponding to the query command from the first interlocking data, and displaying the second interlocking data, where the method includes:
displaying an input box for inputting the query command, and if the query command written by the user according to a preset language is received, acquiring an attribute field from the query command to serve as an attribute field to be queried;
acquiring interlocking data with the attribute field to be inquired as the second interlocking data from the first interlocking data, and displaying the second interlocking data;
the attribute field is a name corresponding to the data content of the interlocking data, and the preset language is sql.
Optionally, the method further comprises:
and displaying the attribute code corresponding to each attribute field when receiving an instruction of querying the attribute code corresponding to the attribute field input by the user, so that the user can write the query command according to the attribute code.
Optionally, the method further comprises:
if an instruction for displaying the interlocking data corresponding to the plurality of preset types at the same time is received, generating a window corresponding to each preset type, and displaying the interlocking data corresponding to each preset type through the window corresponding to each preset type.
In a second aspect, an embodiment of the present invention provides an apparatus for automatically processing interlocking data, including:
the acquisition module is used for acquiring interlocking data generated in the operation process of the interlocking system and classifying the interlocking data according to the preset data type; the data types comprise signal machine data, turnout data, relay data and route data;
the setting module is used for setting configuration parameters of the target interlocking data aiming at the target interlocking data corresponding to each data type; the configuration parameters comprise a log path, an interlocking number, a log version and an analysis format;
and the storage module is used for importing the target interlocking data into a preset database according to the data type corresponding to the target interlocking data and the configuration parameters.
The embodiment of the invention provides an automatic processing method and device of interlocking data. When a user needs to inquire certain interlocking data, the interlocking data can be quickly positioned by matching with a specific inquiry instruction according to the data type of the interlocking data, so that the automation of the analysis of the interlocking data is realized, the analysis efficiency and the analysis accuracy are improved, the normal operation of other systems related to interlocking is ensured, and the operation efficiency of the whole traffic system is improved. The method avoids the defect of manual analysis, improves the efficiency of solving problems for the staff analyzing the interlocking data, and also improves the efficiency of debugging and testing the whole system. Meanwhile, the automatic processing method of the interlocking data provided by the embodiment can continuously analyze the interlocking data for a long time, is used by different workers, and has universality and universality.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and those skilled in the art can also obtain other drawings according to the drawings without creative efforts.
FIG. 1 is a schematic flow diagram of a method for automated processing of interlocking data according to one embodiment of the present invention;
FIG. 2 is a schematic diagram of an interface for querying interlocking data according to data types of the interlocking data according to another embodiment of the present invention;
FIG. 3 is a schematic diagram of an interface for setting configuration parameters for interlocking data according to another embodiment of the present invention;
FIG. 4 is a schematic diagram of an interface for importing interlocking data into a database according to another embodiment of the invention;
FIG. 5 is a schematic diagram of an interface for providing a route status queried according to a query command according to another embodiment of the invention;
FIG. 6 is a schematic diagram of an interface for querying a state of a semaphore based on a query command according to another embodiment of the invention;
FIG. 7 is a flow diagram illustrating a more detailed method for automated processing of interlocking data according to one embodiment of the present invention;
fig. 8 is a flowchart of a more specific apparatus for automated processing of interlocking data according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Fig. 1 is a schematic flow chart of an automated processing method for providing interlocking data according to the embodiment, and referring to fig. 1, the method includes:
101: acquiring interlocking data generated in the operation process of an interlocking system, and classifying the interlocking data according to the preset data type; the data types comprise signal machine data, turnout data, relay data and route data;
102: setting configuration parameters of target interlocking data aiming at the target interlocking data corresponding to each data type; the configuration parameters comprise a log path, an interlocking number, a log version and an analysis format;
103: and importing the target interlocking data into a preset database according to the data type and the configuration parameters corresponding to the target interlocking data.
The method provided by the embodiment is executed by a device capable of executing the steps, such as a computer or a server. The method is mainly used for solving the problems of low efficiency and low accuracy of the existing interlocking data analysis by manpower.
The data type is used for dividing the interlocking data, and the staff can define the data type according to actual needs. For example, as shown in fig. 2, the data categories may include signal data (signal in fig. 2), switch data (switch log in fig. 2), relay data (not shown in fig. 2), route data (route log in fig. 2), and physical sections, logical sections, non-routes, PSD (Platform vehicles) status, car wash log, Ats2Ci commands (control center commands), local 2CI commands, CI2Ats command feedback, CI2 local command feedback, adjacent CI transmission, adjacent CI reception, CI2VOBC, VOBC2CI, ERROR _ CODE, general commands, and the like.
It should be noted that, in the operation process of the interlock system, the interlock data records the information of the interlock system at any time and stores the information in a txt format file, and one txt file stores all data interaction and device state information of the interlock system.
The setting of configuration parameters may be performed for each category of data before storing it in a preset database. Before target interlocking data corresponding to a certain data type is stored in a preset database, corresponding configuration parameters can be configured for the target interlocking data, so that the target interlocking data can be quickly analyzed through the configuration parameters and the data type, and the target interlocking data is stored in the preset database. For example, as shown in fig. 3, before the target interlocking data is imported into the preset database, a page as shown in fig. 3 is called out, through which a log path (filled in an input box on the left of the log path in fig. 3), an interlocking number, a log version, and a parsing format are filled in through a "configuration" key in fig. 3, and setting of configuration parameters of the target interlocking data is completed. After the configuration parameters are set, the equipment for storing the target interlocking data analyzes the target data according to the data type and the configuration parameters of the target interlocking data, and stores the target interlocking data into a preset database according to the data type.
The embodiment of the invention provides an automatic processing method of interlocking data, which classifies the interlocking data according to the data types, configures corresponding configuration parameters for the classified data, and stores the data into a preset database. When a user needs to inquire certain interlocking data, the interlocking data can be quickly positioned by matching with a specific inquiry instruction according to the data type of the interlocking data, so that the automation of the analysis of the interlocking data is realized, the analysis efficiency and the analysis accuracy are improved, the normal operation of other systems related to interlocking is ensured, and the operation efficiency of the whole traffic system is improved. The method avoids the defect of manual analysis, improves the efficiency of solving problems for the staff analyzing the interlocking data, and also improves the efficiency of debugging and testing the whole system. Meanwhile, the automatic processing method of the interlocking data provided by the embodiment can continuously analyze the interlocking data for a long time, is used by different workers, and has universality and universality.
Further, on the basis of the above embodiment, the importing, according to the data type and the configuration parameters corresponding to the target interlocking data, the target interlocking data into a preset database includes:
analyzing the target interlocking data into a target csv file according to the configuration parameters, and importing the target csv file into a target storage position of the preset database according to a log path in the configuration parameters;
the target storage position is used for storing interlocking data with the same data type as the data type corresponding to the target interlocking data.
The target storage location may be understood as a folder for storing the same data type as the data type corresponding to the target interlocking data. When configuring the configuration parameters of the target interlocking data, a target storage location may be selected under the target path to store the target interlocking data to the target storage location directly according to the selected target storage location.
For example, as shown in fig. 4, before the target interlocking data is imported into the preset database, in "database import" and "log selection", a storage location to be imported is selected (as determined by marking "pair number" before the storage location in fig. 4). It is understood that one storage location may be selected, or multiple storage locations may be selected, and that when multiple storage locations are selected, it is indicated that target interlock data needs to be imported at each storage location.
The embodiment of the invention provides an automatic processing method of interlocking data, which analyzes target interlocking data into a target csv file, has good compatibility and can adapt to different tool versions. According to the method, the target csv file is imported to the corresponding target storage position, so that the target interlocking data can be directly inquired and positioned according to the target storage position.
Further, on the basis of the foregoing embodiments, the parsing the target interlocking data into a target csv file according to the configuration parameter, and importing the target csv file into a target storage location of the preset database according to a log path in the configuration parameter includes:
analyzing the target interlocking data into the target csv file according to the configuration parameters, selecting the target storage position under a log path in the configuration parameters, setting and deleting original data stored in the target storage position, and importing the target csv file into the target storage position after deleting the original data;
or,
and analyzing the target interlocking data into the target csv file according to the configuration parameters, selecting the target storage position under a log path in the configuration parameters, setting and reserving original data stored in the target storage position, and importing the target csv file into the target storage position.
As shown in fig. 4, the original data may be deleted or retained before the target interlocking data is imported into the preset database. If the left mark of the original data is deleted, the original data in the preset storage position is deleted before the target csv file is imported into the preset storage position (the method prevents the original data from influencing the analysis result at this time too much), otherwise, the original data is reserved, and the target csv file is imported into the preset storage position (the method supports the mode that other types of data are selected to be imported again without influencing the imported data).
The embodiment of the invention provides an automatic processing method of interlocking data, which provides two storage methods for deleting or reserving original data before target interlocking data are imported into a preset database, so that a user can flexibly select the interlocking data according to actual needs, and the method is good in applicability.
Specifically, for realizing the analysis of the interlocking data, a corresponding csv format table needs to be created according to data classification, the interlocking data is analyzed according to configured parameters, and the interlocking data is written into the corresponding table. The configured parameters comprise a log path, an interlocking number, a log version and the like; the data classification comprises signal machine data, turnout data, relay data, access data, physical section data and the like, in each table, the data are sorted according to time and period, and data frames are stored in a segmented mode according to columns. As shown in fig. 3, a button of "log path" is used to select a log folder of interlocking data (target interlocking data) to be parsed, which is generated and stored in a txt format file.
The "interlock number" indicates the number of the concentrated region of the interlock system to which the interlock data file belongs, and a plurality of concentrated regions are provided for one line, and data in each concentrated region can be analyzed and processed.
The log version represents a tool version used for analyzing the current interlocking data (target interlocking data), namely a version for analyzing a data format, the interlocking is changed with other system interfaces, and the corresponding log version needs to be upgraded to adapt to the change generated by the interlocking data frame format so as to be analyzed correctly. For example, the data versions of the bird's house line and the interconnecting line are different.
"configuration" indicates the current way in which the interlocks interface with the VOBC. For example, in a swallow room line and an interconnection line, since the interlock does not correspond to VOBC interface data, the format for parsing VOBC data is different.
The 'analysis' button realizes that all txt format log files in the selected folder (target storage position) are classified and written into the csv format table file according to the configured parameters, namely the interlock number, the log version and the configuration. The interlocking system has different data formats according to different line requirements, and the data format corresponding to the interlocking system is selected in the log version so as to correctly analyze the data format.
By clicking an analysis button, popping up an analysis process mark scroll bar, reading configured information (configuration parameters), preliminarily analyzing interlocking data (target interlocking data), and indicating that the analysis of the data is finished when the analysis scroll bar is finished.
As shown in fig. 3, for example, all log files in the log directory are parsed, the log files are data in the swallow room concentration area 1, and the format of the interlocking data interface is latest; the input interlocking number is 1, the log version input is more than or equal to the latest version 7.1, the input is 8.0, the current data is the swallow room data, so that the interface with the VOBC belongs to the swallow room, the default is the swallow room, and the configuration of the data parameters is completed.
Next, to explain the meaning of each piece of data and graphically display, the contents in the above csv table are written into each table (each storage location) of the database. Each table in a database (preset database) corresponds to a csv table (csv file), the head of each table shows the meaning of each row of data, and the database import is executed, namely, the contents in the csv table are written into each table of the database according to columns. When the database import operation is executed, the type of the interlocking data to be imported can be manually selected, and all the interlocking data can be selected for importing.
As shown in FIG. 4, the "delete original data" (i.e. delete original data) option is selectable, and indicates whether to perform an import operation of data after deleting all data of the database. For example, when a file is re-analyzed, the item is selected to empty all data in the database, so that the previous old data is prevented from influencing the analysis result; the item is not selected, so that when the type of the imported data is selected and selected, the method can support the selection of other types of data to be imported again without influencing the data imported before.
And the 'execution' button realizes that the selected type of csv data (csv file) is written into a corresponding table of the database, the scroll bar in the importing process stops explaining that the importing data is finished, and the guide frame is closed. As shown in fig. 4, in order to delete original data in the database, new route logs, traffic signal logs, physical section logs, and ERROR _ CODE (ERROR CODE data) are introduced at the same time.
The automatic processing method of the interlocking data provided by the embodiment brings great convenience to the interlocking debugging and problem analysis, and various abnormal phenomena and problems which occur in the process of debugging the interlocking and other system equipment and in the process of testing can be analyzed by the device to determine the reason of the problems, so that various problems are solved. Meanwhile, the device can synchronously update the analysis method according to the interface data between the interlocks, is simple and easy to learn, is very convenient to use, and reduces the requirement on the capability of an analyst.
Further, in each of the above embodiments, if the target interlock data is interlock data that is continuously generated over time, a time interval during which no interlock data is generated is recorded in the target interlock data.
Further, on the basis of the foregoing embodiments, in the target csv file, the target interlocking data are arranged in the chronological order of generation of the target interlocking data.
Note that "time intervals at which interlock data is not generated" are recorded, "that is," intermittent analysis "and" intermittent setting ". The interlocking inputs, processes and outputs data every period, and the interlocking data is sorted according to the period number. "analysis of broken sequences" and "setting of broken sequences" are mainly to analyze the case where the communication of interlocks with the VOBC is interrupted. If the interlock and the VOBC do not carry out data interaction for 8 continuous periods, the interlock and the VOBC are indicated to be interrupted in communication. The 'popped-up sequence interruption interval frame' can be filled with 8 in the sequence interruption setting, then 'sequence interruption analysis' is clicked, and whether the communication between the interlock and the VOBC is interrupted or not can be checked according to a display result.
The method for automatically processing the interlocking data provides 'broken sequence analysis' and 'broken sequence setting', ensures the integrity of the stored interlocking data, and lays a foundation for accurately analyzing the interlocking data.
Further, on the basis of the above embodiments, the method further includes:
after receiving an instruction of inquiring interlocking data of a preset data type, acquiring a storage position for storing the interlocking data of the preset data type from the preset database to obtain a storage position to be searched, searching first interlocking data corresponding to the preset data type from the storage position to be searched, and displaying the first interlocking data;
and if a query command which is input by a user and is queried according to the first interlocking data is received, acquiring second interlocking data corresponding to the query command from the first interlocking data, and displaying the second interlocking data.
It should be noted that the query command is a further search of the first interlocking data, and may be written in sql language, for example, the format of the query command is "format: select from table name where attribute field xx ". When the traffic signal with the route ID of 31 is queried, the corresponding query command is "select × from log _ route _ data _ rt _ ID of 31".
In the method, when a user needs to inquire certain interlocking data, the interlocking data can be quickly positioned by matching with a specific inquiry instruction according to the data type of the interlocking data, so that the automation of analyzing the interlocking data is realized, the analysis efficiency and the analysis accuracy are improved, the normal operation of other systems related to interlocking is ensured, and the operation efficiency of the whole traffic system is improved. The method avoids the defect of manual analysis, improves the efficiency of solving problems for the staff analyzing the interlocking data, and also improves the efficiency of debugging and testing the whole system. Meanwhile, the automatic processing method of the interlocking data provided by the embodiment can continuously analyze the interlocking data for a long time, is used by different workers, and has universality and universality.
Further, on the basis of the foregoing embodiments, if an inquiry command for inquiring according to the first interlocking data is received, the acquiring, from the first interlocking data, second interlocking data corresponding to the inquiry command, and displaying the second interlocking data includes:
displaying an input box for inputting the query command, and if the query command written by the user according to a preset language is received, acquiring an attribute field from the query command to serve as an attribute field to be queried;
acquiring interlocking data with the attribute field to be inquired as the second interlocking data from the first interlocking data, and displaying the second interlocking data;
the attribute field is a name corresponding to the data content of the interlocking data, and the preset language is sql.
Further, on the basis of the above embodiments, the method further includes:
and displaying the attribute code corresponding to each attribute field when receiving an instruction of querying the attribute code corresponding to the attribute field input by the user, so that the user can write the query command according to the attribute code.
Further, on the basis of the above embodiments, the method further includes:
if an instruction for displaying the interlocking data corresponding to the plurality of preset types at the same time is received, generating a window corresponding to each preset type, and displaying the interlocking data corresponding to each preset type through the window corresponding to each preset type.
For example, as shown in FIG. 2, the interlocking data is queried and analyzed. The interface analysis list comprises all interlocking related data such as signal machine data, physical and logical section data, non-access and access data, PSD state data, turnout and car washer data, ATS or a command sent to the interlocking in the spot, command feedback interlocked to the ATS or the spot, adjacent interlocking sending and receiving data, interlocking and VOBC communication data under different lines, generated error codes, a general command and the like, and the analysis query of the interlocking data of the data type can be carried out by selecting any one item to open.
In fig. 2, the "analysis" menu list includes all the main type data options, and when any item in the menu list is clicked, such as "traffic signal" (preset data type), the current interface displays the option data interface, so that multiple option analysis interfaces (i.e., multiple windows, which display the interlocking data corresponding to each preset type through the window corresponding to each preset type) can be opened simultaneously without mutual influence, and multiple page tables capable of being switched with each other can be formed.
As shown in fig. 5, a command query interface (a "query" button in fig. 5) is provided on the data analysis interface, and all data is queried and displayed by default, but the data log is often too large to facilitate problem searching, so that a query command is provided, and data meeting conditions in the table is queried and specified by inputting an sql statement (i.e., the query command), and is displayed, thereby improving the efficiency of interlocking data analysis.
As shown in fig. 5, in the opened option interface, for example, the traffic signal log data, the "query" button is clicked to query all the traffic signal data by default, the current interface displays all the traffic signal data, and the header is the format attribute of the traffic signal log. The command prompt box (input box for inputting the query command) supports the sql query command, and the basic sql query command format is as follows:
select from table name where attribute field xx
The table name and the attribute field can be obtained through a query description (triggering the query description button, namely inputting an instruction of an attribute code corresponding to the query attribute field) on the right side of the query button. For example, as shown in FIG. 5, the reason why the JK3-6AG route signal machine is turned off is analyzed. The route ID is 31, the state of the route in the route list is queried, and the sql query command is:
select*from log_route_data where rt_Id＝31
clicking on "query" the interface displays only the status data for route 31 as shown in fig. 5 (where the data of a certain data category is displayed as the first interlocking data. As a result of the inquiry, the route is previously locked at 1269 cycle time, and the traffic signal is turned off due to other reasons. The reason for the light-off of the annunciator is analyzed by inquiring the state of the annunciator. Inquiring the signal log, and inputting the following inquiry commands:
select*from log_signal_data where SigId＝14and sn>＝1268
the semaphore data is queried with a semaphore ID of 14 and a start period of 1268, as shown in fig. 6. As can be seen from the query results, in period 1268, the annunciator normally turns on the yellow light; the signal is turned off at 1269, and the state of the "broken filament" (the name corresponding to the data content of the interlocking data) shows "broken filament", which indicates that the signal is turned off due to the broken filament. The reason for the sudden light failure of the access JK3-6AG signal is found out.
As shown in fig. 7, the present embodiment provides another method for automatically processing interlock data, including:
an interlocking data log file path is selected. I.e. configuring the log path as shown in fig. 3.
Corresponding parameters are input according to the selected interlocking data. As shown in fig. 3, parameters such as interlock number, log version, parsing format, etc. are configured.
And analyzing the data file into a csv table file according to the configuration parameters. As shown in FIG. 3, clicking the "parse" button, and finishing the importing of the interlocking data log into the database when the progress bar is stopped from scrolling.
And importing the table file content into the database according to the data type option. As shown in fig. 4, the storage location is selected by marking "pair number".
And acquiring and displaying the database content according to the data type selected and analyzed. As shown in fig. 2, a data type is selected, and interlocking data corresponding to the data type is displayed.
And screening and displaying the database content according to the query command. As shown in fig. 5 and 6, the interlocking data corresponding to the "search command" is searched for from the interlocking data corresponding to the data type by the input "search command" and displayed.
As shown in fig. 8, the present embodiment provides an automated processing apparatus of interlocking data, comprising an acquisition module 801, a setting module 802, and a storage module 803, wherein,
an obtaining module 801, configured to obtain interlocking data generated in an interlocking system operation process, and classify the interlocking data according to a preset data type; the data types comprise signal machine data, turnout data, relay data and route data;
a setting module 802, configured to set configuration parameters of target interlocking data for target interlocking data corresponding to each data type; the configuration parameters comprise a log path, an interlocking number, a log version and an analysis format;
and the storage module 803 is configured to import the target interlocking data into a preset database according to the data type and the configuration parameters corresponding to the target interlocking data.
The device for automatically processing interlocking data provided in this embodiment is suitable for the method for automatically processing interlocking data provided in the above embodiment, and will not be described herein again.
The embodiment of the invention provides an automatic processing device of interlocking data, which classifies the interlocking data according to the data types, configures corresponding configuration parameters for the classified data, and stores the configured data into a preset database. When a user needs to inquire certain interlocking data, the interlocking data can be quickly positioned by matching with a specific inquiry instruction according to the data type of the interlocking data, so that the automation of the analysis of the interlocking data is realized, the analysis efficiency and the analysis accuracy are improved, the normal operation of other systems related to interlocking is ensured, and the operation efficiency of the whole traffic system is improved. The method avoids the defect of manual analysis, improves the efficiency of solving problems for the staff analyzing the interlocking data, and also improves the efficiency of debugging and testing the whole system. Simultaneously, the automatic processing device of interlocking data who adopts this embodiment to provide can last for a long time carry out the work of analysis to the interlocking data, supplies different staff to use, has the universality and commonality.
Specifically, the method and the device for automatically processing the interlocking data solve the defect that the interlocking problem process completely depends on manpower, ensure the accuracy and the effectiveness of the analysis of the interlocking data, and improve the accuracy and the efficiency of problem solving. The following effects are achieved:
the requirement on the capability of personnel is reduced. The interlocking data automatic analysis device is simple to operate and convenient to use, does not need manual data analysis, only needs to learn the operation method of the device, and avoids manpower waste;
the reliability and accuracy of data analysis are guaranteed. The method for automatically analyzing the interlocking data is realized by software programming, and the analysis of the interlocking data log is realized by software codes, so that the defects of low accuracy and easy error caused by human factors are overcome;
and (6) automatically analyzing. The device realizes the import, analysis and result display of the interlocking data through software programming, can analyze a large amount of interlocking data in batch and has high analysis speed, greatly shortens the time of analyzing the interlocking data and improves the efficiency compared with manual analysis;
optionality of data analysis. The interlocking data automatic analysis method can manually select the data to be analyzed, for example, only the signaler and the route data in the whole log can be analyzed, all the data in the whole log can also be analyzed, and the interlocking data can be analyzed according to the actual requirement;
the interface is clear. The data analysis result is classified and displayed according to the main interlocking logic, and the hexadecimal data frames are converted into the meanings of all the characters to be output, so that the data are convenient and clear to check, and the efficiency of processing and solving problems is improved;
by using the automatic data analysis device, the external environment of data analysis can be freely selected, the automatic data analysis device can continuously work for a long time, and the accuracy and the effectiveness of an analysis result are ensured;
maintainability. When the format of the interlocking data frame changes, the software can be modified to update.
The method for automatically processing the interlocking data provided by the embodiment mainly comprises the steps of analyzing the interlocking data and automatically inquiring. The analysis of the interlocking data is to extract all data frames and keywords and classify and store the data frames and the keywords. During programming, the difficulty of software programming is high, so that the analysis of the interlocking data is realized by writing a script file through per language. When software is programmed, the script is executed by calling batch processing through c #, and the method is completed. The method for realizing the automatic query of the interlocking data adopts a means combined with the SQLite database operation, the sql statement and the like to store the interlocking data in the database for interface display, and provides the sql query statement support during software programming to realize the data screening function.
The automatic analysis method is realized through programming language design, and is technically more accurate, reliable and effective. Under the conditions of multi-user use and multi-round test, the device can effectively analyze the interlocking data. Especially when a large amount of interlocking data are analyzed, the device can accurately and automatically analyze, various defects of manual analysis are completely avoided, the problem solving efficiency is improved for interlocking data analysis personnel, and the debugging and testing efficiency of the whole system is also improved. In addition, due to the automatic analysis method adopted by the interlocking data, the device can continuously work for a long time and is used by different personnel, and the device has universality and universality.
Finally, it should be noted that: the above embodiments are only used for illustrating the technical solutions of the embodiments of the present invention, and are not limited thereto; although embodiments of the present invention have been described in detail with reference to the foregoing embodiments, those skilled in the art will understand that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present invention.
Claims (10)
1. An automated processing method of interlocking data, comprising:
acquiring interlocking data generated in the operation process of an interlocking system, and classifying the interlocking data according to the preset data type; the data types comprise signal machine data, turnout data, relay data and route data;
setting configuration parameters of target interlocking data aiming at the target interlocking data corresponding to each data type; the configuration parameters comprise a log path, an interlocking number, a log version and an analysis format;
and importing the target interlocking data into a preset database according to the data type and the configuration parameters corresponding to the target interlocking data.
2. The method according to claim 1, wherein the importing the target interlocking data into a preset database according to the data type and the configuration parameters corresponding to the target interlocking data comprises:
analyzing the target interlocking data into a target csv file according to the configuration parameters, and importing the target csv file into a target storage position of the preset database according to a log path in the configuration parameters;
the target storage position is used for storing interlocking data with the same data type as the data type corresponding to the target interlocking data.
3. The method according to claim 2, wherein the parsing the target interlocking data into a target csv file according to the configuration parameters, and importing the target csv file into a target storage location of the preset database according to a log path in the configuration parameters includes:
analyzing the target interlocking data into the target csv file according to the configuration parameters, selecting the target storage position under a log path in the configuration parameters, setting and deleting original data stored in the target storage position, and importing the target csv file into the target storage position after deleting the original data;
or,
and analyzing the target interlocking data into the target csv file according to the configuration parameters, selecting the target storage position under a log path in the configuration parameters, setting and reserving original data stored in the target storage position, and importing the target csv file into the target storage position.
4. The method according to claim 3, wherein if the target interlocking data is interlocking data that is continuously generated over time, a time interval during which no interlocking data is generated is recorded in the target interlocking data.
5. The method of claim 4, wherein the target interlocking data is arranged in chronological order of generation of the target interlocking data in the target csv file.
6. The method of claim 5, further comprising:
after receiving an instruction of inquiring interlocking data of a preset data type, acquiring a storage position for storing the interlocking data of the preset data type from the preset database to obtain a storage position to be searched, searching first interlocking data corresponding to the preset data type from the storage position to be searched, and displaying the first interlocking data;
and if a query command which is input by a user and is queried according to the first interlocking data is received, acquiring second interlocking data corresponding to the query command from the first interlocking data, and displaying the second interlocking data.
7. The method according to claim 6, wherein if a query command for querying according to the first interlocking data is received, the obtaining second interlocking data corresponding to the query command from the first interlocking data and displaying the second interlocking data comprises:
displaying an input box for inputting the query command, and if the query command written by the user according to a preset language is received, acquiring an attribute field from the query command to serve as an attribute field to be queried;
acquiring interlocking data with the attribute field to be inquired as the second interlocking data from the first interlocking data, and displaying the second interlocking data;
the attribute field is a name corresponding to the data content of the interlocking data, and the preset language is sql.
8. The method of claim 7, further comprising:
and displaying the attribute code corresponding to each attribute field when receiving an instruction of querying the attribute code corresponding to the attribute field input by the user, so that the user can write the query command according to the attribute code.
9. The method of claim 6, further comprising:
if an instruction for displaying the interlocking data corresponding to the plurality of preset types at the same time is received, generating a window corresponding to each preset type, and displaying the interlocking data corresponding to each preset type through the window corresponding to each preset type.
10. An automated processing device for interlocking data, comprising:
the acquisition module is used for acquiring interlocking data generated in the operation process of the interlocking system and classifying the interlocking data according to the preset data type; the data types comprise signal machine data, turnout data, relay data and route data;
the setting module is used for setting configuration parameters of the target interlocking data aiming at the target interlocking data corresponding to each data type; the configuration parameters comprise a log path, an interlocking number, a log version and an analysis format;
and the storage module is used for importing the target interlocking data into a preset database according to the data type corresponding to the target interlocking data and the configuration parameters.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711321510.9A CN108170727A (en) | 2017-12-12 | 2017-12-12 | A kind of automatic processing method and device for interlocking data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711321510.9A CN108170727A (en) | 2017-12-12 | 2017-12-12 | A kind of automatic processing method and device for interlocking data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108170727A true CN108170727A (en) | 2018-06-15 |
Family
ID=62525721
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711321510.9A Pending CN108170727A (en) | 2017-12-12 | 2017-12-12 | A kind of automatic processing method and device for interlocking data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108170727A (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108959527A (en) * | 2018-06-28 | 2018-12-07 | 卡斯柯信号有限公司 | The method for reading display interlocking log based on Windows file mapping technology |
| CN109436035A (en) * | 2018-09-18 | 2019-03-08 | 交控科技股份有限公司 | Interlock data creation method |
| CN109815124A (en) * | 2018-12-20 | 2019-05-28 | 交控科技股份有限公司 | Method and device, the interlock system of interlock defect analysis based on MBSE |
| CN110674109A (en) * | 2019-09-06 | 2020-01-10 | 中国平安财产保险股份有限公司 | Data import method, system, computer device and computer readable storage medium |
| CN110920698A (en) * | 2019-12-09 | 2020-03-27 | 交控科技股份有限公司 | Computer interlocking system supporting multiple test car lines |
| CN111324779A (en) * | 2020-02-28 | 2020-06-23 | 卡斯柯信号有限公司 | Visual information processing method of interlocking logical relationship based on knowledge graph |
| CN111688766A (en) * | 2020-06-11 | 2020-09-22 | 中国铁道科学研究院集团有限公司通信信号研究所 | Automatic sectional route arranging method for high-speed railway complex long-route |
| CN111845866A (en) * | 2020-06-29 | 2020-10-30 | 通号城市轨道交通技术有限公司 | Automatic generation method and device of interlocking configuration file and electronic equipment |
| CN113268455A (en) * | 2021-04-26 | 2021-08-17 | 卡斯柯信号(成都)有限公司 | Boolean logic-based automatic configuration method and system for interlocking data |
| CN114912385A (en) * | 2021-02-07 | 2022-08-16 | 大唐移动通信设备有限公司 | Data screening method and device |
| WO2024178974A1 (en) * | 2023-03-01 | 2024-09-06 | 北京全路通信信号研究设计院集团有限公司 | Interlocking condition configurability implementation method, interlocking system, and electronic device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070112900A1 (en) * | 2004-06-25 | 2007-05-17 | Yan Arrouye | Methods and systems for managing data |
| JP5452457B2 (en) * | 2010-12-13 | 2014-03-26 | 三菱電機株式会社 | Linked chart creation device and linked chart creation method |
| CN105653575A (en) * | 2015-12-04 | 2016-06-08 | 重庆川仪自动化股份有限公司 | Data checking method and reporting system employed by same |
| CN106250495A (en) * | 2016-08-02 | 2016-12-21 | 上海自仪泰雷兹交通自动化系统有限公司 | A kind of automatic generation method of signaling system track database |
| CN106776515A (en) * | 2016-12-16 | 2017-05-31 | 刘立 | The method and device of data processing |
-
2017
- 2017-12-12 CN CN201711321510.9A patent/CN108170727A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070112900A1 (en) * | 2004-06-25 | 2007-05-17 | Yan Arrouye | Methods and systems for managing data |
| JP5452457B2 (en) * | 2010-12-13 | 2014-03-26 | 三菱電機株式会社 | Linked chart creation device and linked chart creation method |
| CN105653575A (en) * | 2015-12-04 | 2016-06-08 | 重庆川仪自动化股份有限公司 | Data checking method and reporting system employed by same |
| CN106250495A (en) * | 2016-08-02 | 2016-12-21 | 上海自仪泰雷兹交通自动化系统有限公司 | A kind of automatic generation method of signaling system track database |
| CN106776515A (en) * | 2016-12-16 | 2017-05-31 | 刘立 | The method and device of data processing |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108959527A (en) * | 2018-06-28 | 2018-12-07 | 卡斯柯信号有限公司 | The method for reading display interlocking log based on Windows file mapping technology |
| CN108959527B (en) * | 2018-06-28 | 2023-06-09 | 卡斯柯信号有限公司 | Method for reading and displaying interlocking log based on Windows file mapping technology |
| CN109436035A (en) * | 2018-09-18 | 2019-03-08 | 交控科技股份有限公司 | Interlock data creation method |
| CN109815124A (en) * | 2018-12-20 | 2019-05-28 | 交控科技股份有限公司 | Method and device, the interlock system of interlock defect analysis based on MBSE |
| CN109815124B (en) * | 2018-12-20 | 2022-02-15 | 交控科技股份有限公司 | MBSE-based interlocking function defect analysis method and device and interlocking system |
| CN110674109A (en) * | 2019-09-06 | 2020-01-10 | 中国平安财产保险股份有限公司 | Data import method, system, computer device and computer readable storage medium |
| CN110674109B (en) * | 2019-09-06 | 2024-02-06 | 中国平安财产保险股份有限公司 | Data importing method, system, computer equipment and computer readable storage medium |
| CN110920698B (en) * | 2019-12-09 | 2022-02-01 | 交控科技股份有限公司 | Computer interlocking system supporting multiple test car lines |
| CN110920698A (en) * | 2019-12-09 | 2020-03-27 | 交控科技股份有限公司 | Computer interlocking system supporting multiple test car lines |
| CN111324779A (en) * | 2020-02-28 | 2020-06-23 | 卡斯柯信号有限公司 | Visual information processing method of interlocking logical relationship based on knowledge graph |
| CN111688766A (en) * | 2020-06-11 | 2020-09-22 | 中国铁道科学研究院集团有限公司通信信号研究所 | Automatic sectional route arranging method for high-speed railway complex long-route |
| CN111688766B (en) * | 2020-06-11 | 2022-04-05 | 中国铁道科学研究院集团有限公司通信信号研究所 | Automatic Sectional Arrangement Method for Complicated and Long Routes of High-speed Railway |
| CN111845866A (en) * | 2020-06-29 | 2020-10-30 | 通号城市轨道交通技术有限公司 | Automatic generation method and device of interlocking configuration file and electronic equipment |
| CN114912385A (en) * | 2021-02-07 | 2022-08-16 | 大唐移动通信设备有限公司 | Data screening method and device |
| CN113268455A (en) * | 2021-04-26 | 2021-08-17 | 卡斯柯信号(成都)有限公司 | Boolean logic-based automatic configuration method and system for interlocking data |
| CN113268455B (en) * | 2021-04-26 | 2022-07-26 | 卡斯柯信号(成都)有限公司 | Boolean logic-based automatic configuration method and system for interlocking data |
| WO2024178974A1 (en) * | 2023-03-01 | 2024-09-06 | 北京全路通信信号研究设计院集团有限公司 | Interlocking condition configurability implementation method, interlocking system, and electronic device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108170727A (en) | A kind of automatic processing method and device for interlocking data | |
| CN106294673B (en) | Method and system for analyzing log data in real time by user-defined rule | |
| CN101713823B (en) | Satellite telemetry data reduction processing method | |
| US11528195B2 (en) | System for creating network troubleshooting procedure | |
| US6952658B2 (en) | System for determining fault causes | |
| CN108038054B (en) | Automatic testing method and device and computer readable storage medium | |
| CN108108297A (en) | The method and apparatus of automatic test | |
| CN107479540B (en) | Method for diagnosing faults and system | |
| CN111815099A (en) | Assembly line production management method and system | |
| CN111723515A (en) | Method, device and system for operating operator | |
| CN110232013B (en) | Test method, test device, controller and medium | |
| CN117873979A (en) | System log intelligent analysis method and device based on large language model | |
| CN115712623A (en) | Batch data fault-tolerant acquisition method based on capture metadata change | |
| CN108803561B (en) | Program automatic checking method and system for body-in-white line body control program | |
| CN113821554A (en) | Method for realizing data acquisition of heterogeneous database | |
| CN113674115B (en) | University data management auxiliary system and method based on data management technology | |
| US20250053574A1 (en) | Connector For Process Mining And Other Tools | |
| CN112035308A (en) | Method and device for generating system interface test table | |
| CN115328442B (en) | Hazardous chemical substance enterprise safety risk management and control platform constructed based on low code platform | |
| CN118037268A (en) | Equipment point detection method, device, equipment and storage medium | |
| CN117093497A (en) | Test report processing method and device, electronic equipment and storage medium | |
| CN115933922A (en) | Visualization tool and method based on online intelligent underwriting rule configuration | |
| CN115826755A (en) | AR teaching device and using method thereof | |
| CN109542768A (en) | A kind of multi-lingual automatic testing method based on Labview | |
| CN116107906A (en) | Regression test case knowledge base maintenance and regression test case recommendation method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180615 |