{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,11,24]],"date-time":"2025-11-24T07:10:46Z","timestamp":1763968246284,"version":"3.41.0"},"reference-count":34,"publisher":"Association for Computing Machinery (ACM)","issue":"2","license":[{"start":{"date-parts":[[2017,4,28]],"date-time":"2017-04-28T00:00:00Z","timestamp":1493337600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"funder":[{"DOI":"10.13039\/100000001","name":"NSF","doi-asserted-by":"publisher","award":["IIS-1217869, IIS-1217869, IIS-1450560 and IIS-1524382"],"award-info":[{"award-number":["IIS-1217869, IIS-1217869, IIS-1450560 and IIS-1524382"]}],"id":[{"id":"10.13039\/100000001","id-type":"DOI","asserted-by":"publisher"}]},{"name":"UCSC"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["ACM Trans. Database Syst."],"published-print":{"date-parts":[[2017,6,30]]},"abstract":"<jats:p>\n            In recent years, data examples have been at the core of several different approaches to schema-mapping design. In particular, Gottlob and Senellart introduced a framework for schema-mapping discovery from a single data example, in which the derivation of a schema mapping is cast as an optimization problem. Our goal is to refine and study this framework in more depth. Among other results, we design a polynomial-time log(\n            <jats:italic>n<\/jats:italic>\n            )-approximation algorithm for computing optimal schema mappings from a given set of data examples (where\n            <jats:italic>n<\/jats:italic>\n            is the combined size of the given data examples) for a restricted class of schema mappings; moreover, we show that this approximation ratio cannot be improved. In addition to the complexity-theoretic results, we implemented the aforementioned log(\n            <jats:italic>n<\/jats:italic>\n            )-approximation algorithm and carried out an experimental evaluation in a real-world mapping scenario.\n          <\/jats:p>","DOI":"10.1145\/3044712","type":"journal-article","created":{"date-parts":[[2017,4,28]],"date-time":"2017-04-28T12:38:23Z","timestamp":1493383103000},"page":"1-41","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":15,"title":["Approximation Algorithms for Schema-Mapping Discovery from Data Examples"],"prefix":"10.1145","volume":"42","author":[{"given":"Balder Ten","family":"Cate","sequence":"first","affiliation":[{"name":"UC Santa Cruz, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Phokion G.","family":"Kolaitis","sequence":"additional","affiliation":[{"name":"UC Santa Cruz and IBM Research\u2014Almaden"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Kun","family":"Qian","sequence":"additional","affiliation":[{"name":"UC Santa Cruz, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Wang-Chiew","family":"Tan","sequence":"additional","affiliation":[{"name":"Recruit Institute of Technology and UC Santa Cruz, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2017,4,28]]},"reference":[{"key":"e_1_2_1_1_1","volume-title":"Muse: Mapping understanding and design by example. In ICDE. 10--19.","author":"Alexe Bogdan","year":"2008","unstructured":"Bogdan Alexe , Laura Chiticariu , Ren\u00e9e J. Miller , and Wang Chiew Tan . 2008 a. Muse: Mapping understanding and design by example. In ICDE. 10--19. Bogdan Alexe, Laura Chiticariu, Ren\u00e9e J. Miller, and Wang Chiew Tan. 2008a. Muse: Mapping understanding and design by example. In ICDE. 10--19."},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.14778\/1453856.1453886"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/2043652.2043656"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/1989323.1989338"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/1150334.1150336"},{"key":"e_1_2_1_6_1","doi-asserted-by":"publisher","DOI":"10.14778\/2850583.2850586"},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.5555\/1734953.1734954"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/1558334.1558341"},{"key":"e_1_2_1_9_1","unstructured":"A. Bonifati E. Q. Chang T. Ho V. S. Lakshmanan and R. Pottinger. 2005. HePToX: Marrying XML and heterogeneity in your P2P databases. In VLDB. 1267--1270.  A. Bonifati E. Q. Chang T. Ho V. S. Lakshmanan and R. Pottinger. 2005. HePToX: Marrying XML and heterogeneity in your P2P databases. In VLDB. 1267--1270."},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/2274576.2274596"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/2539032.2539035"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1007\/s13740-016-0057-4"},{"key":"e_1_2_1_13_1","volume-title":"AMW","author":"Cate Balder","year":"2015","unstructured":"Balder ten Cate , Phokion Kolaitis , Kun Qian , and Wang-Chiew Tan . 2015 . Approximation algorithms for schema-mapping discovery from data examples . In AMW 2015. Balder ten Cate, Phokion Kolaitis, Kun Qian, and Wang-Chiew Tan. 2015. Approximation algorithms for schema-mapping discovery from data examples. In AMW 2015."},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1287\/moor.4.3.233"},{"key":"e_1_2_1_15_1","doi-asserted-by":"crossref","unstructured":"Anish Das Sarma Aditya G. Parameswaran Hector Garcia-Molina and Jennifer Widom. 2010. Synthesizing view definitions from data. In ICDT. 89--103.  Anish Das Sarma Aditya G. Parameswaran Hector Garcia-Molina and Jennifer Widom. 2010. Synthesizing view definitions from data. In ICDT. 89--103.","DOI":"10.1145\/1804669.1804683"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.tcs.2004.10.033"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/1114244.1114249"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-642-10562-3_2"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/1667053.1667055"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1016\/0166-218X(92)90294-K"},{"key":"e_1_2_1_21_1","doi-asserted-by":"crossref","unstructured":"L. M. Haas M. A. Hern\u00e1ndez H. Ho L. Popa and M. Roth. 2005. Clio grows up: From research prototype to industrial tool. In ACM SIGMOD. 805--810.  L. M. Haas M. A. Hern\u00e1ndez H. Ho L. Popa and M. Roth. 2005. Clio grows up: From research prototype to industrial tool. In ACM SIGMOD. 805--810.","DOI":"10.1145\/1066157.1066252"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/800125.804034"},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-1-4684-2001-2_9"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1145\/1065167.1065176"},{"key":"e_1_2_1_25_1","unstructured":"KRDB. 2013a. OBDA Mappings from IMDB to Ontology. Retreived from https:\/\/raw.githubusercontent.com\/wiki\/ontop\/ontop\/attachments\/Example_MovieOntology\/movieontology.obda.  KRDB. 2013a. OBDA Mappings from IMDB to Ontology. Retreived from https:\/\/raw.githubusercontent.com\/wiki\/ontop\/ontop\/attachments\/Example_MovieOntology\/movieontology.obda."},{"key":"e_1_2_1_26_1","unstructured":"KRDB. 2013b. Ontop Project. Retrieved from https:\/\/github.com\/ontop\/ontop\/wiki\/Example_MovieOntology.  KRDB. 2013b. Ontop Project. Retrieved from https:\/\/github.com\/ontop\/ontop\/wiki\/Example_MovieOntology."},{"key":"e_1_2_1_27_1","unstructured":"KRDB. 2013c. SQL Script to Generate the Schema Only IMDB Database. Retrieved from https:\/\/raw.githubusercontent.com\/wiki\/ontop\/ontop\/attachments\/Example_MovieOntology\/imdbpg.sql.  KRDB. 2013c. SQL Script to Generate the Schema Only IMDB Database. Retrieved from https:\/\/raw.githubusercontent.com\/wiki\/ontop\/ontop\/attachments\/Example_MovieOntology\/imdbpg.sql."},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/543613.543644"},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1016\/0022-0000(89)90002-0"},{"volume-title":"Proceedings of the International Conference on Very Large Data Bases (VLDB). 77--88","author":"Miller R. J.","key":"e_1_2_1_30_1","unstructured":"R. J. Miller , L. M. Haas , and M. A. Hern\u00e1ndez . 2000. Schema mapping as query discovery . In Proceedings of the International Conference on Very Large Data Bases (VLDB). 77--88 . R. J. Miller, L. M. Haas, and M. A. Hern\u00e1ndez. 2000. Schema mapping as query discovery. In Proceedings of the International Conference on Very Large Data Bases (VLDB). 77--88."},{"key":"e_1_2_1_31_1","doi-asserted-by":"publisher","DOI":"10.1145\/1559845.1559873"},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.1145\/62212.62233"},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.1145\/258533.258641"},{"key":"e_1_2_1_34_1","doi-asserted-by":"publisher","DOI":"10.1145\/375663.375729"}],"container-title":["ACM Transactions on Database Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3044712","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3044712","content-type":"application\/pdf","content-version":"vor","intended-application":"syndication"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3044712","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T19:07:27Z","timestamp":1750273647000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3044712"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2017,4,28]]},"references-count":34,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2017,6,30]]}},"alternative-id":["10.1145\/3044712"],"URL":"https:\/\/doi.org\/10.1145\/3044712","relation":{},"ISSN":["0362-5915","1557-4644"],"issn-type":[{"type":"print","value":"0362-5915"},{"type":"electronic","value":"1557-4644"}],"subject":[],"published":{"date-parts":[[2017,4,28]]},"assertion":[{"value":"2015-12-01","order":0,"name":"received","label":"Received","group":{"name":"publication_history","label":"Publication History"}},{"value":"2017-01-01","order":1,"name":"accepted","label":"Accepted","group":{"name":"publication_history","label":"Publication History"}},{"value":"2017-04-28","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}