AMySQL-Based Software System of Urban Land Planning Database of Shanghai in China

Abstract

With the development of the digital city, data and data analysis have become more and more important. The database is the foundation of data analysis. In this paper, the software system of the urban land planning database of Shanghai in China is developed based onMySQL. The conceptual model of the urban land planning database is proposed, and the entities, attributes and connections of this model are discussed. Then the E-R conceptual model is transformed into a logical structure, which is supported by the relational databasemanagement system (DBMS). Based on the conceptual and logical structures, by using SpringBoot as the back-end framework and using MySQL and Java API as the development tools, a platformwith datamanagement, information sharing,map assistance and other functions is established. The functionalmodules in this platformare designed. The results of JMeter test show that the DBMS can add, store and retrieve information data stably, and it has the advantages of fast response and low error rate. The software system of the urban land planning database developed in this paper can improve the efficiency of storing and managing land data, eliminating redundant data and sharing data.