Heterogeneous Database Integration Method Based on Configurable Template

A technology for configuring templates and integration methods, which is applied in structured data retrieval, database management systems, and electronic digital data processing. Issues such as configuration flexibility and integration depth achieve the effect of improving practicability and stability and overcoming information redundancy

Active Publication Date: 2018-05-08
BEIJING INSTITUTE OF TECHNOLOGYGY
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The purpose of the present invention is to overcome the defects of the prior art and solve the problem that the integrated retrieval platform cannot take into account the flexibility of configuration and the depth of integration, so that the openness of the integrated platform and the degree of integration of resources are difficult to meet the needs of users. A Heterogeneous Database Integration Method Based on Templates

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 Database Integration Method Based on Configurable Template
  • Heterogeneous Database Integration Method Based on Configurable Template
  • Heterogeneous Database Integration Method Based on Configurable Template

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] (1) Construction process of configurable knowledge template

[0028] The construction of configurable knowledge template involves three elements: basic information of data source, knowledge organization structure and knowledge template. The basic information of the data source includes the type of each database to be integrated (Oracle, Mysql, SQLServer, etc.), URL, user name, password, etc. This method will set the corresponding link method according to the different types of databases. The knowledge organization structure refers to reading the data structure of each database, intercepting part of the information, reorganizing according to user needs, and organizing it into a new knowledge structure. Knowledge templates refer to templates generated from the template attribute type table configuration according to the knowledge organization structure, and are used to display the integrated knowledge content and structure to users. The construction rules of these templat...

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 present invention solves the problem that an integrated retrieval platform cannot take account of both configuration flexibility and integrating depth, so that the openness of the integrated platform and the integrating degree of resources are difficult to meet user requirements, and provides a heterogeneous database integrating method based on configurable templates. The method comprises the steps of: 1, inputting basic information of data sources to be integrated, newly creating knowledge templates, configuring incidence relation of each field in the data sources, and forming new knowledge organization structures; 2, matching attribute types for each field in the newly created knowledge templates so as to form a showing interfaces of the knowledge templates; and 3, carrying out cross-database retrieval on an index table of each knowledge template, returning a retrieval list, carrying out depth retrieval, on the basis of click of a user and according to the organization structure of the knowledge template to which entries belong, and expressing details by using the appertaining knowledge template as a carrier.

Description

technical field [0001] The invention belongs to the technical field of knowledge management and data integration, and relates to a heterogeneous database integration method based on a configurable template. Background technique [0002] With the advent of the era of big data and the in-depth development of the knowledge economy, enterprises, research institutes and other research and development and production institutions pay more and more attention to the management of knowledge, implement a lot of information software, and generate a large amount of data, which are stored in different in the database. However, knowledge that is relatively independent and lacks organization is difficult to exert its full value, so it is necessary to integrate these resources effectively through the integration of heterogeneous databases. [0003] These databases have the characteristics of system heterogeneity and structure heterogeneity, and are called heterogeneous databases. Conventio...

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/25
Inventor 郝佳阎艳徐哲赢明振军
Owner BEIJING INSTITUTE OF TECHNOLOGYGY
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