Application Research On Service-oriented Real-time Database For Smart Residential Quarter Integrated Information Platform

In October 2016,the first domestic " Green and Smart Residential Quarter guide(Trial)" and the idea of Green and Smart Residential Quarter was firstly proposed by Shandong province.Smart community comprehensive information cloud platform is composed by many heterogeneous sub-systems or sub-platforms,the data in smart quarter has features of heterogeneity,distributed deployment of data source and large amount of transient data.the database should have the ability of rapidly storing multi-source and heterogeneous real-time data,meeting the diversity of data requirements and providing cross-platform data access.Besides,the smart city calls for Network interconnection,data sharing and coordination,in this environment,the traditional concept of “develop once,long time use” is not appropriate.In this thesis the real-time database for smart residential quarter integrated information platform base on service-oriented architecture is proposed in the background of smart city and smart quarter.The thesis does a research on SOA,smart community comprehensive information platform,smart community real-time database.Based on the needs of platform,the thesis proposes a service-oriented real-time database for smart residential quarter integrated information platform model.And real-time database building method are studied,platform architecture model is designed and explained.In terms of the key technologies which are applied in real-time database,multi-thread,socket and other technologies are adopted to solve the problem of concurrent communication.The system formulates unified communication protocol,uses hash-table data structure as the index structure,and applies classification management strategy.The independent progress of historical data storage is established,and the system set up the historical data management mechanism which combined SQL Server with file system.And to meet the diversification of data requirements of information cloud platform,web service and WCF technology are employed to develop multi-granularity real-time/history service.Finally through comparing with SQL Server performance which is used as a real-time database,the quickness of real-time data acquisition is validated.the effectiveness of the service-oriented architecture(SOA)application is verified by the practical application result of real-time database in a smart quarter.The real-time database proves to satisfy needs of the information cloud platform.