Open Access

ARTICLE

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

Pei Yin¹, Jing Cheng^2,*
1 Department of Civil Engineering, School of Mechanics and Engineering Science, Shanghai University, Shanghai, 200444, China
2 College of Civil and Transportation Engineering, Shenzhen University, Shenzhen, 518057, China
* Corresponding Authors: Jing Cheng. Email: ,
(This article belongs to this Special Issue: Numerical Methods in Engineering Analysis, Data Analysis and Artificial Intelligence)

Computer Modeling in Engineering & Sciences 2023, 135(3), 2387-2405. https://doi.org/10.32604/cmes.2023.023666

Received 08 May 2022; Accepted 08 August 2022; Issue published 23 November 2022

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.

---

Keywords

Software; database; database management system; urban land planning; MySQL

---