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

Zhiyuan Wu; Mingyue He; Mei Yang

doi:doi:10.11648/j.earth.20231204.11

| Peer-Reviewed

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

Zhiyuan Wu, Mingyue He, Mei Yang

Published in Earth Sciences (Volume 12, Issue 4)

Received: 6 June 2023 Accepted: 26 June 2023 Published: 6 July 2023

Views: Downloads:

Download PDF

Share This Article

Twitter
Linked In
Facebook

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), 2024. 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

Plain Text BibTeX RIS

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

Zhiyuan Wu

School of Information Engineering, China University of Geosciences (Beijing), Beijing, China
Mingyue He

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

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

Download PDF

Sections

Plain Text BibTeX RIS

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