CN104615630A - Data format conversion method between isomerous database systems - Google Patents

Data format conversion method between isomerous database systems Download PDF

Info

Publication number
CN104615630A
CN104615630A CN201410584236.4A CN201410584236A CN104615630A CN 104615630 A CN104615630 A CN 104615630A CN 201410584236 A CN201410584236 A CN 201410584236A CN 104615630 A CN104615630 A CN 104615630A
Authority
CN
China
Prior art keywords
file
database
iba
data
real
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
Application number
CN201410584236.4A
Other languages
Chinese (zh)
Other versions
CN104615630B (en
Inventor
谢勤
何洁
陈睿
汪淼
姚平
占友元
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Baoxin Software Wuhan Co ltd
Original Assignee
Wuhan Iron and Steel Group Corp
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Wuhan Iron and Steel Group Corp filed Critical Wuhan Iron and Steel Group Corp
Priority to CN201410584236.4A priority Critical patent/CN104615630B/en
Publication of CN104615630A publication Critical patent/CN104615630A/en
Application granted granted Critical
Publication of CN104615630B publication Critical patent/CN104615630B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/10File systems; File servers
    • G06F16/17Details of further file system functions
    • G06F16/178Techniques for file synchronisation in file systems
    • G06F16/1794Details of file format conversion
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25Integrating or interfacing systems involving database management systems
    • G06F16/258Data format conversion from or to a database

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a data format conversion method between isomerous database systems. The method comprises the following steps that 1, network communication among an IBA database, an interface machine and a PI real-time database is set up, and a station number written in the PI real-time database after being converted is defined; 2, a collecting period is set for data of PDA files needing to be collected in the IBA database according to a temporal mode, and a data collecting template is built; 3, a file directory of reading the PDA files in the IBA database is set in IBA datcoordinator software, a file directory where text files are stored is guided out, and the data needing to be collected are converted into the text files; 4, an installation directory of an IBA database file conversion function service program is set up; 5, the text files are converted into text files capable of being recognized by a PI-batch file interface of the PI real-time database, and the final files are transmitted to an output directory and written in the PI real-time database. Through data format conversion between an IBA server and the PI real-time database, data sharing between the isomerous database systems is achieved.

Description

The method of Data Format Transform between heterogeneous database system
Technical field
The present invention relates to the method for Data Format Transform between heterogeneous database system, belong to field of computer technology.
Background technology
The production run Quality Monitoring Control System of steel production industry is the quality management platform based on the exploitation of PI real-time dataBase system, and it is the bridge that factory's bottom control network is connected with tension management infosystem.Analyze data and first need Data Source, PI real-time dataBase system provides the support to OPC, and this has the system of open OPC standard interface can realize data acquisition easily for those.And for there is no the special instrument system (such as IBA database) of OPC standard interface, how to realize the data sharing between heterogeneous database system, just there is the problem that data among heterogeneous databases exchanges.
Summary of the invention
Technical matters to be solved by this invention is to provide the method for Data Format Transform between a kind of heterogeneous database system, the file storing directory of IBA database is monitored with fixed cycle, data in IBA database are converted to the text formatting that PI real time data bank interface PI-BATCHFile interface can identify, be written in PI real-time data base, and the file after translates data formats is moved to output directory from working directory, realize the data sharing between heterogeneous database system.
For solving the problems of the technologies described above, the technical scheme designed by the present invention comprises the following steps:
I, set up network communication between IBA database and interface message processor (IMP) and PI real-time data base, the station number of write PI real-time data base after definition conversion;
II, interface message processor (IMP) installed derive the hardware unit that in IBA database, PDA file is required, and by the data in the PDA file needing in IBA database to gather temporally pattern collection period is set, set up data acquisition masterplate;
III, arrange in IBAdatcoordinator software and read file directory that in IBA database, PDA file is deposited and derive the file directory that text deposits, by the hardware unit that PDA file in IBAdatcoordinator software and derivation IBA database is required, read the PDA file in IBA database successively, the data that need gather change into text in a time-sequential manner according to the order of the data acquisition masterplate set up in Step II, leave in the file on interface message processor (IMP), and be A file by this file folder definition; Text file format with the collection period set in data acquisition masterplate as the time interval, apportion display image data, namely first of text acquisition time is classified as, second is classified as the value of first data acquisition target at corresponding time point, 3rd is classified as the value of second data acquisition target at corresponding time point, the like, until last data acquisition object;
The installation directory of IV, establishment IBA database file conversion function service routine, under copying files to this catalogue of establishment, the file that IBA database file conversion function service routine uses comprises:
Convertto_pibf.ini: system environments configuration file;
The executable program of Convertto_pibf.exe:IBA database file conversion function.
The executable program of InputUtil.exe: registration Convertto_pibf.exe to Windows service managerZ-HU;
V, Convertto_pibf.exe coupling system environment profile Convertto_pibf.ini, A file is monitored with the form fixed cycle of windows service, the text that PI-batchflie interface text being converted to real-time data base PI can identify, definitive document is moved to output directory, and this output directory is defined as B file;
PI-Batchflie interface interface routine, by the data of B file Chinese version file write PI real-time data base, can realize the collection of IBA database data.
The method of Data Format Transform between heterogeneous database system of the present invention, take VB.NET as developing instrument, the interface software of soft and hardware device and PI real-time data base is derived in conjunction with IBA database data, achieve the Data Format Transform between IBA server and PI real-time data base, providing a kind of optional method for gathering IBA database data, the Data Format Transform between other heterogeneous databases also being had to the meaning of reference.
Accompanying drawing explanation
What Fig. 1 illustrated is that IBA server data gathers masterplate.
Fig. 2 signal be the data layout of the text that IBA server is derived according to data acquisition masterplate.
What Fig. 3 illustrated is file transform function service routine system environments configuration file.
What Fig. 4 illustrated is the text data layout after conversion.
Embodiment
Below in conjunction with accompanying drawing embodiment, the present invention is further detailed explanation.
The specific embodiment of the present invention, for certain IBA database, illustrates that the concrete operation step of Data Format Transform between IBA database and PI real-time data base is as follows:
1, before Data Format Transform, following work completes:
Network communication between IBA database and interface message processor (IMP) and PI real-time data base is normal;
The station number of write PI real-time data base after defined conversion.(here with TAG0, TAG1, TAG2, TAG3 for example)
2, the hardware unit that in derivation IBA database, PDA file is required is installed on interface message processor (IMP), and the data acquisition masterplate set up as shown in Figure 1, wherein suppose the data of the corresponding TAG0 of channel number 1:7, the data of the corresponding TAG1 of 4:30, the data of the corresponding TAG2 of channel number 4:31, the data of the corresponding TAG3 of channel number 5:16, SIZE and MODE can be used for the sampling period (i.e. collection period) that setting data gathers, and in this embodiment, collection period is temporal mode.
3, arrange in IBAdatcoordinator software and read file directory that in IBA database, PDA file is deposited and derive the file directory that text deposits, by the hardware unit that PDA file in IBAdatcoordinator software and derivation IBA database is required, read the PDA file in IBA database successively, the data that need gather change into text in a time-sequential manner according to the order of data acquisition masterplate, leave in (this file folder definition is A file) in a file of interface message processor (IMP); Text file format is shown in Fig. 2.What wherein first row was corresponding is acquisition time, can find out that text is the data derived according to time series.What secondary series was corresponding is the data of storing in IBA database in passage 1:7, in like manner the 3rd row, the 4th row, and the 5th row are corresponding is respectively channel number 4:30 in IBA database, the data of 4:31,5:16 storage.
4, create the installation directory of IBA database file conversion function service routine, the file that this IBA database file conversion function service routine uses comprises:
ConvertTo_pibf.ini: system environments configuration file, service routine is run the parameter used and is set by this configuration file, comprise IBA database PDA convert file storing path, the storing path of the text that the PI-batchflie interface interface of the real-time data base PI of generation can identify after transforming, the work station point title of the PI corresponding with the image data that the data acquisition masterplate set up in Step II sets, service routine reads the time interval of IBA database PDA convert file;
ConvertTo_pibf.exe: service routine installation file, the i.e. executable program of IBA database file conversion function.
The executable program of InputUtil.exe: registration ConvertTo_PiBF.exe to Windows service managerZ-HU.
By above-mentioned file copy under the installation directory created, the configuration file of configuration system environments as shown in Figure 3.
5, Convertto_pibf.exe (this program is that developing instrument is worked out with VB.NET) coupling system environment profile ConvertTo_pibf.ini, A file is monitored with the form fixed cycle of windows service, the text that PI-batchflie interface text being converted to real-time data base PI can identify, moves to output directory (referred to as B) by definitive document.The text data layout that PI-batchflie interface can identify as shown in Figure 4.
The data (data layout after conversion is shown in Fig. 4) of B file Chinese version file write in PI real-time data base by PI-Batchflie interface interface routine, achieve the collection of IBA database data.

Claims (1)

1. the method for Data Format Transform between heterogeneous database system, is characterized in that: the method comprises the following steps:
I, set up network communication between IBA database and interface message processor (IMP) and PI real-time data base, the station number of write PI real-time data base after definition conversion;
II, interface message processor (IMP) installed derive the hardware unit that in IBA database, PDA file is required, and by the data in the PDA file needing in IBA database to gather temporally pattern collection period is set, set up data acquisition masterplate;
III, arrange in IBAdatcoordinator software and read file directory that in IBA database, PDA file is deposited and derive the file directory that text deposits, by the hardware unit that PDA file in IBAdatcoordinator software and derivation IBA database is required, read the PDA file in IBA database successively, the data that need gather change into text in a time-sequential manner according to the order of the data acquisition masterplate set up in Step II, leave in the file on interface message processor (IMP), and be A file by this file folder definition; Text file format with the collection period set in data acquisition masterplate as the time interval, apportion display image data, namely first of text acquisition time is classified as, second is classified as the value of first data acquisition target at corresponding time point, 3rd is classified as the value of second data acquisition target at corresponding time point, the like, until last data acquisition object;
The installation directory of IV, establishment IBA database file conversion function service routine, under copying files to this catalogue of establishment, the file that IBA database file conversion function service routine uses comprises:
Convertto_pibf.ini: system environments configuration file;
The executable program of Convertto_pibf.exe:IBA database file conversion function.
The executable program of InputUtil.exe: registration Convertto_pibf.exe to Windows service managerZ-HU;
V, Convertto_pibf.exe coupling system environment profile Convertto_pibf.ini, A file is monitored with the form fixed cycle of windows service, the text that PI-batchflie interface text being converted to real-time data base PI can identify, definitive document is moved to output directory, and this output directory is defined as B file;
PI-Batchflie interface interface routine, by the data of B file Chinese version file write PI real-time data base, can realize the collection of IBA database data.
CN201410584236.4A 2014-10-27 2014-10-27 The method of Data Format Transform between heterogeneous database system Active CN104615630B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201410584236.4A CN104615630B (en) 2014-10-27 2014-10-27 The method of Data Format Transform between heterogeneous database system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201410584236.4A CN104615630B (en) 2014-10-27 2014-10-27 The method of Data Format Transform between heterogeneous database system

Publications (2)

Publication Number Publication Date
CN104615630A true CN104615630A (en) 2015-05-13
CN104615630B CN104615630B (en) 2018-03-27

Family

ID=53150076

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201410584236.4A Active CN104615630B (en) 2014-10-27 2014-10-27 The method of Data Format Transform between heterogeneous database system

Country Status (1)

Country Link
CN (1) CN104615630B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108984603A (en) * 2018-06-05 2018-12-11 试金石信用服务有限公司 Isomeric data acquisition method, equipment, storage medium and system

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050240586A1 (en) * 2004-04-21 2005-10-27 Shimadzu Corporation Data processing system for instrumental analysis, server and data processing method
CN103092980A (en) * 2013-01-31 2013-05-08 中国科学院自动化研究所 Method and system of data automatic conversion and storage
US20130117330A1 (en) * 2011-11-07 2013-05-09 International Business Machines Corporation Retaining corporate memory
CN103809946A (en) * 2012-11-09 2014-05-21 镇江华扬信息科技有限公司 Method for integrating heterogeneous database based on XML (extensible markup language) and middleware
CN104111834A (en) * 2014-07-07 2014-10-22 北京京东尚科信息技术有限公司 Method and device for exchanging data between heterogeneous databases

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050240586A1 (en) * 2004-04-21 2005-10-27 Shimadzu Corporation Data processing system for instrumental analysis, server and data processing method
US20130117330A1 (en) * 2011-11-07 2013-05-09 International Business Machines Corporation Retaining corporate memory
CN103809946A (en) * 2012-11-09 2014-05-21 镇江华扬信息科技有限公司 Method for integrating heterogeneous database based on XML (extensible markup language) and middleware
CN103092980A (en) * 2013-01-31 2013-05-08 中国科学院自动化研究所 Method and system of data automatic conversion and storage
CN104111834A (en) * 2014-07-07 2014-10-22 北京京东尚科信息技术有限公司 Method and device for exchanging data between heterogeneous databases

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108984603A (en) * 2018-06-05 2018-12-11 试金石信用服务有限公司 Isomeric data acquisition method, equipment, storage medium and system

Also Published As

Publication number Publication date
CN104615630B (en) 2018-03-27

Similar Documents

Publication Publication Date Title
CN108052681B (en) Method and system for synchronizing structured data between relational databases
CN106933206B (en) Source independent queries in distributed industrial systems
CN106933208B (en) Distributed industrial performance monitoring and analysis
CN100589418C (en) The generation method and the generation system of alarm correlation rule
CN113009889A (en) Distributed industrial performance monitoring and analysis platform
CN104090889A (en) Method and system for data processing
CN102752294B (en) Method and system for synchronizing data of multiple terminals on basis of equipment capacity
CN109634970A (en) Table method of data synchronization, equipment, storage medium and device
CN107944005B (en) Data display method and device
CN103927314A (en) Data batch processing method and device
CN102984325A (en) System and method for integrating mobile phone test data
CN103914307A (en) Interactive-interface fast implementation method based on reusable library
CN103297561B (en) IP address source tracing method and device
CN105159831A (en) Method for automatically monitoring quality of software code
CN105637488A (en) Tracing source code for end user monitoring
CN110858125B (en) Industrial data acquisition and storage method and system for numerical control system
CN105279285A (en) Synchronization system and method of relation-type database and non-relation-type database
EP2897401A1 (en) Method and device for guaranteeing consistency of planning data
CN114610588A (en) Database performance analysis method and device, electronic equipment and storage medium
Ahrabian et al. Data analysis as a web service: A case study using IoT sensor data
CN104657437A (en) Monitoring method and monitoring device for promotion status data
CN103942311A (en) Multiplexing method of monitoring system variables
CN104615630A (en) Data format conversion method between isomerous database systems
Lourenço et al. An online transparency for accountability maturity model
CN103955192B (en) A kind of curve form data sampling method for sewage work

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant
TR01 Transfer of patent right

Effective date of registration: 20180404

Address after: 430000 Wuhan City, Hubei Qingshan District thirty Street (No. 6 metallurgical Road)

Patentee after: Wuhan test, Engineering Technology Co. Ltd.

Address before: 430080 Wuchang, Hubei Friendship Road, No. A, block, floor 999, 15

Patentee before: Wuhan Iron & Steel (Group) Corp.

TR01 Transfer of patent right
TR01 Transfer of patent right

Effective date of registration: 20210813

Address after: 430084 floor 15-22, building 4, Wuhan International Steel Logistics Service Center (Ganggu), Qingshan Town, Qingshan District, Wuhan City, Hubei Province

Patentee after: Baoxin software (Wuhan) Co.,Ltd.

Address before: 430000 30 Jiefang, Qingshan District, Wuhan City, Hubei Province

Patentee before: WUHAN KAOKELIER ENGINEERING TECHNOLOGY Co.,Ltd.

TR01 Transfer of patent right