CN106294294B - Rail traffic signal system unifies the consistency desired result method of formatted data file - Google Patents
Rail traffic signal system unifies the consistency desired result method of formatted data file Download PDFInfo
- Publication number
- CN106294294B CN106294294B CN201610629159.9A CN201610629159A CN106294294B CN 106294294 B CN106294294 B CN 106294294B CN 201610629159 A CN201610629159 A CN 201610629159A CN 106294294 B CN106294294 B CN 106294294B
- Authority
- CN
- China
- Prior art keywords
- data
- file
- uft
- tables
- verification
- 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.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/126—Character encoding
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Computer Security & Cryptography (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Train Traffic Observation, Control, And Security (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of consistency desired result methods that rail traffic signal system unifies formatted data file, comprising: imports UFT file, and establishes data structure according to the UFT file；Data format verification is carried out to UFT file；Consistency verification of data is carried out to UFT file；As a result, there are the data cells of mistake in mark UFT file in output verification.The present invention can effectively reduce the error rate of UFT data file.
Description
Technical field
The present invention relates to technical field of rail traffic.
Background technique
Rail traffic signal system unifies formatted data file (UFT) file and Urban Rail Transit Signal system is described in detail
The definition method of related physical and logical data needed for system operation design and these data, it is metro operation design
Basic file is the design of subsequent database, the generation of locking sheet, system signal design, the fixed survey in scene and other relevant designs
Provide the foundation foundation, once mistake occurs in the document definition, will lead to the change of doing over again of subsequent relevant work, reduces
System design efficiency.
Because UFT data file includes a data form more than 50 altogether, mainly there are the gradient, speed limit, length chain, topological structure, control
Area, track switch, platform, semaphore, section, car stop, meter shaft, beacon, shield door, platform emergency off push-button, Flood gate, ventilating shaft etc.
Etc. related datas, data volume included in each table is different according to project, route yard complex situations are different and it is different,
It and is at present manually to fill in or by writing that the various formula of Excel calculate as a result, therefore more or less can
Some mistakes are generated, and inefficient.It there are also other parts content, is carried out by writing various formula in Excel
Association and calculating, but if certain one or more data content fills in mistake, the result that relative formula calculates
Just all mistake.And when route yard situation complexity, just will appear a large amount of various format errors, formula mistake,
The problems such as leakage volume is miscoded, data are inconsistent.
Summary of the invention
The purpose of the present invention is to provide the consistency desired results that a kind of rail traffic signal system unifies formatted data file
Method can effectively reduce the error rate of UFT data file.
Realizing the technical solution of above-mentioned purpose is:
A kind of rail traffic signal system unifies the consistency desired result method of formatted data file, comprising:
UFT file is imported, and data structure is established according to the UFT file, UFT file is unified for rail traffic signal system
Formatted data file；
Data format verification is carried out to UFT file；
Consistency verification of data is carried out to UFT file；
As a result, there are the data cells of mistake in mark UFT file in output verification.
In the consistency desired result method that above-mentioned rail traffic signal system unifies formatted data file, the foundation
Data structure refers to: after confirmation imports UFT file, successively importing the gradient, speed limit, length chain, topological structure, control area, track switch, stands
Platform, semaphore, section, car stop, meter shaft, beacon, shield door, platform emergency off push-button, Flood gate and ventilating shaft data form
Standard data is stored in established data structure.
In the consistency desired result method that above-mentioned rail traffic signal system unifies formatted data file, the data
Format check includes:
For each tables of data provided in verification rule list, all tables comprising requiring are checked whether；
Check whether data type defined in data field is consistent with the data arranged in the tables of data in UFT tables of data,
And whether the title and field of element are consistent and unique with what is required；
Check whether element term defined in UFT tables of data and number (hereinafter referred ID) value meet the requirements, masurium
Whether the character length of title meets range, and whether ID value is in claimed range；
Check whether various ID values cited in UFT tables of data can retrieve in the tables of data cited in it.
In the consistency desired result method that above-mentioned rail traffic signal system unifies formatted data file, the data
Consistency desired result includes:
For each tables of data for providing in verification rule list, be examined successively mileage value in respective cell whether with track
It is consistent in tables of data；
Check whether sideline (Segment) and the tables of data of track (Track) of all references are consistent；
Cited in inspection area controller (ZC), semaphore (Signals) and meter shaft section (Blocks) tables of data
Whether data item is virtual value；
Whether the axle-counting points for checking control area's boundary point are shared meter shaft；
Check the correctness for the data length filled in all tables of data.
The beneficial effects of the present invention are:
The present invention, which verifies, checks manually generated UFT document, according to the verification rule that it is defined, in data format sum number
According to check results, and the mistake progress automatic marking to verification out is provided in terms of consistency, the audit of next step is facilitated to correct.
All verification checking processes are all that computer executes automatically after the artificial selection UFT file to be tested, can be from essence
The upper generation for reducing hand-written mistake, greatly improves the correctness of UFT documentation process, improves to a certain extent and is
The efficiency of design of uniting and the correctness of data.
Detailed description of the invention
Fig. 1 is the flow chart that rail traffic signal system of the invention unifies formatted data file；
Fig. 2 is the flow chart that data format verifies in the present invention；
Fig. 3 is the flow chart of consistency verification of data in the present invention.
Specific embodiment
The present invention will be further described with reference to the accompanying drawings.
Fig. 1, Fig. 2 and Fig. 3 are please referred to, rail traffic signal system of the invention unifies formatted data file, including following
Step:
S1 imports UFT file, and UFT file unifies formatted data file for rail traffic signal system, and according to the UFT
File establishes data structure i.e.: confirmation have been introduced into the signal system track UFT file that need to be verified, if do not find or
Failure is imported, warning note is carried out.After confirmation imports UFT file, the gradient, speed limit, length chain, topological structure, control are successively imported
Area, track switch, platform, semaphore, section, car stop, meter shaft, beacon, shield door, platform emergency off push-button, Flood gate, ventilating shaft etc.
The standard data of data form is stored in established data structure.
S2 carries out data format verification to UFT file, includes the following steps:
S21 checks in UFT tables of data whether include required all tables.It is defined according in format check rule list
Each tables of data, then the tables of data verified needed for being successively read traverses imported UFT data, if in the UFT number of importing
According to existing in table, then next table inspection is carried out；If it does not exist, then continuing to verify next table after providing miscue
Lattice whether there is, until the verification of all tables of data finishes.
S22, check data type defined in data field in UFT tables of data whether with the data one that are arranged in the tables of data
It causes, and whether the title of element and field are consistent and unique with what is required.First read verification rule list defined in table name,
Then data column name, data column key field traverse UFT tables of data, find corresponding tables of data, and navigate to needs and sentence
On disconnected data column, successively whether consistent with desired data type verification reads the data type arranged, if inconsistent
Miscue is successively provided according to table name, column name, error message and is exported.
S23, checks whether element term defined in UFT tables of data and ID value meet the requirements, and the character of element term is long
Whether degree meets range, and whether ID value is in claimed range.The number of requirement inspection defined in verification rule list is read first
According to table, while reading element term and ID and be worth limitation range, then find corresponding table in UFT, corresponding title and
ID value starts multilevel iudge, and is exported according to actual result.
S24, checks whether various ID values cited in UFT tables of data can be retrieved in the tables of data cited in it
It arrives.The zone controller mainly quoted in tables of data numbers (ZCID), sideline number (SegmentID), orbital number
(TrackID), whether the data such as node serial number (NodeID) meet rule in cited tables of data.
S3 carries out consistency verification of data to UFT file, includes the following steps:
S31 checks whether related table mileage value is consistent on Track.First determine whether Tracks data form is deposited
?；If there is no mistake is then prompted, this verification will be carried out no longer；If it does, according to each number provided in verification rule list
According to table (such as sideline, platform, semaphore, track switch), be examined successively the mileage value filled in its cell whether with track number
It is consistent according to table, it is inconsistent, miscue is provided, while being marked in former data form.
S32 checks whether the sideline (Segment) of all references and the tables of data of track (Track) are consistent.It first confirms that
Segment and Track tables of data whether there is, and if there is no rule verification is then exited, provide miscue；If deposited
It is reading in verification Rule Information about data table items involved in this inspection rule, is successively handling and mentioned in tables of data
To needs verify data column, provide check results.
S33 is drawn in inspection area controller (ZC), semaphore (Signals) and meter shaft section (Blocks) tables of data
Whether data item is virtual value.Handle in 3 tables in order cited node (Nodes), car stop (Buffer) and
Can axle-counting points (AC DPs) whether there is and find in corresponding tables of data its index value, if error, be made mistake
Prompt.
S34 checks whether the axle-counting points of control area's boundary point are shared meter shaft.It is for ZC tables of data that this, which checks only,.It is first
It first checks that meter shaft tables of data whether there is, then the meter shaft data in ZC table is being read, if current meter shaft data are in meter shaft
It is not present or mismatches in table, error count adds 1, until having read all meter shaft data, provides check results.
S35 checks the correctness for the data length filled in all tables of data.According to what is filled in verification rule list
Tables of data successively verifies, and is successively added up according to the data length read according to sideline number (SegmentID) value, is finally judged
The accumulation length of the same SegmentID in active sheet whether with length phase defined in sideline (Segments) table
Deng, if differed, provide corresponding miscue, until all tables verification finish.
S4, output verification provide and former cell data as a result, in the presence of the data cells of mistake in mark UFT file
Discrepant calculated result etc..
Above embodiments are used for illustrative purposes only, rather than limitation of the present invention, the technology people in relation to technical field
Member, without departing from the spirit and scope of the present invention, can also make various transformation or modification, therefore all equivalent
Technical solution also should belong to scope of the invention, should be limited by each claim.
Claims (3)
1. a kind of consistency desired result method that rail traffic signal system unifies formatted data file characterized by comprising
UFT file is imported, and data structure is established according to the UFT file, UFT file is that rail traffic signal system unifies format
Data file；
Data format verification is carried out to UFT file；
Consistency verification of data is carried out to UFT file；
As a result, there are the data cells of mistake in mark UFT file in output verification；
The consistency verification of data includes:
For each tables of data for providing in verification rule list, be examined successively mileage value in respective cell whether with orbital data
It is consistent on table；
Check whether the sideline of all references is consistent with the tables of data of track；
Whether cited data item is virtual value in inspection area controller, semaphore and meter shaft sector data table；
Whether the axle-counting points for checking control area's boundary point are shared meter shaft；
Check the correctness for the data length filled in all tables of data.
2. rail traffic signal system according to claim 1 unifies the consistency desired result method of formatted data file,
It is characterized in that, the data structure of establishing refers to: after confirmation imports UFT file, successively importing the gradient, speed limit, length chain, topology
Structure, control area, track switch, platform, semaphore, section, car stop, meter shaft, beacon, shield door, platform emergency off push-button, Flood gate
With the standard data of ventilating shaft data form, it is stored in established data structure.
3. rail traffic signal system according to claim 1 unifies the consistency desired result method of formatted data file,
It is characterized in that, the data format verification includes:
For each tables of data provided in verification rule list, all tables comprising requiring are checked whether；
Check whether data type defined in data field is consistent with the data arranged in the tables of data in UFT tables of data, and member
Whether the title and field of element are consistent and unique with what is required；
Check whether element term defined in UFT tables of data and ID value meet the requirements, whether the character length of element term accords with
Range is closed, ID value is whether in claimed range；
Check whether various ID values cited in UFT tables of data can retrieve in the tables of data cited in it.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610629159.9A CN106294294B (en) | 2016-08-03 | 2016-08-03 | Rail traffic signal system unifies the consistency desired result method of formatted data file |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610629159.9A CN106294294B (en) | 2016-08-03 | 2016-08-03 | Rail traffic signal system unifies the consistency desired result method of formatted data file |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106294294A CN106294294A (en) | 2017-01-04 |
| CN106294294B true CN106294294B (en) | 2019-03-26 |
Family
ID=57664385
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610629159.9A Active CN106294294B (en) | 2016-08-03 | 2016-08-03 | Rail traffic signal system unifies the consistency desired result method of formatted data file |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106294294B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107451342A (en) * | 2017-07-18 | 2017-12-08 | 交控科技股份有限公司 | A kind of rule verification method and device of rail traffic signal system basic data |
| CN107807972B (en) * | 2017-10-19 | 2020-12-22 | 北京科技大学 | Test data consistency detection method |
| CN110688243A (en) * | 2019-09-26 | 2020-01-14 | 卡斯柯信号(北京)有限公司 | Inspection method of automatic inspection tool for train control center engineering data sheet |
| CN115092215A (en) * | 2022-05-24 | 2022-09-23 | 卡斯柯信号有限公司 | Connection relation-based intersection checking method |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102799690A (en) * | 2012-08-13 | 2012-11-28 | 南京莱斯信息技术股份有限公司 | Method for verifying page input by using database technology |
| CN103246574A (en) * | 2012-02-10 | 2013-08-14 | 阿里巴巴集团控股有限公司 | Verification method and verification device for data accuracy |
| CN104361119A (en) * | 2014-12-02 | 2015-02-18 | 中国农业银行股份有限公司 | Data cleaning method and system |
| CN104915262A (en) * | 2015-06-18 | 2015-09-16 | 国云科技股份有限公司 | Calibration system and method based on EXCEL data structure |
| CN105205039A (en) * | 2015-11-04 | 2015-12-30 | 国网新疆电力公司电力科学研究院 | Customizable SCD (substation configuration description) file verification method |
| CN105224511A (en) * | 2015-09-23 | 2016-01-06 | 山东网聪信息科技有限公司 | A kind of method of calibration of intelligent substation SCD file |
| CN105225076A (en) * | 2015-11-12 | 2016-01-06 | 国网宁夏电力公司经济技术研究院 | Analysis of prices data Collection & Processing System |
| CN105701236A (en) * | 2016-02-22 | 2016-06-22 | 上海自仪泰雷兹交通自动化***有限公司 | Automatic generating method of ATP system software database beside CBTC system rail |
-
2016
- 2016-08-03 CN CN201610629159.9A patent/CN106294294B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103246574A (en) * | 2012-02-10 | 2013-08-14 | 阿里巴巴集团控股有限公司 | Verification method and verification device for data accuracy |
| CN102799690A (en) * | 2012-08-13 | 2012-11-28 | 南京莱斯信息技术股份有限公司 | Method for verifying page input by using database technology |
| CN104361119A (en) * | 2014-12-02 | 2015-02-18 | 中国农业银行股份有限公司 | Data cleaning method and system |
| CN104915262A (en) * | 2015-06-18 | 2015-09-16 | 国云科技股份有限公司 | Calibration system and method based on EXCEL data structure |
| CN105224511A (en) * | 2015-09-23 | 2016-01-06 | 山东网聪信息科技有限公司 | A kind of method of calibration of intelligent substation SCD file |
| CN105205039A (en) * | 2015-11-04 | 2015-12-30 | 国网新疆电力公司电力科学研究院 | Customizable SCD (substation configuration description) file verification method |
| CN105225076A (en) * | 2015-11-12 | 2016-01-06 | 国网宁夏电力公司经济技术研究院 | Analysis of prices data Collection & Processing System |
| CN105701236A (en) * | 2016-02-22 | 2016-06-22 | 上海自仪泰雷兹交通自动化***有限公司 | Automatic generating method of ATP system software database beside CBTC system rail |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106294294A (en) | 2017-01-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106294294B (en) | Rail traffic signal system unifies the consistency desired result method of formatted data file | |
| CN110222445B (en) | BIM and design information based integration, collaborative design and delivery method and system | |
| CN110843870B (en) | Method for maintaining fixed capacity of high-speed railway network graph under abnormal event | |
| Biancardo et al. | Procedural Modeling‐Based BIM Approach for Railway Design | |
| CN104361095B (en) | A kind of power distribution network artwork data management method based on dual system | |
| CN110377682B (en) | Track type determination method and device, computing equipment and storage medium | |
| CN109582943B (en) | Method for automatically generating engineering data table | |
| CN105539521A (en) | Automatic basic data generating method and system of CBTC (Communication Based Train Control) system circuit | |
| CN109033479B (en) | Urban track traffic interconnect electronic map data generate system and method | |
| CN106250495A (en) | A kind of automatic generation method of signaling system track database | |
| CN106339565A (en) | Method for converting COMOS data to PDMS data in pipeline design | |
| CN104679949A (en) | Method for creating Paramics road network based on XML (Extensive Markup Language) road network data | |
| CN110414113B (en) | Method for automatically generating railway station plane overall layout diagram | |
| Bešinović et al. | Microscopic models and network transformations for automated railway traffic planning | |
| Huang et al. | Design of track alignment using building information modeling | |
| CN115063978B (en) | Bus arrival time prediction method based on digital twins | |
| CN113326040B (en) | Development and implementation method of rail transit interlocking system | |
| CN111862303A (en) | BIM technology-based subway station pipeline migration and transformation demonstration method | |
| Mirabadi et al. | Automatic generation and verification of railway interlocking control tables using FSM and NuSMV | |
| Desjardins et al. | Introduction Linking rail and urban development: reflections on French and British experience | |
| CN116797105B (en) | Price index statistical method and system based on engineering standardized coding | |
| CN114435433B (en) | Method and device for verifying automatic trigger route conflict | |
| Vávra et al. | Arrangement of the internal environment structure of the sw database for the technological timetable construction | |
| CN105701236A (en) | Automatic generating method of ATP system software database beside CBTC system rail | |
| CN112632200A (en) | Method and system for generating urban rail transit electronic map |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 201206 Shanghai City, Pudong New Area Jinhai Road No. 1000 Building No. 28 Applicant after: Shanghai electric traffic automation system Co., Ltd. Address before: 201206 Shanghai City, Pudong New Area Jinhai Road No. 1000 Building No. 28 Applicant before: Shanghai is from instrument Tai Leizi traffic automation System Co., Ltd |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |