DataXFormer: An interactive data transformation tool

John Morcos; Ziawasch Abedjan; Ihab F. Ilyas; Mourad Ouzzani; Paolo Papotti; Michael Stonebraker

doi:10.1145/2723372.2735366

DataXFormer: An interactive data transformation tool

John Morcos, Ziawasch Abedjan, Ihab F. Ilyas, Mourad Ouzzani, Paolo Papotti, Michael Stonebraker

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

18 Scopus citations

Abstract

While syntactic transformations require the application of a formula on the input values, such as unit conversion or date format conversions, semantic transformations, such as zip code to city, require a look-up in some reference data. We recently presented DataXFormer, a system that leverages Web tables, Web forms, and expert sourcing to cover a wide range of transformations. In this demonstration, we present the user-interaction with DataXFormer and show scenarios on how it can be used to transform data and explore the effectiveness and efficiency of several approaches for transformation discovery, leveraging about 112 million tables and online sources.

Original language	English (US)
Title of host publication	SIGMOD 2015 - Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data
Publisher	Association for Computing Machinery
Pages	883-888
Number of pages	6
Volume	2015-May
ISBN (Electronic)	9781450327589
DOIs	https://doi.org/10.1145/2723372.2735366
State	Published - May 27 2015
Externally published	Yes
Event	ACM SIGMOD International Conference on Management of Data, SIGMOD 2015 - Melbourne, Australia Duration: May 31 2015 → Jun 4 2015

Other

Other	ACM SIGMOD International Conference on Management of Data, SIGMOD 2015
Country/Territory	Australia
City	Melbourne
Period	5/31/15 → 6/4/15

Keywords

Data enrichment
Data integration
Data transformation
Deep web
Web forms
Web tables
Wrapper

ASJC Scopus subject areas

Software
Information Systems

Access to Document

10.1145/2723372.2735366

Cite this

Morcos, J, Abedjan, Z, Ilyas, IF, Ouzzani, M, Papotti, P & Stonebraker, M 2015, DataXFormer: An interactive data transformation tool. in SIGMOD 2015 - Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data. vol. 2015-May, Association for Computing Machinery, pp. 883-888, ACM SIGMOD International Conference on Management of Data, SIGMOD 2015, Melbourne, Australia, 5/31/15. https://doi.org/10.1145/2723372.2735366

@inproceedings{2694f56b56c44001928887401da8a697,

title = "DataXFormer: An interactive data transformation tool",

abstract = "While syntactic transformations require the application of a formula on the input values, such as unit conversion or date format conversions, semantic transformations, such as zip code to city, require a look-up in some reference data. We recently presented DataXFormer, a system that leverages Web tables, Web forms, and expert sourcing to cover a wide range of transformations. In this demonstration, we present the user-interaction with DataXFormer and show scenarios on how it can be used to transform data and explore the effectiveness and efficiency of several approaches for transformation discovery, leveraging about 112 million tables and online sources.",

keywords = "Data enrichment, Data integration, Data transformation, Deep web, Web forms, Web tables, Wrapper",

author = "John Morcos and Ziawasch Abedjan and Ilyas, {Ihab F.} and Mourad Ouzzani and Paolo Papotti and Michael Stonebraker",

year = "2015",

month = may,

day = "27",

doi = "10.1145/2723372.2735366",

language = "English (US)",

volume = "2015-May",

pages = "883--888",

booktitle = "SIGMOD 2015 - Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data",

publisher = "Association for Computing Machinery",

note = "ACM SIGMOD International Conference on Management of Data, SIGMOD 2015 ; Conference date: 31-05-2015 Through 04-06-2015",

}

TY - GEN

T1 - DataXFormer

T2 - ACM SIGMOD International Conference on Management of Data, SIGMOD 2015

AU - Morcos, John

AU - Abedjan, Ziawasch

AU - Ilyas, Ihab F.

AU - Ouzzani, Mourad

AU - Papotti, Paolo

AU - Stonebraker, Michael

PY - 2015/5/27

Y1 - 2015/5/27

N2 - While syntactic transformations require the application of a formula on the input values, such as unit conversion or date format conversions, semantic transformations, such as zip code to city, require a look-up in some reference data. We recently presented DataXFormer, a system that leverages Web tables, Web forms, and expert sourcing to cover a wide range of transformations. In this demonstration, we present the user-interaction with DataXFormer and show scenarios on how it can be used to transform data and explore the effectiveness and efficiency of several approaches for transformation discovery, leveraging about 112 million tables and online sources.

AB - While syntactic transformations require the application of a formula on the input values, such as unit conversion or date format conversions, semantic transformations, such as zip code to city, require a look-up in some reference data. We recently presented DataXFormer, a system that leverages Web tables, Web forms, and expert sourcing to cover a wide range of transformations. In this demonstration, we present the user-interaction with DataXFormer and show scenarios on how it can be used to transform data and explore the effectiveness and efficiency of several approaches for transformation discovery, leveraging about 112 million tables and online sources.

KW - Data enrichment

KW - Data integration

KW - Data transformation

KW - Deep web

KW - Web forms

KW - Web tables

KW - Wrapper

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

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

U2 - 10.1145/2723372.2735366

DO - 10.1145/2723372.2735366

M3 - Conference contribution

AN - SCOPUS:84957568249

VL - 2015-May

SP - 883

EP - 888

BT - SIGMOD 2015 - Proceedings of the 2015 ACM SIGMOD International Conference on Management of Data

PB - Association for Computing Machinery

Y2 - 31 May 2015 through 4 June 2015

ER -

DataXFormer: An interactive data transformation tool

Abstract

Other

Keywords

ASJC Scopus subject areas

Access to Document

Other files and links

Fingerprint

Cite this