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 (US)
Title of host publicationCIKM 2012 - Proceedings of the 21st ACM International Conference on Information and Knowledge Management
Pages872-881
Number of pages10
DOIs
StatePublished - 2012
Externally publishedYes
Event21st ACM International Conference on Information and Knowledge Management, CIKM 2012 - Maui, HI, United States
Duration: Oct 29 2012Nov 2 2012

Other

Other21st ACM International Conference on Information and Knowledge Management, CIKM 2012
CountryUnited States
CityMaui, HI
Period10/29/1211/2/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 CIKM 2012 - Proceedings of the 21st ACM International Conference on Information and Knowledge Management (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.

CIKM 2012 - Proceedings of the 21st ACM International Conference on Information and Knowledge Management. 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 CIKM 2012 - Proceedings of the 21st ACM International Conference on Information and Knowledge Management. pp. 872-881, 21st ACM International Conference on Information and Knowledge Management, CIKM 2012, Maui, HI, United States, 10/29/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 CIKM 2012 - Proceedings of the 21st ACM International Conference on Information and Knowledge Management. 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?. CIKM 2012 - Proceedings of the 21st ACM International Conference on Information and Knowledge Management. 2012. pp. 872-881
@inproceedings{1735e6fa10b44c4f825055e82641f893,
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",
doi = "10.1145/2396761.2396872",
language = "English (US)",
isbn = "9781450311564",
pages = "872--881",
booktitle = "CIKM 2012 - Proceedings of the 21st ACM International Conference on Information and Knowledge Management",

}

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

Y1 - 2012

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 - CIKM 2012 - Proceedings of the 21st ACM International Conference on Information and Knowledge Management

ER -