Measures in SQL

Summary: Measures: a new column type attached to tables to encode calculations as composable units. Semantics rely on context-sensitive expressions and an evaluation context, enabling in-place expansion to standard SQL while preserving SQL semantics and delivering multidimensional expressiveness. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 6844
Venue: SIGMOD
Year: 2024
Pagerank: 5.6976548e-05
Overall Rank: 7,116 | 51.18%
DOI: 10.1145/3626246.3653374

Incoming Non-self Citations Over Time

Authors

1. Julian Hyde (Google)
2. John Fremlin (Google)

BibTeX Citation

@inproceedings{hyde_sigmod24,
        title = {{Measures in SQL}},
        author = {Hyde, Julian and Fremlin, John},
        series = {{SIGMOD} '24},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3626246.3653374},
        url = {https://dl.acm.org/doi/10.1145/3626246.3653374},
        year = {2024}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
9,350	Enterprise Application-Database Co-Innovation for Hybrid Transactional/Analytical Processing: A Virtual Data Model and Its Query Optimization Needs	2025	SIGMOD	5.2841297e-05
10,117	Semantic Data Modeling, Graph Query, and SQL, Together at Last?	2026	CIDR	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 2 of 2 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
445	Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources	2018	SIGMOD	0.00018336751
2,021	WinMagic : Subquery Elimination Using Window Aggregation	2003	SIGMOD	9.297379e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	12,289	Efficient Implementation of Generalized Quantification in Relational Query Languages	2013	VLDB
2	1,558	SchemaSQL - A Language for Interoperability in Relational Multi-database Systems	1996	VLDB
3	7,774	Building Advanced SQL Analytics From Low-Level Plan Operators	2021	SIGMOD
4	5,950	Translating and Optimizing SQL Queries Having Aggregates	1987	VLDB
5	7,008	Business Modeling Using SQL Spreadsheets	2003	VLDB
6	1,687	Spreadsheets in RDBMS for OLAP	2003	SIGMOD
7	4,166	A Foundation for Multi-Dimensional Databases	1997	VLDB
8	12,315	Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations	2012	SIGMOD
9	1,860	Querying Multiple Features of Groups in Relational Databases	1996	VLDB
10	12,713	Composite Subset Measures	2006	VLDB