Select your language

Schweizerische Stiftung für Edelstein-Forschung - SSEF - Comprehensive reference database

Schweizerische Stiftung für Edelstein-Forschung - SSEF - Comprehensive reference database

Exasol


We are very happy with the outcome of this project. It is still ongoing and we hope for further collaboration in developing the database.“

Dr. Hao Wang, Research Scientist SSEF

Initial situation
Precious stones and pearls are among the most valuable materials in the world. However, before they are processed into luxury goods, their authenticity must be tested. The Swiss Foundation for Gemstone Research (SSEF) operates a testing laboratory in Basel. Gemstones are tested for chemical and physical properties in a series of analyses and pearls are X-rayed. Thus, a large amount of data on each gemstone examined accumulates. This ultimately forms the basis of a comprehensive gemstone determination and thus for the issuing of an examination report. The SSEF would like to collate this data in a database and have access to the collected comparative values at any time in order to optimise the classification with statistical models.


Challenge
After an object is analysed using various test methods, the measurement results from several sources are transferred to a database. However, the data is structured differently. iRIX has to unify the data, create a dashboard and ensure that measurement results are correctly integrated into the database. The SSEF database contains test results of authenticity, proof of treatment and country of origin. The aim is to create a comprehensive reference database that can be used for the future identification of gemstones.


Solution
iRIX provides a database and supports the SSEF in defining the toolset for visualising and comparing the data. The data in different formats is automatically converted and fed into the database. The aim of the database is to bring together a set of analysis results that can be accessed in different formats and at different times so that they can be visualised and compared at any time.


Added value for the client
The manual transfer of data and thus the risk of incorrect entries is eliminated. "With iRIX's know-how, we have defined the database structure as well as built a database. We are now working on the internal software that accesses our analytical data from the analytical devices and integrates it into the database," adds Dr Hao Wang.

Technologies used

Postgres, Zeppelin Notebooks (Python)

Further customer projects

Efficient master data management

Efficient master data management

Implementation of a cost-effective pilot solution

read more

DWH automation

DWH automation

Through iRIX coaching to establish a DWH automation tool

read more

Analysis Solar data Coal silo

Analysis Solar data Coal silo

From coal silo to electricity storage

read more

Contact us

Subject *
Name *
Email *
Message
I agree with the privacy policy

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.