Architecture and CRUD Complete Analysis and Algorithm of the Integration of Distributed Database Access in the Same Configuration

Abstract

A distributed database with the same configuration is an important storage scheme for the extensible data of an information system. This storage scheme can effectively increase the access and storage capacity of the system and improve its response speed. However, the response speed of the traditional distributed database in the same configuration will gradually slow down when the traffic of the system increases or the access concurrency of the system expands. This article adopts the Mycat middleware and the form of Oracle database node and builds a new type of distributed database with the same configuration on the server side. It develops a dynamic switch and parser for a multiple data source, to parse and route CRUD operations in order to realize the dynamic connection control of the Mycat server and multiple Oracle database nodes and the effective distribution of data resources. Through analyzing the shard field of the CRUD statements, the integrated parser can implement the operation of the database by involving only a single or a few nodes without the Mycat server and communicate directly with the Oracle database of corresponding nodes. It can also implement the operation of the database by involving several or all of the database nodes to communicate and route with the Mycat server. This scheme can effectively reduce the operating pressure of distributed data source servers, reduce the execution time of CRUD operations, and greatly improve access speeds during large concurrent visits. At present, this achievement has been successfully applied to the cloud service of a large project with complex computing.