Check patentability & draft patents in minutes with Patsnap Eureka AI!

Data synchronization method, device and equipment for relational database and data warehouse

A data warehouse and data synchronization technology, applied in relational databases, database updates, database models, etc., can solve problems such as unsatisfactory needs

Pending Publication Date: 2020-02-18
北京淇瑀信息科技有限公司
View PDF5 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

At present, a period of time is often reserved for data synchronization between the database and the data warehouse during the period of less daily business processing. However, with the improvement of real-time data requirements for many business data, the current practice can no longer meet the requirements. need

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
  • Data synchronization method, device and equipment for relational database and data warehouse
  • Data synchronization method, device and equipment for relational database and data warehouse
  • Data synchronization method, device and equipment for relational database and data warehouse

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040]Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments, however, can be embodied in various forms and should not be construed as limited to the embodiments set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the concept of example embodiments to those skilled in the art. The same reference numerals in the drawings denote the same or similar parts, and thus their repeated descriptions will be omitted.

[0041] Furthermore, the described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided in order to give a thorough understanding of embodiments of the present disclosure. However, those skilled in the art will appreciate that the technical solutions of the present disclosure may be practiced without one or ...

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 a data synchronization method and device for a relational database and a data warehouse, electronic equipment and a computer readable medium. The method comprises the steps ofobtaining a binary log file from a relational database in real time; analyzing the binary log file to generate a plurality of data updating records; respectively transmitting the plurality of data updating records to a plurality of partitions of a distributed message publishing and subscribing system; generating a synchronization task according to the data updating record; and synchronizing the plurality of data updating records into a data warehouse according to the synchronization task. According to the data synchronization method and device for the relational database and the data warehouse, the electronic equipment and the computer readable medium, data in the relational database can be updated into the data warehouse in real time, so that business personnel can analyze and process the data conveniently.

Description

technical field [0001] The present disclosure relates to the field of computer information processing, in particular, to a data synchronization method, device, electronic equipment and computer-readable medium for relational databases and data warehouses. Background technique [0002] A relational database refers to a database that uses a relational model to organize data. It stores data in the form of rows and columns for easy understanding by users. The series of rows and columns of a relational database are called tables, and a group of tables consists of up the database. A user retrieves data in a database through a query, which is an executable code used to limit certain areas in the database. Data warehouse, the English name is Data Warehouse, which can be abbreviated as DW or DWH. A data warehouse is a strategic collection that provides support for all types of data for decision-making processes at all levels of an enterprise. It is a single data store created for ...

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/28G06F16/27G06F16/23
CPCG06F16/284G06F16/283G06F16/27G06F16/235
Inventor 张超曾勇平王安滨常富洋
Owner 北京淇瑀信息科技有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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