Paper No. 116-4
Presentation Time: 8:00 AM-5:30 PM
INTEGRATION OF DEEP-TIME DATABASES: TOWARDS BUILDING A DEEP-TIME DIGITAL EARTH
LI, Haipeng, Department of Paleogeography, Deep-time Digital Earth Research Center of Excellence (Suzhou), Kunshan, Jiangsu 215347, China, XU, Shuyan, School of the Earth Sciences, Zhejiang University, Hangzhou, Zhejiang 310027, China; Zhejiang Provincial Key Laboratory of Geographic Information Science, Hangzhou, Zhejiang 310028, China, PETERS, Shanan, Department of Geoscience, University of Wisconsin - Madison, Madison, IA 53706, QUINN, Daven, Department of Geoscience, University of Wisconsin – Madison, 1215 W Dayton, Madison, WI 53703, OGG, James, Deep-time Digital Earth Research Center of Excellence (Suzhou), International Union of Geological Sciences (IUGS), Kunshan, Jiangsu, China, HOU, Mingcai, Institute of Sedimentary Geology, Chengdu University of Technology, Chengdu, Sichuan, 610059, China and SCOTESE, Christopher, Director, PALEOMAP Project,, 134 Dodge, Evanston, IL 60202
The integration of deep-time databases is a key aspect in the creation of a comprehensive digital model of Earth's history, known as the "deep-time digital Earth." This model would enable scientists to better comprehend the intricate processes that have shaped our planet and its life forms over time. Currently, the data are dispersed across various databases and research institutions, making it challenging for scientists to fully utilize the information contained in the data.
We present a virtual integration of deep-time databases. We will demonstrate this integration using the Macrostrat, PBDB, GeoLexicon, and the climatically sensitive lithologies databases. The first step involves identifying the available information from each data source and deciding on the relevant data attributes, such as lithology, age, and formation name. The next step is aligning the schemata of different data sources to a common mediated schema, allowing attribute names with the same semantics to be merged. For example, sfm (stratigraphic formation) in PBDB is equivalent to Fm in Macrostrat. The third step is to create an integration layer that allows users to access and query data from various sources as if they were stored in a single database. This integration layer uses the mediated schema to translate queries and data among different sources and provides tools and interfaces for data visualization and analysis. Our goal is to make deep-time data more easily accessible and usable for a better understanding of Earth's history.
![[Visit Client Website]](/img/gsa/banner.jpg)