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: 13560
Venue: VLDB
Year: 2024
Pagerank: 4.5953106e-05
Overall Rank: 8,052 | 43.99%
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,736	Unveiling Challenges for LLMs in Enterprise Data Engineering	2026	VLDB	4.456315e-05
9,235	ThriftLLM: On Cost-Effective Selection of Large Language Models for Classification Queries	2025	VLDB	4.3690661e-05
10,112	SEFRQO: A Self-Evolving Fine-Tuned RAG-Based Query Optimizer	2026	SIGMOD	4.1945683e-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
369	Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation	2024	VLDB	0.0002547515
517	Can Foundation Models Wrangle Your Data?	2023	VLDB	0.00021169035
567	NaLIR: An Interactive Natural Language Interface for Querying Relational Databases	2014	SIGMOD	0.00019966681
898	Data Compression Support in Databases	1994	VLDB	0.00015525779
1,417	Data Compression in Oracle	2003	VLDB	0.00012104308
1,443	Compressing SQL Workloads	2002	SIGMOD	0.00011947004
1,527	Generic Schema Matching, Ten Years Later	2011	VLDB	0.00011499442
2,349	RPT: Relational Pre-trained Transformer Is Almost All You Need towards Democratizing Data Preparation	2021	VLDB	8.9876423e-05
2,908	SPARTAN: A Model-Based Semantic Compression System for Massive Data Tables	2001	SIGMOD	7.9306333e-05
3,745	DeepSqueeze: Deep Semantic Compression for Tabular Data	2020	SIGMOD	6.7926132e-05
3,787	White-box Compression: Learning and Exploiting Compact Table Representations	2020	CIDR	6.7674374e-05
6,366	ISUM: Efficiently Compressing Large and Complex Workloads for Scalable Index Tuning	2022	SIGMOD	5.0943443e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
10,693	Evoschema: Towards Text-To-Sql Robustness Against Schema Evolution	2025	VLDB	4.1945683e-05
10,796	Horizon: Robust Checks for SQL Migration Using LLMs	2025	VLDB	4.1945683e-05
369	Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation	2024	VLDB	0.0002547515
5,437	SNAILS: Schema Naming Assessments for Improved LLM-Based SQL Inference	2025	SIGMOD	5.5033018e-05
10,452	ScaleLLM: A Technique for Scalable LLM-augmented Data Systems	2025	SIGMOD	4.1945683e-05
5,928	SchemaPile: A Large Collection of Relational Database Schemas	2024	SIGMOD	5.2685946e-05
10,210	SchemaRAG: A Schema-aware Retrieval-Augmented Generation Framework for Text-to-SQL	2026	SIGMOD	4.1945683e-05
2,945	Few-shot Text-to-SQL Translation using Structure and Content Prompt Learning	2023	SIGMOD	7.8377395e-05
4,908	Combining Small Language Models and Large Language Models for Zero-Shot NL2SQL	2024	VLDB	5.8339245e-05
1,271	Schema Summarization	2006	VLDB	0.00012923966