{"id":"https://openalex.org/W4323927094","doi":"https://doi.org/10.46298/lmcs-22(2:9)2026","title":"Direct Access for Answers to Conjunctive Queries with Aggregation","display_name":"Direct Access for Answers to Conjunctive Queries with Aggregation","publication_year":2026,"publication_date":"2026-04-21","ids":{"openalex":"https://openalex.org/W4323927094","doi":"https://doi.org/10.46298/lmcs-22(2:9)2026"},"language":"en","primary_location":{"id":"doi:10.46298/lmcs-22(2:9)2026","is_oa":true,"landing_page_url":"https://doi.org/10.46298/lmcs-22(2:9)2026","pdf_url":"https://lmcs.episciences.org/18067/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":"preprint","indexed_in":["arxiv","crossref","datacite","doaj"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://lmcs.episciences.org/18067/pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5019792601","display_name":"Idan Eldar","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Idan Eldar","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5030337488","display_name":"Nofar Carmeli","orcid":"https://orcid.org/0000-0003-0673-5510"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Nofar Carmeli","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5006706357","display_name":"Benny Kimelfeld","orcid":"https://orcid.org/0000-0002-7156-1572"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Benny Kimelfeld","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":1,"citation_normalized_percentile":{"value":0.00118577,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":"Volume 22, Issue 2","issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9987999796867371,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9987999796867371,"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/T11010","display_name":"Logic, Reasoning, and Knowledge","score":0.9980000257492065,"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.9972000122070312,"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/lexicographical-order","display_name":"Lexicographical order","score":0.9286059737205505},{"id":"https://openalex.org/keywords/semiring","display_name":"Semiring","score":0.8544595241546631},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.6176191568374634},{"id":"https://openalex.org/keywords/representation","display_name":"Representation (politics)","score":0.514670193195343},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.504212498664856},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.49143683910369873},{"id":"https://openalex.org/keywords/commutative-property","display_name":"Commutative property","score":0.4753971993923187},{"id":"https://openalex.org/keywords/logarithm","display_name":"Logarithm","score":0.45870766043663025},{"id":"https://openalex.org/keywords/order","display_name":"Order (exchange)","score":0.450281023979187},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.4319218397140503},{"id":"https://openalex.org/keywords/time-complexity","display_name":"Time complexity","score":0.4308852553367615},{"id":"https://openalex.org/keywords/feature","display_name":"Feature (linguistics)","score":0.42404791712760925},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4128812849521637},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.4044792056083679},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.3846432864665985},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.20998844504356384}],"concepts":[{"id":"https://openalex.org/C159254197","wikidata":"https://www.wikidata.org/wiki/Q1144915","display_name":"Lexicographical order","level":2,"score":0.9286059737205505},{"id":"https://openalex.org/C21696900","wikidata":"https://www.wikidata.org/wiki/Q1333055","display_name":"Semiring","level":2,"score":0.8544595241546631},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.6176191568374634},{"id":"https://openalex.org/C2776359362","wikidata":"https://www.wikidata.org/wiki/Q2145286","display_name":"Representation (politics)","level":3,"score":0.514670193195343},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.504212498664856},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.49143683910369873},{"id":"https://openalex.org/C183778304","wikidata":"https://www.wikidata.org/wiki/Q165474","display_name":"Commutative property","level":2,"score":0.4753971993923187},{"id":"https://openalex.org/C39927690","wikidata":"https://www.wikidata.org/wiki/Q11197","display_name":"Logarithm","level":2,"score":0.45870766043663025},{"id":"https://openalex.org/C182306322","wikidata":"https://www.wikidata.org/wiki/Q1779371","display_name":"Order (exchange)","level":2,"score":0.450281023979187},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.4319218397140503},{"id":"https://openalex.org/C311688","wikidata":"https://www.wikidata.org/wiki/Q2393193","display_name":"Time complexity","level":2,"score":0.4308852553367615},{"id":"https://openalex.org/C2776401178","wikidata":"https://www.wikidata.org/wiki/Q12050496","display_name":"Feature (linguistics)","level":2,"score":0.42404791712760925},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4128812849521637},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.4044792056083679},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.3846432864665985},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.20998844504356384},{"id":"https://openalex.org/C10138342","wikidata":"https://www.wikidata.org/wiki/Q43015","display_name":"Finance","level":1,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"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/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.0},{"id":"https://openalex.org/C94625758","wikidata":"https://www.wikidata.org/wiki/Q7163","display_name":"Politics","level":2,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"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/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C41895202","wikidata":"https://www.wikidata.org/wiki/Q8162","display_name":"Linguistics","level":1,"score":0.0}],"mesh":[],"locations_count":7,"locations":[{"id":"doi:10.46298/lmcs-22(2:9)2026","is_oa":true,"landing_page_url":"https://doi.org/10.46298/lmcs-22(2:9)2026","pdf_url":"https://lmcs.episciences.org/18067/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:arXiv.org:2303.05327","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2303.05327","pdf_url":"https://arxiv.org/pdf/2303.05327","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},{"id":"pmh:oai:arXiv.org:2303.05327","is_oa":true,"landing_page_url":"https://arxiv.org/abs/2303.05327","pdf_url":"https://arxiv.org/pdf/2303.05327","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"pmh:oai:HAL:lirmm-04617768v1","is_oa":true,"landing_page_url":"https://hal-lirmm.ccsd.cnrs.fr/lirmm-04617768","pdf_url":"https://hal-lirmm.ccsd.cnrs.fr/lirmm-04617768v1/file/Efficient_Direct_Access_to_Answers_of_Aggregate_Queries_Over_Databases___ICDT_2024_CR%20%281%29.pdf","source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"https://dastlab.github.io/edbticdt2024/","raw_type":"info:eu-repo/semantics/conferenceObject"},{"id":"pmh:oai:drops-oai.dagstuhl.de:19786","is_oa":true,"landing_page_url":"https://drops.dagstuhl.de/entities/document/10.4230/LIPIcs.ICDT.2024.4","pdf_url":"https://drops.dagstuhl.de/storage/00lipics/lipics-vol290-icdt2024/LIPIcs.ICDT.2024.4/LIPIcs.ICDT.2024.4.pdf","source":{"id":"https://openalex.org/S4377196569","display_name":"DROPS (Schloss Dagstuhl \u2013 Leibniz Center for Informatics)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I2799853480","host_organization_name":"Schloss Dagstuhl \u2013 Leibniz Center for Informatics","host_organization_lineage":["https://openalex.org/I2799853480"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"InProceedings"},{"id":"doi:10.48550/arxiv.2303.05327","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2303.05327","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"Preprint"},{"id":"doi:10.4230/lipics.icdt.2024.4","is_oa":true,"landing_page_url":"https://doi.org/10.4230/lipics.icdt.2024.4","pdf_url":null,"source":{"id":"https://openalex.org/S7407052059","display_name":"Dagstuhl Research Online Publication Server","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":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"ConferencePaper"}],"best_oa_location":{"id":"doi:10.46298/lmcs-22(2:9)2026","is_oa":true,"landing_page_url":"https://doi.org/10.46298/lmcs-22(2:9)2026","pdf_url":"https://lmcs.episciences.org/18067/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":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320320879","display_name":"Deutsche Forschungsgemeinschaft","ror":"https://ror.org/018mejw64"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4323927094.pdf","grobid_xml":"https://content.openalex.org/works/W4323927094.grobid-xml"},"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W185248416","https://openalex.org/W2367685979","https://openalex.org/W2365090138","https://openalex.org/W2371578151","https://openalex.org/W2862035520","https://openalex.org/W3039072955","https://openalex.org/W2091264056","https://openalex.org/W4323927094","https://openalex.org/W1968050632","https://openalex.org/W1565030492"],"abstract_inverted_index":{"We":[0,41,144,196,217],"study":[1,219],"the":[2,43,63,76,86,89,92,102,107,158,165,175,192,200,203,209,215,220,230,254],"fine-grained":[3,142],"complexity":[4,201],"of":[5,78,88,101,104,109,202,222,256],"conjunctive":[6,30],"queries":[7,48,121,125,240],"with":[8,36,248],"grouping":[9],"and":[10,111,122,211,244,259],"aggregation.":[11],"For":[12,124],"common":[13],"aggregate":[14,210,239],"functions":[15],"(e.g.,":[16],"min,":[17,257],"max,":[18,258],"count,":[19],"sum),":[20],"such":[21,47,252],"a":[22,33,37,54,67,98,116,184,246,262],"query":[23,31],"can":[24],"be":[25,81],"phrased":[26],"as":[27,183,234,253],"an":[28,249],"ordinary":[29],"over":[32,261],"database":[34],"annotated":[35,154,228],"suitable":[38],"commutative":[39,185],"semiring.":[40],"investigate":[42],"ability":[44],"to":[45,62,96,151,174],"evaluate":[46],"by":[49,66,229],"constructing":[50],"in":[51,85,141,164,214],"loglinear":[52,84],"time":[53],"data":[55,93],"structure":[56,94],"that":[57,146,157],"provides":[58],"logarithmic-time":[59],"direct":[60],"access":[61],"answers":[64,79],"ordered":[65],"given":[68],"lexicographic":[69,166],"order.":[70,167,216],"This":[71],"task":[72],"is":[73,130],"nontrivial":[74],"since":[75],"number":[77],"might":[80],"larger":[82],"than":[83],"size":[87],"input,":[90],"so":[91],"needs":[95],"provide":[97],"compact":[99],"representation":[100,182],"space":[103],"answers.":[105],"In":[106],"absence":[108],"aggregation":[110],"annotation,":[112],"past":[113,148,169],"research":[114],"established":[115],"sufficient":[117],"tractability":[118,194],"condition":[119,129],"on":[120],"orders.":[123],"without":[126],"self-joins,":[127],"this":[128,188],"not":[131,162,172],"just":[132],"sufficient,":[133],"but":[134,226],"also":[135,218],"necessary":[136],"(under":[137],"conventional":[138],"lower-bound":[139],"assumptions":[140],"complexity).":[143],"show":[145,198],"all":[147,224],"results":[149],"continue":[150],"hold":[152],"for":[153,187],"databases,":[155],"assuming":[156],"annotation":[159,212],"itself":[160],"does":[161],"participate":[163],"Yet,":[168],"algorithms":[170],"do":[171],"apply":[173],"count-distinct":[176,260],"aggregation,":[177,189],"which":[178],"has":[179],"no":[180],"efficient":[181],"semiring;":[186],"we":[190,207,237],"establish":[191],"corresponding":[193],"condition.":[195],"then":[197],"how":[199],"problem":[204],"changes":[205],"when":[206,236],"include":[208],"value":[213],"impact":[221],"having":[223,245],"relations":[225],"one":[227],"multiplicative":[231],"identity":[232],"(one),":[233],"happens":[235],"translate":[238],"into":[241],"semiring":[242,247],"annotations,":[243],"idempotent":[250],"addition,":[251],"case":[255],"logarithmic-size":[263],"domain.":[264]},"counts_by_year":[{"year":2024,"cited_by_count":1}],"updated_date":"2026-07-13T07:31:44.756512","created_date":"2023-03-12T00:00:00"}