{"id":"https://openalex.org/W3116393070","doi":"https://doi.org/10.1145/3452021.3458331","title":"Tractable Orders for Direct Access to Ranked Answers of Conjunctive Queries","display_name":"Tractable Orders for Direct Access to Ranked Answers of Conjunctive Queries","publication_year":2021,"publication_date":"2021-06-18","ids":{"openalex":"https://openalex.org/W3116393070","doi":"https://doi.org/10.1145/3452021.3458331","mag":"3116393070"},"language":"en","primary_location":{"id":"doi:10.1145/3452021.3458331","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3452021.3458331","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 40th ACM SIGMOD-SIGACT-SIGAI 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":null,"display_name":"Nofar Carmeli","orcid":null},"institutions":[{"id":"https://openalex.org/I174306211","display_name":"Technion \u2013 Israel Institute of Technology","ror":"https://ror.org/03qryx823","country_code":"IL","type":"education","lineage":["https://openalex.org/I174306211"]}],"countries":["IL"],"is_corresponding":true,"raw_author_name":"Nofar Carmeli","raw_affiliation_strings":["Technion, Haifa, Israel"],"affiliations":[{"raw_affiliation_string":"Technion, Haifa, Israel","institution_ids":["https://openalex.org/I174306211"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Nikolaos Tziavelis","orcid":null},"institutions":[{"id":"https://openalex.org/I12912129","display_name":"Northeastern University","ror":"https://ror.org/04t5xt781","country_code":"US","type":"education","lineage":["https://openalex.org/I12912129"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Nikolaos Tziavelis","raw_affiliation_strings":["Northeastern University, Boston, MA, USA"],"affiliations":[{"raw_affiliation_string":"Northeastern University, Boston, MA, USA","institution_ids":["https://openalex.org/I12912129"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Wolfgang Gatterbauer","orcid":null},"institutions":[{"id":"https://openalex.org/I12912129","display_name":"Northeastern University","ror":"https://ror.org/04t5xt781","country_code":"US","type":"education","lineage":["https://openalex.org/I12912129"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Wolfgang Gatterbauer","raw_affiliation_strings":["Northeastern University, Boston, MA, USA"],"affiliations":[{"raw_affiliation_string":"Northeastern University, Boston, MA, USA","institution_ids":["https://openalex.org/I12912129"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Benny Kimelfeld","orcid":null},"institutions":[{"id":"https://openalex.org/I174306211","display_name":"Technion \u2013 Israel Institute of Technology","ror":"https://ror.org/03qryx823","country_code":"IL","type":"education","lineage":["https://openalex.org/I174306211"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Benny Kimelfeld","raw_affiliation_strings":["Technion, Haifa, Israel"],"affiliations":[{"raw_affiliation_string":"Technion, Haifa, Israel","institution_ids":["https://openalex.org/I174306211"]}]},{"author_position":"last","author":{"id":null,"display_name":"Mirek Riedewald","orcid":null},"institutions":[{"id":"https://openalex.org/I12912129","display_name":"Northeastern University","ror":"https://ror.org/04t5xt781","country_code":"US","type":"education","lineage":["https://openalex.org/I12912129"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Mirek Riedewald","raw_affiliation_strings":["Northeastern University, Boston, MA, USA"],"affiliations":[{"raw_affiliation_string":"Northeastern University, Boston, MA, USA","institution_ids":["https://openalex.org/I12912129"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I174306211"],"apc_list":null,"apc_paid":null,"fwci":1.363,"has_fulltext":false,"cited_by_count":9,"citation_normalized_percentile":{"value":0.83092611,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"325","last_page":"341"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10720","display_name":"Complexity and Algorithms in Graphs","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/T10720","display_name":"Complexity and Algorithms in Graphs","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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.9987000226974487,"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/T12288","display_name":"Optimization and Search Problems","score":0.9987000226974487,"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.852400004863739},{"id":"https://openalex.org/keywords/decidability","display_name":"Decidability","score":0.678600013256073},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.6601999998092651},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.6072999835014343},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.5848000049591064},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.5210000276565552},{"id":"https://openalex.org/keywords/computational-complexity-theory","display_name":"Computational complexity theory","score":0.4674000144004822},{"id":"https://openalex.org/keywords/characterization","display_name":"Characterization (materials science)","score":0.4311999976634979}],"concepts":[{"id":"https://openalex.org/C159254197","wikidata":"https://www.wikidata.org/wiki/Q1144915","display_name":"Lexicographical order","level":2,"score":0.852400004863739},{"id":"https://openalex.org/C153269930","wikidata":"https://www.wikidata.org/wiki/Q430001","display_name":"Decidability","level":2,"score":0.678600013256073},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.6601999998092651},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.6072999835014343},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.5848000049591064},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.5210000276565552},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.4812000095844269},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.46950000524520874},{"id":"https://openalex.org/C179799912","wikidata":"https://www.wikidata.org/wiki/Q205084","display_name":"Computational complexity theory","level":2,"score":0.4674000144004822},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.45980000495910645},{"id":"https://openalex.org/C2780841128","wikidata":"https://www.wikidata.org/wiki/Q5073781","display_name":"Characterization (materials science)","level":2,"score":0.4311999976634979},{"id":"https://openalex.org/C34736171","wikidata":"https://www.wikidata.org/wiki/Q918333","display_name":"Preprocessor","level":2,"score":0.4162999987602234},{"id":"https://openalex.org/C311688","wikidata":"https://www.wikidata.org/wiki/Q2393193","display_name":"Time complexity","level":2,"score":0.39820000529289246},{"id":"https://openalex.org/C134026603","wikidata":"https://www.wikidata.org/wiki/Q846354","display_name":"P","level":3,"score":0.36079999804496765},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.35030001401901245},{"id":"https://openalex.org/C2776013622","wikidata":"https://www.wikidata.org/wiki/Q2103021","display_name":"Polynomial hierarchy","level":3,"score":0.3095000088214874},{"id":"https://openalex.org/C16221470","wikidata":"https://www.wikidata.org/wiki/Q846564","display_name":"Conjunctive normal form","level":2,"score":0.3003999888896942},{"id":"https://openalex.org/C2164484","wikidata":"https://www.wikidata.org/wiki/Q5170150","display_name":"Core (optical fiber)","level":2,"score":0.28130000829696655},{"id":"https://openalex.org/C115988155","wikidata":"https://www.wikidata.org/wiki/Q3262192","display_name":"Decision problem","level":2,"score":0.2676999866962433},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.262800008058548},{"id":"https://openalex.org/C156340839","wikidata":"https://www.wikidata.org/wiki/Q2704791","display_name":"Enumeration","level":2,"score":0.26190000772476196}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3452021.3458331","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3452021.3458331","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 40th ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G6024405640","display_name":null,"funder_award_id":"IIS-1956096,CAREER IIS-1762268","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320309327","display_name":"Google","ror":"https://ror.org/00njsd438"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W1607456165","https://openalex.org/W1986338919","https://openalex.org/W1989640573","https://openalex.org/W2004899468","https://openalex.org/W2040895999","https://openalex.org/W2066617111","https://openalex.org/W2098207812","https://openalex.org/W2111340560","https://openalex.org/W2146507303","https://openalex.org/W2150115297","https://openalex.org/W2256089709","https://openalex.org/W2423871547","https://openalex.org/W2536131596","https://openalex.org/W2779119908","https://openalex.org/W2942813159","https://openalex.org/W2963025941","https://openalex.org/W3006809958","https://openalex.org/W3037451332","https://openalex.org/W3137215238","https://openalex.org/W4230805768","https://openalex.org/W4251445346"],"related_works":[],"abstract_inverted_index":{"We":[0,68,94,164,198],"study":[1],"the":[2,13,26,41,44,50,54,83,98,103,126,133,147,161,174,190,204],"question":[3],"of":[4,43,52,82,85,105,137,173,176,185,193,203],"when":[5],"we":[6,47,131,157],"can":[7],"provide":[8],"logarithmic-time":[9],"direct":[10,62,114],"access":[11,63,115,139],"to":[12,16,97,123,140,159,189],"k-th":[14],"answer":[15,56,144,148],"a":[17,22,29,34,75,142,150,154,167,171,183],"Conjunctive":[18],"Query":[19],"(CQ)":[20],"with":[21,64,70],"specified":[23],"ordering":[24],"over":[25,195],"answers,":[27],"following":[28],"preprocessing":[30],"step":[31],"that":[32,58,112,156,201],"constructs":[33],"data":[35],"structure":[36],"in":[37,40,119,207],"time":[38],"quasilinear":[39],"size":[42],"database.":[45],"Specifically,":[46],"embark":[48],"on":[49],"challenge":[51,128],"identifying":[53],"tractable":[55,86,117],"orderings":[57,72,88,101],"allow":[59],"for":[60,89,110,170],"ranked":[61,113],"such":[65,211],"complexity":[66,80],"guarantees.":[67],"begin":[69],"lexicographic":[71,87],"and":[73,108,187],"give":[74],"decidable":[76],"characterization":[77],"(under":[78],"conventional":[79],"assumptions)":[81],"class":[84,175,209],"every":[90],"CQ":[91],"without":[92,179],"self-joins.":[93],"then":[95],"continue":[96],"more":[99,134],"general":[100],"by":[102,181],"sum":[104],"attribute":[106],"weights":[107],"show":[109],"it":[111],"is":[116],"only":[118,141],"trivial":[120],"cases.":[121],"Hence,":[122],"better":[124],"understand":[125],"computational":[127],"at":[129,149],"hand,":[130],"consider":[132],"modest":[135],"task":[136,155],"providing":[138],"single":[143],"(i.e.,":[145],"finding":[146],"given":[151],"position)":[152],"-":[153],"refer":[158],"as":[160],"selection":[162,194],"problem.":[163],"indeed":[165],"achieve":[166],"quasilinear-time":[168],"algorithm":[169],"subset":[172],"full":[177],"CQs":[178],"self-joins,":[180],"adopting":[182],"solution":[184],"Frederickson":[186],"Johnson":[188],"classic":[191],"problem":[192],"sorted":[196],"matrices.":[197],"further":[199],"prove":[200],"none":[202],"other":[205],"queries":[206],"this":[208],"admit":[210],"an":[212],"algorithm.":[213]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":5},{"year":2021,"cited_by_count":1}],"updated_date":"2026-04-11T08:14:18.477133","created_date":"2021-01-05T00:00:00"}