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

Yin, Pei; Cheng, Jing

doi:10.32604/cmes.2023.023666

Cited by 2 publications

(1 citation statement)

References 19 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…They proposed and implemented a data replication solution that imports data from the predominantly relational MySQL databases into Elasticsearch, which a MySQL document stores as a possible alternative for a more efficient data search. Yin P et al [32] developed a software system for an urban land planning database in Shanghai, China, based on MySQL; They established a platform with functions of data management, information sharing, and map assistance to realize efficient storage and management of land data.…”

Section: Literature Reviewmentioning

confidence: 99%

Design and Management of a Spatial Database for Monitoring Building Comfort and Safety

Guo,

Qi,

Zhao

et al. 2023

Buildings

View full text Add to dashboard Cite

As the impacts of climate change on urban environments and buildings become more and more prominent, building comfort and structural safety monitoring becomes crucial. However, efficiently storing and managing the multi-source monitoring data generated during the long-term monitoring process has been an urgent challenge. In order to solve the above problems, this paper designs and develops a spatial database management system for building comfort and structural safety monitoring based on standard database development tools. A conceptual model of a spatial database for building comfort and structural safety monitoring is proposed, and the entities, attributes, and connections in the model are discussed to transform the E-R conceptual model into a logical model supported by an object-relational spatial database management system. Based on this conceptual and logical model, a mainstream backend framework was adopted and combined with common database and programming language tools and BIM (Building Information Modeling) technology for development to establish a spatial database management system with data storage, management, analysis, and visualization functions. We designed building monitoring experiments and proved through the experiments that the database management system can stably store, analyze, and manage the monitoring data and visualize the display, with the advantages of a fast response speed and low error rate. The spatial database system improves the storage and management efficiency of building comfort and structural safety monitoring data, eliminates redundant data, and realizes comprehensive analysis and management of building comfort and structural safety monitoring data. It provides data support for building comfort and structural safety assessment, helps users analyze the formation mechanism and evolution law of the urban heat island effect, assesses the interrelationship between climate change and urban building morphology, and constructs an urban thermal environment that is more adaptable to climate change.

show abstract

Section: Literature Reviewmentioning

confidence: 99%