Database design method for city management

Abstract

A database design method for city management comprises the following steps: firstly, designing database functions according to business functions and application requirements, so that the database functions can perform data management, data storage, data retrieval and data uploading / exporting, have a huge data processing function, and process structured data stored in a database; secondly, performing logic design and physical design on the processed structured data, finally designing a database table structure according to urban management business processes and application requirements, and presenting business table and dimension table structure contents, thereby realizing management of all data information. The database designed by the invention is beneficial to enhancing the data management capability of an existing platform, ensures the performance requirements of background mass data storage, retrieval and uploading, provides a data basis for stable operation of a system, analysisand mining of future city management data and construction of a smart city database, and effectively improves the utilization rate of data resources.

Description

technical field [0001] The invention relates to the technical field of database design, in particular to a database design method oriented to city management. Background technique [0002] my country's urban planning and construction management has made remarkable achievements, and urban planning laws and regulations and implementation mechanisms have basically been formed. However, there are still some outstanding problems in the process of urban management, especially in the process of urban management and law enforcement. , setting up stalls, motor vehicles / non-motor vehicles parking indiscriminately, etc., greatly restricting the construction of urban civilization. [0003] In order to solve the above problems, many domestic video analysis manufacturers have built various city management video analysis systems, which are used to assist the refined and intelligent management of cities, and have achieved certain results. However, in the process of system construction, softw...

AI Technical Summary

Problems solved by technology

[0002] my country's urban planning and construction management has made remarkable achievements, and urban planning laws and regulations and implementation mechanisms have been basically formed. However, there are still some outstanding problems in the process of urban management, especially in the process of urban management and law enforcement. , setting up stalls, and random parking of motor vehicles / non-motor vehicles have greatly restricted the construction of urban civilization.

[0003] In order to solve the above problems, many video analysis manufacturers in China have built various city management video analysis systems to assist the refined and intelligent management of cities, and achieved certain results. However, in the process of system construction, the main focus is on the realization of software functions Mainly, the comprehensive design of the urban management system database and the potential value of urban management data are not fully considered

Images