Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Heterogeneous data integration method and device

An integration method and heterogeneous data technology, applied in the field of data communication, can solve the problems of no external network entry, inability to access data, integration and other problems

Inactive Publication Date: 2010-10-20
SHANDONG CVIC SOFTWARE ENG
View PDF3 Cites 16 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] With the intensification of the informatization of pharmaceutical and device enterprises, the various application systems within the pharmaceutical and device enterprises have gradually increased in stages. The overall management of the pharmaceutical and device enterprises needs to integrate the data of the databases under all the application systems of all enterprises. However, due to the network The environment is not interlinked. Pharmaceutical and device companies do not provide access to the external network. The internal network and external network of the database of the Food and Drug Administration are isolated. Integrating different types of data in different databases, that is, heterogeneous data, cannot realize the monitoring of data in all databases, that is, it cannot realize the monitoring of all pharmaceutical and device companies

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
  • Heterogeneous data integration method and device
  • Heterogeneous data integration method and device
  • Heterogeneous data integration method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0026] Firstly, the heterogeneous data integration method provided by the embodiment of the present invention is described. The flow chart of the method is as follows figure 1 shown, including:

[0027] S101: Obtain data in a database corresponding to a preset upload task.

[0028] Due to the different application systems used by drug device companies, the databases used are different. For example, two drug device companies use Oracle and DB2 databases respectively. Due to the different types of databases and the different data structures in them, the database used by the Food and Drug Administration is the most It is the same database used by one of the drug and device companies. Therefore, under the premise that the drug regulatory bureau and the drug and device company are connected to each other, the drug regulatory bureau can only monitor one drug and device company. In order to realize the network interoperability between the Food and Drug Administration and the pharmac...

Embodiment 2

[0044] Steps S101, S102, and S104 of this embodiment are the same as those of S101, S102, and S104 of Embodiment 1. The difference between the two embodiments is that the method of uploading the XML file is based on the maximum ID number. As mentioned above, the XML file includes the maximum ID number data field identifier, and each enterprise needs to upload at least one task each time, then the maximum ID number of the uploaded task this time is the maximum ID number of the last successfully uploaded task and the maximum ID number of this uploaded task. The sum of the number of tasks, for example: the last maximum ID number of company A is 10, and the number of upload tasks this time is 5, that is, 5 upload tasks must be completed, then the maximum ID number of this upload task is 15, that is, this time The maximum ID number in the five XML files converted by the pharmaceutical device company based on the data obtained by the upload task is 15. When the Food and Drug Adminis...

Embodiment 3

[0058] There are a large number of pharmaceutical and device companies in the jurisdiction of the Food and Drug Administration, and a large amount of data is involved every day. Therefore, this embodiment can not only realize the monitoring of data, but also analyze and process the data, so as to better realize the monitoring of data. Its flow chart is as Figure 4 shown, including:

[0059] S301: Configure the execution time according to the minimum upload time granularity; the execution time includes: upload task release time, file analysis time, analysis file deletion time, data transfer time, historical data clearing time and data sorting time;

[0060] The execution time is configured through the preset configuration file quarta-reminder.xml according to the minimum upload time granularity of one second of the application system used by the external network server of the Food and Drug Administration. For example: 7:00 to 8:00 every day is set as the upload task release t...

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 heterogeneous data integration method and a heterogeneous data integration device. The heterogeneous data integration method comprises the following steps: acquiring data in a database corresponding to a predetermined upload task; converting the acquired data into an XML file in a predetermined format; uploading the XML file to an out-server; and storing the XML file in an integrated database of a medicament supervisory bureau by using the out-server, wherein the upload task comprises at least one of medicament purchase, medicament stock, medicament sale, medical equipment purchase, medical equipment sale, medical equipment storage, unqualified medicament, medical equipment stock and medical equipment use. Due to the application of the technical scheme, the network intercommunication of the medicament supervisory bureau and a medical equipment enterprise and the integration of heterogeneous data are realized, namely the integration of different types of data in different types of databases used by all medical equipment enterprises is realized; and the integrated database is stored in a server used by the medicament supervisory bureau so as to realize the monitoring of the data, namely realize the monitoring of all of the medical equipment enterprises.

Description

technical field [0001] The present invention relates to the technical field of data communication, in particular to a heterogeneous data integration method and device. Background technique [0002] With the intensification of the informatization of pharmaceutical and device enterprises, various application systems within the pharmaceutical and device enterprises are gradually increasing. The environment is not connected. Pharmaceutical and device companies do not provide access to the external network. The internal network of the database of the Food and Drug Administration is isolated from the external network. Integrating different types of data in different databases, that is, heterogeneous data, cannot realize the monitoring of data in all databases, that is, it cannot realize the monitoring of all pharmaceutical and device companies. Contents of the invention [0003] In view of this, the purpose of the present invention is to provide a heterogeneous data integration...

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
IPC IPC(8): G06F17/30G06Q50/00G06Q50/22
Inventor 商亮岳岩孙呈梅
Owner SHANDONG CVIC SOFTWARE ENG
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com