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

Heterogeneous database conversion method, apparatus and device, and storage medium

A conversion method and database technology, which is applied in the database field, can solve problems such as fixed and single conversion methods, and the inability to realize mutual conversion of various types of databases, so as to achieve the effect of improving compatibility and flexibility, and improving conversion efficiency

Inactive Publication Date: 2019-07-09
北京启迪区块链科技发展有限公司
View PDF4 Cites 29 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, the database conversion method in the prior art is relatively fixed and single, unable to support multiple types of databases, and unable to realize the mutual conversion of multiple types of databases, and unable to provide independent database conversion services externally, reducing the conversion efficiency of different types of 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
  • Heterogeneous database conversion method, apparatus and device, and storage medium
  • Heterogeneous database conversion method, apparatus and device, and storage medium
  • Heterogeneous database conversion method, apparatus and device, and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0028] figure 1 It is a flow chart of a heterogeneous database conversion method provided by Embodiment 1 of the present invention. This embodiment is applicable to the case of using the database conversion service provided by the heterogeneous database conversion method in this embodiment to convert a database. The method It can be implemented by a heterogeneous database conversion device, which can be implemented in the form of software and / or hardware, as a tool that can independently provide external database conversion services. The method specifically includes the following:

[0029] Step 110, acquiring the DDL statement to be converted and the DML statement to be converted associated with the source data table in the source database.

[0030] In a specific embodiment of the present invention, a database refers to a warehouse for storing data, which is essentially a file system. Data is stored in a specific format, and users can perform operations such as adding, modify...

Embodiment 2

[0043] On the basis of the first embodiment above, this embodiment provides a preferred implementation of the heterogeneous database conversion method, which can convert and insert the source data table into the target database through the converted operation language. Wherein, step 110 may specifically include the following steps 410-430, step 120 may specifically include the following steps 440-450, and step 130 may specifically include the following steps 460-490, Figure 4 It is a flowchart of a heterogeneous database conversion method provided by Embodiment 2 of the present invention, such as Figure 4 As shown, the method includes the following specific:

[0044] Step 410, receiving the connection information of the source database and the name information of the source data table.

[0045] In a specific embodiment of the present invention, the data conversion tool provides an interface for the user to input the connection information of the source database and the indi...

Embodiment 3

[0064] Figure 5 It is a schematic structural diagram of a heterogeneous database conversion device provided by Embodiment 3 of the present invention. This embodiment is applicable to the situation where the database conversion service provided by the heterogeneous database conversion method in this embodiment is used to convert the database. The device The heterogeneous database conversion method described in any embodiment of the present invention can be realized. Specifically, the device includes:

[0065] Source data acquisition module 510, for acquiring the DDL statement to be converted and the DML statement to be converted associated with the source data table in the source database;

[0066] A statement conversion module 520, configured to convert the DDL statement to be converted and the DML statement to be converted into a target DDL statement and a target DML statement conforming to the grammar rules of the target database;

[0067] The target data generation modul...

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 embodiment of the invention discloses a heterogeneous database conversion method apparatus and device and a storage medium. The method comprises the steps of obtaining a to-be-converted DDL statement and a to-be-converted DML statement associated with a source data table in a source database; respectively converting the to-be-converted DDL statement and the to-be-converted DML statement into atarget DDL statement and a target DML statement which conform to a target database grammar rule; and synchronizing the source data table in the target database according to the target DDL statement and the target DML statement to obtain a converted target data table. According to the embodiment of the invention, different types of database operation languages are converted. Mutual conversion between various types of databases can be supported. CAn independent database conversion service is provided outwards so that compatibility and flexibility of database conversion are improved. Limits of database types and conversion directions iare avoided, dual conversion of the source data table, the grammatical rules and the data content of the source database is achieved, and conversion efficiency of the database is improved.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of databases, and in particular, to a heterogeneous database conversion method, device, device and storage medium. Background technique [0002] With the rapid development of database technology, various types of database applications have emerged, and various types of databases use their unique SQL (Structured Query Language, Structured Query Language) language for data collection, storage, operation and dissemination, etc. , the corresponding interaction, sharing and integration between different types of databases has become complex and cumbersome. [0003] Currently, ETL (Extract-Transform-Load, data warehouse technology) tools can be used for database conversion. Among them, each ETL tool implements differently and supports different database types. The ETL tool can be used to convert the database of the database type supported by the ETL tool, by extracting, transposing and ...

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 Applications(China)
IPC IPC(8): G06F16/2453G06F16/25G06F16/27
Inventor 田成权
Owner 北京启迪区块链科技发展有限公司
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