Design and Implementation of Database Management System for Mineral, Rock and Fossil Specimen Resources

Abstract

According to the demand for standardized input, management and sharing of mineral, rock and fossil specimen data, based on the mineral, rock and fossil specimen description standards and specifications released by National Infrastructure of Mineral, Rock and Fossil for Science and Technology (NIMRF), a database management system for mineral, rock and fossil specimen resources was designed and developed. In this paper, the overall architecture of the database system is designed using the front-end and back-end separation model and three-layer structure, and then relevant description standards and specifications are integrated into the design of the mineral, rock and fossil specimen database. Finally, based on current popular open source frameworks such as Spring Boot, Vue, etc., the management system has been developed. It realizes management functions of adding, deleting, updating and querying for the mineral, rock and fossil specimen database and also includes function of system management. In this way, a uniform mineral, rock and fossil specimen resource database can be built, which lay a solid foundation for data sharing of mineral, rock and specimen resources on the NIMRF platform. The application of the database management system is helpful to promote material sharing by information sharing, and improve the utilization rate of existing specimen resources.