{"id":"https://openalex.org/W7166688735","doi":"https://doi.org/10.48550/arxiv.2606.28387","title":"Schema-First Retrieval: Embedding Catalogs for Natural Language Analytics","display_name":"Schema-First Retrieval: Embedding Catalogs for Natural Language Analytics","publication_year":2026,"publication_date":"2026-06-23","ids":{"openalex":"https://openalex.org/W7166688735","doi":"https://doi.org/10.48550/arxiv.2606.28387"},"language":null,"primary_location":{"id":"doi:10.48550/arxiv.2606.28387","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2606.28387","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,"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"},"type":"preprint","indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.48550/arxiv.2606.28387","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5001097821","display_name":"Adarsh Agrawal","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Agrawal, Adarsh","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5139643263","display_name":"Shashank Indukuri","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Indukuri, Shashank","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":null,"has_fulltext":false,"cited_by_count":0,"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.4487999975681305,"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.4487999975681305,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.12729999423027039,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.0949999988079071,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6205000281333923},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.510200023651123},{"id":"https://openalex.org/keywords/natural-language-user-interface","display_name":"Natural language user interface","score":0.4867999851703644},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.453000009059906},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.438400000333786},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.4133000075817108},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.40119999647140503},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.3978999853134155},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.3878999948501587},{"id":"https://openalex.org/keywords/metadata","display_name":"Metadata","score":0.383899986743927}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8669000267982483},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6205000281333923},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.6089000105857849},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.510200023651123},{"id":"https://openalex.org/C174252522","wikidata":"https://www.wikidata.org/wiki/Q3816772","display_name":"Natural language user interface","level":3,"score":0.4867999851703644},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.453000009059906},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.438400000333786},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.4133000075817108},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.40119999647140503},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.3978999853134155},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.3878999948501587},{"id":"https://openalex.org/C93518851","wikidata":"https://www.wikidata.org/wiki/Q180160","display_name":"Metadata","level":2,"score":0.383899986743927},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.36739999055862427},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.36550000309944153},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.35409998893737793},{"id":"https://openalex.org/C88006597","wikidata":"https://www.wikidata.org/wiki/Q690117","display_name":"Disk formatting","level":2,"score":0.34610000252723694},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.3425000011920929},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.34209999442100525},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.33070001006126404},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.3301999866962433},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.3240000009536743},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.31299999356269836},{"id":"https://openalex.org/C96956885","wikidata":"https://www.wikidata.org/wiki/Q6138701","display_name":"RDF query language","level":5,"score":0.30559998750686646},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.3046000003814697},{"id":"https://openalex.org/C44291984","wikidata":"https://www.wikidata.org/wiki/Q1074173","display_name":"Question answering","level":2,"score":0.303600013256073},{"id":"https://openalex.org/C161156560","wikidata":"https://www.wikidata.org/wiki/Q1638872","display_name":"Document retrieval","level":2,"score":0.298799991607666},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.2946999967098236},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.28760001063346863},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.28700000047683716},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.2865999937057495},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.2815999984741211},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.2770000100135803},{"id":"https://openalex.org/C551230270","wikidata":"https://www.wikidata.org/wiki/Q4368942","display_name":"Data retrieval","level":2,"score":0.2700999975204468},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.26820001006126404},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.25690001249313354},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2563999891281128}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.48550/arxiv.2606.28387","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2606.28387","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,"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"}],"best_oa_location":{"id":"doi:10.48550/arxiv.2606.28387","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2606.28387","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,"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"},"sustainable_development_goals":[{"score":0.4792117178440094,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Enterprise":[0],"text-to-SQL":[1],"systems":[2],"often":[3],"fail":[4],"before":[5,91],"SQL":[6,92,146],"is":[7,120,162],"generated:":[8],"the":[9,12],"model":[10],"receives":[11],"wrong":[13],"schema":[14],"context.":[15],"Modern":[16],"warehouses":[17],"contain":[18],"thousands":[19],"of":[20],"tables,":[21,62],"abbreviated":[22],"columns,":[23,63],"informal":[24],"metrics,":[25,64],"hidden":[26],"join":[27],"conventions,":[28],"and":[29,66,87,104],"permission":[30],"boundaries":[31],"that":[32,47,159],"are":[33],"not":[34,171],"captured":[35],"by":[36],"raw":[37],"table":[38,102,124,133],"names.":[39],"We":[40],"introduce":[41],"Schema-First":[42,98],"Retrieval,":[43],"a":[44,153,163,172],"retrieval":[45,119,165],"layer":[46],"embeds":[48],"catalog":[49,60,160],"metadata":[50],"rather":[51],"than":[52],"warehouse":[53],"rows.":[54],"The":[55],"system":[56],"indexes":[57],"five":[58],"typed":[59],"objects,":[61],"relationships,":[65],"query":[67,74,130],"history,":[68],"using":[69],"object-specific":[70],"text":[71],"templates.":[72],"At":[73],"time,":[75],"it":[76],"combines":[77],"parallel":[78],"vector":[79],"search,":[80],"lineage":[81],"expansion,":[82],"cross-encoder":[83,105],"reranking,":[84],"workload":[85],"memory,":[86],"deterministic":[88],"access-control":[89],"gates":[90],"generation.":[93],"On":[94,126,139],"CRUSH4SQL":[95],"(1,534":[96],"questions),":[97,129,142],"Retrieval":[99],"reaches":[100],"96.4%":[101],"recall@20":[103],"reranking":[106],"adds":[107],"+11.1":[108],"points":[109,122],"at":[110,123],"column":[111],"recall@10;":[112],"against":[113],"an":[114],"equally-templated":[115],"BM25":[116],"baseline,":[117],"semantic":[118],"+32.8":[121],"recall@5.":[125],"SEDE":[127],"(857":[128],"history":[131],"raises":[132],"recall@5":[134],"from":[135,149],"52.1%":[136],"to":[137,151],"92.3%.":[138],"BIRD":[140],"(96":[141],"schema-first":[143],"context":[144],"reduces":[145],"execution":[147],"errors":[148],"15.6%":[150],"6.2%,":[152],"2.5x":[154],"reduction.":[155],"These":[156],"results":[157],"show":[158],"selection":[161],"first-class":[164],"problem":[166],"for":[167],"natural":[168],"language":[169],"analytics,":[170],"prompt":[173],"formatting":[174],"detail.":[175]},"counts_by_year":[],"updated_date":"2026-07-28T07:46:37.118299","created_date":"2026-07-01T00:00:00"}