Hostname: page-component-74656f9884-rngvg Total loading time: 0 Render date: 2026-11-05T15:03:35.348Z Has data issue: false hasContentIssue false

Classifying minerals and their related names in a relational database

Published online by Cambridge University Press:  20 April 2023

Liubomyr Gavryliv*
Affiliation:
Comenius University, Faculty of Natural Sciences, Department of Mineralogy, Petrology and Economic Geology, Ilkovičova, Bratislava, Slovakia
Vitalii Ponomar
Affiliation:
University of Oulu, Faculty of Technology, Fiber and Particle Engineering Research Unit, Pentti Kaiteran katu 1, Oulu, Finland
Marián Putiš
Affiliation:
Comenius University, Faculty of Natural Sciences, Department of Mineralogy, Petrology and Economic Geology, Ilkovičova, Bratislava, Slovakia
*
Corresponding author: Liubomyr Gavryliv; Email: liubomyr.gavryliv@uniba.sk
Rights & Permissions [Opens in a new window]

Abstract

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 mindat.org 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.

Information

Type
Article
Copyright
Copyright © The Author(s), 2023. Published by Cambridge University Press on behalf of The Mineralogical Society of the United Kingdom and Ireland
Figure 0

Figure 1. A database schema for the classification and relations context. The data type definitions are as follows: int – integer; varchar – variable character field; bool – Boolean; txt – text; uuid – a universally unique identifier; PK – primary key; and FK – foreign key.

Figure 1

Table 1. Classification of the mineral-related names.

Figure 2

Table 2. The dependency between species status and its attributes.