Research on Decompostion Method of Relational Database Oriented to Microservice Refactoring

The traditional monolithic system architecture faces challenges such as low development efficiency, high maintenance costs, and limited scalability. Refactoring it into a microservice architecture improves efficiency and scalability. Database decomposition is crucial in this process to achieve independence and decoupling between microservices. A decomposition method for relational database is proposed in this paper, which combines static analysis and dynamic analysis to build the incidence matrix between tables, and then clusters the incidence matrix by spectral clustering algorithm to obtain database decomposition results, and automatically matches the decomposition results with microservices. Based on the above mentioned method, an automatic relational database decomposition tool has been designed and implemented. Experimental verification has shown that the tool can efficiently achieve relational database decomposition, thereby enabling support for microservices refactoring to legacy systems.