Generating Succinct Descriptions of Database Schemata for Cost-Efficient Prompting of Large Language Models

Summary: Schemonic generates concise textual descriptions of relational schemata for cost-efficient LLM prompting by abbreviating and grouping similar schema elements. It casts schema compression as combinatorial optimization solved via ILP with heuristic warm-starts and preprocessing, yielding large token/cost savings while preserving text-to-SQL accuracy. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: 13561
Venue: VLDB
Year: 2024
Pagerank: 4.5909042e-05
Overall Rank: 8,054 | 44.03%
DOI: 10.14778/3681954.3682017

Incoming Non-self Citations Over Time

Authors

1. Immanuel Trummer

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
8,732	Unveiling Challenges for LLMs in Enterprise Data Engineering	2026	VLDB	4.4520434e-05
9,240	ThriftLLM: On Cost-Effective Selection of Large Language Models for Classification Queries	2025	VLDB	4.3648789e-05
10,112	SEFRQO: A Self-Evolving Fine-Tuned RAG-Based Query Optimizer	2026	SIGMOD	4.1905499e-05

Outgoing Citations (Sorted by Pagerank)

Showing 12 of 12 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
366	Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation	2024	VLDB	0.00025580097
516	Can Foundation Models Wrangle Your Data?	2023	VLDB	0.00021194444
565	NaLIR: An Interactive Natural Language Interface for Querying Relational Databases	2014	SIGMOD	0.00019945986
894	Data Compression Support in Databases	1994	VLDB	0.00015516667
1,415	Data Compression in Oracle	2003	VLDB	0.00012102269
1,443	Compressing SQL Workloads	2002	SIGMOD	0.00011944621
1,527	Generic Schema Matching, Ten Years Later	2011	VLDB	0.00011494604
2,348	RPT: Relational Pre-trained Transformer Is Almost All You Need towards Democratizing Data Preparation	2021	VLDB	8.9903659e-05
2,906	SPARTAN: A Model-Based Semantic Compression System for Massive Data Tables	2001	SIGMOD	7.9324961e-05
3,741	DeepSqueeze: Deep Semantic Compression for Tabular Data	2020	SIGMOD	6.7952067e-05
3,757	White-box Compression: Learning and Exploiting Compact Table Representations	2020	CIDR	6.7804933e-05
6,364	ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning	2022	SIGMOD	5.0895007e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
10,701	Evoschema: Towards Text-To-Sql Robustness Against Schema Evolution	2025	VLDB	4.1905499e-05
10,802	Horizon: Robust Checks for SQL Migration Using LLMs	2025	VLDB	4.1905499e-05
366	Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation	2024	VLDB	0.00025580097
5,448	SNAILS: Schema Naming Assessments for Improved LLM-Based SQL Inference	2025	SIGMOD	5.4980173e-05
10,462	ScaleLLM: A Technique for Scalable LLM-augmented Data Systems	2025	SIGMOD	4.1905499e-05
5,929	SchemaPile: A Large Collection of Relational Database Schemas	2024	SIGMOD	5.2635297e-05
10,210	SchemaRAG: A Schema-aware Retrieval-Augmented Generation Framework for Text-to-SQL	2026	SIGMOD	4.1905499e-05
2,948	Few-shot Text-to-SQL Translation using Structure and Content Prompt Learning	2023	SIGMOD	7.8301799e-05
4,908	Combining Small Language Models and Large Language Models for Zero-Shot NL2SQL	2024	VLDB	5.835596e-05
1,270	Schema Summarization	2006	VLDB	0.00012911456