Leveraging query logs for schema mapping generation in U-MAP

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. Categories and Subject Descriptors H.2.5 [Database Management]: Heterogeneous Databases General Terms Algorithms, Design Keywords schema mapping, query logs, usage, data exchange, data integration

• Type: Journal
• Year: 2011
• Where: SIGMOD
• Authors: Hazem Elmeleegy, Ahmed K. Elmagarmid, Jaewoo Lee
• Keywords: Database, Heterogeneous Databases, Mapping Techniques, Schema Mapping, SIGMOD 2011