Method for updating resource reserve data of mineral resource reserve database

Through automatic comparison and differential update of the national condition database and reserve database, the problems of low efficiency and poor quality of mineral resource reserve data updates have been solved, and more efficient and accurate data updates have been achieved.

CN119025529AInactive Publication Date: 2024-11-26HENAN PROVINCE LAND SPACE SURVEY PLANNING INSTITUTE
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202410336908.3
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-03-22
Publication Date
2024-11-26
Estimated Expiration
Not applicable · inactive patent

AI Technical Summary

Technical Problem

The update of existing mineral resource reserve data mainly relies on manual operations, resulting in low data timeliness, poor quality, low efficiency and error-prone.

Method used

By automatically comparing the resource reserve data records in the national condition database and the reserve database, updating them according to the differences in the set fields, calculating imbalance and judging the balance relationship, and clearing the redundant data after the update is completed.

Benefits of technology

It realizes faster, efficient and accurate data updates in resource reserves, improves the timeliness and quality of data, and reduces the occurrence of manual errors.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119025529A_ABST
    Figure CN119025529A_ABST
Patent Text Reader

Abstract

The invention relates to a mineral resource reserve database resource reserve data updating method, and belongs to the technical field of mineral resource reserve data management. According to the method, resource reserve data records in a mineral resource national condition investigation database (a national condition database for short) and a mineral resource reserve database (a reserve database for short) are automatically compared according to set fields, and the difference between the national condition database and the reserve database is determined by automatically comparing the set fields of the records in the two databases; and updating the resource reserve data of the reserve library according to the difference. Compared with a method of manually updating data in daily reserve management, the method adopted by the invention can update the reserve library more quickly, efficiently and accurately by using the national condition library.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The invention relates to a method for updating resource reserve data of a mineral resource reserve database, belonging to the technical field of mineral resource reserve data management. Background Art

[0002] Mineral resources are the material basis for economic and social development and play a key role in the healthy development of the national economy.

[0003] The existing update management mainly relies on manual work, where mineral resource reserve management data is manually updated one by one. Since the amount of data on resource reserves in the reserve library is very large, the workload of manual updating is huge, which in turn affects efficiency, and errors are easy to occur due to human errors. Summary of the invention

[0004] The purpose of the present invention is to provide a method for updating resource reserve data of a mineral resource reserve database to solve the current problems of low data timeliness, poor data quality and low efficiency and easy errors caused by manual updating.

[0005] In order to solve the above technical problems, the present invention provides a method for updating resource reserve data in a mineral resource reserve database, the method comprising the following steps:

[0006] 1) Automatically compare the resource reserve data records in the national conditions database and the reserve database according to the set fields;

[0007] 2) If the set fields of the records in the national conditions database and the resource reserve data records in the reserve database are the same, then determine whether the reserve types are the same. If they are the same, delete the year-end value in the reserve database and replace it with the year-end value of the reserve in the corresponding record in the national conditions database; if the reserve types are different, update them according to the differences between the national conditions database and the reserve database;

[0008] 3) If the setting fields of the records in the national conditions database and the resource reserve data records in the reserve database are not all the same, they need to be updated according to the differences between the national conditions database and the reserve database.

[0009] Furthermore, in the step 2), when the reserve types are different, if the reserve type exists in the reserve library but not in the national conditions library, the year-end value of the record in the reserve library is deleted; if the reserve type exists in the national conditions library but not in the reserve library, the record in the national conditions library that does not contain the beginning-of-year value is added to the reserve library.

[0010] Furthermore, in the step 3), when the setting field exists in the reserve library but not in the national conditions library, the year-end value of the record in the reserve library is deleted; when the setting field exists in the national conditions library but not in the reserve library, the record in the national conditions library that does not contain the beginning-of-year value is added to the reserve library.

[0011] Furthermore, the setting fields include mining area number, registration classification number, mineral resource code, statistical object, ore type and ore grade.

[0012] Furthermore, the method also includes calculating the imbalance of each record in the reserve library, judging whether the balance relationship is satisfied according to the imbalance, and updating the value of the corresponding field of the reserve library resource reserve data table with the imbalance.

[0013] Furthermore, the calculation formula of the unbalance amount is:

[0014] Unbalanced amount = end-of-year value - beginning-of-year value + mining volume + loss volume - exploration increase and decrease volume - recalculation increase and decrease volume

[0015] If the unbalanced value is equal to zero, it means that the equilibrium relationship is satisfied.

[0016] Furthermore, the method also includes updating the remark information recorded in the reserve library, and appending the string "data adjustment was carried out according to the results of the national conditions survey" to the remark information.

[0017] Furthermore, the step 1) is to import the national conditions database into the reserve database for automatic comparison.

[0018] Furthermore, the method also includes clearing the national conditions database imported into the reserve library after the update is completed.

[0019] The beneficial effects of the present invention are as follows: as an improved invention, the present invention automatically compares the resource reserve data records in the national conditions database and the reserve database according to the set fields, determines the difference between the national conditions database and the reserve database by automatically comparing the set fields under each record in the two databases, and updates the resource reserve data for the reserve database according to the difference. Compared with the method of manually updating data often used in daily reserve management, the method adopted by the present invention can use the national conditions database to update the resource reserve data of the reserve database more quickly, efficiently and accurately. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] Figure 1 It is a schematic diagram of a program interface used in the method for updating resource reserve data of a reserve library of the present invention;

[0021] Figure 2 It is a flow chart of the method for updating the resource reserve data of the reserve library of the present invention. DETAILED DESCRIPTION

[0022] The specific implementation of the present invention will be further described below in conjunction with the accompanying drawings.

[0023] The present invention automatically compares the resource reserve data records in the national conditions database and the reserve database according to the set fields, determines the difference between the national conditions database and the reserve database by automatically comparing the set fields under each record in the two databases, and updates the resource reserve data in the reserve database according to the difference. The specific implementation process of the method is as follows Figure 2 As shown, the detailed description is given below.

[0024] S1. Obtain national conditions database and reserve database

[0025] The reserve database is used to store the resource reserve information of mineral resources, including many data record tables, among which the resource reserve table includes many fields, such as mining area number, registration classification number, mineral code, statistical object, ore type, ore grade, reserve type, year-end value, beginning value, mining volume, loss volume, exploration increase and decrease, etc. In addition to the fields in the reserve database, the national conditions database also includes other fields. In addition, since the beginning value of the resource reserve data record in the reserve database is the end value of the previous year, it cannot be modified during subsequent updates.

[0026] In order to facilitate the subsequent automatic comparison in this embodiment, the resource reserve data table in the national conditions database is first imported into the reserve database, and a record-by-record comparison is performed in the reserve database. As another implementation method, the national conditions database and the reserve database can also be imported into a common database.

[0027] S2. Automatically compare the resource reserve data records in the national conditions database and the reserve database according to the set fields.

[0028] When comparing records one by one, the set fields in each record are compared. The set fields in this embodiment include mining area number, registration classification number, mineral code, statistical object, ore type and ore grade. As other implementations, the set fields can be part of the above field names and more field names, which can be set according to actual conditions. This embodiment uses the comparison of the above 6 fields to determine whether two records are the same record, for example, if there are records with exactly the same 6 fields in the two libraries.

[0029] S3. Execute different update strategies according to the comparison results.

[0030] S3-1 When the names of the set fields of the records in the two databases are not completely the same, and there are records in the national conditions database and no corresponding records in the reserves database.

[0031] In this embodiment, when the mining area number, registration classification number, mineral product code, statistical object, ore type and ore grade of the same mining area or mine in the two databases are not all the same, and there is a record in the national conditions database but no corresponding record in the reserve database, the resource reserve record in the national conditions database is removed from the resource volume at the beginning of the year and then added to the reserve database. The specific principle implementation code is as follows:

[0032] INSERT INTO KCL_ZYCL

[0033] (ND,KQBH,DJFLBH,KSBH,KCDM,TJDX,KSLX,KSPJ,ZYCLLB,ZYCLLX,JSL,KSL,KCZHM,KCZH)

[0034] SELECT

[0035] CLK_YEAR,A.KQBH,A.DJFLBH,A.KSBH,A.KCDM,A.TJDX,A.KSLX,A.KSPJ,

[0036] A.ZYCLLB,A.ZYCLLX,A.JSL,A.KSL,A.KCZHM,A.KCZH

[0037] FROM KCL_ZYCL_National Conditions Database A

[0038] WHERE A.ND=GQK_YEAR

[0039] AND(A.ZYCLLB=19001OR A.ZYCLLB=19002)

[0040] AND NOT EXISTS(SELECT 1FROM KCL_ZYCL B

[0041] WHERE((A.KSPJ=B.KSPJ)AND(B.KSLX=A.KSLX)AND

[0042] (A.TJDX=B.TJDX)

[0043] AND(B.KCDM=A.KCDM)AND(A.DJFLBH=B.DJFLBH)

[0044] AND(B.KQBH=A.KQBH)AND(A.ND=GQK_YEAR)

[0045] AND(B.ND=CLK_YEAR));

[0046] S3-2 When the names of the set fields of the records in the two databases are not completely the same, and there are records in the reserves database but no corresponding records in the national conditions database.

[0047] If the mining area number, registration classification number, mineral product code, statistical object, ore type, and ore grade of the same mining area or mine in the two databases are not completely the same, and there is a record in the reserve database but no corresponding record in the national conditions database, the year-end value in the corresponding record in the reserve database will be deleted. The specific principle implementation code is as follows: DELETE A.*

[0048] FROM KCL_ZYCL A,KCL_ZYCL_National Conditions Database B

[0049] WHERE A.ND=CLK_YEAR AND A.KQBH=B.KQBH AND A.DJFLBH=B.DJFLBH

[0050] AND B.ND=GQK_YEAR AND(A.ZYCLLB=19001OR A.ZYCLLB=19002)

[0051] AND NOT EXISTS

[0052] (SELECT 1FROM KCL_ZYCL_National Conditions Library B

[0053] WHERE(A.ND=CLK_YEAR)AND(B.ND=GQK_YEAR)

[0054] AND(B.KQBH=A.KQBH)AND(B.DJFLBH=A.DJFLBH)

[0055] AND(B.KSPJ=A.KSPJ)AND(B.KSLX=A.KSLX)

[0056] AND(B.TJDX=A.TJDX)AND(B.KCDM=A.KCDM));

[0057] S3-3 When the names of the set fields of the records in the two databases are all the same, the reserve types are different, and there are records in the national conditions database but no corresponding records in the reserves database.

[0058] If the mining area number, registration classification number, mineral product code, statistical object, ore type, and ore grade of the same mining area or mine in the two databases are all the same, but the reserve types are different and there is a record in the national conditions database but no corresponding record in the reserve database, then the resource reserve record in the national conditions database will be removed from the resource volume at the beginning of the year and added to the reserve database. For the specific principle code, refer to step S3-1, except that a judgment condition for the reserve type needs to be added to the program algorithm conditions.

[0059] S3-4 When the names of the set fields of the records in the two databases are all the same, the reserve types are different, and there are records in the reserve database but no corresponding records in the national conditions database.

[0060] In this embodiment, if the mining area number, registration classification number, mineral product code, statistical object, and ore grade of the same mining area or mine in the two databases are all the same, but the reserve types are different and there is a record in the reserve database but no corresponding record in the national conditions database, the year-end value of the record in the reserve database is deleted. For the specific principle code, refer to step S3-2, and only one reserve type judgment condition needs to be added to the program algorithm conditions.

[0061] S3-5 When the setting field names of the records in the two databases are all the same and the reserve types are also the same.

[0062] If the same mining area or mining area number, registration classification number, mineral code, statistical object, ore grade, and reserve type are all the same in the two databases, then the year-end value of the record in the reserve database needs to be replaced. For the specific principle code, refer to step S3-2. First, the year-end value in the reserve database is deleted through the program algorithm, and then replaced by the year-end value of the record in the corresponding national conditions database.

[0063] S4. Determine whether the resource reserve data records in the updated reserve library satisfy the balance relationship.

[0064] According to the management rules of reserve data, the resource reserves at the beginning and end of the year must maintain a balanced relationship. Therefore, the present invention determines the balance relationship of each record in the reserve library after the update in step 3, calculates the imbalance amount of each record in the reserve library, determines whether the balance relationship is satisfied according to the imbalance amount, and updates the value of the corresponding field of the resource reserve data table in the reserve library with the imbalance amount.

[0065] The calculation formula of unbalance is:

[0066] Unbalanced amount = year-end value - beginning value + mining amount + loss amount - exploration increase and decrease amount - recalculated increase and decrease amount. When the unbalanced amount is equal to zero, it means that the record satisfies the balance relationship, otherwise it does not satisfy the balance relationship.

[0067] The calculated data (i.e., unbalanced amount) replaces the value of the [Other] field in the KCL_ZYCL table in the reserve library. The specific principle implementation code is as follows:

[0068] 'rs1 is the set of records that need to modify other values, and rs2 is a temporary storage for the records extracted from rs1 that participate in the operation

[0069] rs1.MoveFirst

[0070] While Not rs1.EOF

[0071] 'Call function get_zyl_sql to extract the mine records with the same mining area number, classification number, mineral code, mineral combination, statistical object, ore type, ore grade, resource reserve type, and display serial number in the kcl_zycl table and rs1 collection to rs2, and extract the beginning of the year inventory of 19012

[0072] sqlstr2=get_zyl_sql(rs1,19012)

[0073] Set rs2=CurrentDb.OpenRecordset(sqlstr2)

[0074] If Not(rs2.BOF And rs2.EOF)Then' Determine whether the current record set is empty

[0075] Arr quantity at the beginning of the year (0) = rs2! jsl

[0076] arr beginning of the year holdings (1) = rs2! ksl

[0077] End If

[0078] rs2.Close

[0079] Set rs2 = Nothing

[0080] 'According to the above method, extract 19004, 19005, 19006, 19008, and 19001 into the arrays of arr mining volume, arr loss volume, arr exploration increase and decrease volume, arr recalculation increase and decrease volume, and arr year-end inventory volume respectively

[0081] sqlstr2=get_zyl_sql(rs1,19007)

[0082] Set rs2=CurrentDb.OpenRecordset(sqlstr2)

[0083] jsl_tmp = arr year-end reserves (0) - arr year-beginning reserves (0) + arr mining volume (0) + arr loss volume (0) - arr exploration increase and decrease volume (0) - arr recalculation increase and decrease volume (0)

[0084] ksl_tmp = arr end-of-year reserves (1) - arr beginning-of-year reserves (1) + arr mining reserves (1) + arr losses (1) - arr exploration increases and decreases (1) - arr recalculated increases and decreases (1)

[0085] 'If the difference in metal quantity and ore quantity is all 0, and there is an [Other] item, delete the [Other] item value

[0086] If Not(jsl_tmp=0And ksl_tmp=0)Then

[0087] If Not(rs2.BOF And rs2.EOF)Then'Judge whether there is an [Other] item, and the metal amount and ore amount are not all 0, if so, modify the [Other] item value

[0088]

[0089] 'If there is no record for the [Other] item, and the metal quantity and ore quantity are not all 0, a new record needs to be inserted (except ZYCLLB, which is not inserted, and the other records are copied from rs1)

[0090]

[0091]

[0092] S5 modifies the remarks in the reserve library.

[0093] In order to facilitate the staff to timely understand whether the reserve library has been updated, the present invention modifies the value of the [Remarks] field in the KCL_KS table in the reserve library, and adds the content "Data adjustment based on national conditions survey results" to indicate that the resource reserve data of the mining area or mine has been updated. The specific principle implementation code is as follows:

[0094] 'TableTemp is the record where other values ​​of the fields have been modified

[0095] UPDATE DISTINCTROW KCL_KS

[0096] INNER JOIN TableTemp

[0097] ON((KCL_KS.DJFLBH=TableTemp.DJFLBH)

[0098] AND(KCL_KS.KQBH=TableTemp.KQBH)

[0099] AND(KCL_KS.ND=TableTemp.ND))

[0100] SET KCL_KS.CLTJBZ="The resource reserves were adjusted according to the national conditions survey results.

[0101] "&KCL_KS.CLTJBZ

[0102] WHERE(

[0103] KCL_KS.CLTJBZ NOT LIKE "*National Survey Results Data*"

[0104] OR KCL_KS.CLTJBZ IS NULL );

[0106] S6. Clear redundant data.

[0107] When the above process is completed, it means that the resource reserve data of the reserve library has been completely updated, and the national conditions library data imported into the reserve library is redundant data. At this time, the imported national conditions library temporary data can be cleared. The specific principle implementation code is as follows:

[0108] 'Traverse the tables in the target database and delete the existing national conditions database tables that were originally imported

[0109] For Each tblDef In targetDB.TableDefs

[0110] If(tblDef.Name Like"*National Conditions Database*")Then On Error Resume Next

[0111] CurrentDb.Execute("drop table"&tblDef.Name)

[0112] End If

[0113] Next tblDef

[0114] The method of the present invention can be developed into a corresponding management system, which can be used Figure 1 The program interface is provided for users to operate. The present invention automatically compares the records in the national conditions database and the reserve database according to the set fields, determines the difference between the national conditions database and the reserve database by automatically comparing the set fields under each record in the two databases, and updates the resource reserve data of the reserve database according to the difference. Compared with the method of manually updating data often used in daily reserve management, the method adopted by the present invention can use the national conditions database to update the reserve database more quickly, efficiently and accurately.

Claims

1. A method for updating resource reserve data in a mineral resource reserve database, characterized in that: The method comprises the following steps: 1) Automatically compare the resource reserve data records in the national conditions database and the reserve database according to the set fields; 2) If the set fields of the records in the national conditions database and the resource reserve data records in the reserve database are the same, then determine whether the reserve types are the same. If they are the same, delete the year-end value in the reserve database and replace it with the year-end value of the reserve in the corresponding record in the national conditions database; if the reserve types are different, update them according to the differences between the national conditions database and the reserve database; 3) If the setting fields of the records in the national conditions database and the resource reserve data records in the reserve database are not all the same, they need to be updated according to the differences between the national conditions database and the reserve database.

2. The method for updating resource reserve data of a mineral resource reserve database according to claim 1, characterized in that: In the step 2), when the reserve types are different, if the reserve type exists in the reserve library but not in the national conditions library, the year-end value of the record in the reserve library is deleted; if the reserve type exists in the national conditions library but not in the reserve library, the record in the national conditions library that does not contain the beginning-of-year value is added to the reserve library.

3. The method for updating resource reserve data of a mineral resource reserve database according to claim 1, characterized in that: In the step 3), when the setting field exists in the reserve library but not in the national conditions library, the year-end value of the record in the reserve library is deleted; when the setting field exists in the national conditions library but not in the reserve library, the record in the national conditions library that does not contain the beginning-of-year value is added to the reserve library.

4. The method for updating resource reserve data of a mineral resource reserve database according to any one of claims 1 to 3, characterized in that: The setting fields include mining area number, registration classification number, mineral code, statistical object, ore type and ore grade.

5. The method for updating resource reserve data of a mineral resource reserve database according to claim 1, characterized in that: The method also includes calculating the unbalanced amount of each record in the reserve library, judging whether the balance relationship is satisfied according to the unbalanced amount, and updating the value of the corresponding field of the resource reserve data table of the reserve library with the unbalanced amount.

6. The method for updating resource reserve data of a mineral resource reserve database according to claim 5, characterized in that: The calculation formula of the unbalance amount is: Unbalanced amount = end-of-year value - beginning-of-year value + mining volume + loss volume - exploration increase and decrease volume - recalculation increase and decrease volume If the unbalanced value is equal to zero, it means that the equilibrium relationship is satisfied.

7. The method for updating resource reserve data of a mineral resource reserve database according to claim 1, characterized in that: The step 1) is to import the national conditions database into the reserve database for automatic comparison.

8. The method for updating resource reserve data of a mineral resource reserve database according to claim 6, characterized in that: The method also includes clearing the national conditions library imported into the reserve library after the update is completed.