A Semi-Automated Hybrid Schema Matching Framework for Vegetation Data Integration

05/11/2023
by   Md. Asif-Ur-Rahman, et al.
0

Integrating disparate and distributed vegetation data is critical for consistent and informed national policy development and management. Australia's National Vegetation Information System (NVIS) under the Department of Climate Change, Energy, the Environment and Water (DCCEEW) is the only nationally consistent vegetation database and hierarchical typology of vegetation types in different locations. Currently, this database employs manual approaches for integrating disparate state and territory datasets which is labour intensive and can be prone to human errors. To cope with the ever-increasing need for up to date vegetation data derived from heterogeneous data sources, a Semi-Automated Hybrid Matcher (SAHM) is proposed in this paper. SAHM utilizes both schema level and instance level matching following a two-tier matching framework. A key novel technique in SAHM called Multivariate Statistical Matching is proposed for automated schema scoring which takes advantage of domain knowledge and correlations between attributes to enhance the matching. To verify the effectiveness of the proposed framework, the performance of the individual as well as combined components of SAHM have been evaluated. The empirical evaluation shows the effectiveness of the proposed framework which outperforms existing state of the art methods like Cupid, Coma, Similarity Flooding, Jaccard Leven Matcher, Distribution Based Matcher, and EmbDI. In particular, SAHM achieves between 88 better F1 scores in comparison with state-of-the-art techniques. SAHM is also shown to be several orders of magnitude more efficient than existing techniques.

READ FULL TEXT
research
06/01/2020

NEMA: Automatic Integration of Large Network Management Databases

Network management, whether for malfunction analysis, failure prediction...
research
07/20/2021

Information Integration using the Typed Graph Model

Schema and data integration have been a challenge for more than 40 years...
research
10/14/2020

Valentine: Evaluating Matching Techniques for Dataset Discovery

Data scientists today search large data lakes to discover and integrate ...
research
03/08/2022

It's AI Match: A Two-Step Approach for Schema Matching Using Embeddings

Since data is often stored in different sources, it needs to be integrat...
research
10/05/2020

LEAPME: Learning-based Property Matching with Embeddings

Data integration tasks such as the creation and extension of knowledge g...
research
07/10/2014

XML Matchers: approaches and challenges

Schema Matching, i.e. the process of discovering semantic correspondence...
research
03/14/2019

A Hybrid Data Cleaning Framework using Markov Logic Networks

With the increase of dirty data, data cleaning turns into a crux of data...

Please sign up or login with your details

Forgot password? Click here to reset