Project Description
Currently, the new 52°North SOS version 4.x supports data storage for many different Database Management Systems based on Hibernate, such as Postgres/PostGIS, Oracle/Oracle Spatial, or Microsoft SQL.
This project aims to connect Rasdaman as an alternative data storage backend to the 52°North SOS and explore storing array observations in the SOS. We currently explore the integration process and consider several alternatives:
- create the internal data source representation of the SOS by implementing the 52°North SOS Rasdaman “data access objects”,
- create Rasdaman-Hibernate mappings for 52°North SOS, e.g. by implementing a generic Rasdaman JDBC driver.
Eventually, the project shall allow users to:
- integrate 52°North SOS into petascope,
- query data from Rasdaman using the SOS interface, e.g. timeseries of single raster cells, and
- integrate the configuration of Rasdaman as a datasource into the configuration wizard.
You may wonder why the 52°North SOS needs another DBMS if it already has two of them, which are well known and pretty fast. After that you will wonder why the 52°North SOS would want to integrate this backend data storage if there is nothing special about it. It’s perfectly fine for you to ask these questions and we’ll try to give you some answers.
- Rasdaman is the first (and currently only fully implemented) array DBMS.
- Rasdaman supports multi-dimensional raster data of unlimited size through an SQL-style query language. It allows the quick set up array-intensive services, which are distinguished by their flexibility, speed and scalability.
- It’s the 52°North SOS’ responsibility to offer its users as many storage alternatives as possible.
Here is an overview of how the 52°North SOS will be connected to Rasdaman:
About me
My name is Badoiu Simona Andreea and I am a 4th year student at Politehnica University of Bucharest, studying Computer Science. You can follow me and the development progress on GitHub or you can visit the Sensor Data Access for Rasdaman wiki page.
Bruce Bannerman says
Good luck with your project. It certainly has a lot of potential.
Will you be also looking at modelling observations data as per Observations and Measurements?
That is, not just the observed or measured value, but related ‘metadata’ as well?
DanielNuest says
Thanks for your interest!
The project right now is in the phase to make Rasdaman available through a database abstraction layer, i.e. Hibernate.
Then we will conceptualize how to provide data access via the SOS interface. I don’t really want to replicate data services for raster data (e.g. WCS) just with O&M encoding. I (currently) like the idea of having access to the time series of a single array cell.
Would you be interested to discuss our ideas or do you have a use case in mind?
Bruce Bannerman says
Hi Daniel,
Yes, I have several use cases.
I’d be happy to discuss off-line.
You have my email address.
Bruce