Design Of Data Upload System Based On Database Cluster

With the development of network technology,the amount of business data of major companies has increased exponentially,and the traditional single database architecture model cannot meet new needs.Therefore,it has important research significance to transform the traditional database architecture into a distributed data cluster structure.However,for traditional relational databases,the data difference incremental capture technology of multi-node database clusters is the focus of current research.In data migration operations,how to deal with foreign key constraint relationships is a difficult problem In response to the above-mentioned problems,this thesis has made an in-depth study on the incremental capture of data differences in the oracle database cluster and the detection and resolution of foreign key conflicts.The specific work is as follows:1.The difference comparison algorithm is designed to solve the problem of the incremental capture of the difference of the database cluster.It is realized through the API provided by the database manufacturer to compare the difference data of the database in a point-to-point manner.This method is easy to implement and it can be realized under the premise of using the original database system structure.2.Designed a foreign key conflict resolution algorithm.Due to the foreign key constraint relationship in multiple data tables,the data synchronization operation lacks key synchronization sequence records.In order to solve this problem,this thesis proposes a model of the foreign key constraint relationship of the data table as a directed acyclic graph,and finally outputs the result that can avoid foreign key conflicts.This thesis does experiments to prove the algorithm proposed above,and shows the superiority of the algorithm through real data.Finally,the system was successfully applied to a company’s cascaded database management system,realized the multi-regional database cluster reporting function,ensured the data interaction between the company and each branch company,significantly improved office efficiency,and achieved good effect.