The Research On The Development And Application Of Ha'erbin Bicyclic District Engineering Geological Database

Database applied in the field of Geological, traditional database lacks of processing functions and graphics processing space functional attributes Therefore, for the existence of serious problems in the database, the database uses the specialized mapping software to map the needed graphics to make the convenience of the users, and to enhance interface level. At the same time, for enhancing the maintenance of data systems, it sets up Excel function force, achieving data backup. Its main thesis as follows:(1) This article discusses the current status and development of the database based on the geotechnical database information management and feasibility. The rapid development of information technology economically, theoretically, technically and engineering applications that four aspects of the geotechnical data management feasibility.(2) Brief introduction to the basic concepts of the database, a database system from the database, multiple user applications, database management systems (DBMS), computer systems (including hardware and software), human five parts, with the realization of data sharing, reduce redundant data, and maintaining data consistency, data independence, security, confidentiality, parallel control features.(3) It introduces the database development. The needing analysis is the key to the smoothly development of the system. It notes the use of SQL Server 2000 and VB6.0, in the development process, the advantages SQL Server 2000 has been fully exploited, and received good results.The system also introduced the development environment, systems design and research methods. The district of Harbin geotechnical database system designed mainly includes three aspects: geological main business database design, user interface design and system manipulation design. The design makes it as complete as possible, operate more flexible and convenience.(4) Data is the foundation of the system, the main city geotechnical investigation techniques is drilling, digging, the original testing, laboratory testing, inspection shafts, detection and monitoring. So the city of geological information systems, data sources primarily for decades, with the urban construction of the geological survey, geotechnical investigation, the base piletesting, monitoring results in data collection, followed by a comprehensive, concise, practical principles: First, focus on urban areas, new development areas;Second, the information gathered can be put in storage;Third, based on the original data and derived from the synthetic data and integrated data can be computed automatically.After analyzing the issue and summing up the systems required data elements : geological conditions, soil mechanics and physical indicators, detailed test data, analysis of data quality information, static three-axis testing results, the project of information, survey information, conclusions and recommendations of the project, geological information table plans, it establishes the model of the system at all levels, database tables, and the system made more reasonable structure, the structure can be fully reflected not only in the engineering investigations information, but also to facilitate the future development of the subsystems. Compared with previous geological database structure, such a structure designed to facilitate the application of more functional development.(5)The structure and function of subsystems, of Hashi geotechnical database management system The functional structure of the system is designed to follow the theory advanced guidance, using mature technologies to support the analysis of the design principles. For Harbin geotechnical characteristics of the database, it used relationship-based data formats. Database management system is made of system maintenance, data inquiry, data editing, graphics production and display, and data export. Through the information recorded, modify, add, delete, information, exporting and production of graphics work. It achieves geological scientific information management for the effective use of information to facilitate conditions. At the same time this system has a good system maintenance functions, only legitimate users can access the system and users can add to and modify passwords.System achieved geological prospecting information sharing for the next survey, investigation and the overall urban planning provided the theoretical basis of geological valuable. The database functions and interface design, beautiful picture quality, enhanced the appeal procedures and diagnosis, the operation simple, convenient and suitable for non-professional computer engineers. The database technology made some prospects for the development of the geotechnical database, it can contribute to the Harbin City urbanplanning, design, construction, management.