Application of Association Rule Algorithm in Distributed New SQL Database Design

Abstract

In recent years, with the increasingly widespread application of digital technology in various enterprises, the role of databases in various enterprises will also become increasingly important. A lot of useful and critical information is often hidden in a large amount of information stored in the database system. How to obtain this information efficiently and accurately has always been a problem, so data mining technology came into being. This paper aims to study the application of association rule algorithm in distributed NewSQL database design. On the basis of analyzing the classical association rule algorithm, the advantages of NewSQL database and the processing process of SQL, the traditional association rule algorithm is improved and a distributed algorithm is designed. NewSQL database, in order to improve the performance of the algorithm for testing, this paper uses multiple computers to form a local area network to simulate the NewSQL database system. The test results show that when the minimum support is low, the execution efficiency of the improved association rule algorithm is slightly better than that of the traditional association rule algorithm