Heterogeneous database building method, device and equipment and readable storage medium

A database and data technology, applied in the field of communication, can solve the problems of uncommon use, heavy workload, and high degree of code coupling

Pending Publication Date: 2020-06-05
CHINA UNITED NETWORK COMM GRP CO LTD
View PDF5 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The present disclosure provides a method, device, equipment, and computer-readable storage medium for buil...

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 building method, device and equipment and readable storage medium
  • Heterogeneous database building method, device and equipment and readable storage medium
  • Heterogeneous database building method, device and equipment and readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0045] In the data synchronization process of the customer service system, the data is written into the database and the target database at the same time, and the business program is embedded in the database and the target database at the same time. When the data is updated or changed, it is necessary to change the business program of the database and the target database to realize the data Synchronization, this method has a very high degree of code coupling and a lot of work.

[0046] Aiming at the problem of high coupling degree of database codes and heavy workload of staff, this application proposes a solution for building a heterogeneous database, which synchronizes data sources to Kafka through DTS, stores data in ElasticSearch through Kafka, and implements heterogeneous database construction. The effect of building a heterogeneous database through DTS, Kafka, and ElasticSearch.

[0047] figure 1 It is a flowchart of a method for building a heterogeneous database accordi...

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 provides a heterogeneous database building method, device and equipment and a readable storage medium, and the method comprises the steps: obtaining to-be-synchronized data, wherein theto-be-synchronized data comprises the business data and/or log files of at least one database; synchronizing the to-be-synchronized data to a data transfer station; and synchronizing the to-be-synchronized data in the data transfer station to a target database. According to the method, the device, the equipment and the computer readable storage medium provided by the invention, the heterogeneous database synchronization process is simplified, and a heterogeneous database architecture which is relatively universal and relatively low in code coupling degree is established.

Description

technical field [0001] The present disclosure relates to the technology of building a database, in particular to a technology of building a heterogeneous database, which belongs to the communication field. Background technique [0002] A heterogeneous database system is a collection of related multiple database systems, which can realize data sharing and transparent access. Several database systems already existed before joining the heterogeneous database system. Each database system has its own application characteristics, complete sex controls and security controls. [0003] The existing customer service system implements heterogeneous databases through synchronous operations, directly updates business data in the database, and transmits the content in the database to ElasticSearch. [0004] However, the efficiency of this method is too low. Every time the database is changed, the code needs to be modified, and the code coupling is very high; and a manual "translation" op...

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/178G06F16/18G06F16/182G06F16/27
CPCG06F16/178G06F16/1815G06F16/182G06F16/27
Inventor 于向丽刘金财薄涛
Owner CHINA UNITED NETWORK COMM GRP 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