Building a semantic/metrics layer using Calcite
Channel: The ASF
Date: 2023-12-13

A semantic layer, also known as a metrics layer, lies between business users and the database, and lets those users compose queries in the concepts that they understand. It also governs access to the data, manages data transformations, and can tune the database by defining materializations.
Like many new ideas, the semantic layer is a distillation and evolution of many old ideas, such as query languages, multidimensional OLAP, and query federation.

In this talk, we describe the features we are adding to Calcite to define business views, query measures, and optimize performance. 

Speaker: Julian Hyde
Julian Hyde is the original developer of Apache Calcite, an open source framework for building data management systems, and Morel, a functional query language. Previously he created Mondrian, an analytics engine, and SQLstream, an engine for continuous queries. He is an engineer at Google, where he works on Looker and BigQuery.