Technology of utilizing Apriori algorithm to carry out intelligent grouping optimization on parallel database storage in real-time increment replication software of database

A technology of incremental replication and database, which is applied in database distribution/replication, special data processing applications, electronic digital data processing, etc., and can solve problems such as unretrieved solutions and system implementation

Inactive Publication Date: 2017-11-21
邓方 +1
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] At present, the relevant field has not yet retrieved the same solution and system implementation as the present invention

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
  • Technology of utilizing Apriori algorithm to carry out intelligent grouping optimization on parallel database storage in real-time increment replication software of database
  • Technology of utilizing Apriori algorithm to carry out intelligent grouping optimization on parallel database storage in real-time increment replication software of database
  • Technology of utilizing Apriori algorithm to carry out intelligent grouping optimization on parallel database storage in real-time increment replication software of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0010] During normal operation, the replication software collects corresponding performance statistical information, such as transaction numbers and table names contained in each transaction, and saves them in the transaction record table.

[0011] The basic content of the transaction record table is shown in the following table:

[0012]

[0013] After accumulating enough performance statistics data, use the Apriori algorithm to calculate the probability that different tables appear in the same transaction at the same time. According to the preset minimum support MinSup, filter out the table sets whose probability of appearing in a transaction at the same time is greater than the minimum support. If the analysis result is not ideal, you can adjust the minimum support and recalculate.

[0014] By default, the Apriori algorithm starts calculation from the size of the entire data set, which in this patent application is the number of all data tables participating in the repl...

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 discloses a technology of utilizing an Apriori algorithm to carry out optimization parallel database storage efficiency in a database replication environment. Sets of tables with high relevance, namely the table sets, are found through carrying out Apriori relevance analysis on transaction information in the database replication environment. Transactions of modifying the tables belonging to the same table set are assigned, according to table names in the table set, to the same database connection for execution, transactions belonging to the different table sets are assigned to different connections for execution, thus interference between the connections is reduced to the greatest extent, and performance of parallel multi-connection processing is fully utilized.

Description

technical field [0001] The invention belongs to the technical field of incremental replication of databases, in particular to the application field of relational databases. technical background [0002] In an enterprise information application environment, there is often a need to move data in one application environment to another application environment for processing or use. Moreover, in many scenarios, such requirements have high real-time requirements, and the amount of data is often large. This demand has spawned a batch of software that obtains source database change information based on triggers or database transaction logs, and copies the changes to the target database for re-execution. We call it real-time incremental data replication software, or real-time incremental data synchronization software. The technology it adopts is correspondingly called real-time incremental data replication technology or real-time incremental data synchronization technology. [000...

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): G06F17/30
CPCG06F16/27
Inventor 邓方
Owner 邓方
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