Based on the analysis of the functional requirements for data management and risk management of important metal mineral resources in key areas of my country’s neighboring countries, the functional structure of the information management and risk management system for the strategic selection of metal mineral resources in neighboring countries as shown in Figure 9.3 was established. .

Figure 9.3 Functional structure diagram of information management and risk management system for strategic selection of metal mineral resources in neighboring countries

(1) Mineral resource data management in neighboring countries

This function The subsystem is mainly used to manage the data of important mineral resources databases in key areas of my country's neighboring countries. These data include: geography, geology, important minerals, mining development and other spatial data at different scales in key areas of my country's neighboring countries. Important mineral areas have spatial attributes. Attribute data and decision-making data for risk management and evaluation, as well as text information reflecting the country's political, economic, mining laws and regulations, etc. Depending on the type and characteristics of the data, different management methods are used.

The first category is direct management.

This type of data includes two types.

1) Data containing spatial attributes. Including: ① point data: cities, towns, airports, etc.; ② line data: rivers, water systems, highways, railways, linear structural zones, etc.; ③ area data: countries, lakes, catchment basins, geological maps, etc.

These data are managed directly. After the data is obtained, copy it directly to the folder in the corresponding directory of this system. Through this application system, these data can be displayed, queried, and overlaid on other layers.

2) Plain text data. Including: the political and economic foundation of neighboring countries, national-level mining resource profiles and mining policies and other information.

After these data are obtained, they are organized into Microsoft Word documents and placed in the corresponding folders; this system is used to call the Microsoft Word documents so that users can obtain the corresponding information.

The second category: attribute data managed by Access. This type of data includes 3 types.

A. Use Access to manage attribute data and generate spatial data through this application system.

In order to improve the flexibility and real-time performance of the software, the attribute data of these data are managed in the Access database. Users can convert the data in the database into ArcInfo through operations on the application system software. Shape format file.

This type of data includes: three types of point data: mineral deposits, mines and mining companies.

B. Use Access to manage data, and generate data files in Excel format through the operation of this software.

Users can query and retrieve data in the underlying Access database through the query and retrieval functions of this application software. The final data is displayed in the form of Excel tables, and the data can be processed in Excel format files. storage.

This type of data includes: mineral reserve information at various levels, as well as the results of fuzzy queries and attribute data queries on mines, mineral deposits and mining companies.

C. Use Access to manage indicator data values ??used for risk assessment decisions.

In the study of decision-making methods related to risk management of the development and utilization of metal mineral resources in neighboring countries, the establishment of a risk evaluation index system and the selection of related models are discussed in detail. This includes area risk assessment and point area risk assessment.

The main modules of the mineral resources data management subsystem of surrounding countries include:

1) Data management and maintenance. Used for the creation and deletion of important mineral resources databases, mining development databases, national resource information databases, strategic selection risk assessment databases, mineral product market databases, development project databases and other databases and their data tables in key areas in my country's neighboring countries, as well as in each database Input and update data records, and can also import data from other databases (such as GIS databases).

2) Data retrieval and query. Used to query and retrieve data in specified databases and data tables according to user-set conditions.

The types of data query functions include:

A. Fuzzy query: Set the query category, such as mineral deposits, mines and mining companies, etc., and enter what the user wants to query in the query field. Keyword or field, the query results display all records containing the query keyword or field. In the query results, you can use the positioning function to display the location of the query results on the map. The main function of this query is to provide users with a fuzzy query with fewer certain factors.

B. Attribute query: Set query categories, such as mineral deposits, mines and mining companies, etc., and help users clarify the content they want to query through the selection of content in the drop-down list box, and finally graphically display it on the map Give a show. In attribute query, users are allowed to conduct multi-condition compound query by selecting fields. The search fields in the attribute query include the main attribute fields in the data table corresponding to the query category such as mineral deposits.

C. Spatial range query: Spatial range query can set circles, rectangles, polygons and select existing graphics in various ways. For circular space query, users are allowed to set the query radius or select it on the graph; for rectangular and polygon space query, users are allowed to outline graphics as needed.

For selecting existing graphics, users are allowed to select some areal layers (such as countries, geological units, etc. areal graphics), and then perform query retrieval within the selected area. All query results should be stored in the form of Shape layers or Excel tables.

D. Buffer query: Buffer query can set circles, rectangles, polygons, straight lines and select existing graphics in various ways. Users select a certain area according to their needs, then set the buffer radius and perform buffer query and retrieval. Buffer query includes three buffer query methods: inward query, outward query and bidirectional query. The results of buffer queries are saved in the form of Shape layer files.

3) Properties are associated with layers. It is used to establish the association between the specified data in the database and certain layers, so that the required data can be displayed in these layers.

4) Graphical data display. It is used to display or allow users to view various data information such as resources, investment environment, development status, etc. at the designated location or area in the selected map (Figure 9.4).

Figure 9.4 Information Management and Risk Management System Interface for Strategic Selection of Metal Mineral Resources in Neighboring Countries

There are two ways to view data.

Graphic view: The main interface of the system displays the distribution range of the entire Asia or a specified country. By clicking on the graph with the mouse, you can enter the viewing window and follow the prompts to view and retrieve data.

View in directory structure: Click on the tree layer directory structure to guide you step by step to view or retrieve the required content.

(2) Strategic selection decision analysis

This functional subsystem is mainly used for risk grading and quantitative evaluation of strategic selections of mineral resources in my country’s neighboring countries, and key metal mineral market risk assessments. Early warning and comprehensive evaluation of risks of major development projects. Basic functional modules include the following four types.

1) Model management. This functional module is mainly provided for expert users to create, search, modify, calculate and store various models required for decision analysis. In addition to risk assessment models that combine gray and fuzzy comprehensive assessment, risk assessment based on gray cluster analysis, and mineral product market risk assessment based on VaR, the system's model library can also be used by expert users to make decisions based on Analysis requires independently creating new models or adjusting the original models after the system is put into use, including setting the basic information of the model, selecting the type of model, setting the variables and data sources of the model, creating expressions for the model, and selecting the model. Solving algorithms, etc.

2) Regional risk assessment. It mainly realizes the risk assessment of mineral resource development strategic areas in my country's neighboring countries. First, the risk assessment model is used to quantitatively assess the risk, and then the assessed risk value is compared with the corresponding risk grading standards formulated to obtain the corresponding risk in the assessment area. risk rating. On this basis, the risk of the evaluated areas is distinguished and displayed in nine colors in three systems on the spatial map according to the risk evaluation value.

3) Project risk assessment. It mainly conducts risk assessment or multi-project risk comparison for large-scale metal mineral resource development projects in neighboring countries.

4) Mineral product market risk assessment and early warning. It mainly uses the market risk value V aR model to evaluate the fluctuation risks of futures market prices of six major metal mineral products, and considers the impact of changes in exchange rates and interest rates on price risks. At the same time, by setting a certain threshold for the risk of mineral product price fluctuations, early warning of market risks is achieved to prevent huge mineral product import and export losses caused by large fluctuations in mineral product futures prices, interest rates, and exchange rates.

(3) System management

This functional subsystem mainly implements GIS-based maps, layers, and graphics elements in the strategic selection information management and risk management system for metal mineral resources in surrounding countries. Information is maintained and operated. The basic functional module includes the following three aspects.

1) Thematic map management. This functional module is mainly used to save, delete, and import thematic maps, while also realizing functions such as clearing graphic data, correcting, rotating, and scaling maps, and generating graphics from data tables.

2) Layer management. This functional module is mainly used to load, create, merge and separate certain thematic map layers. It also implements functions such as moving, rotating and scaling layers, as well as creating and updating layer attribute fields.

3) System tools. The functions of this module include: setting submaps, fill patterns, colors, and fonts in the map; changing the system library; restoring or cleaning and deleting elements; defining the map range with the mouse; setting flashing colors; output of graphics and images, etc.