Research On Homogeneous Distributed Database Modeling And Access Integration Algorithm

The modern Internet information system service format has become more abundant,the amount of data has shown explosive growth,and data processing has increasingly become a bottleneck in the development of information systems.Among them,the traditional stand-alone database is restricted by factors such as hardware load and has become the most important constraint factor.The emergence of distributed databases effectively solves the above problems and has become the preferred data storage method for large-scale information systems.The homogeneous structure(consistent library table structure)distributed database explored in this article is one of the important storage schemes for the scalability data of information systems.It can effectively increase the system's access capacity and storage capacity,and improve the system's response speed.However,in the case of increasing system access,the response speed of homogeneous distributed databases will gradually slow down.Therefore,it is urgent to reconstruct the access process and optimize its connection and query algorithms to meet the needs of practical applications.This article analyzes the characteristics of current popular relational databases and non-relational databases,compares the difference of different products,and selects Oracle as the storage solution for data nodes.Through the analysis of different database middleware products at home and abroad,the mature Mycat middleware is selected as the node of the distributed database,and then the extended research of reconfiguration connection process and dynamic optimization query algorithm is performed.This article uses the form of Mycat middleware and Oracle database nodes to build a homogeneous distributed database on the server side.Through in-depth research on Mycat middleware and optimization of its configuration,combined with Mycat's core database and table separation technology,read-write separation technology,master-slave replication function,global self-incrementing ID technology,etc.,a highly available homogeneous distributed database system.Designed and implemented a homogeneous distributed database architecture based on Oracle,using Mycat middleware,and independently developed an API data access exchange module,providing a unified interface for external access and data processing.This article adopts SpringCloud to meet the requirements of scalability and high availability to build a microservices framework.It selects five components with complete functions and stable performance,including Eureka,Feign,Hystrix,Gateway,and Config components,and completes the construction of an integrated distributed data access platform..One of the core achievements of the integrated distributed data access platform is the design and implementation of an integrated access algorithm.The CRUD operations of database access are analyzed and routed at the application layer of the system to implement the Mycat server and multiple Oracle database nodes.Dynamic connection control.The algorithm performs a complete judgment on the fragment fields in the CRUD operation statement,and directly communicates with its corresponding Oracle database node for operations involving only a single database node without going through the Mycat server.For operations involving multiple database nodes,then It needs to communicate with Mycat server to improve data access efficiency and save system resources.Some of the results in this article have been adopted by an actual commercial project and run for one year with the effect reaching the expected goal.During the process of the development,CRUD operation tests of different orders of magnitude data were recorded to record their running time and resource consumption,and the test results were analyzed,which proved that the integrated algorithm can significantly improve the efficiency of data access and effectively reduce system resources consume.