Showing 1–1 of 1 results for author: Fremlin, J

Measures in SQL

Authors: Julian Hyde, John Fremlin

Abstract: SQL has attained widespread adoption, but Business Intelligence tools still use their own higher level languages based upon a multidimensional paradigm. Composable calculations are what is missing from SQL, and we propose a new kind of column, called a measure, that attaches a calculation to a table. Like regular tables, tables with measures are composable and closed when used in queries. SQL-with… ▽ More SQL has attained widespread adoption, but Business Intelligence tools still use their own higher level languages based upon a multidimensional paradigm. Composable calculations are what is missing from SQL, and we propose a new kind of column, called a measure, that attaches a calculation to a table. Like regular tables, tables with measures are composable and closed when used in queries. SQL-with-measures has the power, conciseness and reusability of multidimensional languages but retains SQL semantics. Measure invocations can be expanded in place to simple, clear SQL. To define the evaluation semantics for measures, we introduce context-sensitive expressions (a way to evaluate multidimensional expressions that is consistent with existing SQL semantics), a concept called evaluation context, and several operations for setting and modifying the evaluation context. △ Less

Submitted 10 January, 2025; v1 submitted 31 May, 2024; originally announced June 2024.

Comments: To be published in SIGMOD-Companion 24, June 9-15, 2024, Santiago, AA, Chile; 10 pages; updated with corrections as of 2024/05/31, and for formatting as of 2025/01/10