Structured data tool optimization method and device, electronic equipment and storage medium

Abstract

The invention relates to the technical field of big data, and discloses a structured data tool optimization method, which comprises the steps of: acquiring an original structured data tool, and establishing a data synchronization mechanism for the original structured data tool and a pre-constructed source database to obtain an initial structured data tool; adding a link copy copying function intoa data transmission link of the initial structured data tool to obtain a standard structured data tool; establishing a synchronous updating mechanism for a configuration table in the standard structured data tool and a corresponding data table in the source database to obtain a target structured data tool; and performing search optimization on a configuration table in the target structured data tool by utilizing a preset search optimization algorithm to obtain an optimized structured data tool. The invention further provides a structured data tool optimization device, electronic equipment anda computer readable storage medium. According to the structured data tool optimization method and the structured data tool optimization device, intelligent optimization of the structured data tool canbe realized.

Description

technical field [0001] The present invention relates to the field of big data technology, in particular to a method, device, electronic equipment and computer-readable storage medium for optimizing structured data tools. Background technique [0002] A structured data tool refers to a tool that can realize data migration, and is usually used to transfer data from a source database to a target database. At present, the optimization methods for structured data tools have the following problems: [0003] 1. Failure to establish a data synchronization mechanism between the structured data tool and the source database in advance, and unable to ensure the establishment of a secure link with the source database; [0004] 2. Due to the independence of data transmission links in structured data tools, that is, the synchronization table of a data transmission link is not related to other data transmission links. In different links, the same table in different source databases require...

AI Technical Summary

Problems solved by technology

[0003] 1. Failure to establish a data synchronization mechanism between the structured data tool and the source database in advance, and unable to ensure the establishment of a secure link with the source database;

[0004] 2. Due to the independence of data transmission links in structured data tools, that is, the synchronization table of a data transmission link is not related to other data transmission links. In different links, the same table in different source databases requires multiple A manual operation has brought great inefficiency;

[0005] 3. When the configuration table in the structured data tool has imported the source database data table during synchronization, if the data in the source database data table is updated, you need to manually update the data in the structured data tool again. It takes a lot of time and effort to configure the data in the table;

[0006] 4. The search function of the structured data tool is not optimized, so it is impossible to search the data tables of other pages on the current page, which is more troublesome to operate

Images