Schweizerische Stiftung für Edelstein-Forschung - SSEF - Comprehensive reference database
„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.
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)
