{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,11,19]],"date-time":"2025-11-19T06:54:53Z","timestamp":1763535293299},"reference-count":41,"publisher":"Association for Computing Machinery (ACM)","issue":"1","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2009,8]]},"abstract":"<jats:p>We address the problem of unsupervised matching of schema information from a large number of data sources into the schema of a data warehouse. The matching process is the first step of a framework to integrate data feeds from third-party data providers into a structured-search engine's data warehouse. Our experiments show that traditional schema-based and instance-based schema matching methods fall short. We propose a new technique based on the search engine's clicklogs. Two schema elements are matched if the distribution of keyword queries that cause click-throughs on their instances are similar. We present experiments on large commercial datasets that show the new technique has much better accuracy than traditional techniques.<\/jats:p>","DOI":"10.14778\/1687627.1687649","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"181-192","source":"Crossref","is-referenced-by-count":18,"title":["HAMSTER"],"prefix":"10.14778","volume":"2","author":[{"given":"Arnab","family":"Nandi","sequence":"first","affiliation":[{"name":"University of Michigan, Ann Arbor"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Philip A.","family":"Bernstein","sequence":"additional","affiliation":[{"name":"Microsoft Research"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2009,8]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1145\/371920.372163"},{"key":"e_1_2_1_2_1","volume-title":"WebDB","author":"Amer-Yahia S.","year":"2007","unstructured":"S. Amer-Yahia . A Database Solution to Search 2.0 (keynote talk) . WebDB , 2007 . S. Amer-Yahia. A Database Solution to Search 2.0 (keynote talk). WebDB, 2007."},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/1409220.1409221"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066283"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-30192-9_58"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-30192-9_58"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1007\/11536406_8"},{"key":"e_1_2_1_8_1","author":"Bernstein P.","year":"2001","unstructured":"P. Bernstein , J. Madhavan , and E. Rahm . Generic Schema Matching with Cupid. VLDB Journal , 2001 . P. Bernstein, J. Madhavan, and E. Rahm. Generic Schema Matching with Cupid. VLDB Journal, 2001.","journal-title":"Generic Schema Matching with Cupid. VLDB Journal"},{"key":"e_1_2_1_9_1","volume-title":"VLDB","author":"Bernstein P.","year":"2006","unstructured":"P. Bernstein , S. Melnik , and J. Churchill . Incremental Schema Matching . VLDB , 2006 . P. Bernstein, S. Melnik, and J. Churchill. Incremental Schema Matching. VLDB, 2006."},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.14778\/1453856.1453940"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/276305.276323"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/376284.375731"},{"key":"e_1_2_1_13_1","author":"Doan A.","year":"2005","unstructured":"A. Doan and A. Halevy . Semantic Integration Research in the Database Community: A Brief Survey. AI Magazine , 2005 . A. Doan and A. Halevy. Semantic Integration Research in the Database Community: A Brief Survey. AI Magazine, 2005.","journal-title":"AI Magazine"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-24750-0_19"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066168"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2008.4497410"},{"key":"e_1_2_1_17_1","volume-title":"BTW Workshop","author":"Engmann D.","year":"2007","unstructured":"D. Engmann and S. Massmann . Instance matching with COMA++ . In BTW Workshop , 2007 . D. Engmann and S. Massmann. Instance matching with COMA++. In BTW Workshop, 2007."},{"key":"e_1_2_1_18_1","volume-title":"Ontology Matching","author":"Euzenat J.","year":"2007","unstructured":"J. Euzenat and P. Shvaiko . Ontology Matching . Springer-Verlag , 2007 . J. Euzenat and P. Shvaiko. Ontology Matching. Springer-Verlag, 2007."},{"key":"e_1_2_1_19_1","volume-title":"SIGMOD","author":"He B.","year":"2003","unstructured":"B. He and K. Chang . Statistical Schema Integration across the Deep Web . SIGMOD , 2003 . B. He and K. Chang. Statistical Schema Integration across the Deep Web. SIGMOD, 2003."},{"key":"e_1_2_1_20_1","volume-title":"VLDB","author":"Hong J.","year":"2008","unstructured":"J. Hong , H. Zhongtian , and D. Bell . An Evidential Approach to Query Interface Matching on the Deep Web . VLDB , 2008 . J. Hong, H. Zhongtian, and D. Bell. An Evidential Approach to Query Interface Matching on the Deep Web. VLDB, 2008."},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142566"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/1135777.1135917"},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-74958-5_60"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1145\/543613.543644"},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2005.39"},{"key":"e_1_2_1_26_1","volume-title":"CIDR","author":"Madhavan J.","year":"2007","unstructured":"J. Madhavan , S. Jeffery , S. Cohen , X. Dong , D. Ko , C. Yu , and A. Halevy . Web-scale Data Integration: You can only afford to Pay As You Go . CIDR , 2007 . J. Madhavan, S. Jeffery, S. Cohen, X. Dong, D. Ko, C. Yu, and A. Halevy. Web-scale Data Integration: You can only afford to Pay As You Go. CIDR, 2007."},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2008.4497419"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.5555\/876875.879024"},{"key":"e_1_2_1_29_1","volume-title":"Semantic Search","author":"Mika P.","year":"2008","unstructured":"P. Mika . Microsearch : An Interface for Semantic Search . Semantic Search , 2008 . P. Mika. Microsearch: An Interface for Semantic Search. Semantic Search, 2008."},{"key":"e_1_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDEW.2006.69"},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1145\/1041410.1041421"},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.1007\/s007780100057"},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.1023\/A:1026543900054"},{"key":"e_1_2_1_34_1","volume-title":"VLDB","author":"Sayyadian M.","year":"2005","unstructured":"M. Sayyadian , Y. Lee , A. Doan , and A. Rosenthal . Tuning Schema matching Software using Synthetic Scenarios . VLDB , 2005 . M. Sayyadian, Y. Lee, A. Doan, and A. Rosenthal. Tuning Schema matching Software using Synthetic Scenarios. VLDB, 2005."},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2007.367880"},{"key":"e_1_2_1_36_1","doi-asserted-by":"publisher","DOI":"10.1007\/11603412_5"},{"key":"e_1_2_1_37_1","volume-title":"CIDR","author":"Smith K.","year":"2009","unstructured":"K. Smith , P. Mork , L. Seligman , A. Rosenthal , M. Morse , D. Allen , and M. Li . The Role of Schema Metching in Large Enterprises . CIDR , 2009 . K. Smith, P. Mork, L. Seligman, A. Rosenthal, M. Morse, D. Allen, and M. Li. The Role of Schema Metching in Large Enterprises. CIDR, 2009."},{"key":"e_1_2_1_38_1","doi-asserted-by":"publisher","DOI":"10.1145\/375663.375739"},{"key":"e_1_2_1_39_1","doi-asserted-by":"publisher","DOI":"10.1145\/1367497.1367545"},{"key":"e_1_2_1_40_1","doi-asserted-by":"publisher","DOI":"10.17487\/RFC2413"},{"key":"e_1_2_1_41_1","doi-asserted-by":"publisher","DOI":"10.1145\/503104.503108"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/1687627.1687649","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T11:24:47Z","timestamp":1672226687000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/1687627.1687649"}},"subtitle":["using search clicklogs for schema and taxonomy matching"],"short-title":[],"issued":{"date-parts":[[2009,8]]},"references-count":41,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2009,8]]}},"alternative-id":["10.14778\/1687627.1687649"],"URL":"https:\/\/doi.org\/10.14778\/1687627.1687649","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2009,8]]}}}