An Overview of Schema Extraction and Matching Techniques

Muhammad Umair Hassan; Kamran Shankat; Dongmie Niu; Sundas Mahreen; Yingjun Ma; Fatima Haider; Muhammad Mubashir; Xiuyang Zhao

doi:10.1109/IMCEC.2018.8469502

An Overview of Schema Extraction and Matching Techniques

Muhammad Umair Hassan, Kamran Shankat, Dongmie Niu, Sundas Mahreen, Yingjun Ma, Fatima Haider, Muhammad Mubashir, Xiuyang Zhao

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

3 Scopus citations

Abstract

W383 contains huge amount of data both in structured and unstructured form. One of the forms for the structured data is HTML tables for which metadata are not explicitly stored/available. As a result, data in such tables cannot be queried accurately and users cannot get exact results to their queries through search engines. Schema extraction establishes schema for data found in different form of web tables. Once the schema of web tables has been extracted, the tables can be created and populated against this schema which can be queried using SQL resulting much better results than traditional search engines. Schema Matching determines number of correspondences which identifies the similar elements from two different schemas. Columns and data values are compared one after the other to match schema. In this paper, different ways of extracting data from tables are mentioned and different tools used for schema extraction are named. Two techniques for Schema Matching are briefly explained.

Original language	English (US)
Title of host publication	Proceedings of 2018 2nd IEEE Advanced Information Management, Communicates, Electronic and Automation Control Conference, IMCEC 2018
Publisher	Institute of Electrical and Electronics Engineers Inc.
Pages	1290-1294
Number of pages	5
ISBN (Print)	9781538618035
DOIs	https://doi.org/10.1109/IMCEC.2018.8469502
State	Published - Sep 20 2018
Externally published	Yes

Bibliographical note

Generated from Scopus record by KAUST IRTS on 2023-09-20

Access to Document

10.1109/IMCEC.2018.8469502

Cite this

Hassan, M. U., Shankat, K., Niu, D., Mahreen, S., Ma, Y., Haider, F., Mubashir, M., & Zhao, X. (2018). An Overview of Schema Extraction and Matching Techniques. In Proceedings of 2018 2nd IEEE Advanced Information Management, Communicates, Electronic and Automation Control Conference, IMCEC 2018 (pp. 1290-1294). Institute of Electrical and Electronics Engineers Inc.. https://doi.org/10.1109/IMCEC.2018.8469502

@inproceedings{d1209e42e4c348bb812a4f6d25ea0f2c,

title = "An Overview of Schema Extraction and Matching Techniques",

abstract = "W383 contains huge amount of data both in structured and unstructured form. One of the forms for the structured data is HTML tables for which metadata are not explicitly stored/available. As a result, data in such tables cannot be queried accurately and users cannot get exact results to their queries through search engines. Schema extraction establishes schema for data found in different form of web tables. Once the schema of web tables has been extracted, the tables can be created and populated against this schema which can be queried using SQL resulting much better results than traditional search engines. Schema Matching determines number of correspondences which identifies the similar elements from two different schemas. Columns and data values are compared one after the other to match schema. In this paper, different ways of extracting data from tables are mentioned and different tools used for schema extraction are named. Two techniques for Schema Matching are briefly explained.",

author = "Hassan, {Muhammad Umair} and Kamran Shankat and Dongmie Niu and Sundas Mahreen and Yingjun Ma and Fatima Haider and Muhammad Mubashir and Xiuyang Zhao",

note = "Generated from Scopus record by KAUST IRTS on 2023-09-20",

year = "2018",

month = sep,

day = "20",

doi = "10.1109/IMCEC.2018.8469502",

language = "English (US)",

isbn = "9781538618035",

pages = "1290--1294",

booktitle = "Proceedings of 2018 2nd IEEE Advanced Information Management, Communicates, Electronic and Automation Control Conference, IMCEC 2018",

publisher = "Institute of Electrical and Electronics Engineers Inc.",

address = "United States",

}

Hassan, MU, Shankat, K, Niu, D, Mahreen, S, Ma, Y, Haider, F, Mubashir, M & Zhao, X 2018, An Overview of Schema Extraction and Matching Techniques. in Proceedings of 2018 2nd IEEE Advanced Information Management, Communicates, Electronic and Automation Control Conference, IMCEC 2018. Institute of Electrical and Electronics Engineers Inc., pp. 1290-1294. https://doi.org/10.1109/IMCEC.2018.8469502

An Overview of Schema Extraction and Matching Techniques. / Hassan, Muhammad Umair; Shankat, Kamran; Niu, Dongmie et al.
Proceedings of 2018 2nd IEEE Advanced Information Management, Communicates, Electronic and Automation Control Conference, IMCEC 2018. Institute of Electrical and Electronics Engineers Inc., 2018. p. 1290-1294.

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

TY - GEN

T1 - An Overview of Schema Extraction and Matching Techniques

AU - Hassan, Muhammad Umair

AU - Shankat, Kamran

AU - Niu, Dongmie

AU - Mahreen, Sundas

AU - Ma, Yingjun

AU - Haider, Fatima

AU - Mubashir, Muhammad

AU - Zhao, Xiuyang

N1 - Generated from Scopus record by KAUST IRTS on 2023-09-20

PY - 2018/9/20

Y1 - 2018/9/20

N2 - W383 contains huge amount of data both in structured and unstructured form. One of the forms for the structured data is HTML tables for which metadata are not explicitly stored/available. As a result, data in such tables cannot be queried accurately and users cannot get exact results to their queries through search engines. Schema extraction establishes schema for data found in different form of web tables. Once the schema of web tables has been extracted, the tables can be created and populated against this schema which can be queried using SQL resulting much better results than traditional search engines. Schema Matching determines number of correspondences which identifies the similar elements from two different schemas. Columns and data values are compared one after the other to match schema. In this paper, different ways of extracting data from tables are mentioned and different tools used for schema extraction are named. Two techniques for Schema Matching are briefly explained.

AB - W383 contains huge amount of data both in structured and unstructured form. One of the forms for the structured data is HTML tables for which metadata are not explicitly stored/available. As a result, data in such tables cannot be queried accurately and users cannot get exact results to their queries through search engines. Schema extraction establishes schema for data found in different form of web tables. Once the schema of web tables has been extracted, the tables can be created and populated against this schema which can be queried using SQL resulting much better results than traditional search engines. Schema Matching determines number of correspondences which identifies the similar elements from two different schemas. Columns and data values are compared one after the other to match schema. In this paper, different ways of extracting data from tables are mentioned and different tools used for schema extraction are named. Two techniques for Schema Matching are briefly explained.

UR - https://ieeexplore.ieee.org/document/8469502/

UR - http://www.scopus.com/inward/record.url?scp=85055680884&partnerID=8YFLogxK

U2 - 10.1109/IMCEC.2018.8469502

DO - 10.1109/IMCEC.2018.8469502

M3 - Conference contribution

SN - 9781538618035

SP - 1290

EP - 1294

BT - Proceedings of 2018 2nd IEEE Advanced Information Management, Communicates, Electronic and Automation Control Conference, IMCEC 2018

PB - Institute of Electrical and Electronics Engineers Inc.

ER -

An Overview of Schema Extraction and Matching Techniques

Abstract

Bibliographical note

Access to Document

Other files and links

Fingerprint

Cite this