LucidDB is an open-source database purpose-built to power data warehouses, OLAP servers and business intelligence systems.

According to the product website, its architecture is based on column-store, bitmap indexing, hash join/aggregation, and page-level multiversioning.

[3][4] It handles ETL functionality using extensions to ANSI SQL, by using 'wrappers' around a range of data sources (databases, text files, Web services, etc.

[5] LucidDB achieves high performance by automatically identifying required indexes and creating them on the fly without the need for manual intervention.

LucidDB has had a long run as the first pure play open source column store database.