{"id":"https://openalex.org/W2143102052","doi":"https://doi.org/10.1145/1989284.1989302","title":"Provenance for aggregate queries","display_name":"Provenance for aggregate queries","publication_year":2011,"publication_date":"2011-06-13","ids":{"openalex":"https://openalex.org/W2143102052","doi":"https://doi.org/10.1145/1989284.1989302","mag":"2143102052"},"language":"en","primary_location":{"id":"doi:10.1145/1989284.1989302","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1989284.1989302","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the thirtieth 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/A5021101350","display_name":"Yael Amsterdamer","orcid":"https://orcid.org/0000-0001-8032-9962"},"institutions":[{"id":"https://openalex.org/I16391192","display_name":"Tel Aviv University","ror":"https://ror.org/04mhzgx49","country_code":"IL","type":"education","lineage":["https://openalex.org/I16391192"]}],"countries":["IL"],"is_corresponding":true,"raw_author_name":"Yael Amsterdamer","raw_affiliation_strings":["Tel Aviv University, Tel Aviv, Israel","Tel Aviv University, Tel Aviv, Israel,"],"affiliations":[{"raw_affiliation_string":"Tel Aviv University, Tel Aviv, Israel","institution_ids":["https://openalex.org/I16391192"]},{"raw_affiliation_string":"Tel Aviv University, Tel Aviv, Israel,","institution_ids":["https://openalex.org/I16391192"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073835385","display_name":"Daniel Deutch","orcid":"https://orcid.org/0009-0001-0838-0162"},"institutions":[{"id":"https://openalex.org/I124227911","display_name":"Ben-Gurion University of the Negev","ror":"https://ror.org/05tkyf982","country_code":"IL","type":"education","lineage":["https://openalex.org/I124227911"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Daniel Deutch","raw_affiliation_strings":["Ben Gurion University, Beer Sheva, Israel"],"affiliations":[{"raw_affiliation_string":"Ben Gurion University, Beer Sheva, Israel","institution_ids":["https://openalex.org/I124227911"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5036528289","display_name":"Val Tannen","orcid":"https://orcid.org/0009-0008-6847-7274"},"institutions":[{"id":"https://openalex.org/I79576946","display_name":"University of Pennsylvania","ror":"https://ror.org/00b30xv10","country_code":"US","type":"education","lineage":["https://openalex.org/I79576946"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Val Tannen","raw_affiliation_strings":["University of Pennsylvania, Philadelphia, PA, USA"],"affiliations":[{"raw_affiliation_string":"University of Pennsylvania, Philadelphia, PA, USA","institution_ids":["https://openalex.org/I79576946"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5021101350"],"corresponding_institution_ids":["https://openalex.org/I16391192"],"apc_list":null,"apc_paid":null,"fwci":35.0438,"has_fulltext":false,"cited_by_count":161,"citation_normalized_percentile":{"value":0.99745944,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"153","last_page":"164"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9930999875068665,"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/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9923999905586243,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8080277442932129},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.7920106053352356},{"id":"https://openalex.org/keywords/provenance","display_name":"Provenance","score":0.7132514119148254},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.6321690678596497},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.5386431217193604},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.49501198530197144},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.4836250841617584},{"id":"https://openalex.org/keywords/encode","display_name":"ENCODE","score":0.44653430581092834},{"id":"https://openalex.org/keywords/semantics","display_name":"Semantics (computer science)","score":0.42241692543029785},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.4209508001804352},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.18105298280715942},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.10786592960357666}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8080277442932129},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.7920106053352356},{"id":"https://openalex.org/C2780049196","wikidata":"https://www.wikidata.org/wiki/Q23582628","display_name":"Provenance","level":2,"score":0.7132514119148254},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.6321690678596497},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5386431217193604},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.49501198530197144},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4836250841617584},{"id":"https://openalex.org/C66746571","wikidata":"https://www.wikidata.org/wiki/Q1134833","display_name":"ENCODE","level":3,"score":0.44653430581092834},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.42241692543029785},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4209508001804352},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.18105298280715942},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.10786592960357666},{"id":"https://openalex.org/C5900021","wikidata":"https://www.wikidata.org/wiki/Q163082","display_name":"Petrology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C127313418","wikidata":"https://www.wikidata.org/wiki/Q1069","display_name":"Geology","level":0,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","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/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","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/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1989284.1989302","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1989284.1989302","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the thirtieth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4","score":0.47999998927116394}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":45,"referenced_works":["https://openalex.org/W15647449","https://openalex.org/W39730884","https://openalex.org/W151136274","https://openalex.org/W1486664688","https://openalex.org/W1512100729","https://openalex.org/W1521472623","https://openalex.org/W1552694902","https://openalex.org/W1558832481","https://openalex.org/W1563464195","https://openalex.org/W1565971213","https://openalex.org/W1578937649","https://openalex.org/W1590740310","https://openalex.org/W1975612259","https://openalex.org/W1983178058","https://openalex.org/W1990391007","https://openalex.org/W1992609556","https://openalex.org/W2012670464","https://openalex.org/W2029038562","https://openalex.org/W2040228039","https://openalex.org/W2065538099","https://openalex.org/W2075422000","https://openalex.org/W2093149131","https://openalex.org/W2099477710","https://openalex.org/W2100197079","https://openalex.org/W2100444372","https://openalex.org/W2112582917","https://openalex.org/W2115479634","https://openalex.org/W2120342618","https://openalex.org/W2124026371","https://openalex.org/W2125332694","https://openalex.org/W2126880670","https://openalex.org/W2129666400","https://openalex.org/W2130872776","https://openalex.org/W2144622944","https://openalex.org/W2150616017","https://openalex.org/W2151322578","https://openalex.org/W2156399060","https://openalex.org/W2158915538","https://openalex.org/W2165766811","https://openalex.org/W2166709576","https://openalex.org/W2167541073","https://openalex.org/W2169600045","https://openalex.org/W2293299776","https://openalex.org/W2293935537","https://openalex.org/W6660736801"],"related_works":["https://openalex.org/W2354627941","https://openalex.org/W2468279273","https://openalex.org/W2347483153","https://openalex.org/W2353379336","https://openalex.org/W2379683085","https://openalex.org/W2363868702","https://openalex.org/W119841348","https://openalex.org/W2057416894","https://openalex.org/W4312445213","https://openalex.org/W316061934"],"abstract_inverted_index":{"We":[0,55,96],"study":[1,149],"in":[2,15,100,136],"this":[3,64,98,137],"paper":[4],"provenance":[5,35,77,90,157],"information":[6,12,78],"for":[7,26,105,119,153],"queries":[8,59,107,124,129,145,155],"with":[9,42,76,125,146],"aggregation.":[10],"Provenance":[11],"was":[13],"studied":[14],"the":[16,38,50,84,93,109,113,127,150],"context":[17],"of":[18,44],"various":[19],"query":[20,53],"languages":[21],"that":[22,57],"do":[23],"not":[24,79],"allow":[25],"aggregation,":[27],"and":[28,48,117,148],"recent":[29],"work":[30],"has":[31],"suggested":[32],"to":[33,91,132,143],"capture":[34],"by":[36],"annotating":[37],"different":[39],"database":[40],"tuples":[41,81],"elements":[43],"a":[45,70,101],"commutative":[46],"semiring":[47],"propagating":[49],"annotations":[51],"through":[52],"evaluation.":[54],"show":[56],"aggregate":[58],"pose":[60],"novel":[61],"challenges":[62],"rendering":[63],"approach":[65,99],"inapplicable.":[66],"Consequently,":[67],"we":[68,74,140],"propose":[69],"new":[71],"approach,":[72],"where":[73,108],"annotate":[75],"just":[80],"but":[82],"also":[83],"individual":[85],"values":[86,94],"within":[87],"tuples,":[88],"using":[89],"describe":[92],"computation.":[95],"realize":[97],"concrete":[102],"construction,":[103],"first":[104],"\"simple\"":[106],"aggregation":[110,142],"operator":[111],"is":[112],"last":[114],"one":[115],"applied,":[116],"then":[118],"arbitrary":[120],"(positive)":[121],"relational":[122],"algebra":[123],"aggregation;":[126],"latter":[128],"are":[130],"shown":[131],"be":[133],"more":[134],"challenging":[135],"context.":[138],"Finally,":[139],"use":[141],"encode":[144],"difference,":[147],"semantics":[151],"obtained":[152],"such":[154],"on":[156],"annotated":[158],"databases.":[159]},"counts_by_year":[{"year":2025,"cited_by_count":11},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":7},{"year":2022,"cited_by_count":15},{"year":2021,"cited_by_count":15},{"year":2020,"cited_by_count":12},{"year":2019,"cited_by_count":17},{"year":2018,"cited_by_count":10},{"year":2017,"cited_by_count":10},{"year":2016,"cited_by_count":8},{"year":2015,"cited_by_count":7},{"year":2014,"cited_by_count":11},{"year":2013,"cited_by_count":18},{"year":2012,"cited_by_count":11}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}