News & Articles

Our articles on Databases, Scalability & Materialized Views

and best practices and ideas

Latest Articles

Query Optimisation
Materialized Views
Tech

Star schema optimization in LeapDB

LeapDB includes "star schema optimization" which is a technique for improving query performance on star schema queries that filter out rows based on filters in dimension tables. This reduces IO for star schema queries and provides opportunities for query parallelization.

Tech
5
 min read

Using a materialized view to accelerate multiple queries on a large dataset

I use my benchmark queries on the BTS Ontime data set in a materialized view context and compare performance of the queries when using the materialized view against querying the base table.

Query Optimisation
8
 min read

WARP vs InnoDB on a wide 75GiB table

A comparison between InnoDB and WARP on two decades of the BTS ontime flight data, a 109 column wide table.

Tech
8
 min read

LeapDB includes the WARP storage engine for analytical queries

The WARP storage engine provides columnar storage, automatic bitmap indexing and parallel query with star schema optimization

Tech
5
 min read

Introduction to materialized views

An introduction to materialized views

Materialized Views
5
 min read

Change data capture

An overview of change data capture with LeapDB

Tech
5
 min read