Abstract: This paper discusses the practical significance and necessity of establishing an integrated database system for physical achievements generated by exploration projects in crisis mines, as well as the basic principles for setting up such a database system, its fundamental structural design, and the functions of its database management system.
Keywords: crisis mine; physical asset integration; database
I. Introduction
In the “Integration of Physical Results from Critical Mine Exploration Projects” project, in accordance with the project’s intended design, while completing the project’s assigned tasks, we collected and organized a large volume of physical geological data from previously validated exploration projects, including core samples and associated mine specimens. We also collected and properly prepared a certain number of representative large-scale ore specimens from the mines. At the same time, we completed the scanning and digitization of images for some key core samples.
This paper aims to discuss how, after collecting and organizing a wide variety of physical specimens, data, and images, we can leverage increasingly sophisticated information-processing technologies to structure the collected specimen data into a query-based database. This approach will enable the crisis-mine exploration results to be presented in a more intuitive, comprehensive, and objective manner, while also supporting efforts in science popularization, educational outreach, and professional teaching.
II. The Necessity and Practical Conditions for Building an Integrated Database of Physical Outcomes from Crisis-Mine Exploration Projects
(1) Background and Purpose of the “National Project for Prospecting Substitute Resources to Succeed Critical Mines”:
A so-called "crisis mine" refers to large- and medium-sized state-owned mines whose recoverable reserves, under current mining technologies and extraction capacities, have a remaining service life of 15 years or less. Most of China's non-oil and gas mines were built relatively early, and now most have entered the mid-to-late stages of mining. Some key mines are facing the serious issue of insufficient resources for continued mining operations.
Today, there are two important approaches to mineral exploration: exploration focused on existing mines and exploration guided by metallogenic belts. Practice has shown that the deep and peripheral areas of already developed mines represent crucial avenues for discovering new ore deposits and expanding resource reserves. Old mines are characterized by well-exposed geological features and abundant geological data. Therefore, undertaking successor resource exploration at crisis mines—characterized by a focus on exploiting existing mines—is a practical and sound strategic choice.
Meanwhile, China faces a serious shortage of proven reserves in its medium- and large-sized mines, making it imperative to promptly identify replacement resources. According to a resource potential survey conducted by the Ministry of Natural Resources on 18 mineral types and 565 medium- and large-sized mines across China, 192 of these mines have the potential to further increase their recoverable reserves through exploration in deeper or adjacent areas.
It was against this backdrop that, in September 2004, the 63rd Executive Meeting of the State Council reviewed and approved the "Outline for the National Program on Prospecting for Substitute Resources to Sustain Critical Mines (2004-2010)." The meeting decided to carry out prospecting activities around or at greater depths of existing mines with resource potential and market demand, with the aim of extending the service life of these mines. This represents a commercially oriented geological endeavor undertaken by the state, accompanied by policy support. This is precisely the reason behind the launch of the "National Program on Prospecting for Substitute Resources to Sustain Critical Mines" project.
(2) The significance of building the “Integrated Database System for Physical Outcomes of Critical Mine Exploration Projects”:
As a follow-up project to the “National Crisis Mine Successor Resource Exploration” initiative, the “Integration of Physical Results from Crisis Mine Exploration Projects” aims to comprehensively track the implementation progress of the national crisis mine successor resource exploration projects, systematically collect important physical geological data from major and medium-sized solid mineral mines across the country, and conduct preliminary research and integrate these collected physical geological data. This effort is intended to compile and provide physical results data for the national crisis mine successor resource exploration initiative, thereby serving society.
The mines involved in the Crisis Mine Project are, for the most part, well-known, long-established mines in China. Many of these mines host ore deposits of significant representative value, and their physical geological specimens carry profound geological and ore-depositological implications. They represent an important source for collecting specimens for the National Physical Specimen Repository. The collection, organization, preservation, and archiving of these physical specimens are of great practical significance for enriching the content of the National Physical Specimen Repository, establishing a clearly structured national archive system for physical geological data on mineral resources, and facilitating subsequent systematic analytical research.
(3) Realistic conditions for the construction of the database system for the “Integration of Physical Results of Critical Mine Exploration Projects”:
Through the collection and tracking of information on the progress of mineral exploration projects in crisis mines, as well as on the physical data generated, we have gained a deeper understanding of both the progress of these projects and the nature of the physical data produced. By engaging in fieldwork practice, we have continuously identified and resolved issues encountered during our work. Through the ongoing refinement of our guiding principles and working approaches, we have laid a solid foundation for the large-scale implementation of physical data collection and compilation efforts.
3. Strategic Approach to Building an Integrated Database of Physical Outcomes from Crisis Mine Exploration Projects
(1) Basic principles for establishing a database system:
1. Maximize the highlighting of the integrated data characteristics of physical findings, and prominently showcase background information, physical materials, and imagery related to mine site documentation.
2. Retrieve customer search queries through the database, and use the mineralization belt map module to integrate mine information and corresponding results data (specimen images, key core scan images, accompanying specimen images, etc.) into graphical retrieval and directory tree displays.
3. Implement centralized display of retrieved content in specific categories, with the aim of identifying and summarizing certain patterns and preliminary research findings through comparative analysis.
(2) The basic structure of database systems and the functions of database management systems:
1. This database is composed of a management system program, an integrated database of results, and several functional modules (Figure 1).
1) User Help Module: Provides users with guidance on how to properly use the database, collects user feedback, offers database version information, and provides developer contact details.
2) System maintenance module: Includes data backup and data recovery, among other functions.
3) Data Input Module: Used to input data into the database.
4) Data backup module: Used for backing up data in the database.
5) Ore-formation Belt Control Module (Graphical Retrieval): This module is used to project the correct information retrieved from the results database onto the graphical retrieval of ore-forming belts, enabling intuitive visualization.
6) Data Output Module: Used for outputting various data charts and query results.
7) Query module: Used to query database content under different conditions.
2. To manage and utilize information in the database, the physical results integration database management system for the crisis mine exploration project should have the following functions:
1) Data input: Includes adding, modifying, deleting, and saving data.
2) Data Output: Output of various data tables and query results, with output formats presented in tabular form or expressed in graphical retrieval.
3) Data Query: Includes fuzzy queries (single or specific field queries) and exact queries (entering several query criteria simultaneously to refine the query results).
4) Field Search: By establishing a “data dictionary,” “field retrieval” becomes possible.
5) Data Statistics: Aggregate the search results generated under different retrieval conditions, compile reports, and prepare for research and analysis.
6) Print output: Images, tables, and other content that need to be printed during daily management and user browsing.
7) Help and Guidance: Includes system usage instructions, data retrieval tips, and guidelines for various values when entering data.
IV. Characteristics, Challenges, and Supporting Role in the Construction of an Integrated Information Database for Achievements in Exploration of Crisis Mines
(1) Characteristics and Challenges in the Construction of an Integrated Information Database for Research Outcomes
1. Classification characteristics of integrated information data on research outcomes:
The data content integrated from physical material resources is characterized by large volumes, relatively unstandardized content, complex storage media, and substantial multimedia data. Given these characteristics, a specialized classification approach is required. If we broadly categorize digitized materials according to their physical form, they can be divided into sections such as core samples, accompanying hand specimens, large specimens, thin sections, and other physical-material-related data. Alternatively, based on the mineral species associated with critical mines, they can be classified into categories such as gold mines, copper mines, lead-zinc mines, and so forth. Another classification method involves grouping digitized files according to their types: Word documents, stereoscopic video AVI files, microscopic slice images in JPG format, comprehensive columnar diagrams of core sample outer surfaces in PDF format, and mine borehole profile images in JPEG format. Yet another approach is to classify materials based on the geological metallogenic belts to which the mines belong, as well as the administrative regions where the mines are located. Each critical mine can serve as an individual unit for self-classification—progressively expanding the classification hierarchy down to specific levels such as mine, borehole, well section, drilling run, and even individual core-sample images. This systematic approach ensures the orderly organization and completeness of digitized physical data for each critical mine; however, it also introduces certain technical limitations regarding resource sharing and comparative analysis.
The construction of an integrated information database for geological achievements should not only reflect the characteristics of exploration projects in crisis mines but also meet the practical needs of database development, be user-friendly, and allow for maximum online publication. To this end, based on the data characteristics and actual applications, the integrated information database for geological achievements can be built as one or more separate databases, or various databases can be combined into a single integrated system.
1) Directory database
This primarily contains a catalog of digital documents related to various crisis mines. During the establishment process, a detailed catalog of data for each crisis mine can first be published separately as a directory database on a webpage or interface, enabling users to gain a clearer understanding of the general status of physical geological information for each crisis mine, thereby saving time in their searches and preparing them for more targeted, in-depth inquiries.
2) Digital Achievement Data Database
A database will be established to store digitized files containing comprehensive data on crisis mines. Through this database, users will be able to access complete digitized records of crisis mines, including text, images, and video materials.
3) Individual Mine Database
The various crisis-stricken mines will be organized into a database according to individual units. The purpose of doing so is to achieve clear thinking and make data query and retrieval design relatively straightforward. However, this approach introduces technical limitations when it comes to comparing and comprehensively utilizing mine data.
For the processing of multimedia data—including digital scans of mine geological maps, video recordings of large specimens, three-dimensional images of hand specimens, microscopic thin-section images, and textual documentation of research findings—external files can be used for storage. Additionally, a new field can be added to the database to store the file names, enabling easy retrieval of the corresponding multimedia information during searches. These files can be in text format, scanned graphic formats, or video formats. Raw physical data can be entered manually or converted from fixed-length files into a standardized format compliant with database specifications.
2. Challenges in the Construction of an Integrated Information Database for Research Outcomes
1) The information submitted for physical materials is incomplete.
The digital data used to build this database were collected, compiled, and organized through the submission and gathering of physical materials from the Critical Mine Exploration Project, after which they were categorized, filed, and stored. During the process of submission and collection, the completeness of the data reflecting the actual geological characteristics of the mines was rigorously ensured. Under the guidance of project supervision and review experts, representative drill holes were carefully selected in strict accordance with operational procedures. With coordinated cooperation from the project implementing agencies, field organization and on-site acceptance were completed. The materials were then transported to the national repository using secure packaging methods—all of which have influenced the integrity of the physical data.
2) Data Fidelity in the Digitization of Original Materials
During the digitalization of core samples, it is essential to systematically remove unnecessary information surrounding the core-image data according to core intervals during image cropping, stitching, and brightness adjustment. Additionally, overlapping stitching should be applied to duplicate sections. Only in this way can the images remain consistent with the actual core samples, thereby maximizing the preservation of the integrity of the digitized data without distortion.
3) The national map of major mineralized zones (belts) and their effective application in the integrated results database.
A metallogenic district (or belt) is a geological unit with potential for mineral resources. A key challenge in building a database lies in how to organically integrate the physical geological data from existing crisis mines with maps of metallogenic districts and belts, thereby providing supportive assistance to exploration projects targeting these crisis mines.
(2) Supporting assistance provided for crisis mine exploration projects
The integrated database of exploration results for crisis mines is a digital compilation of physical geological data from these mines. It should not be limited merely to the simple integration of physical materials; rather, it should be tailored to the specifics of each project and, whenever relevant data can be obtained, expand the meaning of the term “results” within the “integrated results.” This integration goes beyond mere compilation of physical materials—it should also encompass a holistic synthesis of all achievements made in crisis mine exploration projects, including such elements as newly identified resource reserves, breakthroughs in exploration technologies, innovative mineral prospecting and prediction methods, and new discoveries and insights gained during the course of the project. The purpose of doing so is to provide a more comprehensive overview of the results from crisis mine projects, enabling database users to gain a clearer, more intuitive understanding of the original conditions of these mines, their associated data and information, and the achievements attained through the exploration efforts. In this way, the database will truly serve as a valuable resource for supporting crisis mine exploration projects and will become a rich repository of data for subsequent scientific research.
V. Conclusion
As for the work of building an integrated database system for physical findings from crisis-mine exploration projects, the most critical task at present is to clarify our thinking, continuously refine and define the database requirements, integrate project data resources, further detail and improve module functionalities, and enhance the overall capabilities of the database system. This will enable us to comprehensively integrate materials in archival form and establish a digitized, archive-style database of physical specimens from crisis mines. The resulting information service products will represent China’s major mineral types, various metallogenic belts, and primary genetic types. By integrating and analyzing these data, we can provide supportive technical services for crisis-mine exploration projects, fully harnessing the social and economic value of the physical geological data generated by these projects.
References: ??? [1] Zhu Yusheng et al. 2007. Geological Characteristics of Major Metallogenic Regions (Belts) in China and the Metallogenic Sequence of Deposits. Beijing: Geological Publishing House, 208–211.
[2] Li Yin. 2009. Integration of Physical Results from Crisis Mine Exploration Projects—Design for the 2008 Follow-up Projects, Beijing: Center for Physical Geological Data of Land and Resources, 3–12.
[3] Li Yingkang. 2007. A Brief Introduction to the Physical Geological Data Information Service Network System. Selected Papers on Physical Geological Data. Beijing: Geological Publishing House, 126–130.
[4] Zhang Lihai. 2007. A Discussion on the Compilation and Research of Physical Geological Data. Selected Papers on Physical Geological Data. Beijing: Geological Publishing House, 53–57.