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: hc0d874fd70f594b7
Venue: SIGMOD
Year: 2024
Pagerank: 5.5671781e-05
Overall Rank: 7,271 | 51.14%
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,538	Enterprise Application-Database Co-Innovation for Hybrid Transactional/Analytical Processing: A Virtual Data Model and Its Query Optimization Needs	2025	SIGMOD	5.1631227e-05
10,356	Semantic Data Modeling, Graph Query, and SQL, Together at Last?	2026	CIDR	4.9769913e-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
379	Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources	2018	SIGMOD	0.00019507406
2,047	WinMagic : Subquery Elimination Using Window Aggregation	2003	SIGMOD	9.1286561e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	12,586	Efficient Implementation of Generalized Quantification in Relational Query Languages	2013	VLDB
2	1,578	SchemaSQL - A Language for Interoperability in Relational Multi-database Systems	1996	VLDB
3	7,871	Building Advanced SQL Analytics From Low-Level Plan Operators	2021	SIGMOD
4	6,057	Translating and Optimizing SQL Queries Having Aggregates	1987	VLDB
5	7,146	Business Modeling Using SQL Spreadsheets	2003	VLDB
6	1,715	Spreadsheets in RDBMS for OLAP	2003	SIGMOD
7	4,238	A Foundation for Multi-Dimensional Databases	1997	VLDB
8	12,612	Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations	2012	SIGMOD
9	1,899	Querying Multiple Features of Groups in Relational Databases	1996	VLDB
10	13,009	Composite Subset Measures	2006	VLDB