University of Oulu

Gavryliv, L., Ponomar, V., & Putiš, M. (2023). Classifying minerals and their related names in a relational database. Mineralogical Magazine, 87(3), 480-493. doi:10.1180/mgm.2023.23

Classifying minerals and their related names in a relational database

Saved in:
Author: Gavryliv, Liubomyr1; Ponomar, Vitalii2; Putiš, Marián1
Organizations: 1Comenius University, Faculty of Natural Sciences, Department of Mineralogy, Petrology and Economic Geology, Ilkovičova, Bratislava, Slovakia
2University of Oulu, Faculty of Technology, Fiber and Particle Engineering Research Unit, Pentti Kaiteran katu 1, Oulu, Finland
Format: article
Version: accepted version
Access: embargoed
Persistent link:
Language: English
Published: Cambridge University Press, 2023
Publish Date: 2023-10-20


The categorisation of minerals and their related names, such as synonyms, obsolete or historical names, varieties or mixtures, is an asset for designing an interoperable and consistent mineralogical data warehouse. An enormous amount of this data, provided by and other resources, was reviewed and analysed during the research. The analysis indicates the existence of several categories of (1) the abstract titles or designations representing the link to the original material or a group of names or substances without actual physical representation, and (2) the unique names representing actual physical material, compounds, or an aggregate of one or more minerals. A revision of the dependency between the categories attributes stored in a database (e.g. chemical properties, physical properties) and their classification status assigned allowed us to design a robust prototype for maintaining database integrity and consistency. The proposed scheme allows standardisation and structuring of officially regulated and maintained species, e.g. IMA-approved, and, in addition, unregulated ones.

see all

Series: Mineralogical magazine
ISSN: 0026-461X
ISSN-E: 1471-8022
ISSN-L: 0026-461X
Volume: 87
Issue: 3
Pages: 480 - 493
DOI: 10.1180/mgm.2023.23
Type of Publication: A1 Journal article – refereed
Field of Science: 1171 Geosciences
Funding: Liubomyr Gavryliv project No. 3007/01/01 has received funding from the European Union's Horizon 2020 research and innovation Programme based on a grant agreement under the Marie Sklodowska-Curie scheme No. 945478. Additionally, the research was supported by the Slovak Research and Development Agency (contract APVV-19-0065).
Copyright information: This article has been published in a revised form in Mineralogical Magazine This version is free to view and download for private research and study only. Not for re-distribution or re-use. © The Author(s), 2023. Published by Cambridge University Press on behalf of The Mineralogical Society of the United Kingdom and Ireland.