Research And Implementation Of Components Management System In Smart City Based On Dubbo And Geohash

In recent years,with the development of computer and big data technologies,local governments have built smart city systems to improve the level of urban management and government decision-making efficiency.Components(finger Well cover,street lights,parking lots,overpasses,and other urban facilities)are indispensable infrastructures for cities.It is of great significance to develop stable and efficient component management system.This not only fully mobilizes urban resources,combination of components in the city is widely distributed,dense and other characteristics,component system will also play a key role in the construction of internet of things in smart city.Most of the existing related researches use traditional C/S model and relational database for the architecture design,and no special design for architecture stability and concurrency.At the same time,Storage and query of component GIS data have not been optimized in previous studies.In this paper,combining with the smart city project in a certain district of Beijing undertaken by laboratory,the smart city component management system was studied and implemented.The main tasks include three aspects: study system architecture,optimize system performance,and fulfill system functional requirements.The first place for innovation is to realize a stable and extensible technical architecture based on the actual requirements of component system.The second is to use Geoshash coding and Hbase big data technology to optimize GIS data storage and query performance of components.The third is using self-built cache tables to optimize My SQL database query performance.First,a set of stable B/S technology architecture is studied and implemented for specific performance and stability requirements.The technology architecture combines the microservices framework Dubbo with Spring,Nginx,Keepalived and other software to reduce the coupling between system modules and improve system operation stability.The architecture is divided into service layer,load layer,business layer,and storage layer.The service layer encapsulates the service on the basis of meeting the business flow within the module and provides it with a RESTful interface.Using open source software to establish a load layer on existing network to increase network throughput and increase system throughput in a cheap and efficient way.This paper uses Nginx for load balancing and Keepalived to ensure high availability of Nginx,It enhances the stability of operations by improving the system's concurrent processing capabilities.The business layer uses the open source microservices framework Dubbo to achieve the separation of service providers and consumers to improve development efficiency and system scalability.The message middleware Rabbit MQ is used to improve the system's asynchronous processing capabilities.The storage layer uses both Hbase and My SQL databases,My SQL store component running business data,and Hbase store component GIS information.Storage based on data characteristics not only saves storage space but also improves data access efficiency.The Redis database is used to cache hot data and share user session information.The architecture is deployed and operated in cluster mode.Second,it is related to system performance optimization.The performance optimization consists of two parts: the first is to use the self-built cache table to optimize My SQL database,and the second is to use Geoshash encoding technology to encode components' latitude and longitude and then combine the Hbase Rowkey feature to optimize storage and query of component GIS data.The optimization of component GIS data uses a step-by-step approach to explore optimal optimization scheme.First,two issues are raised based on the actual requirements of the component management system,and the disadvantages of direct latitude and longitude are explained,then leading to Geohash indexing technology and illustrating a special case.Finally,Give a query example.Then,from the functional requirements,the component management system is divided into four modules: component data migration,component data management,component data display,and service provision.The data migration module is responsible for migrating the component data in the legacy system to the new database.The data migration is divided into initial migration and incremental migration,and the migration process need ensures the integrity of the data.The data management module is responsible for the daily maintenance of the components.The inspection supervisor discovers the problem components and submits the repairs through the App.The system administrator must promptly handle the real-time status of the problem components.The data display module is responsible for displaying the component data in different dimensions,including query list display,GIS display,and statistical analysis display.The service provision module mainly has two parts: one is responsible for the internal service flow of the component system,and the other is to provide services to other systems.Finally,through effective testing and online operation,this paper proves that the architecture design meets the reliability requirements,data optimization meets the performance requirements,system module partition meets users' requirements,achieving system's expected goal,and improving the government work efficiency and people's life quality.