Procedural Extensions of SQL: Understanding their usage in the wild
Summary: Empirical study of procedural SQL usage across workloads—procedures, UDFs, triggers—reveals magnitude and complexity. SQL-ProcBench: a real-workload benchmark for procedural SQL; cross-engine experiments expose research challenges and opportunities. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Surabhi Gupta (Microsoft)
- 2. Karthik Ramachandra (Microsoft Azure Data (SQL))
BibTeX Citation
@article{gupta_vldb21,
title = {{Procedural Extensions of SQL: Understanding their usage in the wild}},
author = {Gupta, Surabhi and Ramachandra, Karthik},
journal = {PVLDB},
series = {{VLDB} '21},
volume = {14},
number = {8},
pages = {1378--1391},
doi = {10.14778/3457390.3457402},
url = {https://doi.org/10.14778/3457390.3457402},
year = {2021}
}Incoming Citations (Sorted by Pagerank)
Showing 20 of 20 citing papers.
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 22 of 22 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 1,562 | Estimating Progress of Execution for SQL Queries | 2004 | SIGMOD |
| 2 | 6,314 | YeSQL: "You extend SQL" with Rich and Highly Performant User-Defined Functions in Relational Databases | 2022 | VLDB |
| 3 | 5,174 | An In-Depth Benchmarking of Text-to-SQL Systems | 2021 | SIGMOD |
| 4 | 9,241 | Provenance for SQL through Abstract Interpretation: Value-less, but Worthwhile | 2015 | VLDB |
| 5 | 8,096 | Efficient Execution of User-Defined Functions in SQL Queries | 2023 | VLDB |
| 6 | 4,724 | Processing Queries Against Database Procedures: A Performance Analysis | 1988 | SIGMOD |
| 7 | 10,740 | UDFBench: A Tool for Benchmarking UDF Queries on SQL Engines | 2025 | SIGMOD |
| 8 | 4,645 | User-Defined Table Operators: Enhancing Extensibility for ORDBMS | 1999 | VLDB |
| 9 | 14,235 | Supporting Procedural Constructs in SQL Compilers | 1996 | VLDB |
| 10 | 9,917 | The UDFBench Benchmark for General-purpose UDF Queries | 2025 | VLDB |