An easy way to build database and analyze data using OnePeterology

       The 21st century is the era of big data, where scientific research under the new paradigm of data and model-driven knowledge discovery has become the new trend in the scientific field. Under the framework of the international  science project "Deep-time Digital Earth" (DDE), the research team led by Dr. Wang Tao has constructed the OnePetrology database for magmatic rocks. This database adopts a three-in-one approach of "data + mapping + research," based on the magmatic rock knowledge system, with samples as the core,  with self-developed tools to build a magmatic rock database system that integrates big data aggregation and mapping analysis functions.

      The OnePetrology database system includes backend services (cloud), a website (Web), and a scientific research work platform (desktop). The data mainly comes from publicly published literature, tests conducted by the research team, laboratory test data, etc. The data types include basic information on magmatic rock rock types, occurrences, spatial locations, as well as geochronology, geochemistry, (Sr-Nd-Hf-Pb-O) isotopes, and non-traditional (or emerging) isotope data, involving global important orogenic belts, cratons, and some oceans (ocean drilling data).

    The database has preliminarily completed the framework construction and has incorporated a portion of the data, initially forming methods and processes for data aggregation. Currently, there are two ways to contribute data: first, volunteers enter data in the data "data submission portal" set up for this purpose.  The database system has currently built 22 thematic databases and welcomes more disciplinary experts to come to the magmatic rock database to build their own thematic databases.

      The core idea of the database's functionality is to combine big data and software tools for scientific research and exploration. Taking the website as an example, it provides data filtering tools and mapping analysis tools. Data filtering tools include spatial filtering and attribute filtering: spatial filtering can pull cross-sections (set radius), rectangles, custom polygons, global tectonic units, global cratons, China and neighboring areas' main tectonic units, and other search methods, while attribute filtering can set search conditions, value ranges, and fuzzy queries for all fields. Spatial filtering and attribute queries can be used separately or in combination, with query results displayed in table form, spatial distribution maps, and mapping functions. The mapping functions currently built in the database include TAS, Pearce, SiO2-K2O, ACNK-CNK, 2D Density, Heatmap, Profile, etc., each supporting secondary filtering and grouping, facilitating users to quickly discover data patterns.  Currently, online analysis can provide processing capabilities for about 20,000 samples (assuming average desktop computing capabilities). If you need to process larger data volumes, please download the desktop software from the homepage of the website (https://dde.igeodata.org).

     In summary, the DDE OnePetrology magmatic rock database has preliminarily constructed the capabilities for magmatic rock data aggregation and mapping analysis, with other planned functions being built step by step. We warmly welcome more interested experts to participate in the construction and use of the magmatic rock database and to offer your valuable suggestions.