Presentation of a Web-Based Database Design for Documentation and Analysis of Rock Properties

"With increasing data volume, due to enhancing requirements for ground investigation programs for large construction projects, the demand for more efficient filing systems is more and more growing. Depending on the project we also have to use flexible systems to cope with varying data out of different lab and field tests.The chair for Engineering Geology at TUM is developing a web-based database solution to handle all project relevant data in a more appropriate way. We aim to optimize our data management to achieve a fast and easy way of collecting, documenting and analyzing our gained data. The second objective is to provide an easy access to our data for project partners across broadly distributed locations.This Database system consists of a PHP web interface and a MySQL database core. The current setup allows an online access via Internet (www). We are able to grant and constrain access to all data or only arrays of data with our user management system to guarantee the safety of project data and respect all rights and proprietorship. The database system is of modular design and consists of the following three base modules: module of general project data, module of laboratory data and user management module. At the current stage we are able to save and work with all usually generated specific values from unconfined compressive strength tests, brazilian tensile strength tests, point load tests, CERCHAR and LCPC abrasivity tests and ultrasonic tests. The user is able to perform a simple statistical analysis within our database (e.g. average calculation of one sample) and export data as csv or xls files for further analysis.For specific questions within projects we are able to deploy and integrate further modules in our database system. At this moment, we are developing an add on to use this database for different drill test analyses. One of the tools correlates drilling performance and drill head wear measured in the field with rock mechanical properties, and extrapolates the data to estimate the performance and wear in new projects. Today we are managing 90 projects with 550 samples and almost 1350 lab tests with the base module.In our contribution we aim to demonstrate an efficient way of data structuring using a relational database for laboratory and field testing data."