Home            Contact us            FAQs
    
      Journal Home      |      Aim & Scope     |     Author(s) Information      |      Editorial Board      |      MSP Download Statistics

     Research Journal of Applied Sciences, Engineering and Technology

    Abstract
2014(Vol.8, Issue:4)
Article Information:

Utilizing WordNet and Regular Expressions for Instance-based Schema Matching

Ahmed Mounaf Mahdi and Sabrina Tiun
Corresponding Author:  Ahmed Mounaf Mahdi 
Submitted: January 20, 2014
Accepted: February 06, 2014
Published: July 25, 2014
Abstract:
Instance-based matching is the process of finding the correspondence of schema elements by comparing the data from different data sources. It is used as an alternative option when the match between schema elements fails. Instance-based matching is applied in many application areas such as website creation and management, schema evolution and migration, data warehousing, database design and data integration. Sometimes the schema information such as (element name, description, data type, etc.) is unavailable or is unable to get the correct match especially when the element name is abbreviation, therefore, if the schema matching failed, the next step is to focus on values stored in the schemas. For these reasons, many recent approaches focus on instance-based matching. In this study, we propose an approach that combines the strength of pattern recognition utilizing regular expressions for numerical domain as well with WordNet for string domain by getting the similarity coefficient in the range of [0,1]. In previous approach, the regular expression is achieved with a good accuracy for numerical instances only and is not implemented on string instances because we need to know the meaning of string to decide if there is a match or not. The using of WordNet-based measures for string instances should guarantee to improve the effectiveness in terms of Precision (P), Recall (R) and F-measure (F). This approach is evaluated with real dataset and the results are found better than using just equality measure for string especially if the schemas are disjoint. The approach achieved 95.3% F-measure (F).

Key words:  Instance-based matching, regular expression, schema matching, WordNet, , ,
Abstract PDF HTML
Cite this Reference:
Ahmed Mounaf Mahdi and Sabrina Tiun, . Utilizing WordNet and Regular Expressions for Instance-based Schema Matching. Research Journal of Applied Sciences, Engineering and Technology, (4): 460-470.
ISSN (Online):  2040-7467
ISSN (Print):   2040-7459
Submit Manuscript
   Information
   Sales & Services
Home   |  Contact us   |  About us   |  Privacy Policy
Copyright © 2024. MAXWELL Scientific Publication Corp., All rights reserved