CN111460061A - Database management system for solid core data - Google Patents
Database management system for solid core data Download PDFInfo
- Publication number
- CN111460061A CN111460061A CN202010148137.7A CN202010148137A CN111460061A CN 111460061 A CN111460061 A CN 111460061A CN 202010148137 A CN202010148137 A CN 202010148137A CN 111460061 A CN111460061 A CN 111460061A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- core
- module
- core data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 239000007787 solid Substances 0.000 title claims abstract description 34
- 238000007726 management method Methods 0.000 claims abstract description 61
- 238000004458 analytical method Methods 0.000 claims abstract description 26
- 238000010276 construction Methods 0.000 claims abstract description 18
- 238000013523 data management Methods 0.000 claims abstract description 13
- 238000012545 processing Methods 0.000 claims abstract description 13
- 238000000034 method Methods 0.000 claims abstract description 10
- 238000004364 calculation method Methods 0.000 claims abstract description 5
- 238000005553 drilling Methods 0.000 claims description 46
- 230000006870 function Effects 0.000 claims description 40
- 239000011435 rock Substances 0.000 claims description 25
- 238000010586 diagram Methods 0.000 claims description 22
- 238000005259 measurement Methods 0.000 claims description 22
- 238000005065 mining Methods 0.000 claims description 21
- 238000013461 design Methods 0.000 claims description 14
- 238000009826 distribution Methods 0.000 claims description 14
- 230000003993 interaction Effects 0.000 claims description 10
- 229910052500 inorganic mineral Inorganic materials 0.000 claims description 6
- 239000011707 mineral Substances 0.000 claims description 6
- 238000005070 sampling Methods 0.000 claims description 5
- 238000003860 storage Methods 0.000 claims description 5
- 230000010354 integration Effects 0.000 claims description 4
- 238000007639 printing Methods 0.000 claims description 4
- 238000012360 testing method Methods 0.000 claims description 4
- 238000005520 cutting process Methods 0.000 claims description 3
- 238000013479 data entry Methods 0.000 claims description 3
- 230000007246 mechanism Effects 0.000 claims description 3
- 239000000203 mixture Substances 0.000 claims description 3
- 238000004040 coloring Methods 0.000 claims description 2
- 230000009286 beneficial effect Effects 0.000 abstract description 3
- 238000013507 mapping Methods 0.000 abstract description 3
- 238000011161 development Methods 0.000 description 4
- 230000018109 developmental process Effects 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 4
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000011160 research Methods 0.000 description 3
- 230000000007 visual effect Effects 0.000 description 3
- 230000009977 dual effect Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 239000002184 metal Substances 0.000 description 2
- 229910052751 metal Inorganic materials 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- CWYNVVGOOAEACU-UHFFFAOYSA-N Fe2+ Chemical compound [Fe+2] CWYNVVGOOAEACU-UHFFFAOYSA-N 0.000 description 1
- 238000005452 bending Methods 0.000 description 1
- 230000033558 biomineral tissue development Effects 0.000 description 1
- 239000003245 coal Substances 0.000 description 1
- 239000002131 composite material Substances 0.000 description 1
- 238000012937 correction Methods 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 239000010432 diamond Substances 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- PCHJSUWPFVWCPO-UHFFFAOYSA-N gold Chemical compound [Au] PCHJSUWPFVWCPO-UHFFFAOYSA-N 0.000 description 1
- 239000010931 gold Substances 0.000 description 1
- 229910052737 gold Inorganic materials 0.000 description 1
- 238000003384 imaging method Methods 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 150000002739 metals Chemical class 0.000 description 1
- 238000003825 pressing Methods 0.000 description 1
- 229940099259 vaseline Drugs 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/29—Geographical information databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Remote Sensing (AREA)
- Human Computer Interaction (AREA)
- Processing Or Creating Images (AREA)
Abstract
The invention provides a solid core data-oriented database management system, which comprises a core database file module, a core data processing module, a core data management module, a core data calculation module, a space query analysis module and a core data output module, wherein the core database file module is used for storing core data; the implementation method comprises the following steps: constructing a software platform and configuring a hardware environment; selecting a database system; selecting a GIS basic platform; designing and constructing a core database. The invention has the beneficial effects that: the solid core data systematization, standardization, automation, high-efficiency management and application are realized, and the automatic and digital mapping of the drawing is realized, so that the mine automation and informatization management is promoted, and the high-yield and high-efficiency mine construction is realized.
Description
Technical Field
The invention relates to the field of database design, in particular to a solid core data-oriented database management system.
Background
The geological database is a computer-stored file and retrieval system of geological data (including text, data and diagram data), and also realizes the storage, update and retrieval automation of the geological data. Geological databases have originated in the united states, which is also the most common, most notably: the oil data system (PDS) stores data from the United states and Canada fields; a Computer Resource Information Base (CRIB) stores data about world metals and waste metal mineral resources; national Coal Resource Database (NCRDS); a logging control system (WHCS).
With the development and popularization of computer technology and automatic control technology, geological databases have been tested in some conditional geological research and production departments, such as gold mine geological databases and data processing systems developed by second mine investment of Xinjiang non-ferrous corporation in 1986-1989; the research institute of nonferrous metallurgy design of Changsha and the CAD management system of applied mineralization model developed by Vaseline in 1989-1995. Although the traditional core data management mode has certain advantages in data management, some problems still exist, which are mainly shown in the following aspects:
the stored data is single in type, and the attribute database and the spatial graphic database cannot be connected with each other and are common;
the expandability is poor, the database model is limited in a certain business field, and the database model cannot be comprehensively applied to the field of solid core databases;
the system lacks necessary database management tools, such as tools for importing and exporting data, tools for maintaining data online and the like;
the database interface function is poor, a good interface and a convenient secondary development tool are lacked, and the database interface is difficult to adapt to various databases and possible changes of service management modes;
the combination with GIS technology and software is lacked, and the advantages of the existing GIS software in geographic data processing are not fully utilized.
Disclosure of Invention
In view of the above, the present disclosure provides a solid core data-oriented database management system.
The invention provides a solid core data-oriented database management system, which specifically comprises:
a solid core data-oriented database management system specifically comprises: the system comprises a rock core database file module, a rock core data processing module, a rock core data management module, a rock core data calculation module, a space query analysis module, a space data interaction module and a rock core data output module;
the core database file module is used for realizing the functions of importing, inquiring and managing the core data;
the core data processing module is used for realizing the functions of editing a basic GIS, drawing a columnar core diagram and drawing an isopachrome;
the core data management module is used for realizing the unified and standardized management function of the core data;
the core data measurement module is used for realizing the functions of distance measurement, perimeter measurement and area measurement;
the space query analysis module is used for realizing the functions of space feature query and statistics, geometric measurement, general superposition analysis and buffer area analysis;
the spatial data interaction module is used for realizing interaction between a user and the core database, and comprises data entry, and integration of spatial data and attribute data;
and the core data output module is used for exporting the data result and the graphic result of the drilling data.
Further, in the core data processing module, the basic GIS editing function includes: adding, deleting and moving dot and line areas, editing attributes, cutting graphs, and dynamically marking, amplifying, reducing and roaming functions; the drawing function of the columnar core diagram comprises the following steps: the method comprises the steps of adjusting the composition of the drilling columnar core diagram, coloring the lithologic pattern column of the drilling columnar core diagram, customizing the font of the drilling columnar core diagram, and browsing and editing the generated drilling columnar core diagram according to a certain display proportion.
Further, the core data management module specifically includes: mine area information management, graphic information management, document information management, attached table information management, drilling information management, core image management and drilling image contrast analysis management.
Further, the spatial query module specifically includes: spatial feature query, core data statistics, spatial superposition analysis and buffer area analysis.
Further, the core data output module specifically comprises data export and graph export of output data results.
Further, the data export comprises EXCE L report export and original data export, the EXCE L report comprises three types including a drilling record type, a sampling test type and a logging curve type, the original data export comprises export of converting MapGIS vector data into other mainstream software format data, and the graph export comprises plate making and printing of graphs and pictures.
Further, the solid core data-oriented database management system specifically includes:
s101: building a software platform and a hardware environment;
s102, selecting an SQ L Server 2000 database system as an information system database platform;
s103: selecting MapGIS as a GIS basic platform;
s104: and designing a core database.
Further, step S101 specifically includes: the software platform adopts Windows 2000Advance Server; the hardware environment comprises: the server supports RAID5 or more; a disk array cabinet supporting cluster sharing; the hard disk is greater than or equal to 140G; the memory is greater than or equal to 1G; the dual CPU has a model of Pentium III Xeon2.0GHz or more.
Further, step S104 specifically includes: relational database design and construction, spatial database design and construction, and graphical data association with an attribute database.
The design and construction of the relational database specifically comprise the following steps: in the storage structure of the relational database, for text, graphics and image unformatted data, managing by combining a file management mechanism of an operating system and the relational database, establishing an E-R model, and representing the relationship among the attributes of an entity set and the relation among entities in a two-dimensional table form;
the design and construction of the spatial database specifically comprise the following steps: the spatial database comprises a mine area distribution map database, a topographic and geological map database, a mining engineering distribution map database, a mineral reserve map database, a drilling column map database, an exploration profile map database, a geophysical database, a sketch map database and a remote sensing image database; wherein, the hitching of spatial data and attribute data is completed between the mining area distribution map database and the mining engineering distribution map database;
the graphic data is associated with the attribute database, and specifically comprises the following steps: establishing a connection code in an attribute table of a graphic element in the graphic database, and setting the same connection code identification in a corresponding record of the attribute database so as to realize the association of the graphic data and the attribute database.
The technical scheme provided by the invention has the beneficial effects that: the solid core data systematization, standardization, automation, high-efficiency management and application are realized, and the automatic and digital mapping of the drawing is realized, so that the mine automation and informatization management is promoted, and the high-yield and high-efficiency mine construction is realized.
Drawings
FIG. 1 is a block diagram of a solid core data oriented database management system according to the present invention;
FIG. 2 is a database construction overall workflow of a solid core data oriented database management system of the present invention;
FIG. 3 is a connection of a graphic database and an attribute database of a solid core data oriented database management system of the present invention;
FIG. 4 is a diagram of a core database E-R model of a solid core data oriented database management system of the present invention;
fig. 5 is a spatial database group structure of a solid core data-oriented database management system according to the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, embodiments of the present invention will be further described with reference to the accompanying drawings.
Referring to fig. 1, an embodiment of the present invention provides a structure diagram of a solid core data-oriented database management system, which specifically includes:
a solid core data-oriented database management system specifically comprises: the system comprises a rock core database file module, a rock core data processing module, a rock core data management module, a rock core data calculation module, a space query analysis module, a space data interaction module and a rock core data output module;
the core database file module is used for realizing the functions of importing, inquiring and managing the core data;
the core data processing module is used for realizing the functions of editing a basic GIS, drawing a columnar core diagram and drawing an isopachrome;
the core data management module is used for realizing the unified and standardized management function of the core data;
the core data measurement module is used for realizing the functions of distance measurement, perimeter measurement and area measurement;
the space query analysis module is used for realizing the functions of space feature query and statistics, geometric measurement, general superposition analysis and buffer area analysis;
the spatial data interaction module is used for realizing interaction between a user and the core database, and comprises data entry, and integration of spatial data and attribute data;
and the core data output module is used for exporting the data result and the graphic result of the drilling data.
The core data processing module comprises the following functions: editing points, lines and surfaces. Because the basic geological data, the drilling histogram, the exploration profile and the exploration plan related to the system are stored in the vector format of the MapGIS, the module provides the basic GIS graph editing function. The method comprises the interactive operations of adding, deleting and moving dot-line areas, editing attributes, cutting graphs, dynamically marking and amplifying, reducing and roaming and the like.
And drawing a histogram. The drilling histogram can express the actual exploration situation of the drilling by using visual images, and the rock lithology of different depths of the drilling is expressed by using corresponding rock patterns, so that the drilling histogram has high practical application value. The module automatically extracts corresponding data by a computer based on original mining area logging data according to the input drilling data content and the customized imaging format standard, and generates a drilling histogram meeting the standard requirements, wherein the drilling histogram comprises a logging curve and contents of rock and ore samples; the user can adjust the composition of the drilling histogram according to the actual situation of the mining area, color the lithologic pattern column of the histogram, define the font in the diagram, and browse and edit the generated histogram according to a certain display proportion.
And drawing an equal thickness line. And drawing an isopachne of the specified stratum in the mining area according to the layer thickness data of the drilled hole based on the MapGIS contour drawing method.
A core data management module comprising: the method comprises the following steps of (1) managing mining area information, providing functions of adding, updating, deleting and the like of the mining area information, and providing a function of acquiring mining area data; the graphic information management is used for providing functions of adding, updating, deleting and the like of the graphic information and providing an acquisition function of the graphic information; document information management, which provides functions of adding, updating, deleting and the like of document information and provides a function of acquiring graphic information; the auxiliary table information management is used for providing functions of adding, updating, deleting and the like of auxiliary table information and providing a function of acquiring graphic information; the module is mainly responsible for browsing, adding, updating and deleting the drilling data in the core database and the sampling test analysis data related to the drilling; and managing the rock core image, wherein the module manages the related data of the rock core image stored in the database, and realizes the query, modification, storage and update of the related data of the rock core image. Based on the drilling images, the module also realizes the contrast function of different drilling images, a professional can add the images of a plurality of drilling holes needing to be contrastively analyzed into the image contrast module, contrast the images corresponding to the same rock stratum or different rock strata of different drilling holes, and can link the detailed attribute information of the corresponding layer by clicking the image of a certain layer to realize the contrast analysis of the attribute.
And the core data measurement module comprises distance measurement, perimeter measurement and area measurement. Distance measurement, namely clicking a left mouse button at any position on the graph as a starting point, continuously pressing the left mouse button at a certain position, drawing a fold line, clicking a right mouse button at any position as an end, and automatically calculating the length of the fold line by the system and displaying the length of the fold line to a user; perimeter measurement, namely measuring the perimeter of a polygon; the area calculation means that rectangles, polygons and circles are drawn on the graph at will, and the system automatically calculates the area of the drawing area and displays the area to the user.
The spatial query analysis module is used for querying spatial characteristics, well realizing query of spatial entities, finding out spatial entities and spatial ranges and attributes of target positions, displaying an attribute list of the spatial objects, and simultaneously carrying out statistics and analysis to realize a drilling thematic map; core data query realizes composite condition query of core data in a core database, object identification values of space entities meeting conditions are screened out, corresponding space entities are retrieved in the space database according to the object identification values, and two forms of precise query and fuzzy query are set simultaneously, wherein multi-table query can integrate a mining area data table and a drilling data table for query, fields of different tables are matched along with each other, and public fields can be set; core data statistics is completed by analyzing the requirements of statistical reports based on a core database in geological exploration business, and reports meeting industrial specifications, such as mining area drilling statistics, exploration line statistics and the like, are generated; the spatial superposition analysis realizes multilayer data superposition analysis and generates different thematic maps for printing and outputting; the buffer area analysis center, line and surface can establish buffer area, for example, the point buffer area selects a group of point ground objects, or a class of point ground objects or a layer of point ground objects, and forms a buffer area polygon layer according to the given buffer area distance.
And the spatial data interaction module is used for realizing the hooking of the imported data to the spatial data through an attribute hooking program and adding an attribute hooking key field to the MapGIS point-line-surface file.
And the core data output module is divided into two parts of data export and graph output. The data can be exported in a spreadsheet (Excel) or printed as a map. The report forms are divided into a drilling record type, a sampling test type and a logging curve type by considering the practicability, the readability and the like of the report forms. The printed tables specifically comprise a mining area basic information table, a drilling hole bending measurement record table, a drilling hole depth correction record table, a layered database table, a drilling sample sampling record table, a drilling core splitting sample database, a drilling well logging curve layer record table, a table drilling well logging curve point record table, a core image comprehensive data table, a rock total analysis sample record table and a combined sample record table, and 12 tables in total. And a mining area core data collection list, rock patterns and symbols can be output. In addition, the system also provides plate making, printing and outputting of vector data, pictures and other data managed by the database. Moreover, the module also needs to provide the function of converting the mapGIS vector data into other mainstream software data formats.
All the functional modules of the invention are realized on the basis of calling the API function of the MapGIS platform, so that the system can carry out various GIS operations, the output data can be converted into other main stream software formats, and the cross-platform characteristic is realized.
Referring to fig. 2, a database construction flow chart of the invention needs to establish a set of data standards in the system establishing process, an interface is reserved for future data utilization and exchange, the database construction standard needs to be determined before development work according to related national and provincial standards, the database original data is manufactured according to the standards and is subjected to warehousing inspection, attribute data is stored uniformly by adopting an SQ L Server 2000, spatial data is uniformly managed in a MapGIS file mode, and before solid mineral core data enters a database, pre-warehousing processing and modification are carried out, so that correct data can be ensured to enter the database.
Referring to fig. 3, the connection between the graphic database and the attribute database is performed by using a connection code, that is, a connection code is established in the attribute table of the primitive in the graphic database, and the same connection code identifier is set in the corresponding record of the attribute database, and the connection code identifier are combined by software. Because the plug-in database can be composed of a single data table or a plurality of data tables which are mutually related, the internal association is carried out through the associated fields of the tables, and meanwhile, the associated fields of the tables are connected with the corresponding fields of the internal attribute table of the MapGIS spatial database, thereby realizing the integration of the plug-in database and the spatial data graphic database. The core technology is as follows: and calling the internal attribute associated field value of the graph through an API function of the MapGIS platform.
Referring to fig. 4, the E-R model diagram of the relational database may be represented by an Entity-relational diagram (E-R diagram), where the model represents a formalized model of relationships between attributes of an Entity set and relationships between entities in a two-dimensional table format, all data items are the most basic units that cannot be subdivided, and relationships between entities are represented by a table, and relationships of the table are established by common attributes in the tables. In the E-R diagram, the entities are represented by rectangles, the entities are represented by ellipses, and the diamonds represent the connections between the entities.
Referring to FIG. 5, the spatial database is composed of a set of closely related database clusters. The spatial database has various data types and complex interrelation, and the database to be built relates to the fields of exploration, research, production and the like, and comprises a mining area distribution database, a topographic and geological database, a mining engineering distribution database, a mineral reserve database, a drilling columnar database, an exploration profile database, a geophysical database, various sketch databases, a remote sensing image database and the like.
The solid core database management system building process comprises the following steps:
1. building a project based on Visual C + +, and realizing the functions in the MapGIS platform in the project;
2. setting a Visual C + + working environment:
(1) setting bytes: selecting a Settings command under the Project menu, selecting Code Generation in a Category column on a C/C + + page, and setting the Struct number Alignment to 1 Byte;
(2) output directory setting: selecting the Settings command under the Project menu, filling out the MapGIS application catalog in the Outputfiles column on the General page (e.g., c: \ maplis 67\ program);
(3) including library setup: setting the path of the header file and the library file;
3. changing a view class in the engineering into an inherited CGisEditView class;
4. calling OnDraw (pDC) function in the CGisEditView class;
5. establishing a point, line and surface working area:
and organizing point files, line files and face files to be respectively stored and managed by using MapGIS engineering files (. mpj) based on a MapGIS spatial database. The core of mapGIS data management is the operation of point, line and plane working areas. The working areas are data pools for storing space data, topological data, graphic data and attribute data of the entities, and each working area corresponds to a MapGIS data file. The MapGIS development function library provides a series of functions for operating the working area, such as saving the contents in the working area and loading data from the disc into the working area; adding, modifying, deleting, retrieving and the like are carried out on the content in the working area; the complicated work of accessing hard disk data, managing virtual memory and the like is automatically completed by the MapGIS working area management module.
The solid core data-oriented database management system is implemented by the method comprising the following steps:
s101: building a software platform and a hardware environment;
s102, selecting an SQ L Server 2000 database system as an information system database platform;
s103: selecting MapGIS as a GIS basic platform;
s104: and designing a core database.
Step S101 specifically includes: the software platform adopts Windows 2000Advance Server; the hardware environment comprises: the server supports RAID5 or more; a disk array cabinet supporting cluster sharing; the hard disk is greater than or equal to 140G; the memory is greater than or equal to 1G; the dual CPUs are of the type Pentium III Xeon2.0GHz or above.
Step S104 specifically includes: relational database design and construction, spatial database design and construction, and graphical data association with an attribute database.
The design and construction of the relational database specifically comprise the following steps: in the storage structure of the relational database, for text, graphics and image unformatted data, managing by combining a file management mechanism of an operating system and the relational database, establishing an E-R model, and representing the relationship among the attributes of an entity set and the relation among entities in a two-dimensional table form;
the design and construction of the spatial database specifically comprise the following steps: the spatial database comprises a mine area distribution map database, a topographic and geological map database, a mining engineering distribution map database, a mineral reserve map database, a drilling column map database, an exploration profile map database, a geophysical database, a sketch map database and a remote sensing image database; wherein, the hitching of spatial data and attribute data is completed between the mining area distribution map database and the mining engineering distribution map database;
the graphic data is associated with the attribute database, and specifically comprises the following steps: establishing a connection code in an attribute table of a graphic element in the graphic database, and setting the same connection code identification in a corresponding record of the attribute database so as to realize the association of the graphic data and the attribute database.
The invention has the beneficial effects that: the solid core data systematization, standardization, automation, high-efficiency management and application are realized, and the automatic and digital mapping of the drawing is realized, so that the mine automation and informatization management is promoted, and the high-yield and high-efficiency mine construction is realized.
The features of the embodiments and embodiments described herein above may be combined with each other without conflict.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents, improvements and the like that fall within the spirit and principle of the present invention are intended to be included therein.
Claims (10)
1. A database management system for solid core data is characterized in that: a solid core data-oriented database management system specifically comprises: the system comprises a rock core database file module, a rock core data processing module, a rock core data management module, a rock core data calculation module, a space query analysis module, a space data interaction module and a rock core data output module;
the core database file module is used for realizing the functions of importing, inquiring and managing the core data;
the core data processing module is used for realizing the functions of editing a basic GIS, drawing a columnar core diagram and drawing an isopachrome;
the core data management module is used for realizing the unified and standardized management function of the core data;
the core data measurement module is used for realizing the functions of distance measurement, perimeter measurement and area measurement;
the space query analysis module is used for realizing the functions of space feature query and statistics, geometric measurement, general superposition analysis and buffer area analysis;
the spatial data interaction module is used for realizing interaction between a user and the core database, and comprises data entry, and integration of spatial data and attribute data;
and the core data output module is used for exporting the data result and the graphic result of the drilling data.
2. The solid core data-oriented database management system of claim 1, wherein: in the core data processing module, basic GIS editing functions include: adding, deleting and moving dot and line areas, editing attributes, cutting graphs, and dynamically marking, amplifying, reducing and roaming functions; the drawing function of the columnar core diagram comprises the following steps: the method comprises the steps of adjusting the composition of the drilling columnar core diagram, coloring the lithologic pattern column of the drilling columnar core diagram, customizing the font of the drilling columnar core diagram, and browsing and editing the generated drilling columnar core diagram according to a certain display proportion.
3. The solid core data-oriented database management system of claim 1, wherein: the core data management module specifically comprises: mine area information management, graphic information management, document information management, attached table information management, drilling information management, core image management and drilling image contrast analysis management.
4. The solid core data-oriented database management system of claim 1, wherein: the space query module specifically includes: spatial feature query, core data statistics, spatial superposition analysis and buffer area analysis.
5. The solid core data-oriented database management system of claim 1, wherein: the core data output module specifically comprises data export and graph export of output data results.
6. The solid core data-oriented database management system as recited in claim 5, wherein the data export comprises an EXCE L report export and a raw data export, the EXCE L report comprises three types including a drilling record type, a sampling test type and a logging curve type, the raw data export comprises an export of converting MapGIS vector data into other mainstream software format data, and the graph export comprises a platemaking and printing of graphs and pictures.
7. The solid core data-oriented database management system of claim 1, wherein: the solid core data-oriented database management system is implemented by the method comprising the following steps:
s101: building a software platform and a hardware environment;
s102, selecting an SQ L Server 2000 database system as an information system database platform;
s103: selecting MapGIS as a GIS basic platform;
s104: and designing a core database.
8. The solid core data-oriented database management system according to claim 7, wherein: step S101 specifically includes: the software platform adopts Windows 2000Advance Server; the hardware environment comprises: the server supports RAID5 or more; a disk array cabinet supporting cluster sharing; the hard disk is greater than or equal to 140G; the memory is greater than or equal to 1G; the model of the double CPUs is PentiumIII Xeon2.0GHz or above.
9. The solid core data-oriented database management system according to claim 7, wherein: step S104 specifically includes: relational database design and construction, spatial database design and construction, and graphical data association with an attribute database.
10. The solid core data-oriented database management system of claim 9, wherein: the design and construction of the relational database specifically comprise the following steps: in the storage structure of the relational database, for text, graphics and image unformatted data, managing by combining a file management mechanism of an operating system and the relational database, establishing an E-R model, and representing the relationship among the attributes of an entity set and the relation among entities in a two-dimensional table form;
the design and construction of the spatial database specifically comprise the following steps: the spatial database comprises a mine area distribution map database, a topographic and geological map database, a mining engineering distribution map database, a mineral reserve map database, a drilling column map database, an exploration profile map database, a geophysical database, a sketch map database and a remote sensing image database; wherein, the hitching of spatial data and attribute data is completed between the mining area distribution map database and the mining engineering distribution map database;
the graphic data is associated with the attribute database, and specifically comprises the following steps: establishing a connection code in an attribute table of a graphic element in the graphic database, and setting the same connection code identification in a corresponding record of the attribute database so as to realize the association of the graphic data and the attribute database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010148137.7A CN111460061A (en) | 2020-03-05 | 2020-03-05 | Database management system for solid core data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010148137.7A CN111460061A (en) | 2020-03-05 | 2020-03-05 | Database management system for solid core data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111460061A true CN111460061A (en) | 2020-07-28 |
Family
ID=71685570
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010148137.7A Pending CN111460061A (en) | 2020-03-05 | 2020-03-05 | Database management system for solid core data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111460061A (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104732359A (en) * | 2015-04-08 | 2015-06-24 | 陕西延长石油（集团）有限责任公司 | Oil field geographic information and exploration development collaboration work platform system |
| CN104915521A (en) * | 2015-07-01 | 2015-09-16 | 中国地质大学（武汉） | Drilling histogram compilation method based on field documentation data and automatic cartographic generalization |
| CN106651609A (en) * | 2016-09-27 | 2017-05-10 | 云南大学 | Auxiliary information system and method of remote-sensing monitoring for mineral resource exploitation environment |
| CN107909271A (en) * | 2017-11-15 | 2018-04-13 | 国网四川省电力公司经济技术研究院 | A kind of Geotechnical Engineering Investigation Data management and assessment generalized information system |
| CN109215464A (en) * | 2018-09-11 | 2019-01-15 | 中国石油大学(华东) | Trap and oil reservoir three-dimensional concept model building method |
| CN109684778A (en) * | 2019-02-01 | 2019-04-26 | 长江地球物理探测（武汉）有限公司 | A kind of digital cores intelligent management system |
| US20190325642A1 (en) * | 2018-04-19 | 2019-10-24 | Soletanche Freyssinet | Computer platform for pooling and viewing digital data |
| CN110807023A (en) * | 2019-11-08 | 2020-02-18 | 山东电力工程咨询院有限公司 | Survey management and data intelligent analysis system and method based on GIS |
-
2020
- 2020-03-05 CN CN202010148137.7A patent/CN111460061A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104732359A (en) * | 2015-04-08 | 2015-06-24 | 陕西延长石油（集团）有限责任公司 | Oil field geographic information and exploration development collaboration work platform system |
| CN104915521A (en) * | 2015-07-01 | 2015-09-16 | 中国地质大学（武汉） | Drilling histogram compilation method based on field documentation data and automatic cartographic generalization |
| CN106651609A (en) * | 2016-09-27 | 2017-05-10 | 云南大学 | Auxiliary information system and method of remote-sensing monitoring for mineral resource exploitation environment |
| CN107909271A (en) * | 2017-11-15 | 2018-04-13 | 国网四川省电力公司经济技术研究院 | A kind of Geotechnical Engineering Investigation Data management and assessment generalized information system |
| US20190325642A1 (en) * | 2018-04-19 | 2019-10-24 | Soletanche Freyssinet | Computer platform for pooling and viewing digital data |
| CN109215464A (en) * | 2018-09-11 | 2019-01-15 | 中国石油大学(华东) | Trap and oil reservoir three-dimensional concept model building method |
| CN109684778A (en) * | 2019-02-01 | 2019-04-26 | 长江地球物理探测（武汉）有限公司 | A kind of digital cores intelligent management system |
| CN110807023A (en) * | 2019-11-08 | 2020-02-18 | 山东电力工程咨询院有限公司 | Survey management and data intelligent analysis system and method based on GIS |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105046328B (en) | A kind of three-dimensional visualization bridge defect information acquisition management system and method | |
| CN108805510A (en) | A kind of construction drawing design BIM model compliance checking methods and system | |
| WO2019223413A1 (en) | System for constructing urban design digital sandbox | |
| CN110211231B (en) | Three-dimensional geological disaster information model modeling method | |
| CN112559351B (en) | CFD software verification and confirmation database platform | |
| WO2021174752A1 (en) | Method and apparatus for visualizing ambient air quality data, device, and storage medium | |
| CN114379608A (en) | Multi-source heterogeneous data integration processing method for urban rail transit engineering | |
| CN103177103A (en) | Three-dimensional geographical information system management platform | |
| Zhang et al. | The work flow and operational model for geotechnical investigation based on BIM | |
| CN112633822B (en) | Asset management method based on digital twin technology, storage medium and mobile terminal | |
| CN108170855B (en) | CityGML and IFC data unified query and data extraction method | |
| CN115345107A (en) | Method for converting ODB + + file into three-dimensional geometric model | |
| CN110688688A (en) | Method for converting surveying and mapping completion diagrams into surveying and mapping delimiting diagrams in batch | |
| CN117436054B (en) | Geotechnical engineering big data sharing platform | |
| CN201820263U (en) | Field pipeline data acquisition and update system based on topological relation | |
| CN116821223B (en) | Industrial visual control platform and method based on digital twinning | |
| CN107797980A (en) | A kind of geological prospecting borehole data processing and control system based on Internet of Things | |
| CN117076585A (en) | Investigation inside and outside industry integrated system based on three-dimensional geological information model | |
| CN111460061A (en) | Database management system for solid core data | |
| CN112632408A (en) | Environmental geology investigation system based on internet and intelligent technology | |
| Höfle et al. | Using airborne laser scanning data in urban data management-set up of a flexible information system with open source components | |
| CN113360559A (en) | Configurable one-stop large-screen visualization method and device | |
| CN117435579B (en) | Data management system based on geotechnical engineering three-dimensional modeling | |
| Jing et al. | Study on Database Management Methods and Visual Thematic Map for Dynamic Information Data | |
| Wiyadi et al. | Upstream Corporate Database Management Collaboration Using GIS |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |