Research and Application of Geoanalytical Database

Author:He Yutong



Degree Year:2018





Geoanalytical data is the basis for earth scientific research,mineral resources exploration and geological environment evaluation.It is not only an important technical support for the development of land and resources geological surveys,but also the precious data resources for people to know and make better use of the earth.Over the years,many countries have invested a lot of manpower,material and financial resources to obtain more abundant geoanalytical data.The geoanalytical data acquired by geological researchers are not only precious but aslo huge.After these data are obtained,only a small amount of them are published in the literature,and most of the data which scattered in the hands of individuals or units are not reused to play their value and significance.Geoanalytical database research could help researchers effective storage and accumulation of complex geoanalytical of the data,which can finally forms the huge,comprehensive analysis of the geological field database.It can provide data services for researchers to realize the secondary utilization of geoanalytical data,promote the rapid development of geological research methods,and provide basic data resources for digital earth construction.The geoanalytical database,which has great development potential and considerable use value,has been widely concerned by the researchers.Over the years,although the construction of geoanalytical databases at home and abroad has flourished,these formed databases are often researched and developed for specific geological application needs which are poor in versatility,compatibility,and scalability.These formed geoanalytical databases are not suitable for the comprehensive storage of various geoanalytical data and the fusion of massive geoanalytical data.Due to the lack of research on data warehousing methods for different types of data sources,massive geoanalytical data cannot be effectively connected with the database,which reduces the rate of geoanalytical data warehousing and restricts the formation of comprehensive and massive geoanalytical database.In addition,the low efficiency of database-based data service directly affects the application of geoanalytical database.For this reason,this paper has carried out related research work for the purpose of improving the performance of geoanalytical database,accelerating the accumulation of massive geoanalytical data,enhancing the service capacity of geoanalytical database,and promoting the efficient secondary utilization of geoanalytical data.The main contents of this paper are as follows:1)Research and designation of geoanalytical data modalGeoanalytical data model is the basis of building geoanalytical database.It directly determines what kind of geoanalytical data can be stored in the database as well as whether the data stored in the database can be reutilized.The existing geoanalytical data model has strong specificity,weak extensibility.These characters make a limitation for types of geoanalytical data that can be stored.Aiming at the problem,research basing on different types of geological samples including rocks,minerals,soil,water,sediment,and 21 kinds of analytical methods such as electron probe micro analysis(EPMA),inductively coupled plasma mass spectroscopy(ICP-MS),X-ray diffraction(XRD),etc.are conducted to study the geoanalytical data content including the analytical data result,the background description of gelogical samples and the quality descripiton information.Based on the content and classification of geoanalytical data content,module division and interface definition are carried out by using the modularity theory.Modules are encapsulated according to the rules of module combination.The theoretical model,conceptual model and logical model of the geoanalytical database are designed.The model are able to store and effectively reuse different types of geological analysis data,and the model can be extended by adding independent submodules.In general,a more universality,compatibility and extensibility geoanalytical data model are provided.2)Research on storage method of data from instrument testData test report created by analytical instrument is the source of geoanalytical data.It is also the main way for researchers to preserve geoanalytical data.How to effectively store the existing geoanalytical data and the new data is the prerequisite for the massive data accumulation in the geoanalytical database.Aiming at this problem,this paper studies the file format of the data report generated by the geoanalytical instrument test,and develops the storage method based on different types of instrument test data format.Through this method,all kinds of scattered geoanalytical data can be effectively stored in the database,which lays a solid foundation for the formation of massive and comprehensive geoanalytical data.3)Research on storage method of data from geoanalytical literatureThe literature data is an important data source for the geoanalytical database.The research of the literature data storage method is also one of the important content of the study of geoanalytical database.At present,most of the databases only store the literature data,but there is no report introduce the method.To solve this problem,The characters of the structure,data distribution and data format of SHRIMP zircon U-Pb geoanalytical literatures are studied.Data extraction method basing on content,grammer and semantic are studied and optimize.An experiment have been conducted with one hundred literatures and the result proves that the extraction accurancy achive more than 90% and this method can support the transmission of data from literatures to databases.improvement and optimization are needed to further improve the accuracy.4)Development of geoanalytical database comprehensive service platformGeoanalytical data service platform is a communication window between the geoanalytical database and researchers.The functions of the geoanalytical data service platform and the rationality of development directly affect the convenience and efficiency of the database,which is the basis of the wide application between geological researchers.At present,the existing geoanalytical data service platform often only provides data retrieval functions,and the methods have low efficiency in searching geoanalytical data.To solve this problem,a WebGIS based polygon area retrieval method is studied.An Echarts based data vision diagrams including line diagram,histogram,distribution map and heat map were developed.Data management model based on role-permission methods is also suggested.Morever,the platform can be accessed from website.5)Application cases of geoanalytical databaseBasing on the data of SHRIMP zircon U-Pb geochronological study in the database,application cases on the age study of North China Craton as well as the investigation of geological background description of Huangbaiyu-Yangyashan area,eastern Hebei Province are conducted.The statistical analytical method was adopted to make the age distribution vision the and the weighted average age was also calcuated.The result of the age was similar with the accurate age and it verify that the data in the database can be reutilized.The reutilization of the geoanalytical database will bring the new methods for geological study.Basing on the sample description map,samples adopted from Huangbaiyu-Yangyashan area can be acquired easily.The sample and analytical description cover completely the requirements of researchers which verify that the database can be used for geolgoical studies.