{"id":"https://openalex.org/W2016785840","doi":"https://doi.org/10.1145/1142351.1142357","title":"The complexity of data exchange","display_name":"The complexity of data exchange","publication_year":2006,"publication_date":"2006-06-26","ids":{"openalex":"https://openalex.org/W2016785840","doi":"https://doi.org/10.1145/1142351.1142357","mag":"2016785840"},"language":"en","primary_location":{"id":"doi:10.1145/1142351.1142357","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1142351.1142357","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-fifth 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/A5041825861","display_name":"Phokion G. Kolaitis","orcid":"https://orcid.org/0000-0002-8407-8563"},"institutions":[{"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"]},{"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"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Phokion G. Kolaitis","raw_affiliation_strings":["IBM Almaden","IBM Almaden,#TAB#"],"affiliations":[{"raw_affiliation_string":"IBM Almaden","institution_ids":["https://openalex.org/I4210085935"]},{"raw_affiliation_string":"IBM Almaden,#TAB#","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063334529","display_name":"Jonathan Panttaja","orcid":null},"institutions":[{"id":"https://openalex.org/I185103710","display_name":"University of California, Santa Cruz","ror":"https://ror.org/03s65by71","country_code":"US","type":"education","lineage":["https://openalex.org/I185103710"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jonathan Panttaja","raw_affiliation_strings":["UC Santa Cruz","[UC Santa Cruz.]"],"affiliations":[{"raw_affiliation_string":"UC Santa Cruz","institution_ids":["https://openalex.org/I185103710"]},{"raw_affiliation_string":"[UC Santa Cruz.]","institution_ids":["https://openalex.org/I185103710"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5026007789","display_name":"Wang-Chiew Tan","orcid":"https://orcid.org/0009-0003-4659-2291"},"institutions":[{"id":"https://openalex.org/I185103710","display_name":"University of California, Santa Cruz","ror":"https://ror.org/03s65by71","country_code":"US","type":"education","lineage":["https://openalex.org/I185103710"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Wang-Chiew Tan","raw_affiliation_strings":["UC Santa Cruz","[UC Santa Cruz.]"],"affiliations":[{"raw_affiliation_string":"UC Santa Cruz","institution_ids":["https://openalex.org/I185103710"]},{"raw_affiliation_string":"[UC Santa Cruz.]","institution_ids":["https://openalex.org/I185103710"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5041825861"],"corresponding_institution_ids":["https://openalex.org/I1341412227","https://openalex.org/I4210085935"],"apc_list":null,"apc_paid":null,"fwci":8.3737,"has_fulltext":false,"cited_by_count":89,"citation_normalized_percentile":{"value":0.9736006,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"30","last_page":"39"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9991999864578247,"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"}},"topics":[{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9991999864578247,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9988999962806702,"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/T11719","display_name":"Data Quality and Management","score":0.9426000118255615,"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/exptime","display_name":"EXPTIME","score":0.7538613080978394},{"id":"https://openalex.org/keywords/undecidable-problem","display_name":"Undecidable problem","score":0.7233094573020935},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.7191429138183594},{"id":"https://openalex.org/keywords/data-exchange","display_name":"Data exchange","score":0.6606760025024414},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6398121118545532},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.5362975001335144},{"id":"https://openalex.org/keywords/time-complexity","display_name":"Time complexity","score":0.49715831875801086},{"id":"https://openalex.org/keywords/star-schema","display_name":"Star schema","score":0.4165727198123932},{"id":"https://openalex.org/keywords/computational-complexity-theory","display_name":"Computational complexity theory","score":0.4027159810066223},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.3713926672935486},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.2979251742362976},{"id":"https://openalex.org/keywords/decidability","display_name":"Decidability","score":0.28245997428894043},{"id":"https://openalex.org/keywords/pspace","display_name":"PSPACE","score":0.18523770570755005},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.16725295782089233},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.1109614372253418},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.10467782616615295}],"concepts":[{"id":"https://openalex.org/C56049555","wikidata":"https://www.wikidata.org/wiki/Q1276570","display_name":"EXPTIME","level":4,"score":0.7538613080978394},{"id":"https://openalex.org/C192034797","wikidata":"https://www.wikidata.org/wiki/Q3502995","display_name":"Undecidable problem","level":3,"score":0.7233094573020935},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.7191429138183594},{"id":"https://openalex.org/C15845906","wikidata":"https://www.wikidata.org/wiki/Q1172338","display_name":"Data exchange","level":2,"score":0.6606760025024414},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6398121118545532},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.5362975001335144},{"id":"https://openalex.org/C311688","wikidata":"https://www.wikidata.org/wiki/Q2393193","display_name":"Time complexity","level":2,"score":0.49715831875801086},{"id":"https://openalex.org/C190703929","wikidata":"https://www.wikidata.org/wiki/Q1331138","display_name":"Star schema","level":4,"score":0.4165727198123932},{"id":"https://openalex.org/C179799912","wikidata":"https://www.wikidata.org/wiki/Q205084","display_name":"Computational complexity theory","level":2,"score":0.4027159810066223},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.3713926672935486},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.2979251742362976},{"id":"https://openalex.org/C153269930","wikidata":"https://www.wikidata.org/wiki/Q430001","display_name":"Decidability","level":2,"score":0.28245997428894043},{"id":"https://openalex.org/C197685441","wikidata":"https://www.wikidata.org/wiki/Q500716","display_name":"PSPACE","level":3,"score":0.18523770570755005},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.16725295782089233},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.1109614372253418},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.10467782616615295},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/1142351.1142357","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1142351.1142357","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-fifth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.84.2296","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.84.2296","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.soe.ucsc.edu/~wctan/papers/2006/de-complexity.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.896.1793","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.896.1793","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"https://www.researchgate.net/profile/Phokion_Kolaitis/publication/221559955_The_complexity_of_data_exchange/links/02e7e53c00ee012cf8000000.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","score":0.7300000190734863,"display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":30,"referenced_works":["https://openalex.org/W619004858","https://openalex.org/W1497287285","https://openalex.org/W1515520450","https://openalex.org/W1569370144","https://openalex.org/W1982556167","https://openalex.org/W1983867861","https://openalex.org/W1989783863","https://openalex.org/W1992673035","https://openalex.org/W1995628728","https://openalex.org/W2004459113","https://openalex.org/W2007628496","https://openalex.org/W2017372888","https://openalex.org/W2020228538","https://openalex.org/W2028222220","https://openalex.org/W2073446486","https://openalex.org/W2073845305","https://openalex.org/W2095395853","https://openalex.org/W2098297140","https://openalex.org/W2102729564","https://openalex.org/W2125822162","https://openalex.org/W2159668267","https://openalex.org/W2159686758","https://openalex.org/W2159793945","https://openalex.org/W2169602474","https://openalex.org/W2171094216","https://openalex.org/W3127823229","https://openalex.org/W4213165878","https://openalex.org/W4233942885","https://openalex.org/W6675529698","https://openalex.org/W6990023262"],"related_works":["https://openalex.org/W2955773350","https://openalex.org/W2965350305","https://openalex.org/W1506334254","https://openalex.org/W2220980829","https://openalex.org/W3102391036","https://openalex.org/W1854293932","https://openalex.org/W2087376388","https://openalex.org/W1519540095","https://openalex.org/W3136562811","https://openalex.org/W2327840326"],"abstract_inverted_index":{"Data":[0],"exchange":[1],"is":[2,52,81,92,129,152,179,192],"the":[3,34,45,59,62,89,97,100,112,118,121,148,160,173,176,182,185,198,202,222,226,236,239],"problem":[4,80,162,187,228,244],"of":[5,27,36,61,99,114,120,181,205,213,225,242],"transforming":[6],"data":[7,14,37,199,206],"structured":[8,15],"under":[9,16],"a":[10,17,22,28,40,49,54,104,156,193,218],"source":[11,50,174],"schema":[12,19,29,63,72,90,101,177,214],"into":[13],"target":[18,55],"in":[20,83,131,155,170],"such":[21],"way":[23],"that":[24,57,70,87,126,146,168],"all":[25],"constraints":[26,60,98],"mapping":[30,64,91,102,178],"are":[31],"satisfied.":[32],"At":[33],"heart":[35],"exchange,":[38],"lies":[39],"basic":[41],"decision":[42],"problem,":[43,123],"called":[44,108],"existence-of-solutions":[46,122,161,186,227],"problem:":[47],"given":[48],"instance,":[51,175],"there":[53,191],"instance":[56],"satisfies":[58],"at":[65],"hand?":[66],"Earlier":[67],"work":[68],"showed":[69],"for":[71,135,221,229],"mappings":[73,215],"specified":[74],"by":[75],"embedded":[76],"implicational":[77],"dependencies,":[78],"this":[79,136,243],"solvable":[82],"polynomial":[84],"time,":[85],"assuming":[86],"(1)":[88],"kept":[93],"fixed":[94],"and":[95,124,201,216],"(2)":[96],"satisfy":[103],"certain":[105],"structural":[106],"condition,":[107],"weak":[109,149],"acyclicity.We":[110],"investigate":[111],"effect":[113],"these":[115,230],"assumptions":[116],"on":[117,235],"complexity":[119,200,204,224,241],"show":[125,145,167],"each":[127],"one":[128],"indispensable":[130],"deriving":[132],"polynomial-time":[133],"algorithms":[134],"problem.":[137],"Specifically,":[138],"using":[139],"machinery":[140],"from":[141],"universal":[142],"algebra,":[143],"we":[144,209],"if":[147],"acyclicity":[150],"assumption":[151],"relaxed":[153],"even":[154],"minimal":[157],"way,":[158],"then":[159,184],"becomes":[163,188],"undecidable.":[164],"We":[165],"also":[166],"if,":[169],"addition":[171],"to":[172,247],"part":[180],"input,":[183],"EXPTIME-complete.":[189],"Thus,":[190],"provable":[194],"exponential":[195],"gap":[196],"between":[197],"combined":[203,223,240],"exchange.":[207],"Finally,":[208],"study":[210],"restricted":[211],"classes":[212],"develop":[217],"comprehensive":[219],"picture":[220],"restrictions.":[231],"In":[232],"particular,":[233],"depending":[234],"restriction":[237],"considered,":[238],"turns":[245],"out":[246],"be":[248],"either":[249],"EXPTIME-complete":[250],"or":[251],"coNP-complete.":[252]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":15},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":7},{"year":2016,"cited_by_count":5},{"year":2015,"cited_by_count":5},{"year":2014,"cited_by_count":7},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":3}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}