{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,11,5]],"date-time":"2025-11-05T20:24:20Z","timestamp":1762374260433,"version":"3.37.3"},"reference-count":48,"publisher":"Springer Science and Business Media LLC","issue":"1","license":[{"start":{"date-parts":[[2019,5,9]],"date-time":"2019-05-09T00:00:00Z","timestamp":1557360000000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"funder":[{"DOI":"10.13039\/501100001809","name":"National Natural Science Foundation of China","doi-asserted-by":"publisher","award":["61303016"],"award-info":[{"award-number":["61303016"]}],"id":[{"id":"10.13039\/501100001809","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":["Distrib Parallel Databases"],"published-print":{"date-parts":[[2020,3]]},"DOI":"10.1007\/s10619-019-07268-9","type":"journal-article","created":{"date-parts":[[2019,5,9]],"date-time":"2019-05-09T12:16:28Z","timestamp":1557404188000},"page":"193-226","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":6,"title":["Schema matching based on SQL statements"],"prefix":"10.1007","volume":"38","author":[{"given":"Guohui","family":"Ding","sequence":"first","affiliation":[]},{"given":"Shasha","family":"Sun","sequence":"additional","affiliation":[]},{"given":"Guoren","family":"Wang","sequence":"additional","affiliation":[]}],"member":"297","published-online":{"date-parts":[[2019,5,9]]},"reference":[{"key":"7268_CR1","unstructured":"An, Y., Borgid, A., ZMiller, R.\u00a0J.: A semantic approach to discovering schema mapping expressions. In: Proceedings of the International Conference on Data Engineering ICDE\u201907, pp. 206\u2013215 (2007)"},{"key":"7268_CR2","unstructured":"Aumueller, D., Do, H.\u00a0H., Massmann, S., Rahm, E.: Schema and ontology matching with COMA++. In: Proceedings of the ACM SIGMOD International Conference on Management of Data, Baltimore, Maryland, USA, June 14-16, 2005, pp.\u00a0906\u2013908 (2005)"},{"volume-title":"Schema Matching and Mapping. Data-Centric Systems and Applications","year":"2011","key":"7268_CR3","unstructured":"Bellahsene, Z., Bonifati, A., Rahm, E. (eds.): Schema Matching and Mapping. Data-Centric Systems and Applications. Springer, New York (2011)"},{"key":"7268_CR4","unstructured":"Bilke, A., Naumann, F.: Schema matching using duplicates. In: Proceedings of the International Conference on Data Engineering ICDE\u201905, pp. 69\u201380 (2005)"},{"key":"7268_CR5","unstructured":"Bohannon, P., Elnahrawy, E., Fan, W., Flaster, M.: Putting context into schema matching. In: Proceedings of the Very Large Data Bases VLDB\u201906, pp. 307\u2013318 (2006)"},{"key":"7268_CR6","unstructured":"Bonifati, A., Comignani, U., Coquery, E., Thion, R.: Interactive mapping specification with exemplar tuples. In: Proceedings of the 2017 ACM International Conference on Management of Data, SIGMOD Conference 2017, Chicago, IL, USA, May 14\u201319, 2017, pp. 667\u2013682 (2017)"},{"key":"7268_CR7","unstructured":"BreHRM. https:\/\/github.com\/dreajay\/hrm"},{"issue":"1","key":"7268_CR8","doi-asserted-by":"publisher","first-page":"107","DOI":"10.1016\/S0169-7552(98)00110-X","volume":"30","author":"S Brin","year":"1998","unstructured":"Brin, S., Page, L.: The anatomy of a large-scale hypertextual web search engine. Comput. Netw. ISDN Syst. 30(1), 107\u2013117 (1998)","journal-title":"Comput. Netw. ISDN Syst."},{"key":"7268_CR9","doi-asserted-by":"crossref","unstructured":"Cunha, J., Erwig, M., Saraiva, J.: Automatically inferring classsheet models from spreadsheets. In: Proceedings of the Visual Languages and Human-Centric Computing VL\/HCC\u201910, pp. 93\u2013100 (2010)","DOI":"10.1109\/VLHCC.2010.22"},{"key":"7268_CR10","doi-asserted-by":"crossref","unstructured":"Dai, B.\u00a0T., Koudas, N., Srivastavat, D., Tung, A. K.\u00a0H., Venkatasubramaniant, S.: Validating multi-column schema matchings by type. In: Proceedings of the International Conference on Data Engineering ICDE\u201908, pp.\u00a0120\u2013129 (2008)","DOI":"10.1109\/ICDE.2008.4497420"},{"key":"7268_CR11","doi-asserted-by":"publisher","first-page":"610","DOI":"10.1016\/B978-155860869-6\/50060-3","volume-title":"VLDB '02: Proceedings of the 28th International Conference on Very Large Databases","author":"Hong-Hai Do","year":"2002","unstructured":"Do, H.\u00a0H., Rahm, E.: Coma\u2014a system for flexible combination of schema matching approaches. In: Proceedings of the Very Large Data Bases VLDB\u201902, pp.\u00a0610\u2013621 (2002)"},{"issue":"6","key":"7268_CR12","doi-asserted-by":"publisher","first-page":"857","DOI":"10.1016\/j.is.2006.09.002","volume":"32","author":"HH Do","year":"2007","unstructured":"Do, H.H., Rahm, E.: Matching large schemas: approaches and evaluation. Inf. Syst. 32(6), 857\u2013885 (2007)","journal-title":"Inf. Syst."},{"key":"7268_CR13","doi-asserted-by":"crossref","unstructured":"Doan, A., Domingos, P., Halevy, A.: Reconciling schemas of disparate data sources: a machine-learning approach. In: Proceedings of the Special Interest Group on Management Of Data SIGMOD\u201901, pp.\u00a0509\u2013520 (2001)","DOI":"10.1145\/376284.375731"},{"key":"7268_CR14","unstructured":"Dong, X., Halevy, A.\u00a0Y., Yu, C.: Data integration with uncertainty. In: Proceedings of the Very Large Data Bases VLDB\u201907, pp.\u00a0687\u2013698 (2007)"},{"issue":"1","key":"7268_CR15","doi-asserted-by":"publisher","first-page":"550","DOI":"10.14778\/1687627.1687690","volume":"2","author":"Xin Luna Dong","year":"2009","unstructured":"Dong, X., BertiEquille, L., Srivastava, D.: Integrating conflicting data: The role of source dependence. In: Proceedings of the Very Large Data Bases VLDB\u201909, pp.\u00a0550\u2013561 (2009)","journal-title":"Proceedings of the VLDB Endowment"},{"key":"7268_CR16","doi-asserted-by":"crossref","unstructured":"Elmeleegy, H., Ouzzani, M., Elmagarmid, A.: Usage-based schema matching. In: Proceedings of the International Conference on Data Engineering ICDE\u201908, pp.\u00a020\u201329 (2008)","DOI":"10.1109\/ICDE.2008.4497410"},{"key":"7268_CR17","first-page":"207","volume-title":"Lecture Notes in Computer Science","author":"Ronald Fagin","year":"2002","unstructured":"Fagin, R., Kolaitis, P., Miller, R., Popa, L.: Data exchange: Semantics and query answering. In: Proceedings of the International Conference on Database Theory ICDT\u201903, pp.\u00a0207\u2013224 (2003)"},{"key":"7268_CR18","doi-asserted-by":"crossref","DOI":"10.1007\/978-3-031-01845-9","volume-title":"Uncertain Schema Matching. Synthesis Lectures on Data Management","author":"A Gal","year":"2011","unstructured":"Gal, A.: Uncertain Schema Matching. Synthesis Lectures on Data Management. Morgan & Claypool Publishers, San Rafael (2011)"},{"key":"7268_CR19","unstructured":"Gal, A., Roitman, H., Sagi, T.: From diversity-based prediction to better ontology & schema matching. In: Proceedings of the 25th International Conference on World Wide Web, WWW 2016, Montreal, Canada, April 11\u201315, 2016, pp.\u00a01145\u20131155 (2016)"},{"issue":"1","key":"7268_CR20","doi-asserted-by":"publisher","first-page":"186","DOI":"10.1109\/TKDE.2016.2611577","volume":"29","author":"B Gu","year":"2017","unstructured":"Gu, B., Li, Z., Zhang, X., Liu, A., Liu, G., Zheng, K., Zhao, L., Zhou, X.: The interaction between schema matching and record matching in data integration. IEEE Trans. Knowl. Data Eng. 29(1), 186\u2013199 (2017)","journal-title":"IEEE Trans. Knowl. Data Eng."},{"key":"7268_CR21","unstructured":"Halevy, A., Rajaraman, A., Ordille, J.: Data integration: The teenage years. In: Proceedings of the Very Large Data Bases VLDB\u201906, pp.\u00a09\u201316 (2006)"},{"key":"7268_CR22","volume-title":"Efficient Computation of PageRank","author":"TH Haveliwala","year":"1999","unstructured":"Haveliwala, T.H.: Efficient Computation of PageRank. Stanford University, Stanford (1999)"},{"key":"7268_CR23","doi-asserted-by":"crossref","unstructured":"He, B., Chang, K. C.\u00a0C., Han, J.: Discovering complex matchings across web query interfaces: a correlation mining approach. In: Proceedings of the Knowledge Discovery and Data Mining KDD\u201904, pp.\u00a0148\u2013157 (2004)","DOI":"10.1145\/1014052.1014071"},{"key":"7268_CR24","doi-asserted-by":"crossref","unstructured":"Kang, J., Naughton, J.\u00a0F.: On schema matching with opaque column names and data values. In: Proceedings of the Special Interest Group on Management Of Data SIGMOD\u201903, pp.\u00a0205\u2013216 (2003)","DOI":"10.1145\/872757.872783"},{"key":"7268_CR25","unstructured":"KinHRM. https:\/\/github.com\/kinmengbgm\/bgm-hrm"},{"key":"7268_CR26","doi-asserted-by":"crossref","unstructured":"Kohler, H., Zhou, X., Sadiq, S., Shu, Y., Taylor, K.: Sampling dirty data for matching attributes. In: Proceedings of the Special Interest Group on Management Of Data SIGMOD\u201910, pp.\u00a063\u201374 (2010)","DOI":"10.1145\/1807167.1807177"},{"issue":"3","key":"7268_CR27","doi-asserted-by":"publisher","first-page":"311","DOI":"10.1007\/s11280-013-0202-z","volume":"17","author":"S Kutty","year":"2014","unstructured":"Kutty, S., Nayak, R., Chen, L.: A people-to-people matching system using graph mining techniques. World Wide Web 17(3), 311\u2013349 (2014)","journal-title":"World Wide Web"},{"issue":"5","key":"7268_CR28","doi-asserted-by":"publisher","first-page":"1443","DOI":"10.1007\/s11280-014-0285-1","volume":"18","author":"H Kuwada","year":"2015","unstructured":"Kuwada, H., Hashimoto, K., Ishihara, Y., Fujiwara, T.: The consistency and absolute consistency problems of XML schema mappings between restricted dtds. World Wide Web 18(5), 1443\u20131461 (2015)","journal-title":"World Wide Web"},{"issue":"1","key":"7268_CR29","doi-asserted-by":"publisher","first-page":"49","DOI":"10.1016\/S0169-023X(99)00044-0","volume":"33","author":"WS Li","year":"2000","unstructured":"Li, W.S., Clifton, C.: Semint: a tool for identifying attribute correspondences in heterogeneous databases using neural networks. Data Knowl. Eng. 33(1), 49\u201384 (2000)","journal-title":"Data Knowl. Eng."},{"key":"7268_CR30","unstructured":"Madhavan, J., Bernstein, P.\u00a0A., Doan, A., Halevy, A.\u00a0Y.: Corpus-based schema matching. In: Proceedings of the International Conference on Data Engineering ICDE\u201905, pp.\u00a057\u201368 (2005)"},{"key":"7268_CR31","unstructured":"Massmann, S., Engmann, D., Rahm, E.: COMA++: results for the ontology alignment contest OAEI 2006. In: Proceedings of the 1st International Workshop on Ontology Matching (OM-2006) Collocated with the 5th International Semantic Web Conference (ISWC-2006), Athens, Georgia, USA, November 5, 2006 (2006)"},{"key":"7268_CR32","unstructured":"Ma\u00dfmann, S., Raunich, S., Aum\u00fcller, D., Arnold, P., Rahm, E.: Evolution of the COMA match system. In: Proceedings of the 6th International Workshop on Ontology Matching, Bonn, Germany, October 24, 2011 (2011)"},{"key":"7268_CR33","doi-asserted-by":"crossref","unstructured":"Mecca, G., Papotti, P., Raunich, S.: Core schema mappings. In: Proceedings of the Special Interest Group on Management Of Data SIGMOD\u201909, pp.\u00a0655\u2013668 (2009)","DOI":"10.1145\/1559845.1559914"},{"key":"7268_CR34","unstructured":"Melnik, S., Garcia-Molina, H., Rahm, E.: Similarity flooding: A versatile graph matching algorithm and its application to schema matching. In: Proceedings of the International Conference on Data Engineering ICDE\u201902, pp.\u00a0117\u2013128 (2002)"},{"key":"7268_CR35","unstructured":"Miller, R.\u00a0J., Haas, L.\u00a0M., Hernandez, M.\u00a0A.: Schema mapping as query discovery. In: Proceedings of the Very Large Data Bases VLDB\u201900, pp.\u00a077\u201399 (2000)"},{"key":"7268_CR36","volume-title":"Numerical Optimization","author":"J Nocedal","year":"2000","unstructured":"Nocedal, J., Wright, S.J.: Numerical Optimization, 2nd edn. Springer Science & Business Media, New York (2000)","edition":"2"},{"key":"7268_CR37","volume-title":"The PageRank Citation Ranking: Bringing Order to the Web","author":"L Page","year":"1999","unstructured":"Page, L., Brin, S., Motwani, R., Winograd, T.: The PageRank Citation Ranking: Bringing Order to the Web. Stanford InfoLab, Stanford (1999)"},{"key":"7268_CR38","doi-asserted-by":"publisher","first-page":"862","DOI":"10.1016\/B978-012722442-8\/50081-1","volume-title":"Proceedings 2003 VLDB Conference","author":"Rachel A. Pottinger","year":"2003","unstructured":"Pottinger, R.\u00a0A., Bernstein, P.\u00a0A.: Merging models based on given correspondences. In: Proceedings of the Very Large Data Bases VLDB\u201903, pp.\u00a0826\u2013873 (2003)"},{"key":"7268_CR39","doi-asserted-by":"crossref","unstructured":"Qian, L., Cafarella, M.\u00a0J., Jagadish, H.\u00a0V.: Sample-driven schema mapping. In: Proceedings of the Special Interest Group on Management Of Data SIGMOD\u201912, pp.\u00a073\u201384 (2012)","DOI":"10.1145\/2213836.2213846"},{"key":"7268_CR40","doi-asserted-by":"crossref","unstructured":"Radwan, A., Popa, L., Stanoi, I.\u00a0R., Younis, A.: Top-k generation of integrated schemas based on directed and weighted correspondences. In: Proceedings of the Special Interest Group on Management Of Data SIGMOD\u201909, pp.\u00a0641\u2013654 (2009)","DOI":"10.1145\/1559845.1559913"},{"issue":"4","key":"7268_CR41","doi-asserted-by":"publisher","first-page":"334","DOI":"10.1007\/s007780100057","volume":"10","author":"E Rahm","year":"2001","unstructured":"Rahm, E., Bernstein, P.A.: A survey of approaches to automatic schema matching. J. Very Large Data Bases (VLDB) 10(4), 334\u2013350 (2001)","journal-title":"J. Very Large Data Bases (VLDB)"},{"key":"7268_CR42","unstructured":"Sarma, A.\u00a0D., Dong, X., Halevy, A.: Bootstrapping pay-as-you-go data integration systems. In: Proceedings of the Special Interest Group on Management Of Data SIGMOD\u201908, pp.\u00a0861\u2013874 (2008)"},{"key":"7268_CR43","doi-asserted-by":"crossref","unstructured":"Velegrakis, Y., Miller, R.\u00a0J., Hernandez, M.\u00a0A., Fagin, R.: Translating web data. In: Proceedings of the Very Large Data Bases VLDB\u201902, pp.\u00a0598\u2013609 (2002)","DOI":"10.1016\/B978-155860869-6\/50059-7"},{"key":"7268_CR44","unstructured":"Warren, R.\u00a0H., Tompa, F.: Multicolumn substring matching for database schema translation. In: Proceedings of the Very Large Data Bases VLDB\u201906, pp.\u00a0331\u2013342 (2006)"},{"key":"7268_CR45","doi-asserted-by":"crossref","unstructured":"Yakout, M., Ganjam, K., Chakrabarti, K., Chaudhuri, S.: Infogather: Entity augmentation and attribute discovery by holistic matching with web tables. In: Proceedings of the Special Interest Group on Management Of Data SIGMOD\u201912, pp.\u00a097\u2013108 (2012)","DOI":"10.1145\/2213836.2213848"},{"key":"7268_CR46","doi-asserted-by":"crossref","unstructured":"Zhang, M., Chakrabarti, K.: Infogather+: semantic matching and annotation of numeric and time-varying attributes in web tables. In: Proceedings of the Special Interest Group on Management Of Data SIGMOD\u201913, pp.\u00a0145\u2013156 (2013)","DOI":"10.1145\/2463676.2465276"},{"key":"7268_CR47","unstructured":"Zhang, C.\u00a0J., Zhao, Z., Chen, L., Jagadish, H.\u00a0V., Cao, C.\u00a0C.: Crowdmatcher: crowd-assisted schema matching. In: Proceedings of the International Conference on Management of Data, SIGMOD 2014, Snowbird, UT, USA, June 22\u201327, 2014, pp.\u00a0721\u2013724 (2014)"},{"issue":"1","key":"7268_CR48","doi-asserted-by":"publisher","first-page":"718","DOI":"10.14778\/1687627.1687709","volume":"2","author":"Yang Zhou","year":"2009","unstructured":"Zhou, Y., H, C., Yu, J.\u00a0X.: Graph clustering based on structural\/attribute similarities. In: Proceedings of the Very Large Data Bases VLDB\u201909, pp.\u00a0718\u2013729 (2009)","journal-title":"Proceedings of the VLDB Endowment"}],"container-title":["Distributed and Parallel Databases"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s10619-019-07268-9.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/article\/10.1007\/s10619-019-07268-9\/fulltext.html","content-type":"text\/html","content-version":"vor","intended-application":"text-mining"},{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/s10619-019-07268-9.pdf","content-type":"application\/pdf","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,9,17]],"date-time":"2022-09-17T18:40:15Z","timestamp":1663440015000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/s10619-019-07268-9"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2019,5,9]]},"references-count":48,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2020,3]]}},"alternative-id":["7268"],"URL":"https:\/\/doi.org\/10.1007\/s10619-019-07268-9","relation":{},"ISSN":["0926-8782","1573-7578"],"issn-type":[{"type":"print","value":"0926-8782"},{"type":"electronic","value":"1573-7578"}],"subject":[],"published":{"date-parts":[[2019,5,9]]},"assertion":[{"value":"9 May 2019","order":1,"name":"first_online","label":"First Online","group":{"name":"ArticleHistory","label":"Article History"}}]}}