Research on Low Database Coupling Architecture and Its Application in Digital Power Marketing System

In order to meet the needs of flexible deployment and upgrading of digital systems, the realization of application and database decoupling is one of the important technical capabilities that the system requires. For the microservice architecture system, this paper proposes and realizes the low database coupling system architecture, by building the data microservice layer, so the foreground and middle-ground microservices no longer access the database directly but access the data microservices, and the data microservices complete the specific access to the database. In the paper, the handling methods of SQL syntax translation, database access adaptation, data synchronization and other practical problems in data microservices are given. The architecture of the paper is validated by taking a large-scale digital system, the digital power marketing service system, as an example. The system architecture proposed in this paper is universally applicable and has practical value for the flexible construction of enterprise digital systems.