Automatic mapping table building method for heterogeneous database

An automatic mapping and database technology, applied in the computer field, can solve problems such as time-consuming and low efficiency

Pending Publication Date: 2021-05-14
SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
View PDF5 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The steps are extremely time-con

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
  • Automatic mapping table building method for heterogeneous database
  • Automatic mapping table building method for heterogeneous database
  • Automatic mapping table building method for heterogeneous database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] In order to enable those skilled in the art to better understand the solutions of the present invention, the present invention will be further described in detail below in conjunction with specific embodiments. Apparently, the described embodiments are only some of the embodiments of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts fall within the protection scope of the present invention.

[0029] A preferred embodiment is given below:

[0030] When modeling heterogeneous databases, the most important thing is the mapping of field types such as tables. Traditional data integration systems usually adopt the following mapping strategy for the mapping of heterogeneous database field types:

[0031] (1) Determine the source database table structure, specify the data table, the fields in the table and the data types of each f...

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 relates to the field of computers, and particularly provides an automatic mapping table building method for aheterogeneous database. The methodcomprises the following steps: S1, determining a mapping relationship between different database field types and JDBC standard types; S2, obtaining a table structure of an original table, fields in the table and data types of the fields, and mapping the table structure of the original table to the JDBC standard type according to the mapping relation determined in the step S1; and S3, according to the target table type and the mapping relationship determined in the step S1, mapping the JDBC standard type to a specific database field type, and generating a corresponding target table SQL statement according to the mapped table structure. Compared with the prior art, the method has the advantages that the table can be automatically established, the complexity of establishing the heterogeneous database model is reduced, the efficiency is improved, and the method has a high popularization value.

Description

technical field [0001] The invention relates to the field of computers, and specifically provides a method for automatically mapping tables of heterogeneous databases. Background technique [0002] With the rapid development of modern information technology, the world has entered the era of Internet + big data, and the rapid development of artificial intelligence technology is also the result of the rapid development of big data in recent years. Information is profoundly changing people's thinking, production, and lifestyle. More and more industries are beginning to pay attention to data and use data to empower businesses. In recent years, various enterprise data governance application platforms have emerged and developed rapidly, providing one-stop services such as data integration, data development, data science, data governance, data services, and data visualization. [0003] In the processing of big data platforms, how to provide high-speed and stable data migration bet...

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): G06F16/28G06F40/18
CPCG06F16/284G06F40/18
Inventor 王楠楠王庆明李国涛胡清
Owner SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
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