Tech

 Articles

Database technology

All
Query Optimisation
All
Materialized Views
All
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

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

Change data capture

An overview of change data capture with LeapDB

Tech
5
 min read