This research addresses schema retrieval for massive databases by proposing corpus-adaptive fine-tuning where queries are synthesized directly from the target schema. Benchmarking across Spider and BIRD shows that standard off-the-shelf text and code embedders fail to scale to enterprise-level table and column retrieval.
HOW THIS AFFECTS YOU
●
builderYou can improve text-to-SQL accuracy in large enterprise databases by fine-tuning embeddings on your specific schema.
●
researcherYou can utilize new granularity-aware benchmarks to evaluate retrieval performance at the table and column level.