The equipment, system, method and storage medium for mysql aggregation into postgresql database

A database and device technology, applied in the PostgreSQL field, can solve problems such as high error rate, inability to run OLAP scenarios directly, and low efficiency of multiple union online queries in SQL language

Active Publication Date: 2022-06-21
WUHAN DOUYU NETWORK TECH CO LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] The present invention aims to solve the above-mentioned problems that the above-mentioned relational database cannot directly run the SQL language in the OLAP scene of processing massive data after sub-database and sub-table, and the efficiency of multiple union online queries is not high, and the error rate is high. The purpose is to provide A kind of equipment, system, method and storage medium based on MMR optimized MySQL aggregated into PostgreSQL database

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
  • The equipment, system, method and storage medium for mysql aggregation into postgresql database
  • The equipment, system, method and storage medium for mysql aggregation into postgresql database
  • The equipment, system, method and storage medium for mysql aggregation into postgresql database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0058] In order to make the technical means, creation features, goals and effects realized by the present invention easy to understand, the following embodiments describe the device, system, method and storage medium composition, structure, The connection relationship, the specific workflow, and the working principle, function and effect are explained in detail.

[0059] figure 1 A block diagram of a system that aggregates a MySQL database into a PostgreSQL database.

[0060] like figure 1 As shown, in this embodiment, the system 1000 that aggregates the MySQL database into a PostgreSQL database has at least one MySQL device running MySQL and at least one PostgreSQL device running PostgreSQL, and the device 100 that aggregates the MySQL database into a PostgreSQL database may be a certain one A MySQL device, or a PostgreSQL device.

[0061] The MySQL device and the PostgreSQL device are connected via a communication network 200, which is a local area network, a wide area ne...

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 MySQL database is aggregated into a PostgreSQL database device, which is used to aggregate the source-side MySQL database into a target-side PostgreSQL database after sub-databases. It is characterized in that it includes: a pre-setting part; a multi-source asynchronous replication part; Aggregation Department; Data Extraction Department; Full Volume Synchronization Department; SQL Statement Generation Department; Data Consistency Verification Department. The present invention aggregates the MySQL databases or tables after sub-databases and sub-tables into PostgreSQL, so that MySQL databases that have adopted the relational database management system can be aggregated and converted into PostgreSQL databases, so that the query performance of the database in OLAP situations is better than that of the original The performance of MySQL database on OLAP is improved several times. The PostgreSQL aggregate library is obtained by aggregating the data (library) of the sub-database and sub-table. In this way, only one library needs to be queried and the query code of one library needs to be written, so the writing time of the query code can also be saved, and the operation is simple and convenient. Smooth use for database administrators.

Description

technical field [0001] The invention relates to the field of database conversion, in particular to a device, method and system for converting MySQL database aggregation into PostgreSQL. Background technique [0002] Today's data processing can be roughly divided into two categories: online transaction processing OLTP (on-line transaction processing), online analytical processing OLAP (On-Line Analytical Processing). OLTP is the main application of traditional relational databases, mainly for basic, daily transaction processing, such as bank transactions. OLAP is the main application of database systems, supporting complex analysis operations, focusing on decision support, and providing intuitive and easy-to-understand query results. [0003] Specifically, OLTP, also known as transaction-oriented processing system, its basic feature is that the customer's raw data can be immediately transmitted to the computing center for processing, and the processing result is given in a v...

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): G06F16/25G06F16/28
Inventor 陈阳张文明陈少杰
Owner WUHAN DOUYU NETWORK 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