What is the IQ of your data transformation system?

Giansalvatore Mecca, Paolo Papotti, Salvatore Raunich, Donatello Santoro

Research output: Chapter in Book/Report/Conference proceedingConference contribution

7 Citations (Scopus)

Abstract

Mapping and translating data across different representations is a crucial problem in information systems. Many formalisms and tools are currently used for this purpose, to the point that developers typically face a difficult question: "what is the right tool for my translation task?" In this paper, we introduce several techniques that contribute to answer this question. Among these, a fairly general definition of a data transformation system, a new and very efficient similarity measure to evaluate the outputs produced by such a system, and a metric to estimate user efforts. Based on these techniques, we are able to compare a wide range of systems on many translation tasks, to gain interesting insights about their effectiveness, and, ultimately, about their "intelligence".

Original languageEnglish
Title of host publicationACM International Conference Proceeding Series
Pages872-881
Number of pages10
DOIs
Publication statusPublished - 19 Dec 2012
Event21st ACM International Conference on Information and Knowledge Management, CIKM 2012 - Maui, HI, United States
Duration: 29 Oct 20122 Nov 2012

Other

Other21st ACM International Conference on Information and Knowledge Management, CIKM 2012
CountryUnited States
CityMaui, HI
Period29/10/122/11/12

Fingerprint

Information systems

Keywords

  • benchmarks
  • data transformation
  • ETL
  • schema mappings

ASJC Scopus subject areas

  • Human-Computer Interaction
  • Computer Networks and Communications
  • Computer Vision and Pattern Recognition
  • Software

Cite this

Mecca, G., Papotti, P., Raunich, S., & Santoro, D. (2012). What is the IQ of your data transformation system? In ACM International Conference Proceeding Series (pp. 872-881) https://doi.org/10.1145/2396761.2396872

What is the IQ of your data transformation system? / Mecca, Giansalvatore; Papotti, Paolo; Raunich, Salvatore; Santoro, Donatello.

ACM International Conference Proceeding Series. 2012. p. 872-881.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Mecca, G, Papotti, P, Raunich, S & Santoro, D 2012, What is the IQ of your data transformation system? in ACM International Conference Proceeding Series. pp. 872-881, 21st ACM International Conference on Information and Knowledge Management, CIKM 2012, Maui, HI, United States, 29/10/12. https://doi.org/10.1145/2396761.2396872
Mecca G, Papotti P, Raunich S, Santoro D. What is the IQ of your data transformation system? In ACM International Conference Proceeding Series. 2012. p. 872-881 https://doi.org/10.1145/2396761.2396872
Mecca, Giansalvatore ; Papotti, Paolo ; Raunich, Salvatore ; Santoro, Donatello. / What is the IQ of your data transformation system?. ACM International Conference Proceeding Series. 2012. pp. 872-881
@inproceedings{304438f5b248485a96bdf8816986e34a,
title = "What is the IQ of your data transformation system?",
abstract = "Mapping and translating data across different representations is a crucial problem in information systems. Many formalisms and tools are currently used for this purpose, to the point that developers typically face a difficult question: {"}what is the right tool for my translation task?{"} In this paper, we introduce several techniques that contribute to answer this question. Among these, a fairly general definition of a data transformation system, a new and very efficient similarity measure to evaluate the outputs produced by such a system, and a metric to estimate user efforts. Based on these techniques, we are able to compare a wide range of systems on many translation tasks, to gain interesting insights about their effectiveness, and, ultimately, about their {"}intelligence{"}.",
keywords = "benchmarks, data transformation, ETL, schema mappings",
author = "Giansalvatore Mecca and Paolo Papotti and Salvatore Raunich and Donatello Santoro",
year = "2012",
month = "12",
day = "19",
doi = "10.1145/2396761.2396872",
language = "English",
isbn = "9781450311564",
pages = "872--881",
booktitle = "ACM International Conference Proceeding Series",

}

TY - GEN

T1 - What is the IQ of your data transformation system?

AU - Mecca, Giansalvatore

AU - Papotti, Paolo

AU - Raunich, Salvatore

AU - Santoro, Donatello

PY - 2012/12/19

Y1 - 2012/12/19

N2 - Mapping and translating data across different representations is a crucial problem in information systems. Many formalisms and tools are currently used for this purpose, to the point that developers typically face a difficult question: "what is the right tool for my translation task?" In this paper, we introduce several techniques that contribute to answer this question. Among these, a fairly general definition of a data transformation system, a new and very efficient similarity measure to evaluate the outputs produced by such a system, and a metric to estimate user efforts. Based on these techniques, we are able to compare a wide range of systems on many translation tasks, to gain interesting insights about their effectiveness, and, ultimately, about their "intelligence".

AB - Mapping and translating data across different representations is a crucial problem in information systems. Many formalisms and tools are currently used for this purpose, to the point that developers typically face a difficult question: "what is the right tool for my translation task?" In this paper, we introduce several techniques that contribute to answer this question. Among these, a fairly general definition of a data transformation system, a new and very efficient similarity measure to evaluate the outputs produced by such a system, and a metric to estimate user efforts. Based on these techniques, we are able to compare a wide range of systems on many translation tasks, to gain interesting insights about their effectiveness, and, ultimately, about their "intelligence".

KW - benchmarks

KW - data transformation

KW - ETL

KW - schema mappings

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

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

U2 - 10.1145/2396761.2396872

DO - 10.1145/2396761.2396872

M3 - Conference contribution

AN - SCOPUS:84871048471

SN - 9781450311564

SP - 872

EP - 881

BT - ACM International Conference Proceeding Series

ER -