Three-Dimensional Engineering Geology Data Warehouse Constructed by Power Designer

Abstract

The Three-dimensional engineering geology data warehouse is constructed by Power Desinger16.1, with the theme as the rock and mass availability in urban underground space, and with the source data as the borehole data of engineering Investigation. Use the Model-driven Architecture method, reverse engineer the Access data base, extract existed data model, combine research theme to construct the Star data structure model. And check the SQL script in SQL Server2005, to ensure normal operation. 0 Forewords The traditional transaction-oriented designed engineering geology data base has the function to storage original data from work, to draw of geological section and to provide simple check and analysis, but without the decision support function in view of a subject. The purpose of construction a 3D engineering geological data warehouse is to build a decision support system in view of availability of rock and soil mass in urban underground space. Based on the data extraction, data integration, data cleaning and data transformation, the 3D engineering geological data warehouse could achieve the integrated management of massive geological data and to provide reliable data source for the rock and soil mass utilization system in urban underground space. The main feature of 3D engineering geological data base is subject-oriented, integrated, time-varying, relatively stable, and is magnanimous collection of engineering geological spatial data and attribute data. According to the design pattern of traditional data base, the construction of 3D engineering geological data warehouse can be divided into three stages: concept design model, logic design model and physical design model. But the 3D engineering geological data warehouse exist iterative in the construction process. Currently, there are many CASE tools to help developers quickly achieving the data base design, such as Rational Rose by Rational company, Erwin and Bpwin by CA company, Power Designer by Sybase company, Office Visio by Microsoft company, and Oracle Designer by Oracle company. The paper uses the Powerdesigner16.1 to achieve the logical data model (LDM) and physical data model (PDM).