| Peer-Reviewed

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

Received: 6 June 2023     Accepted: 26 June 2023     Published: 6 July 2023
Views:       Downloads:
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.

Published in Earth Sciences (Volume 12, Issue 4)
DOI 10.11648/j.earth.20231204.11
Page(s) 82-89
Creative Commons

This is an Open Access article, distributed under the terms of the Creative Commons Attribution 4.0 International License (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted use, distribution and reproduction in any medium or format, provided the original work is properly cited.

Copyright

Copyright © The Author(s), 2023. Published by Science Publishing Group

Keywords

Mineral Specimen, Rock Specimen, Fossil Specimen, Database, Management System, Spring Boot, Vue

References
[1] CHEN Yuan, YU Bisheng, YUAN Wei. (2003). Development of Geologic Specimen Database Based on Web [J]. Computer Engineering, 5: 181-183.
[2] About NIMRF [EB/OL]. http://www.nimrf.net.cn/pub/jianjie.jsp. 2023, 06.
[3] Description Standard [EB/OL]. http://www.nimrf.net.cn/pub/msbz.jsp. 2023, 06.
[4] Fang Sheng, Qin Xiaoan, Wang Rui. (2021) Journal of Yellow River Conservancy Technical Institute, 33 (4): 50-54.
[5] Spring Boot [EB/OL]. https://spring.io/projects/spring-boot. 2023, 06.
[6] MyBatis SQL mapper framework for Java [EB/OL]. https://blog.mybatis.org/. 2023, 06.
[7] Vue.js - The Progressive JavaScript Framework [EB/OL]. https://vuejs.org/. 2023, 06.
[8] Element - A Desktop UI Toolkit for Web [EB/OL]. https://element.eleme.io/. 2023, 06.
[9] Axios - Promise based HTTP client for the browser and node.js [EB/OL]. https://github.com/axios/axios. 2023, 06.
[10] LI Hang, DONG Anming, YU Jiguo, HAN Yubing. (2022) Design of intelligent agricultural IoT system based on front-rear end separation architecture [J]. Modern Electronics Technique, 45 (14): 63-68.
[11] WANG Jian, LUO Zheng, ZHANG Xi, ZHANG Mengqi, ZHANG Ke. (2020) Design and Implementation of WEB Project Front and Back Separation [J]. Software Engineering, 23 (4): 22-24.
[12] ZHONG Defu, ZHANG Liangguo, AI Hong, HUANG Xiaohua, LYU Junlin. (2019) Framework reconstruction of fishery resource survey data acquisition system based on NodeJS [J]. Fishery Modernization, 46 (6): 104-109.
[13] Wei Jia’nan, Wu Yong, Lin Huajian, Gong Yilong, Song Yun, Fu Junhao. (2020) DESIGN AND IMPLEMENTATION OF “ONE MAP” MANAGEMENT INFORMATION SYSTEM FOR NATURAL RESOURCES BASED ON WEBGIS [J]. Computer Applications and Software, 37 (9): 20-26.
[14] SHAO Jian-wei, LIANG Zhong-min, WANG Jun, HU Yi-ming, LI Bin-quan. (2020) Design and Development of Medium and Long-term Hydrological Forecasting System Based on SpringBoot Framework [J]. Water Resources and Power, 38 (4): 6-9, 5.
[15] XIANG Wu-ming, BAO Liang, YU Shao-hua. (2018) Design of Role Authentication Scheme for RESTful API Based on JWT [J]. Modern Computer, 34: 82-85.
[16] CHEN Jia. (2021) A Microservices Authentication and Authorization Scheme for Power System Based on JWT Token-based Authentication [J]. Electric Engineering, 16: 151-154.
Cite This Article
  • APA Style

    Zhiyuan Wu, Mingyue He, Mei Yang. (2023). Design and Implementation of Database Management System for Mineral, Rock and Fossil Specimen Resources. Earth Sciences, 12(4), 82-89. https://doi.org/10.11648/j.earth.20231204.11

    Copy | Download

    ACS Style

    Zhiyuan Wu; Mingyue He; Mei Yang. Design and Implementation of Database Management System for Mineral, Rock and Fossil Specimen Resources. Earth Sci. 2023, 12(4), 82-89. doi: 10.11648/j.earth.20231204.11

    Copy | Download

    AMA Style

    Zhiyuan Wu, Mingyue He, Mei Yang. Design and Implementation of Database Management System for Mineral, Rock and Fossil Specimen Resources. Earth Sci. 2023;12(4):82-89. doi: 10.11648/j.earth.20231204.11

    Copy | Download

  • @article{10.11648/j.earth.20231204.11,
      author = {Zhiyuan Wu and Mingyue He and Mei Yang},
      title = {Design and Implementation of Database Management System for Mineral, Rock and Fossil Specimen Resources},
      journal = {Earth Sciences},
      volume = {12},
      number = {4},
      pages = {82-89},
      doi = {10.11648/j.earth.20231204.11},
      url = {https://doi.org/10.11648/j.earth.20231204.11},
      eprint = {https://article.sciencepublishinggroup.com/pdf/10.11648.j.earth.20231204.11},
      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.},
     year = {2023}
    }
    

    Copy | Download

  • TY  - JOUR
    T1  - Design and Implementation of Database Management System for Mineral, Rock and Fossil Specimen Resources
    AU  - Zhiyuan Wu
    AU  - Mingyue He
    AU  - Mei Yang
    Y1  - 2023/07/06
    PY  - 2023
    N1  - https://doi.org/10.11648/j.earth.20231204.11
    DO  - 10.11648/j.earth.20231204.11
    T2  - Earth Sciences
    JF  - Earth Sciences
    JO  - Earth Sciences
    SP  - 82
    EP  - 89
    PB  - Science Publishing Group
    SN  - 2328-5982
    UR  - https://doi.org/10.11648/j.earth.20231204.11
    AB  - 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.
    VL  - 12
    IS  - 4
    ER  - 

    Copy | Download

Author Information
  • School of Information Engineering, China University of Geosciences (Beijing), Beijing, China

  • National Mineral Rock and Fossil Specimen Resource Center, China University of Geosciences (Beijing), Beijing, China

  • National Mineral Rock and Fossil Specimen Resource Center, China University of Geosciences (Beijing), Beijing, China

  • Sections