A Method of Data Format Conversion Between Heterogeneous Database Systems

A data format conversion, database technology, applied in the computer field

Active Publication Date: 2018-03-27
WUHAN IRON & STEEL ENG TECH GROUP
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, for special instrument systems without OPC standard interface (such as IBA database), how to realize data sharing between heterogeneous database systems, there is a problem of data exchange between heterogeneous databases

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A Method of Data Format Conversion Between Heterogeneous Database Systems
  • A Method of Data Format Conversion Between Heterogeneous Database Systems
  • A Method of Data Format Conversion Between Heterogeneous Database Systems

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0019] The present invention will be described in further detail below in conjunction with the specific embodiments of the accompanying drawings.

[0020] The specific embodiment of the present invention takes a certain IBA database as an example, and illustrates that the specific operation steps of data format conversion between the IBA database and the PI real-time database are as follows:

[0021] 1. Before data format conversion, the following work has been completed:

[0022] The network communication between the IBA database and the interface machine and the PI real-time database is normal;

[0023] The station number that is written to the PI real-time database after conversion has been defined. (Here take TAG0, TAG1, TAG2, TAG3 as an example)

[0024] 2. Install the necessary hardware devices for exporting PDA files in the IBA database on the interface machine, and establish figure 1 As shown in the data acquisition template, it is assumed that channel number 1:7 co...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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 [0001] The invention relates to a data format conversion method between heterogeneous database systems, and belongs to the technical field of computers. Background technique [0002] The production process quality monitoring system in the iron and steel production industry is a quality management platform developed based on the PI real-time database system. It is a bridge connecting the bottom control network of the factory with the upper management information system. Analyzing data first requires a data source, and the PI real-time database system provides support for OPC, which can facilitate data collection for those systems that have an open OPC standard interface. As for the special instrument system without OPC standard interface (such as IBA database), how to realize data sharing between heterogeneous database systems, there is a problem of data exchange between heterogeneous databases. Contents of the invention [0003] The technical problem to be...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/1794G06F16/258
Inventor 谢勤何洁陈睿汪淼姚平占友元
Owner WUHAN IRON & STEEL ENG TECH GROUP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap