{"id":"https://openalex.org/W1998510030","doi":"https://doi.org/10.1145/1376916.1376936","title":"Answering aggregate queries in data exchange","display_name":"Answering aggregate queries in data exchange","publication_year":2008,"publication_date":"2008-06-09","ids":{"openalex":"https://openalex.org/W1998510030","doi":"https://doi.org/10.1145/1376916.1376936","mag":"1998510030"},"language":"en","primary_location":{"id":"doi:10.1145/1376916.1376936","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1376916.1376936","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-seventh ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://doi.org/10.1145/1376916.1376936","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5088568415","display_name":"Foto Afrati","orcid":null},"institutions":[{"id":"https://openalex.org/I174458059","display_name":"National Technical University of Athens","ror":"https://ror.org/03cx6bg69","country_code":"GR","type":"education","lineage":["https://openalex.org/I174458059"]}],"countries":["GR"],"is_corresponding":true,"raw_author_name":"Foto Afrati","raw_affiliation_strings":["National Technical University of Athens, Athens, Greece"],"affiliations":[{"raw_affiliation_string":"National Technical University of Athens, Athens, Greece","institution_ids":["https://openalex.org/I174458059"]}]},{"author_position":"last","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"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Phokion G. Kolaitis","raw_affiliation_strings":["IBM Almaden Research Center, San Jose, CA, USA"],"affiliations":[{"raw_affiliation_string":"IBM Almaden Research Center, San Jose, CA, USA","institution_ids":["https://openalex.org/I4210085935"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5088568415"],"corresponding_institution_ids":["https://openalex.org/I174458059"],"apc_list":null,"apc_paid":null,"fwci":15.9425,"has_fulltext":false,"cited_by_count":61,"citation_normalized_percentile":{"value":0.98983266,"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":"129","last_page":"138"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9994000196456909,"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.9994000196456909,"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.9983999729156494,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9976000189781189,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/possible-world","display_name":"Possible world","score":0.8084230422973633},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7648816108703613},{"id":"https://openalex.org/keywords/data-exchange","display_name":"Data exchange","score":0.6401803493499756},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.5427451729774475},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.5265498757362366},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4611324369907379},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.45437946915626526},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.44961071014404297},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.4467933475971222},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.43580421805381775},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.195295512676239},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.12016156315803528}],"concepts":[{"id":"https://openalex.org/C136172866","wikidata":"https://www.wikidata.org/wiki/Q1088088","display_name":"Possible world","level":2,"score":0.8084230422973633},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7648816108703613},{"id":"https://openalex.org/C15845906","wikidata":"https://www.wikidata.org/wiki/Q1172338","display_name":"Data exchange","level":2,"score":0.6401803493499756},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.5427451729774475},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.5265498757362366},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4611324369907379},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.45437946915626526},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.44961071014404297},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.4467933475971222},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.43580421805381775},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.195295512676239},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.12016156315803528},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1376916.1376936","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1376916.1376936","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-seventh ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems","raw_type":"proceedings-article"},{"id":"pmh:oai:dspace.lib.ntua.gr:123456789/32161","is_oa":true,"landing_page_url":"http://doi.org/10.1145/1376916.1376936","pdf_url":null,"source":{"id":"https://openalex.org/S4377196837","display_name":"DSpace - NTUA (National Technical University of Athens)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I174458059","host_organization_name":"National Technical University of Athens","host_organization_lineage":["https://openalex.org/I174458059"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Proceedings of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems","raw_type":"info:eu-repo/semantics/conferenceObject"}],"best_oa_location":{"id":"pmh:oai:dspace.lib.ntua.gr:123456789/32161","is_oa":true,"landing_page_url":"http://doi.org/10.1145/1376916.1376936","pdf_url":null,"source":{"id":"https://openalex.org/S4377196837","display_name":"DSpace - NTUA (National Technical University of Athens)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I174458059","host_organization_name":"National Technical University of Athens","host_organization_lineage":["https://openalex.org/I174458059"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Proceedings of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems","raw_type":"info:eu-repo/semantics/conferenceObject"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W49766897","https://openalex.org/W101493532","https://openalex.org/W1968327952","https://openalex.org/W2007628496","https://openalex.org/W2020228538","https://openalex.org/W2031810891","https://openalex.org/W2061712899","https://openalex.org/W2090958287","https://openalex.org/W2102729564","https://openalex.org/W2106039833","https://openalex.org/W2107115563","https://openalex.org/W2110993096","https://openalex.org/W2120436863","https://openalex.org/W2130133338","https://openalex.org/W2140957972","https://openalex.org/W2159668267","https://openalex.org/W2159686758","https://openalex.org/W2163009148","https://openalex.org/W2616737215","https://openalex.org/W2997050146","https://openalex.org/W4256119157","https://openalex.org/W6675529698"],"related_works":["https://openalex.org/W4391002889","https://openalex.org/W3133655068","https://openalex.org/W4248686654","https://openalex.org/W2241676222","https://openalex.org/W2497635663","https://openalex.org/W1981573068","https://openalex.org/W2485872624","https://openalex.org/W2018512069","https://openalex.org/W2120436863","https://openalex.org/W4233495035"],"abstract_inverted_index":{"Data":[0,69],"exchange,":[1,59,163,185],"also":[2,174,323],"known":[3],"as":[4,164,219],"data":[5,35,58,115,162,184,228,320],"translation,":[6],"has":[7,19,81,191],"been":[8,102],"extensively":[9],"investigated":[10],"in":[11,31,57,74,104,114,161,183,195,227,309,319],"recent":[12],"years.":[13],"One":[14],"main":[15,231],"direction":[16],"of":[17,27,34,48,54,64,87,91,98,107,111,119,122,127,130,137,147,155,199,210,214,222,252,261,275,285,305,312,315,328,351],"research":[18],"focused":[20],"on":[21],"the":[22,25,32,49,52,105,108,117,125,142,197,208,211,215,249,258,266,271,276,279,283,291,296,299,310,313,316,358],"semantics":[23,50,180,251,260],"and":[24,51,60,66,134,150,206,270],"complexity":[26,53],"answering":[28],"first-order":[29,112],"queries":[30,56,113],"context":[33,73],"exchange":[36,70],"between":[37],"relational":[38],"schemas.":[39],"In":[40],"this":[41],"paper,":[42],"we":[43,204,331],"initiate":[44],"a":[45,62,72,85,92,135,186,220,345,348,352],"systematic":[46],"investigation":[47],"aggregate":[55,263],"make":[61],"number":[63,346],"conceptual":[65],"technical":[67,232],"contributions.":[68],"is":[71,157,234,265,295,338,347],"which":[75,302],"incomplete":[76],"information":[77],"arises,":[78],"hence":[79],"one":[80,294],"to":[82,168,177,192,342],"cope":[83],"with":[84,357],"set":[86,118,126,136,198,209,221,284],"possible":[88,99,120,128,138,200,223,286,333,349],"worlds,":[89],"instead":[90,327],"single":[93],"database.":[94],"Three":[95],"different":[96],"sets":[97,149],"worlds":[100,121,129,139,224],"have":[101,178],"explored":[103],"study":[106,207,311],"certain":[109],"answers":[110],"exchange:":[116],"all":[123,131],"solutions,":[124,133],"universal":[132,217,317],"derived":[140],"from":[141],"CWA-solutions.":[143],"We":[144,322],"examine":[145],"each":[146,165],"these":[148,289],"point":[151],"out":[152],"that":[153,235,278,325],"none":[154],"them":[156],"suitable":[158],"for":[159,181,225,236,247,298],"aggregation":[160,182,226,255,355],"gives":[166],"rise":[167],"rather":[169],"trivial":[170],"semantics.":[171],"Our":[172,230],"analysis":[173],"reveals":[175],"that,":[176],"meaningful":[179],"strict":[187],"closed":[188],"world":[189],"assumption":[190],"be":[193],"adopted":[194],"selecting":[196],"worlds.":[201,287],"For":[202],"this,":[203],"introduce":[205],"endomorphic":[212],"images":[213],"canonical":[216],"solution":[218],"exchange.":[229,321],"result":[233],"schema":[237],"mappings":[238],"specified":[239],"by":[240],"source-to-target":[241],"tgds,":[242],"there":[243],"are":[244],"polynomial-time":[245],"algorithms":[246],"computing":[248],"range":[250,259,329],"every":[253],"scalar":[254,354],"query,":[256],"where":[257],"an":[262,339],"query":[264,280,356],"greatest":[267],"lower":[268],"bound":[269,274],"least":[272],"upper":[273],"values":[277],"takes":[281],"over":[282],"Among":[288],"algorithms,":[290],"more":[292],"sophisticated":[293],"algorithm":[297],"average":[300,359],"operator,":[301],"makes":[303],"use":[304],"concepts":[306],"originally":[307],"introduced":[308],"core":[314],"solutions":[318],"show":[324],"if,":[326],"semantics,":[330,335],"consider":[332],"answer":[334,350],"then":[336],"it":[337],"NP-complete":[340],"problem":[341],"tell":[343],"if":[344],"given":[353],"operator.":[360]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":3},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":4},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":8},{"year":2012,"cited_by_count":4}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2025-10-10T00:00:00"}