Research on Distributed Database Application for Integrated Urban Underground Pipelines

Advancements in the application of underground pipeline information have led to the increased complexity in the design and implementation of the information management system. With the underground pipelines data being managed by many different government agencies, it becomes increasing more difficult to ensure their integrity, accuracy and timeliness. In this paper, based on our practice on building urban underground pipelines information systems, we propose a distributed database design scheme. In particular, we systematically discuss the core design issues such as infrastructure design of distributed database, structure design of underground pipelines and metadata design; and provide efficient solutions to the key implementation problems such as decentralized storage and access of pipelines data. We have implemented the proposed design scheme in a practical underground pipelines information system application. The real world application shows the effectiveness of our proposal and provides new insights for the further application of distributed management of integrated underground pipelines. This work is partially supported by National Natural Science Foundation of China (40801151).