CN110427363A - Railway signals equipment image information based on relevant database converts storage method - Google Patents
Railway signals equipment image information based on relevant database converts storage method Download PDFInfo
- Publication number
- CN110427363A CN110427363A CN201910026874.7A CN201910026874A CN110427363A CN 110427363 A CN110427363 A CN 110427363A CN 201910026874 A CN201910026874 A CN 201910026874A CN 110427363 A CN110427363 A CN 110427363A
- Authority
- CN
- China
- Prior art keywords
- image
- equipment
- railway
- railway signals
- ifd
- 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.)
- Granted
Links
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Processing Or Creating Images (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of, and the railway signals equipment image information based on relevant database converts storage method, first arrangement railway signals equipment raw image files, guarantees the versatility of all development systems；Image enhancement is carried out using Butterworth low-pass filter, radio-frequency component amplitude is reduced, weakens useless noise；Conversion signal equipment original image is tiff format；Equipment list, component table, parts list is respectively created；Establish table relationship.After the present invention is to image digitazation, convenient for storing, calling in a program and handle；Image information can be stored in batches, improve program to the degree of automation and efficiency of data writing, reading；Data structure after digitized image is simple, clear, regular, stores and calls and is convenient, fast.
Description
Technical field
The invention belongs to the technical fields of railway equipment information system management, and in particular to a kind of based on relevant database
Railway signals equipment image information converts storage method.
Background technique
The development of high-speed railway, to train emergency dispatching, electricity business fault management, cab signal fault information managing, maintenance
More stringent requirements are proposed for the information management systems such as base management, but because of the information management system of signalling arrangement, " is respectively mostly
Political affairs ", globality is not strong, is limited to topical application more, still there is larger gap in information sharing, intelligence degree, automatization level.
It is mainly showed: one is a lack of integrated planning, cannot interconnect；There are technologies not to advise in the application of constituent parts for each application system
Model, standard disunity, phenomena such as regional development is uneven.Second is that resource-sharing level is low；Each application system dispersion is independent, is formed
Many information islands, cannot play resource-sharing advantage；Third is that envelop of function is not comprehensive, the electric management and running being engaged in management,
It is not comprehensive enough that the routines such as shift management manage content.The problem of these every aspects, is wanted with electricity business IT application in management, automation
It asks gap also very big, has not adapted to the requirement of electricity business IT application in management under the new situation, be difficult to accomplish signalling arrangement failure
Quickly, it accurately handles.
The information system management of railway signals equipment image, can make signalling arrangement and facility it is visual, as it can be seen that simultaneously quickly, it is accurate
Ground is presented to each management for participating in maintenance and in-situ processing personnel, and scene is reproduced to be combined with realtime graphic, installations and facilities half
Matter emulation is combined with image photograph, and actual response field data reacts the working condition of all facilities and equipments, refers to emergency
Work low consumption is waved, processing method flexibly, effectively, high quality, the safe operation of equipment is realized with lower cost.
Summary of the invention
The object of the present invention is to provide a kind of, and the railway signals equipment image information based on relevant database converts storage
Method meets the needs of current high-speed railway maintenance maintenance, emergency command.
The technical scheme adopted by the invention is as follows:
Railway signals equipment image information based on relevant database converts storage method, it is characterised in that:
It is realized by following steps:
Step 1: arranging railway signals equipment raw image files, according to point of railway signal system in railway IFD professional standard
Class and coding, with these codings when creating database, to guarantee the versatility of all development systems；
Step 2: image enhancement is carried out using Butterworth low-pass filter, reduces radio-frequency component amplitude, weakens useless make an uproar
Sound；
Step 3: conversion signal equipment original image is tiff format, and file content includes: file header, parameter pointer table and ginseng
Number field, four parts of parametric data table and image data complete image basic information；
Step 4: equipment list, component table, parts list is respectively created；
Step 5: establishing table relationship, and according to railway signals equipment IFD coding rule, equipment, component, part triadic relation are 1 pair
The establishment of two kinds of table relationships more than 1 and 1 pair, relationship passes through two ways matching relationship: (1) the IFD coding and other tables in major key
External bond in first 9 of IFD coding it is identical and determine matching relationship；(2) determine that the matching of the table of table is closed by concordance list
System, the character string of concordance list is first 9 of IFD coding, and the habit of the character string view program designer of concordance list presses ascending order
Or descending arrangement.
In step 2, cut frequency is the transfer function of the low-pass filter of d0 are as follows:
。
In step 3, applicable image type has: thumbnail, include image array and color diagram array, two into
Imaged, RGB image, gray level image.
The invention has the following advantages that
(1) after to image digitazation, convenient for storing, calling in a program and handle.
(2) digitized image is binary system and character type data, is easily stored into SQL server, wherein
The maximum length of Image data type can achieve 2GB.
(3) method and data type used by facilitate memory page to store the data of digitized image, can simplify journey
Sequence structure.
(4) image information can be stored in batches, improve program to the degree of automation and efficiency of data writing, reading.
(5) data structure after digitized image is simple, clear, regular, stores and calls and is convenient, fast.
Detailed description of the invention
Fig. 1 is proving program operation result of the invention.
Specific embodiment
The present invention will be described in detail With reference to embodiment.
Railway signals equipment is many kinds of, and there are the model of oneself, shape, but inside installation used in each factory commercial city
Component and part have the standard of railway systems, to the image data of equipment, component, part, either .jpg .bmp .gif etc.
Various formats can convert TTIF format by image processing software, and the Image type field used in SQL Server is storage
The integer array data of image, SQL Server are not compiled it, but complete to explain by program, data-interface is simple,
It is illustrated.Meanwhile classification and coding of the corresponding equipment of the image in railway signal system, it is saved in and meets railway IFD standard
In the tables of data of " railway engineering information model classification and coding standard (1.0 editions) ", and number is stored in not as data record
It according in record page, and is stored in one group of dedicated page for meeting IFD standard, is only one 16 in the corresponding field of tables of data
The pointer of system, the pointer are directed toward the page for storing the record of the equipment, component or part.Again because in the field of Image type
Holding cannot use the sentences such as INSERT and UPDATA to be inserted into and updated in SQL Server, so special mistake need to be write
Journey handles the data field of image.Program is improved in this way to the image real time transfer ability and computing capability of magnanimity.
The railway signals equipment image information that the present invention relates to a kind of based on relevant database converts storage method, by with
Lower step is realized:
Step 1: arranging railway signals equipment raw image files, according to point of railway signal system in railway IFD professional standard
Class and coding, with these codings when creating database, to guarantee the versatility of all development systems.
For example, the turn-out track machine equipment of signal system, corresponding railway signals equipment IFD is encoded to 54-20 20 90 20
30。
Step 2: image enhancement is processed to image, and processing after-vision effect is more preferable, image more preferably.Method
It is using Butterworth low-pass filter, the energy of image is largely focused on the low frequency and middle frequency of amplitude spectrum, and image
Edge and noise correspond to high frequency section.Therefore radio-frequency component amplitude can be reduced, useless noise can be weakened.Frequency is truncated in it
Rate is the transfer function of the low-pass filter of d0 are as follows:
Using when program can refer to the code of following implemented Butterworth low-pass filter:
Step 3: conversion signal equipment original image is tiff format, and file content includes: file header, parameter pointer table and ginseng
Number field, the complete image basic information of four parts of parametric data table and image data.Isosorbide-5-Nitrae, 8,24 non-depressed contract drawings can be handled
Picture and Isosorbide-5-Nitrae, 8,24 packbit compress image, a CCITT compression image etc., are suitble to storage and the tune of large size development system
With.
Applicable image type has: thumbnail, includes image array and color diagram array, binary picture, RGB
Image, gray level image.
Image sampling, quantization using existing digitized image software, after format is converted.Sampling is will to connect on airspace
Continuous image is transformed into discrete sampling point set, is the discretization to space, the two-dimensional discrete signal through obtaining after over-sampling
Minimum unit be pixel.Quantization is exactly to be represented after the continuous quantity discretization for indicating bright dark information on sampled point with numerical value
Come, is the discretization to brightness size.Later, digital picture is described with the form of integer array, using Image data class
Type is stored into database.
Step 4: equipment list, component table, parts list is respectively created:
1, Eid: data type varchar, device identification number
2, Ename: device name, data type varchar, railway signals equipment include construction equipment, track circuit, signal
Lamp, hump equipment, power-supply device, computer and networks, Train Detection and Identification, controlling equipment, locomotive equipment, is answered at turn-out track equipment
Answer device, microcomputer monitoring
3, EqCode: data type varchar, railway signals equipment IFD coding, coding rule is referring to " railway engineering information mould
Type classification and coding standard (1.0 editions) "
4, EqType: data type varchar, device model
5, ECId: data type varchar, equipment class describes equipment purposes and function
6, Alias: data type varchar, equipment alias, scene habit address
7, Position: data type text, recording equipment infield (the affiliated electricity business section-of railway title-affiliated Railway Bureau-
Affiliated station or station section)
8, EqModel: data type varchar, the physical location code of equipment threedimensional model
9, EImage: data type varchar, the physical location code of equipment original image
10, DataImage: data type Image, the integer array of digital picture, access method is by program staff's self-definition.
Following table is containing the necessary field for having covered digitized image storage, equipment, component, the attribute field of part, engineering field
There is program person freely to expand with maintenance field, the form of component table and parts list is identical to equipment list, and column name can be customized.
Step 5: table relationship is established.According to railway signals equipment IFD coding rule, equipment, component, part triadic relation
For 1 pair of two kinds of table relationship more than 1 and 1 pair, the establishment of relationship passes through two ways matching relationship: (1) the IFD coding in major key and its
First 9 of IFD coding in the external bond of his table are identical and determine matching relationship；(2) of the table of table is determined by concordance list
With relationship, the character string of concordance list is first 9 of IFD coding, and the character string of concordance list is pressed depending on the habit of program designer
Ascending or descending order arrangement.
Fig. 1 is the proving program operation result to the method, and semaphore is signalling arrangement, passes through one-to-many table relationship tune
With this signalling arrangement whole component and part is formed, these components and part are composable, also disassembled.
The contents of the present invention are not limited to cited by embodiment, and those of ordinary skill in the art are by reading description of the invention
And to any equivalent transformation that technical solution of the present invention is taken, all are covered by the claims of the invention.
Claims (3)
1. the railway signals equipment image information based on relevant database converts storage method, it is characterised in that:
It is realized by following steps:
Step 1: arranging railway signals equipment raw image files, according to point of railway signal system in railway IFD professional standard
Class and coding, with these codings when creating database, to guarantee the versatility of all development systems；
Step 2: image enhancement is carried out using Butterworth low-pass filter, reduces radio-frequency component amplitude, weakens useless make an uproar
Sound；
Step 3: conversion signal equipment original image is tiff format, and file content includes: file header, parameter pointer table and ginseng
Number field, four parts of parametric data table and image data complete image basic information；
Step 4: equipment list, component table, parts list is respectively created；
Step 5: establishing table relationship, and according to railway signals equipment IFD coding rule, equipment, component, part triadic relation are 1 pair
The establishment of two kinds of table relationships more than 1 and 1 pair, relationship passes through two ways matching relationship: (1) the IFD coding and other tables in major key
External bond in first 9 of IFD coding it is identical and determine matching relationship；(2) determine that the matching of the table of table is closed by concordance list
System, the character string of concordance list is first 9 of IFD coding, and the habit of the character string view program designer of concordance list presses ascending order
Or descending arrangement.
2. the railway signals equipment image information according to claim 1 based on relevant database converts storage method,
It is characterized by:
In step 2, cut frequency is the transfer function of the low-pass filter of d0 are as follows:
。
3. the railway signals equipment image information according to claim 1 based on relevant database converts storage method,
It is characterized by:
In step 3, applicable image type has: thumbnail, includes image array and color diagram array, binary system figure
Picture, RGB image, gray level image.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910026874.7A CN110427363B (en) | 2019-01-11 | 2019-01-11 | Railway signal equipment image information conversion storage method based on relational database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910026874.7A CN110427363B (en) | 2019-01-11 | 2019-01-11 | Railway signal equipment image information conversion storage method based on relational database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110427363A true CN110427363A (en) | 2019-11-08 |
| CN110427363B CN110427363B (en) | 2023-04-11 |
Family
ID=68408348
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910026874.7A Active CN110427363B (en) | 2019-01-11 | 2019-01-11 | Railway signal equipment image information conversion storage method based on relational database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110427363B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111768312A (en) * | 2020-06-22 | 2020-10-13 | 上海申铁信息工程有限公司 | Building energy consumption monitoring method and device based on railway system data coding |
| CN111907559A (en) * | 2020-06-29 | 2020-11-10 | 中铁第一勘察设计院集团有限公司 | Railway signal train-ground information query display method |
| CN113377867A (en) * | 2021-06-10 | 2021-09-10 | 四川省明厚天信息技术股份有限公司 | Data synchronization method and device and electronic equipment |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2008009135A2 (en) * | 2006-07-21 | 2008-01-24 | Barrodale Computing Services Ltd. | Database adapter for relational datasets |
| CN101609458A (en) * | 2009-07-08 | 2009-12-23 | 北京农业信息技术研究中心 | A kind of digital photo automatic space identification and indexing means |
| CN101911713A (en) * | 2008-09-30 | 2010-12-08 | 松下电器产业株式会社 | Recording medium, reproduction device, system LSI, reproduction method, spectacle, and display device associated with 3D video |
| CN103136445A (en) * | 2013-01-29 | 2013-06-05 | 浙江大学 | Method for converting openEHR information into relational database |
| CN105653569A (en) * | 2014-12-12 | 2016-06-08 | 航天恒星科技有限公司 | Image data expansion processing method and apparatus |
| CN108090281A (en) * | 2017-12-18 | 2018-05-29 | 中国铁路设计集团有限公司 | A kind of railroad track BIM modeling methods based on up to rope V6 systems |
-
2019
- 2019-01-11 CN CN201910026874.7A patent/CN110427363B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2008009135A2 (en) * | 2006-07-21 | 2008-01-24 | Barrodale Computing Services Ltd. | Database adapter for relational datasets |
| CN101911713A (en) * | 2008-09-30 | 2010-12-08 | 松下电器产业株式会社 | Recording medium, reproduction device, system LSI, reproduction method, spectacle, and display device associated with 3D video |
| CN101609458A (en) * | 2009-07-08 | 2009-12-23 | 北京农业信息技术研究中心 | A kind of digital photo automatic space identification and indexing means |
| CN103136445A (en) * | 2013-01-29 | 2013-06-05 | 浙江大学 | Method for converting openEHR information into relational database |
| CN105653569A (en) * | 2014-12-12 | 2016-06-08 | 航天恒星科技有限公司 | Image data expansion processing method and apparatus |
| CN108090281A (en) * | 2017-12-18 | 2018-05-29 | 中国铁路设计集团有限公司 | A kind of railroad track BIM modeling methods based on up to rope V6 systems |
Non-Patent Citations (2)
| Title |
|---|
| 杨万军，孙鲁泉: "基于SQL Server的GSM-R网络质量数据分析***", 《铁路技术创新》 * |
| 马强: "铁路防灾CAD辅助设计软件数据库***设计", 《自动化与仪器仪表》 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111768312A (en) * | 2020-06-22 | 2020-10-13 | 上海申铁信息工程有限公司 | Building energy consumption monitoring method and device based on railway system data coding |
| CN111768312B (en) * | 2020-06-22 | 2023-06-30 | 上海申铁信息工程有限公司 | Building energy consumption monitoring method and device based on railway system data coding |
| CN111907559A (en) * | 2020-06-29 | 2020-11-10 | 中铁第一勘察设计院集团有限公司 | Railway signal train-ground information query display method |
| CN111907559B (en) * | 2020-06-29 | 2022-09-06 | 中铁第一勘察设计院集团有限公司 | Railway signal train-ground information query display method |
| CN113377867A (en) * | 2021-06-10 | 2021-09-10 | 四川省明厚天信息技术股份有限公司 | Data synchronization method and device and electronic equipment |
| CN113377867B (en) * | 2021-06-10 | 2022-10-21 | 四川省明厚天信息技术股份有限公司 | Data synchronization method and device and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110427363B (en) | 2023-04-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110427363A (en) | Railway signals equipment image information based on relevant database converts storage method | |
| CN104362757A (en) | Transformer substation on-line monitoring system based on IEC61850 | |
| CN103826079A (en) | Data management platform | |
| CN108734421A (en) | A kind of Intelligent campus information management platform | |
| CN112184494A (en) | Linkage control method, system and equipment for food sample reservation | |
| CN203149604U (en) | Hand transcriber system for intelligent inspection of industrial equipment | |
| CN109446267B (en) | Cross-database data integration system and method based on 95598 ex-situ double-active disaster recovery model | |
| CN104991929A (en) | Traffic flow data collection method and system | |
| CN110457262A (en) | A kind of archive management system based on big data | |
| CN114152720A (en) | Monitoring platform for carbon emission | |
| CN111507874B (en) | Intelligent campus AIOT big data visualization analysis method | |
| CN110889261A (en) | Method for automating electronic official document service processing | |
| CN112990746A (en) | Cloud platform intelligent management system of inspection and detection mechanism | |
| CN108171487A (en) | A kind of project of transmitting and converting electricity design review system | |
| CN109359202B (en) | Electronic operation and maintenance work order automatic generation method and system based on audio and video recording | |
| CN109408692A (en) | A kind of data archive system based on block chain | |
| CN113626995B (en) | Substation logic model handover method based on digital design | |
| CN110957016B (en) | Physical examination data intelligent identification system and method based on health cloud management platform | |
| CN104732605A (en) | Intelligent attendance system for student management | |
| CN108919695A (en) | A kind of coding method, device, equipment and the storage medium of electrical equipment module | |
| CN106888269A (en) | A kind of meeting summary method for tracing based on electronic whiteboard | |
| CN209248531U (en) | A kind of Digitalization Teaching Materials storage system | |
| CN107705085A (en) | A kind of enterprise employee information management system | |
| CN107682232B (en) | Power grid service flow instance coding method | |
| CN110675948A (en) | Nursing system and monitoring method thereof |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |