A MySQL-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 on MySQL. 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 database management 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 platform with data management, information sharing, map assistance and other functions is established. The functional modules in this platform are 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.