{"id":"https://openalex.org/W4408804635","doi":"https://doi.org/10.21203/rs.3.rs-5887690/v1","title":"Transformer-based Ranking Approaches for Keyword Queries over Relational Databases","display_name":"Transformer-based Ranking Approaches for Keyword Queries over Relational Databases","publication_year":2025,"publication_date":"2025-03-25","ids":{"openalex":"https://openalex.org/W4408804635","doi":"https://doi.org/10.21203/rs.3.rs-5887690/v1"},"language":"en","primary_location":{"id":"doi:10.21203/rs.3.rs-5887690/v1","doi":"https://doi.org/10.21203/rs.3.rs-5887690/v1","is_oa":true,"landing_page_url":"https://doi.org/10.21203/rs.3.rs-5887690/v1","pdf_url":null,"source":{"id":"https://openalex.org/S4306525896","display_name":"Research Square","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Research Square","raw_type":"posted-content"},"parent_works":[],"lineage":["https://openalex.org/W4408804635"],"child_works_count":0,"type":"preprint","is_traditional":true,"indexed_in":["arxiv","crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2503.18768","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5090654471","display_name":"Paulo Martins","orcid":"https://orcid.org/0000-0003-3995-2167","observed_orcids":["https://orcid.org/0000-0003-3995-2167"]},"institutions":[{"id":"https://openalex.org/I62885914","display_name":"Universidade Federal do Amazonas","ror":"https://ror.org/02263ky35","country_code":"BR","type":"education","lineage":["https://openalex.org/I62885914"]}],"countries":["BR"],"is_corresponding":true,"raw_author_name":"Paulo Martins","raw_affiliation_strings":["Federal University of Amazonas"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Federal University of Amazonas","institution_ids":["https://openalex.org/I62885914"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035221043","display_name":"Altigran Soares da Silva","orcid":"https://orcid.org/0000-0002-8992-495X","observed_orcids":["https://orcid.org/0000-0002-8992-495X"]},"institutions":[{"id":"https://openalex.org/I62885914","display_name":"Universidade Federal do Amazonas","ror":"https://ror.org/02263ky35","country_code":"BR","type":"education","lineage":["https://openalex.org/I62885914"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Altigran da Silva","raw_affiliation_strings":["Federal University of Amazonas"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Federal University of Amazonas","institution_ids":["https://openalex.org/I62885914"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112864967","display_name":"Johny Moreira","orcid":"https://orcid.org/0000-0003-4705-9766","observed_orcids":["https://orcid.org/0000-0003-4705-9766"]},"institutions":[{"id":"https://openalex.org/I62885914","display_name":"Universidade Federal do Amazonas","ror":"https://ror.org/02263ky35","country_code":"BR","type":"education","lineage":["https://openalex.org/I62885914"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Johny Moreira","raw_affiliation_strings":["Federal University of Amazonas"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Federal University of Amazonas","institution_ids":["https://openalex.org/I62885914"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5015781017","display_name":"Edleno Silva de Moura","orcid":"https://orcid.org/0000-0002-7860-9575","observed_orcids":["https://orcid.org/0000-0002-7860-9575"]},"institutions":[{"id":"https://openalex.org/I62885914","display_name":"Universidade Federal do Amazonas","ror":"https://ror.org/02263ky35","country_code":"BR","type":"education","lineage":["https://openalex.org/I62885914"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Edleno de Moura","raw_affiliation_strings":["Federal University of Amazonas"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Federal University of Amazonas","institution_ids":["https://openalex.org/I62885914"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5090654471"],"corresponding_institution_ids":["https://openalex.org/I62885914"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":2,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"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.8223000168800354,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.8223000168800354,"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"}},{"id":"https://openalex.org/T10286","display_name":"Information Retrieval and Search Behavior","score":0.12919999659061432,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.006500000134110451,"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/query-ambiguity","display_name":"query ambiguity","score":0.671999990940094},{"id":"https://openalex.org/keywords/data-augmentation","display_name":"data augmentation","score":0.9829999804496765},{"id":"https://openalex.org/keywords/lathe","display_name":"lathe","score":0.7350000143051147},{"id":"https://openalex.org/keywords/naive-users","display_name":"naive users","score":0.3619999885559082}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6713436841964722},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.662887692451477},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6317393779754639},{"id":"https://openalex.org/C189430467","wikidata":"https://www.wikidata.org/wiki/Q7293293","display_name":"Ranking (information retrieval)","level":2,"score":0.6269060969352722},{"id":"https://openalex.org/C2988412617","wikidata":"https://www.wikidata.org/wiki/Q7441656","display_name":"Keyword search","level":2,"score":0.5950709581375122},{"id":"https://openalex.org/C66322947","wikidata":"https://www.wikidata.org/wiki/Q11658","display_name":"Transformer","level":3,"score":0.5820398330688477},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.5471457839012146},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.38983458280563354},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.1206544041633606},{"id":"https://openalex.org/C165801399","wikidata":"https://www.wikidata.org/wiki/Q25428","display_name":"Voltage","level":2,"score":0.0},{"id":"https://openalex.org/C119599485","wikidata":"https://www.wikidata.org/wiki/Q43035","display_name":"Electrical engineering","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.21203/rs.3.rs-5887690/v1","doi":"https://doi.org/10.21203/rs.3.rs-5887690/v1","is_oa":true,"landing_page_url":"https://doi.org/10.21203/rs.3.rs-5887690/v1","pdf_url":null,"source":{"id":"https://openalex.org/S4306525896","display_name":"Research Square","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Research Square","raw_type":"posted-content"},{"id":"pmh:oai:arXiv.org:2503.18768","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2503.18768","pdf_url":"https://arxiv.org/pdf/2503.18768","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":"doi:10.48550/arxiv.2503.18768","doi":"https://doi.org/10.48550/arxiv.2503.18768","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2503.18768","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":false,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2503.18768","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/2503.18768","pdf_url":"https://arxiv.org/pdf/2503.18768","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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"},"sustainable_development_goals":[],"study_designs":[],"awards":[{"id":"https://openalex.org/G1193974739","display_name":null,"funder_award_id":"POSGRAD 2022","funder_id":"https://openalex.org/F4320322994","funder_display_name":"Funda\u00e7\u00e3o de Amparo \u00e0 Pesquisa do Estado do Amazonas"},{"id":"https://openalex.org/G1640538956","display_name":null,"funder_award_id":"406417/2022-9","funder_id":"https://openalex.org/F4320322025","funder_display_name":"Conselho Nacional de Desenvolvimento Cient\u00edfico e Tecnol\u00f3gico"},{"id":"https://openalex.org/G5268021672","display_name":null,"funder_award_id":"2024-7","funder_id":"https://openalex.org/F4320322025","funder_display_name":"Conselho Nacional de Desenvolvimento Cient\u00edfico e Tecnol\u00f3gico"},{"id":"https://openalex.org/G6756993358","display_name":null,"funder_award_id":"/2022-9","funder_id":"https://openalex.org/F4320322025","funder_display_name":"Conselho Nacional de Desenvolvimento Cient\u00edfico e Tecnol\u00f3gico"},{"id":"https://openalex.org/G6794220056","display_name":null,"funder_award_id":"307248/2019-4","funder_id":"https://openalex.org/F4320322025","funder_display_name":"Conselho Nacional de Desenvolvimento Cient\u00edfico e Tecnol\u00f3gico"}],"funders":[{"id":"https://openalex.org/F4320321091","display_name":"Coordena\u00e7\u00e3o de Aperfei\u00e7oamento de Pessoal de N\u00edvel Superior","ror":"https://ror.org/00x0ma614"},{"id":"https://openalex.org/F4320322025","display_name":"Conselho Nacional de Desenvolvimento Cient\u00edfico e Tecnol\u00f3gico","ror":"https://ror.org/03swz6y49"},{"id":"https://openalex.org/F4320322994","display_name":"Funda\u00e7\u00e3o de Amparo \u00e0 Pesquisa do Estado do Amazonas","ror":"https://ror.org/026d6ma13"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4408804635.pdf","grobid_xml":"https://content.openalex.org/works/W4408804635.grobid-xml"},"referenced_works_count":8,"referenced_works":["https://openalex.org/W2762513422","https://openalex.org/W2788550262","https://openalex.org/W2896457183","https://openalex.org/W4310390625","https://openalex.org/W4393335916","https://openalex.org/W4399175313","https://openalex.org/W4401042314","https://openalex.org/W4412886823"],"related_works":["https://openalex.org/W4225728335","https://openalex.org/W4385270389","https://openalex.org/W1547238240","https://openalex.org/W7120403891","https://openalex.org/W3006559676","https://openalex.org/W1976286090","https://openalex.org/W1992735711","https://openalex.org/W1989944922","https://openalex.org/W2148942721","https://openalex.org/W1493773376"],"abstract_inverted_index":{"Abstract":[0],"Relational":[1],"Keyword":[2],"Search":[3],"(R-KwS)":[4],"systems":[5],"enable":[6],"naive/informal":[7],"users":[8],"to":[9,38,72,121,154],"explore":[10],"and":[11,65,113,143,164],"retrieve":[12],"information":[13],"from":[14],"relational":[15,123],"databases":[16],"without":[17],"requiring":[18],"schema":[19,52],"knowledge":[20],"or":[21,41],"query-language":[22],"proficiency.":[23],"Although":[24],"numerous":[25],"R-KwS":[26],"methods":[27],"have":[28],"been":[29],"proposed,":[30],"most":[31,176],"still":[32,82],"focus":[33],"on":[34],"queries":[35,50,64,90,145],"referring":[36],"only":[37],"attribute":[39],"values":[40],"primarily":[42],"address":[43],"performance":[44],"enhancements,":[45],"providing":[46],"limited":[47],"support":[48],"for":[49,129],"referencing":[51],"elements.":[53],"We":[54],"previously":[55],"introduced":[56],"Lathe,":[57],"a":[58,98,105,118,135],"system":[59],"that":[60,103],"accommodates":[61],"schema-based":[62],"keyword":[63],"employs":[66],"an":[67],"eager":[68],"CJN":[69],"evaluation":[70,108],"strategy":[71,138],"filter":[73],"out":[74],"spurious":[75],"Candidate":[76],"Joining":[77],"Networks":[78],"(CJNs).":[79],"However,":[80],"Lathe":[81],"faces":[83],"challenges":[84],"in":[85,162,173],"accurately":[86],"ranking":[87,101,153],"CJNs":[88],"when":[89],"are":[91],"ambiguous.":[92],"In":[93],"this":[94],"work,":[95],"we":[96],"propose":[97],"new":[99],"transformer-based":[100,152],"approach":[102,172],"provides":[104],"more":[106,146],"context-aware":[107],"of":[109,169],"Query":[110],"Matches":[111],"(QMs)":[112],"CJNs.":[114],"Our":[115],"solution":[116],"introduces":[117],"linearization":[119],"process":[120],"convert":[122],"structures":[124],"into":[125],"textual":[126],"sequences":[127],"suitable":[128],"transformer":[130],"models.":[131],"It":[132],"also":[133],"includes":[134],"data":[136],"augmentation":[137],"aimed":[139],"at":[140],"handling":[141],"diverse":[142],"ambiguous":[144],"effectively.":[147],"Experimental":[148],"results,":[149],"comparing":[150],"our":[151,170],"Lathe\u2019s":[155],"original":[156],"Bayesian-based":[157],"method,":[158],"show":[159],"significant":[160],"improvements":[161],"recall":[163],"$R@k$,":[165],"demonstrating":[166],"the":[167,175],"effectiveness":[168],"neural":[171],"delivering":[174],"relevant":[177],"query":[178],"results.":[179]},"counts_by_year":[{"year":2025,"cited_by_count":2}],"updated_date":"2026-11-13T13:42:25.865203","created_date":"2025-03-25T00:00:00"}