{"id":"https://openalex.org/W3028618047","doi":"https://doi.org/10.1145/3375395.3387646","title":"Trade-offs in Static and Dynamic Evaluation of Hierarchical Queries","display_name":"Trade-offs in Static and Dynamic Evaluation of Hierarchical Queries","publication_year":2020,"publication_date":"2020-05-29","ids":{"openalex":"https://openalex.org/W3028618047","doi":"https://doi.org/10.1145/3375395.3387646","mag":"3028618047"},"language":"en","primary_location":{"id":"doi:10.1145/3375395.3387646","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3375395.3387646","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 39th ACM SIGMOD-SIGACT-SIGAI 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":"https://www.research.ed.ac.uk/en/publications/c4778623-30fc-4445-b150-b3a7f5a094e1","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5083237962","display_name":"Ahmet Kara","orcid":"https://orcid.org/0000-0002-1590-0023"},"institutions":[{"id":"https://openalex.org/I40120149","display_name":"University of Oxford","ror":"https://ror.org/052gg0110","country_code":"GB","type":"education","lineage":["https://openalex.org/I40120149"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Ahmet Kara","raw_affiliation_strings":["University of Oxford, Oxford, United Kingdom"],"affiliations":[{"raw_affiliation_string":"University of Oxford, Oxford, United Kingdom","institution_ids":["https://openalex.org/I40120149"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101550827","display_name":"Milo\u0161 Nikoli\u0107","orcid":"https://orcid.org/0000-0002-1548-6803"},"institutions":[{"id":"https://openalex.org/I98677209","display_name":"University of Edinburgh","ror":"https://ror.org/01nrxwf90","country_code":"GB","type":"education","lineage":["https://openalex.org/I98677209"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Milos Nikolic","raw_affiliation_strings":["University of Edinburgh, Edinburgh, United Kingdom"],"affiliations":[{"raw_affiliation_string":"University of Edinburgh, Edinburgh, United Kingdom","institution_ids":["https://openalex.org/I98677209"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035180920","display_name":"Dan Olteanu","orcid":"https://orcid.org/0000-0002-4682-7068"},"institutions":[{"id":"https://openalex.org/I40120149","display_name":"University of Oxford","ror":"https://ror.org/052gg0110","country_code":"GB","type":"education","lineage":["https://openalex.org/I40120149"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Dan Olteanu","raw_affiliation_strings":["University of Oxford, Oxford, United Kingdom"],"affiliations":[{"raw_affiliation_string":"University of Oxford, Oxford, United Kingdom","institution_ids":["https://openalex.org/I40120149"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100710295","display_name":"Haozhe Zhang","orcid":"https://orcid.org/0000-0002-0930-1980"},"institutions":[{"id":"https://openalex.org/I40120149","display_name":"University of Oxford","ror":"https://ror.org/052gg0110","country_code":"GB","type":"education","lineage":["https://openalex.org/I40120149"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Haozhe Zhang","raw_affiliation_strings":["University of Oxford, Oxford, United Kingdom"],"affiliations":[{"raw_affiliation_string":"University of Oxford, Oxford, United Kingdom","institution_ids":["https://openalex.org/I40120149"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5083237962"],"corresponding_institution_ids":["https://openalex.org/I40120149"],"apc_list":null,"apc_paid":null,"fwci":3.399,"has_fulltext":false,"cited_by_count":32,"citation_normalized_percentile":{"value":0.92656712,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"375","last_page":"392"},"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/T11106","display_name":"Data Management and Algorithms","score":0.9995999932289124,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9961000084877014,"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/tuple","display_name":"Tuple","score":0.917971670627594},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8444412350654602},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.34300339221954346},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.09740623831748962}],"concepts":[{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.917971670627594},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8444412350654602},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.34300339221954346},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.09740623831748962},{"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/3375395.3387646","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3375395.3387646","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 39th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"},{"id":"pmh:oai:pure.ed.ac.uk:openaire/c4778623-30fc-4445-b150-b3a7f5a094e1","is_oa":true,"landing_page_url":"https://www.research.ed.ac.uk/en/publications/c4778623-30fc-4445-b150-b3a7f5a094e1","pdf_url":null,"source":{"id":"https://openalex.org/S4306400321","display_name":"Edinburgh Research Explorer (University of Edinburgh)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I98677209","host_organization_name":"University of Edinburgh","host_organization_lineage":["https://openalex.org/I98677209"],"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":"Kara, A, Nikolic, M, Olteanu, D & Zhang, H 2020, Trade-offs in Static and Dynamic Evaluation of Hierarchical Queries. in Proceedings of the 39th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems. Association for Computing Machinery (ACM), pp. 375-392, 2020 ACM SIGMOD/PODS International Conference on Management of Data, Portland, Oregon, United States, 14/06/20. https://doi.org/10.1145/3375395.3387646","raw_type":"contributionToPeriodical"}],"best_oa_location":{"id":"pmh:oai:pure.ed.ac.uk:openaire/c4778623-30fc-4445-b150-b3a7f5a094e1","is_oa":true,"landing_page_url":"https://www.research.ed.ac.uk/en/publications/c4778623-30fc-4445-b150-b3a7f5a094e1","pdf_url":null,"source":{"id":"https://openalex.org/S4306400321","display_name":"Edinburgh Research Explorer (University of Edinburgh)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I98677209","host_organization_name":"University of Edinburgh","host_organization_lineage":["https://openalex.org/I98677209"],"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":"Kara, A, Nikolic, M, Olteanu, D & Zhang, H 2020, Trade-offs in Static and Dynamic Evaluation of Hierarchical Queries. in Proceedings of the 39th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems. Association for Computing Machinery (ACM), pp. 375-392, 2020 ACM SIGMOD/PODS International Conference on Management of Data, Portland, Oregon, United States, 14/06/20. https://doi.org/10.1145/3375395.3387646","raw_type":"contributionToPeriodical"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/17","display_name":"Partnerships for the goals","score":0.4300000071525574}],"awards":[{"id":"https://openalex.org/G2217633705","display_name":null,"funder_award_id":"682588","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"id":"https://openalex.org/G2249120993","display_name":null,"funder_award_id":"682588","funder_id":"https://openalex.org/F4320335254","funder_display_name":"Horizon 2020"},{"id":"https://openalex.org/G4956428346","display_name":null,"funder_award_id":"Horizon 2020 research and innovatio","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"}],"funders":[{"id":"https://openalex.org/F4320320300","display_name":"European Commission","ror":"https://ror.org/00k4n6c32"},{"id":"https://openalex.org/F4320335254","display_name":"Horizon 2020","ror":null}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":42,"referenced_works":["https://openalex.org/W52840101","https://openalex.org/W1579803282","https://openalex.org/W1983022219","https://openalex.org/W2030076354","https://openalex.org/W2050100848","https://openalex.org/W2100444372","https://openalex.org/W2113123266","https://openalex.org/W2151489984","https://openalex.org/W2153715991","https://openalex.org/W2163087774","https://openalex.org/W2169998163","https://openalex.org/W2234276446","https://openalex.org/W2240520130","https://openalex.org/W2284810639","https://openalex.org/W2338322935","https://openalex.org/W2536131596","https://openalex.org/W2585424461","https://openalex.org/W2592257482","https://openalex.org/W2612777267","https://openalex.org/W2624791742","https://openalex.org/W2758730793","https://openalex.org/W2779119908","https://openalex.org/W2795570227","https://openalex.org/W2798396931","https://openalex.org/W2798659310","https://openalex.org/W2799244129","https://openalex.org/W2883227679","https://openalex.org/W2924926522","https://openalex.org/W2949894935","https://openalex.org/W2954931147","https://openalex.org/W2963066364","https://openalex.org/W2963448011","https://openalex.org/W2963560792","https://openalex.org/W3021974799","https://openalex.org/W3100800630","https://openalex.org/W4239086110","https://openalex.org/W4299456444","https://openalex.org/W4300564796","https://openalex.org/W4301265558","https://openalex.org/W4400025441","https://openalex.org/W6640808458","https://openalex.org/W6744318443"],"related_works":["https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2143345456","https://openalex.org/W2143551613","https://openalex.org/W4245395944","https://openalex.org/W1979740464","https://openalex.org/W2138823233","https://openalex.org/W1789991335","https://openalex.org/W2562731034","https://openalex.org/W2101053337"],"abstract_inverted_index":{"We":[0],"investigate":[1],"trade-offs":[2],"in":[3],"static":[4,17],"and":[5,31],"dynamic":[6,41],"evaluation":[7],"of":[8],"hierarchical":[9],"queries":[10],"with":[11],"arbitrary":[12],"free":[13],"variables.":[14],"In":[15,39],"the":[16,19,23,28,32,40,46,51,60],"setting,":[18,42],"trade-off":[20],"is":[21],"between":[22],"time":[24,47],"to":[25,35,49,59],"partially":[26],"compute":[27],"query":[29,52],"result":[30,53],"delay":[33],"needed":[34,48],"enumerate":[36],"its":[37],"tuples.":[38],"we":[43],"additionally":[44],"consider":[45],"update":[50],"under":[54],"single-tuple":[55],"inserts":[56],"or":[57],"deletes":[58],"database.":[61]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":6},{"year":2023,"cited_by_count":8},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":6},{"year":2020,"cited_by_count":4}],"updated_date":"2026-04-22T08:38:42.863108","created_date":"2025-10-10T00:00:00"}