Swissforages: the Free and Open-Source Borehole Data Management System

Most of the time boreholes data, particularly those collected in the past, are in the form of static data reports that describe the stratigraphy and the related characteristics; these data types are generally available as paper documents, or static files like .pdf of images (.ai). While very informative, these documents are not searchable, not interoperable nor easily reusable, since they require a non negligible time for data integration. Sometime, data are archived into database. This certainly improve the find-ability of the data and its accessibility but still do not address the interoperability requirement and therefore, combining data from different sources remain a problematic task. To enable FAIR borehole data and facilitate the different entities (public or private) management Swisstopo (www.swisstopo.ch) has funded the development of a Web application named Borehole Data Management System (BDMS) [1] that adopt the borehole data model () [2] implemented by the Swiss Geological Survey. From the first beta release (2019) several improvements to the platform has been implemented leading to the last official release of the platform (v1.0.2) officially available on www.swissforages.ch. The latest released features includes:<ul><li>Borehole document storage</li> <li>Interface customization</li> <li>Improved access & authorization managemnt</li> <li>External WMS/WMTS background map support</li> <li>User feedbacks form</li> <li>Handling of personalized and versioned terms of service</li> <li>Enhanced bulk data import</li> <li>Minor enhancements and bug fixes</li> </ul><img src="https://contentmanager.copernicus.org/fileStorageProxy.php?f=gnp.47de8bb6070061123701161/sdaolpUECMynit/12UGE&app=m&a=0&c=ed4706d00e320d6aacebe59534e52363&ct=x&pn=gnp.elif&d=1" alt="">&#160;

Download Full-text

Borehole Data Management System: a web interface for borehole data acquisition

10.5194/egusphere-egu2020-19423 ◽

2020 ◽

Author(s):

Massimiliano Cannata ◽

Milan Antonovic ◽

Nils Oesterling ◽

Sabine Brodhag

Keyword(s):

Data Management ◽

Open Source ◽

Management System ◽

Web Application ◽

Data Management System ◽

Data Types ◽

Time Data ◽

Borehole Data ◽

Geological Conditions ◽

Combining Data

The shallow underground is of primary importance in governing and planning the territories where we live. In fact, the uppermost 500 meters below the ground surface are interested by a growing number of anthropic activities like constructions, extraction of drinking water, mineral resources, installation of geothermal probes, etc. Borehole data are therefore essential as they reveal at specific location the vertical sequence of geological layers which in turns can provide an understanding of the geological conditions we can expect in the shallow underground. Unfortunately, data are rarely available in a FAIR way that as the acronym specify are Findable, Accessible, Interoperable and Reusable.Most of the time data, particularly those collected in the past, are in the form of&#160;static data reports that describe the stratigraphy and the related characteristics; these data types are generally available as paper documents, or static files like .pdf of images (.ai). While very informative, these documents are not searchable, not interoperable nor easily reusable, since they require a non negligible time for data integration.&#160;Sometime,&#160;data are archived into database. This certainly improve the find-ability of the data and its accessibility but still do not address the interoperability requirement and therefore, combining data from different sources remain a problematic task. To enable FAIR borehole data and facilitate the different entities (public or private) management swisstopo (www.swisstopo.ch) has funded the development of a Web application named Borehole Data Management System (BDMS) [1] that adopt the borehole data model&#160;() [2] implemented by the Swiss Geological Survey.Among the benefits of adopting a standard model we can identify:<ul><li>Enhance the exchange, the usage and quality of the data</li> <li>Reach data harmonization (level of detail, precise definitions, relationships and dependencies among the data),</li> <li>Establish a common language between stakeholders</li> </ul>The Borehole Data Management System (BDMS)&#160; was developed using the latest Free and Open Source Technologies. The new application integrates some of the today&#8217;s best OSGeo projects and is available as a modular open source solution on GitHub and ready to use in a docker container available on Docker Hub. Through two types of authorization, Explorer users are able to search the BDMS for specific boreholes, navigate a configurable user friendly map, apply filters, explore the stratigraphy layers of each borehole and export all the data in Shapefiles, CSV or PDF. Editors are able to manage in details the informations and publish the results after passing a validation process.&#160;Links[1] http://geoservice.ist.supsi.ch/docs/bdms/index.html[2] https://www.geologieportal.ch/en/knowledge/lookup/data-models/borehole-data-model.html&#160;

Download Full-text

A HIGHLY SCALABLE DATA MANAGEMENT SYSTEM FOR POINT CLOUD AND FULL WAVEFORM LIDAR DATA

ISPRS - International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences ◽

10.5194/isprs-archives-xliii-b4-2020-507-2020 ◽

2020 ◽

Vol XLIII-B4-2020 ◽

pp. 507-512

Author(s):

A. V. Vo ◽

D. F. Laefer ◽

M. Trifkovic ◽

C. N. L. Hewage ◽

M. Bertolotto ◽

...

Keyword(s):

Data Management ◽

Management System ◽

Web Application ◽

Point Cloud ◽

Web Applications ◽

Distributed Database ◽

Data Management System ◽

Data Repository ◽

Lidar Data ◽

Full Waveform

Abstract. The massive amounts of spatio-temporal information often present in LiDAR data sets make their storage, processing, and visualisation computationally demanding. There is an increasing need for systems and tools that support all the spatial and temporal components and the three-dimensional nature of these datasets for effortless retrieval and visualisation. In response to these needs, this paper presents a scalable, distributed database system that is designed explicitly for retrieving and viewing large LiDAR datasets on the web. The ultimate goal of the system is to provide rapid and convenient access to a large repository of LiDAR data hosted in a distributed computing platform. The system is composed of multiple, share-nothing nodes operating in parallel. Namely, each node is autonomous and has a dedicated set of processors and memory. The nodes communicate with each other via an interconnected network. The data management system presented in this paper is implemented based on Apache HBase, a distributed key-value datastore within the Hadoop eco-system. HBase is extended with new data encoding and indexing mechanisms to accommodate both the point cloud and the full waveform components of LiDAR data. The data can be consumed by any desktop or web application that communicates with the data repository using the HTTP protocol. The communication is enabled by a web servlet. In addition to the command line tool used for administration tasks, two web applications are presented to illustrate the types of user-facing applications that can be coupled with the data system.

Download Full-text

Database Considerations for an ICU Patient Data Management System

ASME 1991 Computers in Engineering Conference: Volume 2 — Finite Elements/Computational Geometry; Computers in Education; Robotics and Controls ◽

10.1115/cie1991-0174 ◽

1991 ◽

Author(s):

N. Fumai ◽

C. Collet ◽

M. Petroni ◽

K. Roger ◽

E. Saab ◽

...

Keyword(s):

Data Management ◽

Real Time ◽

Data Storage ◽

Relational Database ◽

Management System ◽

Patient Data ◽

Patient Data Management System ◽

Data Management System ◽

Data Types ◽

Management Structure

Abstract A Patient Data Management System (PDMS) is being developed for use in the Intensive Care Unit (ICU) of the Montreal Children’s Hospital. The PDMS acquires real-time patient data from a network of physiological bedside monitors and facilitates the review and interpretation of this data by presenting it as graphical trends, charts and plots on a color video display. Due to the large amounts of data involved, the data storage and data management processes are an important task of the PDMS. The data management structure must integrate varied data types and provide database support for different applications, while preserving the real-time acquisition of network data. This paper outlines a new data management structure which is based primarily on OS/2’s Extended Edition relational database. The relational database design is expected to solve the query shortcomings of the previous data management structure, as well as offer support for security and concurrency. The discussion will also highlight future advantages available from a network implementation.

Download Full-text

Risk Management on Information Security in ABC Company

ACMIT Proceedings ◽

10.33555/acmit.v4i1.60 ◽

2017 ◽

Vol 4 (1) ◽

pp. 62-66

Author(s):

Luyen Ha Nam

Keyword(s):

Risk Management ◽

Information Security ◽

Data Management ◽

Management System ◽

Risk Mitigation ◽

Data Management System ◽

Data Centre ◽

Long Time ◽

Mitigation Action ◽

Better Than

From long, long time ago until nowadays information still takes a serious position for all aspect of life, fromindividual to organization. In ABC company information is somewhat very sensitive, very important. But how wekeep our information safe, well we have many ways to do that: in hard drive, removable disc etc. with otherorganizations they even have data centre to save their information. The objective of information security is to keep information safe from unwanted access. We applied Risk Mitigation Action framework on our data management system and after several months we have a result far better than before we use it: information more secure, quickly detect incidents, improve internal and external collaboration etc.

Download Full-text