Index recommendation method and device

Abstract

The embodiment of the invention provides an index recommendation method and device which can be used for the technical field of artificial intelligence, and the method comprises the steps: extracting target data from database table information and database SQL information corresponding to a target distributed database and database SQL historical execution log content in a test environment based on a preset database SQL feature index system; and inputting the target data into a preset index efficiency recommendation model, and generating index recommendation result data corresponding to the target distributed database according to data output by the index efficiency recommendation model. The automation degree, the intelligence degree and the efficiency of the index recommendation process can be effectively improved, the effectiveness, the accuracy and the reliability of the index recommendation result can be effectively improved, and then the efficiency of updating and querying the distributed database according to the index recommendation result can be effectively improved.

Description

technical field [0001] The present application relates to the technical field of data processing, in particular to the technical field of artificial intelligence, and in particular to an index recommendation method and device. Background technique [0002] In recent years, with the rapid development of financial technology, more and more banks and other financial institutions have started IT transformation in order to enhance their technology application capabilities and insist on technology empowerment. For example, they will use IBM mainframes, Oracle databases and EMC The IT architecture system based on storage equipment has been transformed into a digital architecture system that adopts X86 service system, distributed database based on MySQL, and uses various emerging technologies to promote the development of business models. [0003] With the development of banking business and the transformation of technical architecture, the distributed system framework is gradually ...

AI Technical Summary

Problems solved by technology

[0003] With the development of banking business and the transformation of technical architecture, the distributed system framework is gradually replacing the system framework dominated by IOE (IBM, Oracle and EMC), but the transformation of IT architecture and the rapid growth of business data have also made the traditional The database index design is difficult to meet the new database specifications, and the data processing efficiency is difficult to meet the update and query requirements. As a result, a series of problems have gradually been caused during the process of system transformation, such as the failure to match the optimal index normally and the efficiency of the database index. Problems such as long data processing time in the process of IT architecture transformation

[0004] However, the existing index selection method requires operation and maintenance personnel to finally select after many attempts, which consumes a lot of manpower and time costs; if selection is based on preset selection criteria, although human participation can be shortened time, but due to the fixed selection criteria, it is impossible to flexibly select the optimal index, so the validity of the index results cannot be guaranteed. Questions of efficiency and automation requirements

Images