{"id":"https://openalex.org/W4385706716","doi":"https://doi.org/10.46298/lmcs-19(3:11)2023","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":2023,"publication_date":"2023-08-09","ids":{"openalex":"https://openalex.org/W4385706716","doi":"https://doi.org/10.46298/lmcs-19(3:11)2023"},"language":"en","primary_location":{"id":"doi:10.46298/lmcs-19(3:11)2023","is_oa":true,"landing_page_url":"https://doi.org/10.46298/lmcs-19(3:11)2023","pdf_url":"https://lmcs.episciences.org/11711/pdf","source":{"id":"https://openalex.org/S114379355","display_name":"Logical Methods in Computer Science","issn_l":"1860-5974","issn":["1860-5974"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310313916","host_organization_name":"Logical Methods in Computer Science e.V.","host_organization_lineage":["https://openalex.org/P4310313916"],"host_organization_lineage_names":["Logical Methods in Computer Science e.V."],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Logical Methods in Computer Science","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://lmcs.episciences.org/11711/pdf","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/I202697423","display_name":"University of Zurich","ror":"https://ror.org/02crff812","country_code":"CH","type":"education","lineage":["https://openalex.org/I202697423"]}],"countries":["CH"],"is_corresponding":true,"raw_author_name":"Ahmet Kara","raw_affiliation_strings":["University of Zurich"],"affiliations":[{"raw_affiliation_string":"University of Zurich","institution_ids":["https://openalex.org/I202697423"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101550827","display_name":"Milo\u0161 Nikoli\u0107","orcid":"https://orcid.org/0000-0002-1548-6803"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Milos Nikolic","raw_affiliation_strings":[],"affiliations":[]},{"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/I202697423","display_name":"University of Zurich","ror":"https://ror.org/02crff812","country_code":"CH","type":"education","lineage":["https://openalex.org/I202697423"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Dan Olteanu","raw_affiliation_strings":["University of Zurich"],"affiliations":[{"raw_affiliation_string":"University of Zurich","institution_ids":["https://openalex.org/I202697423"]}]},{"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/I202697423","display_name":"University of Zurich","ror":"https://ror.org/02crff812","country_code":"CH","type":"education","lineage":["https://openalex.org/I202697423"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Haozhe Zhang","raw_affiliation_strings":["University of Zurich"],"affiliations":[{"raw_affiliation_string":"University of Zurich","institution_ids":["https://openalex.org/I202697423"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5083237962"],"corresponding_institution_ids":["https://openalex.org/I202697423"],"apc_list":null,"apc_paid":null,"fwci":0.6157,"has_fulltext":true,"cited_by_count":4,"citation_normalized_percentile":{"value":0.68811492,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"Volume 19, Issue 3","issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9993000030517578,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9993000030517578,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.998199999332428,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.996399998664856,"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/computer-science","display_name":"Computer science","score":0.7576184272766113},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.7549208402633667},{"id":"https://openalex.org/keywords/enumeration","display_name":"Enumeration","score":0.7438009977340698},{"id":"https://openalex.org/keywords/preprocessor","display_name":"Preprocessor","score":0.6503828763961792},{"id":"https://openalex.org/keywords/degree","display_name":"Degree (music)","score":0.6254845857620239},{"id":"https://openalex.org/keywords/on-the-fly","display_name":"On the fly","score":0.5147686004638672},{"id":"https://openalex.org/keywords/multiplication","display_name":"Multiplication (music)","score":0.49971723556518555},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.49443888664245605},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.43496328592300415},{"id":"https://openalex.org/keywords/matrix-multiplication","display_name":"Matrix multiplication","score":0.43446293473243713},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.41556739807128906},{"id":"https://openalex.org/keywords/execution-time","display_name":"Execution time","score":0.41291549801826477},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.40225154161453247},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.26456689834594727},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.2135722041130066},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.1829589605331421},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.108804851770401},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.08583632111549377},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.08335736393928528}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7576184272766113},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.7549208402633667},{"id":"https://openalex.org/C156340839","wikidata":"https://www.wikidata.org/wiki/Q2704791","display_name":"Enumeration","level":2,"score":0.7438009977340698},{"id":"https://openalex.org/C34736171","wikidata":"https://www.wikidata.org/wiki/Q918333","display_name":"Preprocessor","level":2,"score":0.6503828763961792},{"id":"https://openalex.org/C2775997480","wikidata":"https://www.wikidata.org/wiki/Q586277","display_name":"Degree (music)","level":2,"score":0.6254845857620239},{"id":"https://openalex.org/C2781020372","wikidata":"https://www.wikidata.org/wiki/Q533093","display_name":"On the fly","level":2,"score":0.5147686004638672},{"id":"https://openalex.org/C2780595030","wikidata":"https://www.wikidata.org/wiki/Q3860309","display_name":"Multiplication (music)","level":2,"score":0.49971723556518555},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.49443888664245605},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.43496328592300415},{"id":"https://openalex.org/C17349429","wikidata":"https://www.wikidata.org/wiki/Q1049914","display_name":"Matrix multiplication","level":3,"score":0.43446293473243713},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.41556739807128906},{"id":"https://openalex.org/C2989134064","wikidata":"https://www.wikidata.org/wiki/Q288510","display_name":"Execution time","level":2,"score":0.41291549801826477},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.40225154161453247},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.26456689834594727},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.2135722041130066},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.1829589605331421},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.108804851770401},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.08583632111549377},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.08335736393928528},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C24890656","wikidata":"https://www.wikidata.org/wiki/Q82811","display_name":"Acoustics","level":1,"score":0.0},{"id":"https://openalex.org/C84114770","wikidata":"https://www.wikidata.org/wiki/Q46344","display_name":"Quantum","level":2,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.46298/lmcs-19(3:11)2023","is_oa":true,"landing_page_url":"https://doi.org/10.46298/lmcs-19(3:11)2023","pdf_url":"https://lmcs.episciences.org/11711/pdf","source":{"id":"https://openalex.org/S114379355","display_name":"Logical Methods in Computer Science","issn_l":"1860-5974","issn":["1860-5974"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310313916","host_organization_name":"Logical Methods in Computer Science e.V.","host_organization_lineage":["https://openalex.org/P4310313916"],"host_organization_lineage_names":["Logical Methods in Computer Science e.V."],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Logical Methods in Computer Science","raw_type":"journal-article"},{"id":"pmh:oai:pure.ed.ac.uk:openaire/2096feb6-61ba-4ad2-8f46-6ff3d867f943","is_oa":true,"landing_page_url":"https://www.research.ed.ac.uk/en/publications/2096feb6-61ba-4ad2-8f46-6ff3d867f943","pdf_url":null,"source":{"id":"https://openalex.org/S4406922455","display_name":"Edinburgh Research Explorer","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Kara, A, Nikolic, M, Olteanu, D & Zhang, H 2023, 'Trade-offs in Static and Dynamic Evaluation of Hierarchical Queries', Logical Methods in Computer Science, vol. 19, no. 3, 11, pp. 1-50. https://doi.org/10.46298/lmcs-19(3:11)2023","raw_type":"info:eu-repo/semantics/publishedVersion"},{"id":"pmh:oai:doaj.org/article:f5b4bc587068492db41560436cb4951c","is_oa":true,"landing_page_url":"https://doaj.org/article/f5b4bc587068492db41560436cb4951c","pdf_url":null,"source":{"id":"https://openalex.org/S112646816","display_name":"SHILAP Revista de lepidopterolog\u00eda","issn_l":"0300-5267","issn":["0300-5267","2340-4078"],"is_oa":true,"is_in_doaj":true,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Logical Methods in Computer Science, Vol Volume 19, Issue 3 (2023)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.46298/lmcs-19(3:11)2023","is_oa":true,"landing_page_url":"https://doi.org/10.46298/lmcs-19(3:11)2023","pdf_url":"https://lmcs.episciences.org/11711/pdf","source":{"id":"https://openalex.org/S114379355","display_name":"Logical Methods in Computer Science","issn_l":"1860-5974","issn":["1860-5974"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310313916","host_organization_name":"Logical Methods in Computer Science e.V.","host_organization_lineage":["https://openalex.org/P4310313916"],"host_organization_lineage_names":["Logical Methods in Computer Science e.V."],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Logical Methods in Computer Science","raw_type":"journal-article"},"sustainable_development_goals":[{"score":0.4099999964237213,"id":"https://metadata.un.org/sdg/17","display_name":"Partnerships for the goals"}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":false},"content_urls":{"pdf":"https://content.openalex.org/works/W4385706716.pdf"},"referenced_works_count":53,"referenced_works":["https://openalex.org/W1501421205","https://openalex.org/W1573632260","https://openalex.org/W1579803282","https://openalex.org/W1591791236","https://openalex.org/W1983022219","https://openalex.org/W1985558974","https://openalex.org/W1985598531","https://openalex.org/W2014984050","https://openalex.org/W2030076354","https://openalex.org/W2035037959","https://openalex.org/W2050100848","https://openalex.org/W2100444372","https://openalex.org/W2113123266","https://openalex.org/W2146492010","https://openalex.org/W2148417962","https://openalex.org/W2151489984","https://openalex.org/W2153715991","https://openalex.org/W2163087774","https://openalex.org/W2234276446","https://openalex.org/W2240520130","https://openalex.org/W2284810639","https://openalex.org/W2536131596","https://openalex.org/W2585424461","https://openalex.org/W2592257482","https://openalex.org/W2612777267","https://openalex.org/W2754152545","https://openalex.org/W2790840297","https://openalex.org/W2795570227","https://openalex.org/W2798328745","https://openalex.org/W2798659310","https://openalex.org/W2799038541","https://openalex.org/W2799244129","https://openalex.org/W2883227679","https://openalex.org/W2888177241","https://openalex.org/W2912024553","https://openalex.org/W2924926522","https://openalex.org/W2952451116","https://openalex.org/W2963448011","https://openalex.org/W2963560792","https://openalex.org/W2963909740","https://openalex.org/W2964216306","https://openalex.org/W2967222032","https://openalex.org/W3021974799","https://openalex.org/W3024315987","https://openalex.org/W3028618047","https://openalex.org/W3098289868","https://openalex.org/W3100800630","https://openalex.org/W3148579566","https://openalex.org/W4239086110","https://openalex.org/W4300557927","https://openalex.org/W4400025441","https://openalex.org/W6604139919","https://openalex.org/W6966747855"],"related_works":["https://openalex.org/W2049131127","https://openalex.org/W2787606899","https://openalex.org/W2503642292","https://openalex.org/W2992106244","https://openalex.org/W2963461717","https://openalex.org/W3047787696","https://openalex.org/W3102774506","https://openalex.org/W3121092302","https://openalex.org/W2184961954","https://openalex.org/W2954931147"],"abstract_inverted_index":{"We":[0,107,143],"investigate":[1],"trade-offs":[2],"in":[3,69],"static":[4,17],"and":[5,31,72,76,82,115,160],"dynamic":[6,41],"evaluation":[7],"of":[8,67,121,135,150],"hierarchical":[9,141,151],"queries":[10],"with":[11],"arbitrary":[12],"free":[13],"variables.":[14],"In":[15,39],"the":[16,19,23,28,32,40,46,51,60,65,70,87,92,96,109,112,116,122,165],"setting,":[18,42],"trade-off":[20],"is":[21],"between":[22],"time":[24,47,159],"to":[25,35,49,59,102,140],"partially":[26,90],"compute":[27],"query":[29,52],"result":[30,53],"delay":[33,118,162],"needed":[34,48],"enumerate":[36],"its":[37],"tuples.":[38],"we":[43],"additionally":[44],"consider":[45],"update":[50,113,158],"under":[54],"single-tuple":[55],"inserts":[56],"or":[57],"deletes":[58],"database.":[61],"Our":[62],"approach":[63,131,154],"observes":[64],"degree":[66],"values":[68],"database":[71],"uses":[73],"different":[74],"computation":[75],"maintenance":[77],"strategies":[78],"for":[79,95,104,146],"high-degree":[80],"(heavy)":[81],"low-degree":[83],"(light)":[84],"values.":[85],"For":[86],"latter":[88],"it":[89,98],"computes":[91,99],"result,":[93],"while":[94],"former":[97],"enough":[100],"information":[101],"allow":[103],"on-the-fly":[105],"enumeration.":[106],"define":[108],"preprocessing":[110],"time,":[111,114],"enumeration":[117,161],"as":[119],"functions":[120],"light/heavy":[123],"threshold.":[124],"By":[125],"appropriately":[126],"choosing":[127],"this":[128],"threshold,":[129],"our":[130,153],"recovers":[132],"a":[133,147],"number":[134],"prior":[136],"results":[137],"when":[138],"restricted":[139,148],"queries.":[142],"show":[144],"that":[145],"class":[149],"queries,":[152],"achieves":[155],"worst-case":[156],"optimal":[157],"conditioned":[163],"on":[164],"Online":[166],"Matrix-Vector":[167],"Multiplication":[168],"Conjecture.":[169]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2022,"cited_by_count":1}],"updated_date":"2026-03-04T09:10:02.777135","created_date":"2025-10-10T00:00:00"}