Research On Data Structure SynchronizationTechnology In Database Cluster Pattern

Database cluster pattern produces thousands of databases that are internally consistent in structure.The management and maintenance of these databases consume a lot of human resources.In order to solve this problem,a variety of database structure comparison tools have arisen.However,database structure comparison tools are very complex in operation,and they only stand at the database level for synchronization,which is not consistent with the object-oriented programming thought in software engineering.The author of Hibernate Gavin King also added Hibernate automatic tabulation technology in the framework.Its automatic tabulation technology not only is easy to operate but also conforms to the object-oriented thought.However,in the follow-up development practice,it is found that there are a series of deficiencies in Hibernate automatic tabulation technology,which can not fully satisfy the needs of database structure maintainance for enterprise-level applications.First of all,after studying and comparing the relevant technologies in the field at home and abroad,the author of this paper determines to choose the Hibernate automatic tabulation technology as a basic technical platform,and analyzes its defects.Specially speaking,it can't realize the synchronization in view structure,stored procedure,expanding field's maximum length and removing field;Secondly,this paper designs an upgraded database structure synchronization technology based on Hibernate,innovatively increases four synchronization functions which have been mentioned above.Besides,the author considers that new synchronization functions need to inherit the superperformance of Hibernate automatic tabulation technology,the superperformance is that it can be applied to eight mainstream databases.The experimental results show that the above-metioned synchronization functions have good effect and capability.Thirdly,this paper adds the code of the new synchronization functions into Hibernate framework's source code,completes the integration of new synchronization technology and Hibernate framework,achieves the frame level optimization and upgrading on Hibernate framework;Last but not least,according to synchronization requirements of multiple data sources' s structure in database cluster pattern,this paper designs“one key” database structure synchronization's solution by using upgraded database structure synchronization technology in the Hibernate framework,makes up the limit of Hibernateautomatic tabulation technology which is that it can only synchronize one data source at a time.Compared with the database structure comparison tools,the research result of this paper has faster synchronous speed,good stability,outstanding extensibility and amazing maintainability.Above all,it meets the object-oriented programming thought in software engineering;Compared with Hibernate automatic tabulation technology,the research result of this paper has a more extensive range in synchronization,and is more in line with the demand of database structure's management and maintenance in database cluster pattern.