{"id":"https://openalex.org/W4379135655","doi":"https://doi.org/10.1145/3584372.3588655","title":"Extremal Fitting Problems for Conjunctive Queries","display_name":"Extremal Fitting Problems for Conjunctive Queries","publication_year":2023,"publication_date":"2023-06-02","ids":{"openalex":"https://openalex.org/W4379135655","doi":"https://doi.org/10.1145/3584372.3588655"},"language":"en","primary_location":{"id":"doi:10.1145/3584372.3588655","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3584372.3588655","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3584372.3588655","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 42nd 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":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3584372.3588655","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5080220262","display_name":"Balder ten Cate","orcid":"https://orcid.org/0000-0002-2538-5846"},"institutions":[{"id":"https://openalex.org/I4210135670","display_name":"Amsterdam University of the Arts","ror":"https://ror.org/04dde1554","country_code":"NL","type":"education","lineage":["https://openalex.org/I4210135670"]},{"id":"https://openalex.org/I887064364","display_name":"University of Amsterdam","ror":"https://ror.org/04dkp9463","country_code":"NL","type":"education","lineage":["https://openalex.org/I887064364"]}],"countries":["NL"],"is_corresponding":true,"raw_author_name":"Balder Ten Cate","raw_affiliation_strings":["University of Amsterdam, Amsterdam, Netherlands"],"affiliations":[{"raw_affiliation_string":"University of Amsterdam, Amsterdam, Netherlands","institution_ids":["https://openalex.org/I4210135670","https://openalex.org/I887064364"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057975755","display_name":"V\u00edctor Dalmau","orcid":"https://orcid.org/0000-0002-9365-7372"},"institutions":[{"id":"https://openalex.org/I170486558","display_name":"Universitat Pompeu Fabra","ror":"https://ror.org/04n0g0b29","country_code":"ES","type":"education","lineage":["https://openalex.org/I170486558"]}],"countries":["ES"],"is_corresponding":false,"raw_author_name":"Victor Dalmau","raw_affiliation_strings":["Universitat Pompeu Fabra, Barcelona, Spain"],"affiliations":[{"raw_affiliation_string":"Universitat Pompeu Fabra, Barcelona, Spain","institution_ids":["https://openalex.org/I170486558"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073340449","display_name":"Maurice Funk","orcid":"https://orcid.org/0000-0003-1823-9370"},"institutions":[{"id":"https://openalex.org/I926574661","display_name":"Leipzig University","ror":"https://ror.org/03s7gtk40","country_code":"DE","type":"education","lineage":["https://openalex.org/I926574661"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Maurice Funk","raw_affiliation_strings":["Universit\u00e4t Leipzig, Leipzig, Germany"],"affiliations":[{"raw_affiliation_string":"Universit\u00e4t Leipzig, Leipzig, Germany","institution_ids":["https://openalex.org/I926574661"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5034616829","display_name":"Carsten Lutz","orcid":"https://orcid.org/0000-0002-8791-6702"},"institutions":[{"id":"https://openalex.org/I926574661","display_name":"Leipzig University","ror":"https://ror.org/03s7gtk40","country_code":"DE","type":"education","lineage":["https://openalex.org/I926574661"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Carsten Lutz","raw_affiliation_strings":["Universit\u00e4t Leipzig, Leipzig, Germany"],"affiliations":[{"raw_affiliation_string":"Universit\u00e4t Leipzig, Leipzig, Germany","institution_ids":["https://openalex.org/I926574661"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5080220262"],"corresponding_institution_ids":["https://openalex.org/I4210135670","https://openalex.org/I887064364"],"apc_list":null,"apc_paid":null,"fwci":0.3969,"has_fulltext":true,"cited_by_count":2,"citation_normalized_percentile":{"value":0.59936876,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"89","last_page":"98"},"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.9995999932289124,"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.9995999932289124,"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/T12072","display_name":"Machine Learning and Algorithms","score":0.9991000294685364,"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/T11106","display_name":"Data Management and Algorithms","score":0.9988999962806702,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/homomorphism","display_name":"Homomorphism","score":0.8562139272689819},{"id":"https://openalex.org/keywords/construct","display_name":"Construct (python library)","score":0.6145169138908386},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.6138834953308105},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5473338961601257},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5390822887420654},{"id":"https://openalex.org/keywords/class","display_name":"Class (philosophy)","score":0.5208250284194946},{"id":"https://openalex.org/keywords/tree","display_name":"Tree (set theory)","score":0.4733572006225586},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.42523667216300964},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.408059298992157},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.36578118801116943},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.30315810441970825},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2757008671760559},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.12654760479927063},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.12341687083244324},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.07691678404808044}],"concepts":[{"id":"https://openalex.org/C4042151","wikidata":"https://www.wikidata.org/wiki/Q215111","display_name":"Homomorphism","level":2,"score":0.8562139272689819},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.6145169138908386},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.6138834953308105},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5473338961601257},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5390822887420654},{"id":"https://openalex.org/C2777212361","wikidata":"https://www.wikidata.org/wiki/Q5127848","display_name":"Class (philosophy)","level":2,"score":0.5208250284194946},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.4733572006225586},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.42523667216300964},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.408059298992157},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.36578118801116943},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.30315810441970825},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2757008671760559},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.12654760479927063},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.12341687083244324},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.07691678404808044},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3584372.3588655","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3584372.3588655","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3584372.3588655","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 42nd ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"},{"id":"pmh:oai:dare.uva.nl:openaire_cris_publications/e1ae3470-3b5d-4be6-90bb-5907177977f4","is_oa":true,"landing_page_url":"https://handle.uba.uva.nl/personal/pure/en/publications/extremal-fitting-problems-for-conjunctive-queries(e1ae3470-3b5d-4be6-90bb-5907177977f4).html","pdf_url":"https://pure.uva.nl/ws/files/150360934/3584372.3588655.pdf","source":{"id":"https://openalex.org/S4306400088","display_name":"UvA-DARE (University of Amsterdam)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I887064364","host_organization_name":"University of Amsterdam","host_organization_lineage":["https://openalex.org/I887064364"],"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":"ten Cate, B, Dalmau, V, Funk, M & Lutz, C 2023, Extremal Fitting Problems for Conjunctive Queries. in PODS '23 : Proceedings of the 42nd ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems : June 18-23, 2023, Seattle, WA, USA. Association for Computing Machinery, Nw York, NY, pp. 89-98, 42nd ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems, PODS 2023, Seattle, United States, 18/06/23. https://doi.org/10.1145/3584372.3588655","raw_type":"info:eu-repo/semantics/publishedVersion"}],"best_oa_location":{"id":"doi:10.1145/3584372.3588655","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3584372.3588655","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3584372.3588655","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 42nd ACM SIGMOD-SIGACT-SIGAI Symposium on Principles of Database Systems","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1643949827","display_name":null,"funder_award_id":"AEI/10.13039/501100011033","funder_id":"https://openalex.org/F4320335598","funder_display_name":"Agencia Estatal de Investigaci\u00f3n"},{"id":"https://openalex.org/G2262748287","display_name":null,"funder_award_id":"501100011033","funder_id":"https://openalex.org/F4320335598","funder_display_name":"Agencia Estatal de Investigaci\u00f3n"},{"id":"https://openalex.org/G2601397997","display_name":null,"funder_award_id":"10.13039/501100011033","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"id":"https://openalex.org/G300979063","display_name":null,"funder_award_id":"10.13039/501100011033","funder_id":"https://openalex.org/F4320335598","funder_display_name":"Agencia Estatal de Investigaci\u00f3n"},{"id":"https://openalex.org/G3480869486","display_name":null,"funder_award_id":"13039","funder_id":"https://openalex.org/F4320335598","funder_display_name":"Agencia Estatal de Investigaci\u00f3n"},{"id":"https://openalex.org/G3681454997","display_name":null,"funder_award_id":"13039/501100011033","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"id":"https://openalex.org/G4042783231","display_name":null,"funder_award_id":"501100011033","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"id":"https://openalex.org/G4126322094","display_name":null,"funder_award_id":"01100011033","funder_id":"https://openalex.org/F4320335598","funder_display_name":"Agencia Estatal de Investigaci\u00f3n"},{"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"},{"id":"https://openalex.org/G5036817778","display_name":null,"funder_award_id":"European Union's Horizon 2020 research and innov","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"id":"https://openalex.org/G5080475149","display_name":null,"funder_award_id":"10.13039","funder_id":"https://openalex.org/F4320335598","funder_display_name":"Agencia Estatal de Investigaci\u00f3n"},{"id":"https://openalex.org/G5563793442","display_name":"Logic and Learning: an Algebra and Finite-Model-Theory Approach","funder_award_id":"101031081","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"id":"https://openalex.org/G661330594","display_name":null,"funder_award_id":"00110","funder_id":"https://openalex.org/F4320335598","funder_display_name":"Agencia Estatal de Investigaci\u00f3n"},{"id":"https://openalex.org/G6685425346","display_name":null,"funder_award_id":"0011033","funder_id":"https://openalex.org/F4320335598","funder_display_name":"Agencia Estatal de Investigaci\u00f3n"},{"id":"https://openalex.org/G6823456974","display_name":null,"funder_award_id":"AEI/10.13039/501100011033","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"id":"https://openalex.org/G7084143925","display_name":null,"funder_award_id":"AEI/10","funder_id":"https://openalex.org/F4320335598","funder_display_name":"Agencia Estatal de Investigaci\u00f3n"},{"id":"https://openalex.org/G7266728691","display_name":null,"funder_award_id":"13039/501100011033","funder_id":"https://openalex.org/F4320335598","funder_display_name":"Agencia Estatal de Investigaci\u00f3n"},{"id":"https://openalex.org/G7535663061","display_name":null,"funder_award_id":"AEI/10.","funder_id":"https://openalex.org/F4320335598","funder_display_name":"Agencia Estatal de Investigaci\u00f3n"},{"id":"https://openalex.org/G8260616629","display_name":null,"funder_award_id":"011033","funder_id":"https://openalex.org/F4320335598","funder_display_name":"Agencia Estatal de Investigaci\u00f3n"},{"id":"https://openalex.org/G8318064016","display_name":null,"funder_award_id":"Horizon","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"id":"https://openalex.org/G8633428685","display_name":null,"funder_award_id":"European Union's Horizon 2020 research and innovat","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"id":"https://openalex.org/G8638682022","display_name":null,"funder_award_id":"10.13039/50110001103","funder_id":"https://openalex.org/F4320335598","funder_display_name":"Agencia Estatal de Investigaci\u00f3n"},{"id":"https://openalex.org/G8684520763","display_name":null,"funder_award_id":"PID2019","funder_id":"https://openalex.org/F4320335598","funder_display_name":"Agencia Estatal de Investigaci\u00f3n"}],"funders":[{"id":"https://openalex.org/F4320320300","display_name":"European Commission","ror":"https://ror.org/00k4n6c32"},{"id":"https://openalex.org/F4320320879","display_name":"Deutsche Forschungsgemeinschaft","ror":"https://ror.org/018mejw64"},{"id":"https://openalex.org/F4320335598","display_name":"Agencia Estatal de Investigaci\u00f3n","ror":null}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4379135655.pdf","grobid_xml":"https://content.openalex.org/works/W4379135655.grobid-xml"},"referenced_works_count":30,"referenced_works":["https://openalex.org/W1602046686","https://openalex.org/W1966825814","https://openalex.org/W2009182243","https://openalex.org/W2065521247","https://openalex.org/W2077397644","https://openalex.org/W2098817244","https://openalex.org/W2101827111","https://openalex.org/W2153719564","https://openalex.org/W2165528704","https://openalex.org/W2242104095","https://openalex.org/W2275996142","https://openalex.org/W2338508724","https://openalex.org/W2380715658","https://openalex.org/W2470728525","https://openalex.org/W2609779791","https://openalex.org/W2763521382","https://openalex.org/W2963120669","https://openalex.org/W2965350305","https://openalex.org/W2976817320","https://openalex.org/W2997240502","https://openalex.org/W3007125878","https://openalex.org/W3013082216","https://openalex.org/W3049407862","https://openalex.org/W3081052466","https://openalex.org/W3093489371","https://openalex.org/W3099675727","https://openalex.org/W3129880345","https://openalex.org/W3207383046","https://openalex.org/W4292947496","https://openalex.org/W4320018910"],"related_works":["https://openalex.org/W2366107444","https://openalex.org/W4308159138","https://openalex.org/W4327811209","https://openalex.org/W1979798674","https://openalex.org/W3169947911","https://openalex.org/W3037616202","https://openalex.org/W2963079901","https://openalex.org/W390508480","https://openalex.org/W2294450783","https://openalex.org/W2242104095"],"abstract_inverted_index":{"The":[0],"fitting":[1,25,46,51,54,58,86,108],"problem":[2,9],"for":[3,115,118],"conjunctive":[4],"queries":[5],"(CQs)":[6],"is":[7,29],"the":[8,42,81,84,94,97,105,112,119],"to":[10,37],"construct":[11],"a":[12,16,24,45],"CQ":[13,26],"that":[14],"fits":[15],"given":[17],"set":[18],"of":[19,41,44,64,69,83,96,107,123],"labeled":[20],"data":[21],"examples.":[22],"When":[23],"exists,":[27],"it":[28],"in":[30,67],"general":[31],"not":[32],"unique.":[33],"This":[34],"leads":[35],"us":[36],"proposing":[38],"natural":[39],"refinements":[40,71],"notion":[43],"CQ,":[47,52,55],"such":[48],"as":[49],"most-general":[50],"most-specific":[53],"and":[56,76,100,103,117],"unique":[57],"CQ.":[59],"We":[60,91,110],"give":[61],"structural":[62],"characterizations":[63],"these":[65],"notions":[66],"terms":[68],"(suitable":[70],"of)":[72],"homomorphism":[73],"dualities,":[74],"frontiers,":[75],"direct":[77],"products,":[78],"which":[79],"enable":[80],"construction":[82],"refined":[85],"CQs":[87],"when":[88],"they":[89],"exist.":[90],"also":[92],"pinpoint":[93],"complexity":[95],"associated":[98],"existence":[99],"verification":[101],"problems,":[102],"determine":[104],"size":[106],"CQs.":[109,125],"study":[111],"same":[113],"problems":[114],"UCQs":[116],"more":[120],"restricted":[121],"class":[122],"tree":[124]},"counts_by_year":[{"year":2023,"cited_by_count":2}],"updated_date":"2026-04-13T07:58:08.660418","created_date":"2025-10-10T00:00:00"}
