Leveraging query logs for schema mapping generation in U-MAP

Hazem Elmeleegy, Ahmed Elmagarmid, Jaewoo Lee

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

12 Citations (Scopus)

Abstract

In this paper, we introduce U-MAP, a new system for schema mapping generation. U-MAP builds upon and extends existing schema mapping techniques. However, it mitigates some key problems in this area, which have not been previously addressed. The key tenet of U-MAP is to exploit the usage information extracted from the query logs associated with the schemas being mapped. We describe our experience in applying our proposed system to realistic datasets from the retail and life sciences domains. Our results demonstrate the effectiveness and efficiency of U-MAP compared to traditional approaches.

Original languageEnglish
Title of host publicationProceedings of the ACM SIGMOD International Conference on Management of Data
Pages121-132
Number of pages12
DOIs
Publication statusPublished - 11 Jul 2011
Event2011 ACM SIGMOD and 30th PODS 2011 Conference - Athens, Greece
Duration: 12 Jun 201116 Jun 2011

Other

Other2011 ACM SIGMOD and 30th PODS 2011 Conference
CountryGreece
CityAthens
Period12/6/1116/6/11

Keywords

  • data exchange
  • data integration
  • query logs
  • schema mapping
  • usage

ASJC Scopus subject areas

  • Software
  • Information Systems

Cite this

Elmeleegy, H., Elmagarmid, A., & Lee, J. (2011). Leveraging query logs for schema mapping generation in U-MAP. In Proceedings of the ACM SIGMOD International Conference on Management of Data (pp. 121-132) https://doi.org/10.1145/1989323.1989337

Leveraging query logs for schema mapping generation in U-MAP. / Elmeleegy, Hazem; Elmagarmid, Ahmed; Lee, Jaewoo.

Proceedings of the ACM SIGMOD International Conference on Management of Data. 2011. p. 121-132.

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

Elmeleegy, H, Elmagarmid, A & Lee, J 2011, Leveraging query logs for schema mapping generation in U-MAP. in Proceedings of the ACM SIGMOD International Conference on Management of Data. pp. 121-132, 2011 ACM SIGMOD and 30th PODS 2011 Conference, Athens, Greece, 12/6/11. https://doi.org/10.1145/1989323.1989337
Elmeleegy H, Elmagarmid A, Lee J. Leveraging query logs for schema mapping generation in U-MAP. In Proceedings of the ACM SIGMOD International Conference on Management of Data. 2011. p. 121-132 https://doi.org/10.1145/1989323.1989337
Elmeleegy, Hazem ; Elmagarmid, Ahmed ; Lee, Jaewoo. / Leveraging query logs for schema mapping generation in U-MAP. Proceedings of the ACM SIGMOD International Conference on Management of Data. 2011. pp. 121-132
@inproceedings{84509fe99e764ebc93d27994205d86c6,
title = "Leveraging query logs for schema mapping generation in U-MAP",
abstract = "In this paper, we introduce U-MAP, a new system for schema mapping generation. U-MAP builds upon and extends existing schema mapping techniques. However, it mitigates some key problems in this area, which have not been previously addressed. The key tenet of U-MAP is to exploit the usage information extracted from the query logs associated with the schemas being mapped. We describe our experience in applying our proposed system to realistic datasets from the retail and life sciences domains. Our results demonstrate the effectiveness and efficiency of U-MAP compared to traditional approaches.",
keywords = "data exchange, data integration, query logs, schema mapping, usage",
author = "Hazem Elmeleegy and Ahmed Elmagarmid and Jaewoo Lee",
year = "2011",
month = "7",
day = "11",
doi = "10.1145/1989323.1989337",
language = "English",
isbn = "9781450306614",
pages = "121--132",
booktitle = "Proceedings of the ACM SIGMOD International Conference on Management of Data",

}

TY - GEN

T1 - Leveraging query logs for schema mapping generation in U-MAP

AU - Elmeleegy, Hazem

AU - Elmagarmid, Ahmed

AU - Lee, Jaewoo

PY - 2011/7/11

Y1 - 2011/7/11

N2 - In this paper, we introduce U-MAP, a new system for schema mapping generation. U-MAP builds upon and extends existing schema mapping techniques. However, it mitigates some key problems in this area, which have not been previously addressed. The key tenet of U-MAP is to exploit the usage information extracted from the query logs associated with the schemas being mapped. We describe our experience in applying our proposed system to realistic datasets from the retail and life sciences domains. Our results demonstrate the effectiveness and efficiency of U-MAP compared to traditional approaches.

AB - In this paper, we introduce U-MAP, a new system for schema mapping generation. U-MAP builds upon and extends existing schema mapping techniques. However, it mitigates some key problems in this area, which have not been previously addressed. The key tenet of U-MAP is to exploit the usage information extracted from the query logs associated with the schemas being mapped. We describe our experience in applying our proposed system to realistic datasets from the retail and life sciences domains. Our results demonstrate the effectiveness and efficiency of U-MAP compared to traditional approaches.

KW - data exchange

KW - data integration

KW - query logs

KW - schema mapping

KW - usage

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

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

U2 - 10.1145/1989323.1989337

DO - 10.1145/1989323.1989337

M3 - Conference contribution

SN - 9781450306614

SP - 121

EP - 132

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

ER -