Developing a new data model and database management system of metamorphic rock in response to the big data era

In the study of metamorphism, distinguishing metamorphic stages facilitates the inversion of geodynamic systems. With the increasing refinement of metamorphism research, vast amounts of data have accumulated, aligning with big data characteristics. The big data era presents challenges in data presentation, management, and redundancy reduction. Current rock-geochemical databases often lack comprehensive storage of metamorphic stages and their associated information. This study designs a relational data model by analyzing various attributes of metamorphic rock data. This data model explores the correspondence between metamorphic stages and the data information of each stage, while also considering the correspondence between whole rock data and samples, as well as the presentation of protolith and deformation. A database management system is developed based on this framework, facilitating the creation, deletion, updating, and querying of data. The system enables users to utilize either whole-rock geochemical data or specific metamorphic stage data according to their research requirements. Brief examples illustrate the potential data field applications and future exploration directions. This study aims to enhance data management, providing a foundation for better presentation and utilization of metamorphic rock data, ensuring thorough exploration in the age of big data.