{"id":"https://openalex.org/W2098213459","doi":"https://doi.org/10.1145/1055558.1055592","title":"Locally consistent transformations and query answering in data exchange","display_name":"Locally consistent transformations and query answering in data exchange","publication_year":2004,"publication_date":"2004-06-14","ids":{"openalex":"https://openalex.org/W2098213459","doi":"https://doi.org/10.1145/1055558.1055592","mag":"2098213459"},"language":"en","primary_location":{"id":"doi:10.1145/1055558.1055592","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1055558.1055592","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the twenty-third ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5011691423","display_name":"Marcelo Arenas","orcid":"https://orcid.org/0000-0003-3678-1868"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Marcelo Arenas","raw_affiliation_strings":["University of Toronto"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Toronto","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5051683347","display_name":"Pablo Barcel\u00f3","orcid":"https://orcid.org/0000-0003-2293-2653"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Pablo Barcel\u00f3","raw_affiliation_strings":["University of Toronto"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Toronto","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027117465","display_name":"Ronald Fagin","orcid":"https://orcid.org/0000-0002-7374-0347"},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210085935","display_name":"IBM Research - Almaden","ror":"https://ror.org/005w8dd04","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210085935","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ronald Fagin","raw_affiliation_strings":["IBM Almaden Research Center","IBM Almaden Research Center,#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden Research Center,#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5069883356","display_name":"Leonid Libkin","orcid":"https://orcid.org/0000-0002-6698-2735"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Leonid Libkin","raw_affiliation_strings":["University of Toronto"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Toronto","institution_ids":["https://openalex.org/I185261750"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.9924,"has_fulltext":false,"cited_by_count":92,"citation_normalized_percentile":{"value":0.94257616,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"229","last_page":"240"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9936000108718872,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7983157634735107},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.6229090094566345},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.5897274017333984},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5776793956756592},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.5579407811164856},{"id":"https://openalex.org/keywords/data-exchange","display_name":"Data exchange","score":0.5465039014816284},{"id":"https://openalex.org/keywords/rewriting","display_name":"Rewriting","score":0.5154198408126831},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.49754980206489563},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.45387357473373413},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.4519176781177521},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.39886870980262756},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.39528509974479675},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2618424892425537},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.18321016430854797},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.1306818723678589}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7983157634735107},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.6229090094566345},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.5897274017333984},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5776793956756592},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.5579407811164856},{"id":"https://openalex.org/C15845906","wikidata":"https://www.wikidata.org/wiki/Q1172338","display_name":"Data exchange","level":2,"score":0.5465039014816284},{"id":"https://openalex.org/C154690210","wikidata":"https://www.wikidata.org/wiki/Q1668499","display_name":"Rewriting","level":2,"score":0.5154198408126831},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.49754980206489563},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.45387357473373413},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.4519176781177521},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.39886870980262756},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.39528509974479675},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2618424892425537},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.18321016430854797},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.1306818723678589},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1055558.1055592","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1055558.1055592","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the twenty-third ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.4.9975","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.4.9975","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.toronto.edu/~libkin/papers/pods04.ps.gz","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320334593","display_name":"Natural Sciences and Engineering Research Council of Canada","ror":"https://ror.org/01h531d29"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":39,"referenced_works":["https://openalex.org/W187851124","https://openalex.org/W1482193060","https://openalex.org/W1517150411","https://openalex.org/W1542543925","https://openalex.org/W1558832481","https://openalex.org/W1565106395","https://openalex.org/W1910521678","https://openalex.org/W1966294080","https://openalex.org/W1975733288","https://openalex.org/W1975880448","https://openalex.org/W1985581502","https://openalex.org/W1986832527","https://openalex.org/W1990391007","https://openalex.org/W1992673035","https://openalex.org/W1993953362","https://openalex.org/W2013208146","https://openalex.org/W2016289312","https://openalex.org/W2017740323","https://openalex.org/W2028222220","https://openalex.org/W2045916776","https://openalex.org/W2069658123","https://openalex.org/W2071163366","https://openalex.org/W2073279331","https://openalex.org/W2085536555","https://openalex.org/W2102729564","https://openalex.org/W2152035036","https://openalex.org/W2159686758","https://openalex.org/W2160983447","https://openalex.org/W2171094216","https://openalex.org/W2479567345","https://openalex.org/W2492526546","https://openalex.org/W2501499209","https://openalex.org/W2917990073","https://openalex.org/W4233917839","https://openalex.org/W4252098605","https://openalex.org/W6632533193","https://openalex.org/W6639966916","https://openalex.org/W6654467116","https://openalex.org/W6672119266"],"related_works":["https://openalex.org/W2572349046","https://openalex.org/W1505212787","https://openalex.org/W4226251578","https://openalex.org/W2114334214","https://openalex.org/W2127795772","https://openalex.org/W1981131819","https://openalex.org/W3047081115","https://openalex.org/W2949144621","https://openalex.org/W5304494","https://openalex.org/W3107700780"],"abstract_inverted_index":{"Data":[0],"exchange":[1,40,61,123],"is":[2,84,93,118,187],"the":[3,35,38,68,81,88,116,144,148,171],"problem":[4],"of":[5,17,37,48,147,202,214],"taking":[6],"data":[7,39,60,122],"structured":[8],"under":[9],"a":[10,18,22,65,76,98,101,105,163,178,185],"source":[11,23,102,172],"schema":[12,70],"and":[13,54,134,207,209],"creating":[14],"an":[15,200],"instance":[16,103],"target":[19,31,69,78,109,158],"schema.":[20],"Given":[21],"instance,":[24,79],"there":[25,96],"may":[26],"be":[27,112],"many":[28,121,140],"solutions":[29,133],"-":[30],"instances":[32],"that":[33,83,115,125,139,156,181,192],"satisfy":[34],"constraints":[36],"problem.":[41],"Previous":[42],"work":[43],"has":[44],"identified":[45],"two":[46,211],"classes":[47],"desirable":[49],"solutions:":[50],"canonical":[51,131],"universal":[52,132],"solutions,":[53],"their":[55],"cores.":[56,135],"Query":[57],"answering":[58],"in":[59,170],"amounts":[62],"to":[63,71,130],"rewriting":[64],"query":[66,73,159,186,215],"over":[67,75,107,161],"another":[72],"that,":[74],"materialized":[77],"gives":[80,176],"result":[82],"semantically":[85],"consistent":[86],"with":[87,205],"source.":[89],"A":[90],"basic":[91],"question":[92],"then":[94],"whether":[95,184],"exists":[97],"transformation":[99,164],"sending":[100],"into":[104],"solution":[106],"which":[108],"queries":[110],"can":[111],"answered.We":[113],"show":[114,155,191],"answer":[117],"negative":[119],"for":[120,199,210],"transformations":[124,142],"have":[126],"structural":[127],"properties":[128],"similar":[129],"Namely,":[136],"we":[137,153],"prove":[138],"such":[141,162],"preserve":[143],"local":[145],"structure":[146],"data.":[149],"Using":[150],"this":[151],"notion,":[152],"further":[154],"every":[157],"rewritable":[160],"cannot":[165],"distinguish":[166],"tuples":[167],"whose":[168],"neighborhoods":[169],"are":[173,195],"similar.":[174],"This":[175],"us":[177],"first":[179],"tool":[180],"helps":[182],"check":[183],"rewritable,":[188],"We":[189],"also":[190],"these":[193],"results":[194],"robust:":[196],"they":[197],"hold":[198],"extension":[201],"relational":[203],"calculus":[204],"grouping":[206],"aggregates,":[208],"different":[212],"semantics":[213],"answering.":[216]},"counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":4},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":5},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":8},{"year":2012,"cited_by_count":11}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}