CN104615630A - Data format conversion method between isomerous database systems - Google Patents
Data format conversion method between isomerous database systems Download PDFInfo
- 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
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/17—Details of further file system functions
- G06F16/178—Techniques for file synchronisation in file systems
- G06F16/1794—Details of file format conversion
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data 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
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.
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)
| 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)
| 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 |
-
2014
- 2014-10-27 CN CN201410584236.4A patent/CN104615630B/en active Active
Patent Citations (5)
| 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)
| 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 |