This project
is financed
by the
EUROPEAN
UNION


 

Implementing partner:

NRD
University of Sassari


 

Training course on RDBMS for sub-surface data storage and processing for geological and hydro-geological purposes, Djerba, Tunisia, June 24th – 25th, 2014

Teacher: Cristina Buttau, Cagliari University

The training took place in Djerba and was attended by 11 participants (70% men, 30% women). The structure of the relational Database Management Systems (RDBMS) was explained and appreciated. Participants made practices on table and query creation.

The use of RDBMS in geological and hydro-geological contexts is continuously increasing because of its capacity to store and process a large amount of data, besides it can be easily interfaceable with GIS and MOVE. During the census and collection of the available data and bibliography for the two study areas of Oued Biskra (Algeria) and Oum Zessar (Tunisia) watersheds, a considerable number of sub-surface data constituted of well-logs paper reports, containing information about its location, stratigraphy, hydro-geological features and chemical analysis on aquifer intercepted water was collected. The need to have a standard manner to organize, store and then to process all the collected data led to the creation of a RDBMS built with Microsoft Access ™ software. Storage and management of all the information within this type of system is based on different types of objects including tables and queries. Following this scheme, the information has been organized into nine different tables, each one containing a definite set of data, in this order: ID Well; Wells; Lithology; Geological Time; Formation; Hydrogeology; Well coating; Chemical analysis and Core recovery. All the tables and then all the data stored in them could be easily processed through the query function in order to obtain new tables containing a new set of data depending on the work purposes. The new table can be used to insert well data in the geo-referenced space of ARCgis (ESRI) or in Move (Midland Valley) in order to implement the superficial data with the subsurface one. The geo-referenced data could be used for the reconstruction of the 3D geological model.

 

 

|  English | Français | Valid XHTML 1.0 StrictCSS Valido!Level AA WAI WCAG

Website developed by InTReGA
Licenza Creative Commons
Creative Commons Licence