Why You Care About Relational Algebra (Even Though You Didn't Know It)
Share this Session:
  Julian Hyde   Julian Hyde


Thursday, April 2, 2015
08:30 AM - 09:15 AM

Level:  Technical (may include code)

With data in different systems, in different formats, and accessed via different tools, we need a lingua franca for data. Not all tools speak SQL, and data cannot be moved into a single convenient location. Relational algebra underpins SQL and many other DB languages. It is also perfect for optimizing, caching and mediating. Apache Calcite (formerly Optiq) is a framework for building and optimizing expressions in relational algebra. We show how to write queries, optimize queries using rewrite rules, and write adapters for back-end systems. We also show to configure Calcite to materialize queries, so your interactive analytics are effectively running against a fast in-memory database.

Julian Hyde is lead developer of Apache Calcite, and a contributor to Apache Hive, Apache Drill and Cascading. He wrote the Mondrian OLAP engine (Pentaho Analysis) and the book "Mondrian in Action". He is an architect at Hortonworks and lives in Berkeley, CA with his wife and two sons.

Close Window