CN116340284A - Automatic generation tool for urban rail transit subsystem database and application method - Google Patents

Abstract

The utility model relates to an automatic generation tool and an application method of an urban rail transit subsystem database, which take a signal basic data table as input, realize the automatic generation of the interlocking table and the database based on the establishment principle of the interlocking table and the database, and are mainly applied to the generation of the interlocking table and the subsystem database of a communication-based train operation control system CBTC. Compared with the existing mode of manually compiling an interlocking table, a database and a drawing, the automatic generation of the interlocking table, the ATS, the VOBC and the MAU subsystem database can be realized, the problems of large data volume and long time consumption of manual production are effectively solved, and meanwhile, errors caused by manual compiling can be avoided. The generation time can be greatly shortened, human errors can be reduced, and the accuracy and reliability of data are improved. Meanwhile, the delivery period of the whole project can be shortened, and the labor cost is saved.

Description

Automatic generation tool for urban rail transit subsystem database and application method

Technical Field

The disclosure relates to the technical field of urban rail transit, in particular to an automatic generation tool for an urban rail transit subsystem database, an application method and a control system.

Background

CBTC is currently the mainstream urban rail train automatic control system, consisting mainly of four subsystems, interlock, ATS, VOBC and MAU. They respectively implement the related functions of trackside interlocking control, automatic train monitoring, train-based communication and movement authorization.

A large amount of basic data and calculated logical data are defined in the interlock table, ATS subsystem database, VOBC subsystem database, and MAU subsystem database. Including train travel path, communication zone with ZCs, train command speed, trackside equipment name and mileage, etc.

The method takes a signal basic data table (comprising line information, trackside equipment, vehicle parameters and the like) as input, and based on the principle of programming the interlocking table and the database, the programming of the interlocking table and the databases of all subsystems is accurately and efficiently completed, which is an important ring in the design and development of subway automatic driving systems and is the basis for realizing automatic driving of urban rail signal systems.

The interlocking table and the database at the present stage are also compiled manually, all data of the interlocking table and the database of each subsystem are manually generated by manpower in the prior art, and a plurality of tables have a plurality of data, so that the labor time is huge. For example, when an ATS path correlation database is created, there may be hundreds of correlated routes, and for each route, the positions of a plurality of switches need to be sequentially filled in, which is large in workload and easy to fill in errors; the VOBC data has relatively less logic, but contains a large amount of physical element data, and is easy to miss; when making the MAU database, it is necessary to compare different MAU routes to determine whether to cover certain sections. These contents are difficult to manufacture manually, and have long programming time and are prone to errors.

Disclosure of Invention

In order to solve the problems, the automatic database generating tool takes a signal basic data table as input, and realizes the automatic generation of the interlocking table and the database based on the interlocking table and the database compiling principle. Compared with manual programming, the method can greatly shorten the generation time, reduce human errors and improve the accuracy and reliability of data. Meanwhile, the delivery period of the whole project can be shortened, and the labor cost is saved. The application provides an automatic generation tool for an urban rail transit subsystem database.

In one aspect of the present application, an automatic generation tool for an urban rail transit subsystem database is provided, including:

the data input analysis module is used for reading and analyzing a signal basic data table input by an input source, acquiring and storing data associated with the urban rail transit subsystem from the analyzed data, and sending the data as input data to the data verification module;

the data verification module is used for verifying the input data according to the configured data verification rule, and sending the verification to the data processing module after the verification is completed;

the data processing module is used for taking the input data which is completed in verification as input, compiling rules based on a preset database, generating the urban rail transit subsystem database and sending the urban rail transit subsystem database to the output module;

the output module is used for receiving the databases and automatically outputting the databases of all the urban rail transit subsystems according to a preset data format;

the log module is used for recording log information generated by the automatic generation tool of the urban rail transit subsystem database in the executing operation process.

As an optional embodiment of the present application, optionally, the input source is at least one of the following urban rail transit subsystems:

an interlock subsystem, an ATS subsystem, a VOBC subsystem, or a MAU subsystem.

As an optional embodiment of the present application, optionally, the writing format of the signal base data table is xlsx format.

As an optional embodiment of the present application, optionally, the signal base data table input by the input source is in txt format.

As an optional implementation manner of the application, optionally, the input data is input according to preset data formats, element and attribute requirements and parameter configuration conditions.

As an optional embodiment of the present application, optionally, the data verification rule includes verifying at least one of the following data contents in the input data:

a data type of the input data; or (b)

Uniqueness of the specified elements and attributes in the input data; or (b)

Consistency between associated data in the input data.

As an optional embodiment of the present application, optionally, the data processing module when generating the database data structure includes:

determining software requirement definition of each subsystem based on database compiling rules of each subsystem and the input data which is checked correspondingly;

based on the software requirement definition of each subsystem, calculating and generating:

an interlock table of the interlock subsystem; and/or

A database of ATS subsystems; and/or

A database of VOBC subsystems; and/or

A database of MAU subsystems;

and storing the database according to a first output format, and sending the database to the output module.

As an optional embodiment of the present application, optionally, when generating the database data structure, the data processing module further includes:

calculating and generating a corresponding graph drawing script according to the ATS path and MAU path related information in the input data;

and storing the graph drawing script according to a second output format, and sending the graph drawing script to the output module.

In another aspect of the application, an application method is provided, wherein the application method is implemented based on the automatic generation tool of the urban rail transit subsystem database, and the generation and the acquisition are performed:

xlsx format:

an interlock table of the interlock subsystem; and/or

A database of ATS subsystems; and/or

A database of VOBC subsystems; and/or

A database of MAU subsystems;

and/or

CAD drawing scripts in LSP format.

The invention has the technical effects that:

the automatic generation tool for the urban rail transit subsystem database provided by the invention takes a signal basic data table as input, realizes the automatic generation of the interlocking table and the database based on the interlocking table and the database compiling principle, and is mainly applied to the generation of the interlocking table and the subsystem database of a communication-based train operation control system (CBTC). Compared with the existing mode of manually compiling an interlocking table, a database and a drawing, the automatic generation of the interlocking table, the ATS, the VOBC and the MAU subsystem database can be realized, the problems of large data volume and long time consumption of manual production are effectively solved, and meanwhile, errors caused by manual compiling can be avoided.

The invention can greatly shorten the generation time, reduce human errors and improve the accuracy and reliability of data. Meanwhile, the delivery period of the whole project can be shortened, and the labor cost is saved.

The invention calculates the result based on logic, and then draws the corresponding graph in CAD software according to the result to be output. The method not only ensures the consistency of the graph and the output, but also greatly reduces the error rate of the output result. The reliability and the accuracy of the data are improved, the data compiling period is shortened, and the method has positive pushing effect on shortening the working time of the whole project period.

Other features and aspects of the present disclosure will become apparent from the following detailed description of exemplary embodiments, which proceeds with reference to the accompanying drawings.

Drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate exemplary embodiments, features and aspects of the present disclosure and together with the description, serve to explain the principles of the disclosure.

FIG. 1 is a schematic diagram showing the application composition of an automatic generation tool for an urban rail transit subsystem database according to the present invention;

FIG. 2 is a schematic flow chart of the data input analysis module for reading the trackside element signaller according to the present invention;

FIG. 3 is a schematic diagram showing a calculation flow of the drawing information according to the present invention;

fig. 4 shows a schematic flow chart of the graphic rendering of the present invention.

Detailed Description

Various exemplary embodiments, features and aspects of the disclosure will be described in detail below with reference to the drawings. In the drawings, like reference numbers indicate identical or functionally similar elements.

The word "exemplary" is used herein to mean "serving as an example, embodiment, or illustration. Any embodiment described herein as "exemplary" is not necessarily to be construed as preferred or advantageous over other embodiments.

In addition, numerous specific details are set forth in the following detailed description in order to provide a better understanding of the present disclosure. It will be understood by those skilled in the art that the present disclosure may be practiced without some of these specific details. In some instances, methods, means, elements, and circuits well known to those skilled in the art have not been described in detail in order not to obscure the present disclosure.

In this embodiment, the descriptions of CBTC (urban rail train automatic control system) and its constituent systems "interlock, ATS, VOBC and MAU subsystem" respectively implement related functions of trackside interlock control, automatic train monitoring, train-based communication and movement authorization, and this embodiment will not be described in detail.

In this embodiment, an interlock table of the interlock system may be selectively generated; a database of ATS subsystems; a database of VOBC subsystems; a database of MAU subsystems; CAD drawing scripts in LSP format (mainly ATS and MAU).

In this embodiment, all the charts described above are preferentially generated.

The function of the tool will be described in detail below.

The tool takes a signal basic data table (comprising line information, track side equipment, vehicle parameters and the like) as input, and based on the principle of programming the interlocking table and the database, the programming of the interlocking table and each subsystem database is accurately and efficiently completed, so that the tool is an important ring in the design and development of the subway automatic driving system, and is the basis for realizing automatic driving of the urban rail signal system. By adopting the tool, the input data can be read and analyzed, the interlocking table in the xlsx format, the ATS, VOBC and MAU database data and the corresponding CAD script drawing graph can be output.

Example 1

As shown in fig. 1, the disclosure proposes an automatic generation tool for an urban rail transit subsystem database, including:

the data input analysis module is used for reading and analyzing a signal basic data table input by an input source, acquiring and storing data associated with the urban rail transit subsystem from the analyzed data, and sending the data as input data to the data verification module;

the data verification module is used for verifying the input data according to the configured data verification rule, and sending the verification to the data processing module after the verification is completed;

the data processing module is used for taking the input data which is completed in verification as input, compiling rules based on a preset database, generating the urban rail transit subsystem database and sending the urban rail transit subsystem database to the output module;

the output module is used for receiving the databases and automatically outputting the databases of all the urban rail transit subsystems according to a preset data format;

the log module is used for recording log information generated by the automatic generation tool of the urban rail transit subsystem database in the executing operation process.

The input source is a signal basic data table of the subway system, and related calculation and preparation work are carried out on data required to be generated by each system.

Aiming at the signal basic data table, the signal basic data table is processed according to the format required by the tool software, and the required information file is acquired. From the input signal base data table, 4 databases of interlocking, ATS, VOBC and MAU subsystems can be generated.

The user selects part or all of the basic data by himself.

In this embodiment, various charts generated by the generating tool are correspondingly generated according to the preconditions of setting formats, elements, attributes and the like of data, and are generated by the established formats described by the requirements of the subsystems.

1. And the data input analysis module reads the related information of the signal basic data table, analyzes the information to obtain a required data file and stores the required data file.

As shown in fig. 2, a part of the general properties of the trackside element signal are taken as an example. When the data of the annunciator are read, the data are sequentially read from project configuration-platform information according to the sequence, and the read data are used as input data and sent to the data verification module.

Wherein, the read data has the following format requirements:

1.1, for input data, there is the following format convention:

when the data is written, an xlsx format can be adopted, and all the data after the writing is completed are saved to the same txt file to be used as an input source;

dividing a single row of data columns in a data file by using Tab symbols;

each table is designated by the original table name in "[/XXXX/]", while being used to partition different tables;

each table describes a trackside element, such as: signals is used to describe the semaphore-related elements of this project;

describing a signal machine in each row in a table, and describing different attributes of the signal machine in each column;

a unique identification is required for the attributes of the elements for software identification, for example: the name of the annunciator can be identified by using a sig.

Empty line data may not exist before ending in the same table;

1.2, an input data file containing at least the following elements and attributes:

stock rail side element information comprising: switch, annunciator, platform door, grade, mileage, speed limit, beacon, control area, etc.;

the switch should at least comprise: name, direction, track connection relation, mileage, etc. for restoring topological structure and drawing relevant graph;

other element related attributes at least comprise unique names, equipment mileage, internal numbers and the like, and other attributes are added according to the interlocking table and subsystem database compiling rules;

1.3, configuration parameters related to the project need to be defined in the input file:

the items correspond to vehicle related parameters: length, acceleration and deceleration performance, brake index, weight, etc.;

environmental related parameters: dry rail brake rate, wet rail brake rate, etc.;

data bias parameters: uncertainty index, delay error, etc.

When the architecture design of the data input analysis module is constructed, the design is also performed according to the format requirements.

2. And the data verification module is used for verifying the consistency among the input data type, the uniqueness and the associated data.

2.1, checking the type of input data; for digital data such as mileage, numbers and the like, the digital data cannot be letter or character strings;

2.2, element numbers, names and other elements need to be unique and not repeatable; for partial values, it is desirable that the number is not a non-positive integer within a prescribed range, for example;

2.3, checking consistency among data with association relation, which is specifically defined by input data and requirements. Such as: there are annunciators corresponding to the axes that must be defined in the axes list of the input file; the mileage of the element cannot exceed the mileage range defined by the track; the control area where the element is located must be the control area defined in the input; the counting axes of the section association should be defined in the counting axis list, etc.

The verification rule is only required to be capable of verifying the three aspects, and is specifically set by a user according to a verification object, elements, attributes and the like in data.

3. The data processing module is mainly responsible for processing input data, and obtains final data based on software requirements. The method mainly comprises two types of data calculation, wherein one type is the data related to the interlocking table and the subsystem database, and the other type is the information required by corresponding drawing.

And 3.1, calculating the relevant data of the calculation interlocking table and the database mainly according to the input signal basic data information and the software requirement definition. And respectively generating a database of the output interlocking table and a database of the ATS, VOBC, MAU subsystem by calculation, and storing the data structure according to the format of the output requirement.

When the generation of databases of the three subsystems of the interlocking table and the ATS, VOBC, MAU is realized on software, the software requirement document (specific software requirement) is compiled by taking the respective signal basic data table as input and defining the automatic database generation tool to realize the respective corresponding requirement based on the rule compiling of the databases of the subsystems in the interlocking table and ATS, VOBC, MAU, and the software architecture design, the UI design and the design of the functional modules of the system are carried out according to the specific software requirement. After the design is finished, the corresponding source data (signal basic data table input by each subsystem) can be input, and the corresponding chart files can be generated after processing.

Here, when the data input analysis module processes the input source data, the ATS path and MAU path related information need to be additionally saved for calculation of the graphic drawing data, so as to ensure consistency of the output drawing and the data.

And 3.2, calculating drawing information, and restoring the metro track topological structure mainly according to the input turnout and track connection relation. The detailed flow is then drawn as a track-switch path diagram as shown in fig. 3, based on the traversal algorithm (e.g., BFS, DFS, etc.) and the restriction rules for the approach travel.

In fig. 3, each processing step may directly perform operation processing in a corresponding system, so as to complete the drawing coordinate point of the path information, and after constructing the path in combination with the travel limit rule of the path, obtain the drawing basic information (the topology structure of the graph generation base) of the path.

And 3.3, calculating coordinate values of the corresponding tracks and elements based on the topological structure, and preparing for a subsequent output graph. The flow of the graphic data calculation is shown in fig. 4.

In the basic topological structure, track connection relations are calculated by combining turnout data, and data such as track arrangement, coordinates and the like are calculated, so that track layout drawing of the whole project is realized.

The above calculation and drawing modes are accomplished by those skilled in the art in combination with industry software tools and the like.

And after being processed by the data processing module, the database data structure of a certain traffic subsystem is obtained and is ready for outputting a subsequent output graph.

4. Output module-including output of interlocking tables and database data and output of graphics drawing scripts. The interlocking table and database output are in the form of xlsx, and the graphical script output is an LSP file that can be run by the CAD.

4.1, the contents and order of the interlocking table and database outputs are determined at the data calculation stage. The output phase is simply to show the data in the variables into the output file. Meanwhile, the accuracy of the output data is determined in the calculation process, and the output is not changed any more.

And 4.2, automatically drawing the script language LISP and the calculated element coordinates based on the automatic CAD. Including trackside equipment (annunciators, stations, axle gauges, etc.), track information, track color related element drawings. The output LSP file content is consistent with the database, and the LSP file information is output by software, so that the output speed is high. And loading LSP files through CAD software to obtain the drawing graph.

5. The log module is mainly used for recording information generated in the process of operating software by a user. The log is presented in two ways, one is in the form of a popup window informing the user, and the other is recorded in the form of text. The popup mode is mainly used for feeding back to the user at key nodes, for example, after the input is completed, the popup mode can inform the user of the brief content of the input information, so that whether all data are loaded or not can be checked conveniently.

When the output and drawing of the interlocking list and the database are completed, a popup window prompts the completion of the task. And when some errors occur, popup window prompts are generated, and the user is informed of possible reasons and solutions. The text form not only contains the content of all popup prompts, but also contains detailed information such as requirements, software version numbers and the like. Presented in the form of time, severity, content. And also records smoothly output information.

The automatic generation tool of the urban rail transit subsystem database can be designed by referring to the functional requirements of the modules when the software architecture is designed. The specification such as the design of compiling rules and checking rules is designed by the user according to checked elements/objects.

In software design, the following steps are mainly adopted:

(1) Based on the interlocking table and the rule programming of each subsystem database, the signal basic data table is taken as input, and an automatic database generating tool is defined to realize the requirement and program a software requirement document (specific software requirement);

(2) According to specific software requirements, performing software architecture design, UI design and design of each functional module of the system;

(3) Defining interface modes and interface contents among the modules;

(4) Defining a data structure for use in a software module;

(5) Determining the format and the content of a software input/output file;

(6) Determining a check rule for consistency detection of input data;

(7) Finishing a read-in and data verification function module of a subway signal basic data table;

(8) Completing the input data processing and calculating module;

(9) Finishing an output module, and outputting a related interlocking table, a database and a CAD graph drawing script file;

(10) Performing internal test, modifying codes, and solving various problems found in the test;

(11) And perfecting related documents and formally distributing software.

The software design of the tool is specifically designed by industry designers with reference to the format requirements/module functions and the like of the application, and the design manual/description and the like of the embodiment are not repeated in detail.

It should be noted that although the above-described drawing scheme is described by taking ATS paths and MAU paths as examples, those skilled in the art will appreciate that the present disclosure should not be limited thereto. In fact, the user can flexibly set the drawing object according to the actual application scene, so long as the technical function of the application can be realized according to the technical method.

In this embodiment, the file format is merely a preferred one, and may be adopted as long as format conversion can be performed between application software such as CAD, PROE, and the like.

The modules or steps of the invention described above may be implemented in a general-purpose computing device, they may be centralized in a single computing device, or distributed across a network of computing devices, or they may alternatively be implemented in program code executable by a computing device, such that they may be stored in a memory device and executed by a computing device, or they may be separately fabricated into individual integrated circuit modules, or multiple modules or steps within them may be fabricated into a single integrated circuit module. Thus, the present invention is not limited to any specific combination of hardware and software.

Example 2

Based on the implementation principle of embodiment 1, in another aspect of the present application, an application method is provided, where the application method is implemented based on the automatic generation tool of the urban rail transit subsystem database, and the generation and the obtaining are that:

xlsx format:

an interlock table of the interlock subsystem; and/or

A database of ATS subsystems; and/or

A database of VOBC subsystems; and/or

A database of MAU subsystems;

and/or

CAD drawing scripts in LSP format.

In this embodiment, all charts are preferably generated, and an automatic generation tool for an urban rail transit subsystem database is adopted to generate specific functions and steps of each chart, which are described in embodiment 1.

It should be apparent to those skilled in the art that the implementation of all or part of the above-described embodiments of the method may be implemented by a computer program for instructing relevant hardware, and the program may be stored in a computer readable storage medium, and the program may include the steps of the embodiments of the control methods described above when executed. It will be appreciated by those skilled in the art that implementing all or part of the above-described embodiment methods may be accomplished by a computer program for instructing relevant hardware, and the program may be stored in a computer readable storage medium, which when executed may include the steps of the embodiments of the control methods described above. The storage medium may be a magnetic disk, an optical disc, a Read-only memory (ROM), a random access memory (RandomAccessMemory, RAM), a flash memory (flash memory), a hard disk (HDD), or a Solid State Drive (SSD); the storage medium may also comprise a combination of memories of the kind described above.

Example 3

Still further, another aspect of the present application provides a control system, including:

a processor;

a memory for storing processor-executable instructions;

wherein the processor is configured to implement the application method when executing the executable instructions.

Embodiments of the present disclosure control a system that includes a processor and a memory for storing processor-executable instructions. Wherein the processor is configured to implement any one of the application methods described above when executing the executable instructions.

Here, it should be noted that the number of processors may be one or more. Meanwhile, in the control system of the embodiment of the present disclosure, an input device and an output device may be further included. The processor, the memory, the input device, and the output device may be connected by a bus, or may be connected by other means, which is not specifically limited herein.

The memory is a computer-readable storage medium that can be used to store software programs, computer-executable programs, and various modules, such as: a program or a module corresponding to an application method of an embodiment of the present disclosure. The processor executes various functional applications and data processing of the control system by running software programs or modules stored in the memory.

The input device may be used to receive an input number or signal. Wherein the signal may be a key signal generated in connection with user settings of the device/terminal/server and function control. The output means may comprise a display device such as a display screen.

The foregoing description of the embodiments of the present disclosure has been presented for purposes of illustration and description, and is not intended to be exhaustive or limited to the embodiments disclosed. Many modifications and variations will be apparent to those of ordinary skill in the art without departing from the scope and spirit of the various embodiments described. The terminology used herein was chosen in order to best explain the principles of the embodiments, the practical application, or the technical improvement of the technology in the marketplace, or to enable others of ordinary skill in the art to understand the embodiments disclosed herein.

Claims (9)

1. An automatic generation tool for an urban rail transit subsystem database, comprising:

the data input analysis module is used for reading and analyzing a signal basic data table input by an input source, acquiring and storing data associated with the urban rail transit subsystem from the analyzed data, and sending the data as input data to the data verification module;

the data verification module is used for verifying the input data according to the configured data verification rule, and sending the verification to the data processing module after the verification is completed;

the data processing module is used for taking the input data which is completed in verification as input, compiling rules based on a preset database, generating the urban rail transit subsystem database and sending the urban rail transit subsystem database to the output module;

the output module is used for receiving the databases and automatically outputting the databases of all the urban rail transit subsystems according to a preset data format;

the log module is used for recording log information generated by the automatic generation tool of the urban rail transit subsystem database in the executing operation process.

2. The automated urban rail transit subsystem database creation tool of claim 1, wherein the input source is at least one of the following urban rail transit subsystems:

an interlock subsystem, an ATS subsystem, a VOBC subsystem, or a MAU subsystem.

3. The automated generation tool of urban rail transit subsystem databases of claim 1, wherein the signal base data table is written in xlsx format.

4. The automated generation tool of urban rail transit subsystem databases of claim 3, wherein the signal base data table input by the input source is in txt format.

5. The automated generation tool of urban rail transit subsystem databases of claim 1, wherein the input data is input according to preset data formats, element and attribute requirements, and parameter configuration conditions.

6. The automated generation tool of urban rail transit subsystem databases of claim 1, wherein the data verification rules comprise verification of at least one of the following data contents in the input data:

a data type of the input data; or (b)

Uniqueness of the specified elements and attributes in the input data; or (b)

Consistency between associated data in the input data.

7. The automated generation tool of urban rail transit subsystem databases of claim 1, wherein the data processing module, when generating the database data structure, comprises:

determining software requirement definition of each subsystem based on database compiling rules of each subsystem and the input data which is checked correspondingly;

based on the software requirement definition of each subsystem, calculating and generating:

an interlock table of the interlock subsystem; and/or

A database of ATS subsystems; and/or

A database of VOBC subsystems; and/or

A database of MAU subsystems;

and storing the database according to a first output format, and sending the database to the output module.

8. The automated generation tool of urban rail transit subsystem databases of claim 7, wherein the data processing module, when generating the database data structure, further comprises:

calculating and generating a corresponding graph drawing script according to the ATS path and MAU path related information in the input data;

and storing the graph drawing script according to a second output format, and sending the graph drawing script to the output module.

9. The application method is characterized in that the application method is implemented based on the automatic generation tool of the urban rail transit subsystem database according to any one of claims 1-8, and the generation and the acquisition are carried out:

xlsx format:

an interlock table of the interlock subsystem; and/or

A database of ATS subsystems; and/or

A database of VOBC subsystems; and/or

A database of MAU subsystems;

and/or

CAD drawing scripts in LSP format.

Images