Instance-based Schema Matching for Web Databases by Domain-specific Query Probing [chapter]

Jiying Wang, Ji-Rong Wen, Fred Lochovsky, Wei-Ying Ma
2004 Proceedings 2004 VLDB Conference  
In a Web database that dynamically provides information in response to user queries, two distinct schemas, interface schema (the schema users can query) and result schema (the schema users can browse), are presented to users. Each partially reflects the actual schema of the Web database. Most previous work only studied the problem of schema matching across query interfaces of Web databases. In this paper, we propose a novel schema model that distinguishes the interface and the result schema of
more » ... Web database in a specific domain. In this model, we address two significant Web database schemamatching problems: intra-site and inter-site. The first problem is crucial in automatically extracting data from Web databases, while the second problem plays a significant role in meta-retrieving and integrating data from different Web databases. We also investigate a unified solution to the two problems based on query probing and instance-based schema matching techniques. Using the model, a cross validation technique is also proposed to improve the accuracy of the schema matching. Our experiments on real Web databases demonstrate that the two problems can be solved simultaneously with high precision and recall.
doi:10.1016/b978-012088469-8.50038-3 dblp:conf/vldb/WangWLM04 fatcat:rfmwkhwm6bdvtgi5474qjiubsu