当前位置: X-MOL 学术Mineral. Mag. › 论文详情
Our official English website, www.x-mol.net, welcomes your feedback! (Note: you will need to create a separate account there.)
Classifying minerals and their related names in a relational database
Mineralogical Magazine ( IF 2.7 ) Pub Date : 2023-04-20 , DOI: 10.1180/mgm.2023.23
Liubomyr Gavryliv , Vitalii Ponomar , Marián Putiš

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.



中文翻译:

在关系数据库中对矿物及其相关名称进行分类

矿物及其相关名称(例如同义词、过时或历史名称、品种或混合物)的分类是设计可互操作且一致的矿物学数据仓库的资产。研究期间对 Mindat.org 和其他资源提供的大量数据进行了审查和分析。分析表明存在以下几类:(1) 代表与原始材料或一组没有实际物理表示的名称或物质的链接的抽象标题或名称,以及 (2) 代表实际物理材料、化合物、或一种或多种矿物质的聚集体。数据库中存储的类别属性之间的依赖性的修订(例如化学性质,物理属性)及其分配的分类状态使我们能够设计一个强大的原型来维护数据库的完整性和一致性。拟议的计划允许对官方监管和维护的物种(例如IMA 批准的物种)以及不受监管的物种进行标准化和结构化。

更新日期:2023-04-20
down
wechat
bug