Distributed Real-time Database Of Construction Equipment Operation And Maintenance System

The use phase of the construction equipment operation system is the largest proportion in the whole life cycle of the building.To realize the intelligentization and informatization of the construction equipment operation system,it is necessary to solve the problems of acquisition of multi-source and multi-structure data,distributed deployment and massive instantaneous data in the system.Distributed real-time database collects data and stores them to each node for unified management by distributing technology.In this way,system realizes centralized management and decentralized control,and provide data support for construction equipment operation system.This paper studies from the service demand analysis,distributed real-time database technology,distributed historical file system and application process of construction equipment operation system,mainly carries out the following work:(1)The paper introduced the development of the construction equipment operational system,real-time database and distributed real-time database.By further studying of construction equipment operational system demand for distributed real-time database system,the paper combine with the characteristics of real-time database and the distributed real-time database technology to put forward the construction equipment operational system of the overall architecture of distributed real-time database,as well as the detailed design of the database service.(2)In order to meet the multi-source and multi-structure data collection,this paper proposes to design configuration data collector by DLL technology.On the basis of real-time database,the paper study the database name management and memory data organization.And the scheduling of distributed real-time transactions is solved by using the real-time transaction priority allocation strategy and DLL technology.(3)This paper introduces the history database architecture in distributed real-time database,this article according to the different characteristics of switching quantity and analog quantity to optimize the data storage strategy,by studying the Hadoop distributed file system,combining HDFS with historical database file system to develop the historical file management system based on HDFS.The system provides API data access interface to realize the fast storage and data index of data.(4)At last,the paper analyzes the writing and extracting speed of real-time data in distributed real-time database,and compares the real-time data index with SQL Server to verify the rapidity of the system.By applying the distributed real-time database system to the actual construction equipment operation system,the validity of the system application is verified.Finally,it is proved that the distributed real-time database system can realize the requirements of acquisition of multi-source and multi-structure data,data processing,real-time transaction concurrency control,distributed management and so on..