DataXFormer: An Interactive Data Transformation Tool

被引:8
|
作者
Morcos, John [1 ]
Abedjan, Ziawasch [2 ]
Ilyas, Ihab F. [1 ]
Ouzzani, Mourad [3 ]
Papotti, Paolo [3 ]
Stonebraker, Michael [2 ]
机构
[1] Univ Waterloo, Waterloo, ON, Canada
[2] MIT CSAIL, Cambridge, MA USA
[3] Qatar Comp Res Inst, Ar Rayyan, Qatar
关键词
data integration; data enrichment; data transformation; web tables; web forms; wrapper; deep web;
D O I
10.1145/2723372.2735366
中图分类号
TP [自动化技术、计算机技术];
学科分类号
0812 ;
摘要
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.
引用
收藏
页码:883 / 888
页数:6
相关论文
共 50 条
  • [1] DataXFormer: A Robust Transformation Discovery System
    Abedjan, Ziawasch
    Morcos, John
    Ilyas, Ihab F.
    Ouzzani, Mourad
    Papotti, Paolo
    Stonebraker, Michael
    [J]. 2016 32ND IEEE INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE), 2016, : 1134 - 1145
  • [3] ANALYSIS AND TRANSFORMATION IN AN INTERACTIVE PARALLEL PROGRAMMING TOOL
    KENNEDY, K
    MCKINLEY, KS
    TSENG, CW
    [J]. CONCURRENCY-PRACTICE AND EXPERIENCE, 1993, 5 (07): : 575 - 602
  • [4] An interactive tool for data visualization and clustering
    Iorio, F.
    Miele, G.
    Napolitano, F.
    Raiconi, G.
    Tagliaferri, R.
    [J]. KNOWLEDGE-BASED INTELLIGENT INFORMATION AND ENGINEERING SYSTEMS: KES 2007 - WIRN 2007, PT III, PROCEEDINGS, 2007, 4694 : 870 - +
  • [5] Interactive software tool for data visualisation
    Kolodnytsky, M
    Kovalchuk, A
    [J]. IDAACS'2001: PROCEEDINGS OF THE INTERNATIONAL WORKSHOP ON INTELLIGENT DATA ACQUISITION AND ADVANCED COMPUTING SYSTEMS: TECHNOLOGY AND APPLICATION, 2001, : 107 - 110
  • [6] NdEdit: Interactive data selection tool
    Osborne, JR
    Denbo, DW
    [J]. 18TH INTERNATIONAL CONFERENCE ON INTERACTIVE INFORMATION AND PROCESSING SYSTEMS (IIPS) FOR METEOROLOGY, OCEANOGRAPHY, AND HYDROLOGY, 2002, : 68 - 69
  • [7] An Interactive tool for transparent Data Preprocessing
    Parisot, Olivier
    Tamisier, Thomas
    [J]. ERCIM NEWS, 2015, (100): : 33 - 34
  • [8] Online Interactive Data Mining Tool
    Borhade, Mahesh
    Mulay, Preeti
    [J]. BIG DATA, CLOUD AND COMPUTING CHALLENGES, 2015, 50 : 335 - 340
  • [9] ComVis© -: Interactive data visualization tool
    Gabric, Ivan
    [J]. ANNUAL 2006 OF THE CROATIAN ACADEMY OF ENGINEERING, 2007, : 57 - 68
  • [10] Visual transformation for interactive spatiotemporal data mining
    Cai, Yang
    Stumpf, Richard
    Wynne, Timothy
    Tomlinson, Michelle
    Chung, Daniel Sai Ho
    Boutonnier, Xavier
    Ihmig, Matthias
    Franco, Rafael
    Bauernfeind, Nathaniel
    [J]. KNOWLEDGE AND INFORMATION SYSTEMS, 2007, 13 (02) : 119 - 142