| Keywords |
Relational database management system, database design, table relations, data security, data accessibility, geothermal database, geothermal collaboration, Iceland, Nicaragua, Turkey, ÃSOR, Orkustofnun. |
| Abstract |
In Iceland geothermal information has now been gathered for around 90 years, through both exploration and utilization. ÃSOR (Iceland GeoSurvey), and its predecessor Orkustofnun (National Energy Authority), has been involved in most of the geothermal projects. The information that has accumulated through this costly research and projects is vital and requires both safe and accessible storage. At ÃSOR we have chosen to host our data in a relational database management system (RDBMS). The benefits of using such a database system is, among other things, to ensure data consistency, avoid data dupli¬cation, minimize human errors, maximize data security and accessibility. Data can be retrieved quickly and with ease, compared on a large or a small scale, within and between geothermal areas and reservoirs, between individual wells and other locations of measurements or sampling, and all of this between time intervals. Information can also be shared more easily, which benefits not only ÃSOR’s projects, but also ÃSOR’s clients, related supervisory authorities and institutions involved. This leads to improved collaboration and advances all of ÃSOR’s geothermal projects. Since 2017, three of ÃSOR’s largest clients in Iceland have access to their data in special databases per client hosted at ÃSOR. These client databases do not store just the data belonging to each client, they also have almost the same design and table relations as ÃSOR´s primary database. Two clients abroad, in Nicaragua and Turkey, have their geothermal databases designed according to the design of ÃSOR´s database. The main outlines of ÃSOR´s geothermal database of exploration and production monitoring will be described here, its current design and status. The structure and general usage of the database will be presented, including main database parts, general table structure and table relations, along with many of the database tables. Some few notable examples of database reports from the database chemical part and the borehole part will be presented. |