LucidDB – RDBMS purpose-built entirely for data warehousing and business intelligence

LucidDB is a Database Management System (DBMS) optimized for business intelligence. Besides architectural innovations such as column-store, it supports many advanced features from SQL:2003, including SQL/MED and user-defined transformations written in Java.

LucidDB is the first and only open-source Relational DBMS purpose-built entirely for data warehousing and business intelligence.

It is based on architectural cornerstones such as column-store, bitmap indexing, hash join/aggregation, and page-level multiversioning.

Most database systems (both proprietary and open-source) start life with a focus on transaction processing capabilities, then get analytical capabilities bolted on. By contrast, every component of LucidDB was designed with the requirements of flexible, high-performance data integration and sophisticated query processing in mind. Moreover, comprehensiveness within the focused scope of its architecture means simplicity for the user: no DBA required.

Features include:

• Storage:
  • Column-store tables.
  • Intelligent indexing.
  • Page-level multi-versioning.
  • Warehouse labels.
  • Hot+increment backup.
• Optimization:
  • Star join optimization.
  • Cost-based join ordering and index selection.
• Execution:
  • Hash join/aggregation.
• • Intelligent prefetch.
  • INSERT/UPSERT as bulk load.
• Connectivity:
  • SQL/MED architecture.
  • JDBC foreign data wrapper.
  • Flat file foreign data wrapper.
  • Pluggability.
  • Pentaho Data Integration plugin.
• Extensibility:
  • SQL/JRT architecture.
  • User-defined functions.
  • User-defined transformations.
  • Modify the system without compiling or reviewing the source code.
• Standards:
  • SQL:2003.
  • JDBC.
  • UNICODE.
  • J2EE.

Website: luciddb.sourceforge.net
Support: FAQ
Developer: LucidEra, Inc. & The Eigenbase Project
License: Apache License 2.0

LucidDB is written in Java. Learn Java with our recommended free books and free tutorials.

Return to Relational Databases | Return to Data Warehouse Software

Explore Linux
	Best Free and Open Source Software - A huge collection of recommended free and open source software covering every major category.
	In-depth Linux Software Reviews - Detailed assessments of Linux software covering features, usability and overall quality.
	The Big List of Active Linux Distros - An extensive collection of actively developed Linux distributions.
	Open Source Alternatives - Alternatives to software and services from Google, Microsoft, Apple, Adobe, IBM, Autodesk, Oracle and others.
	Essential Linux System Tools - Indispensable utilities for monitoring, maintaining and managing Linux systems.
	Linux Productivity Tools - Useful utilities for improving productivity and streamlining everyday tasks.
	Alternatives to Popular CLI Tools - Modern alternatives to familiar command-line utilities supplied with Linux systems.
	Awesome Free Linux Game Tools - Tools, utilities and companion software that improve gaming on Linux.
	Machine Learning on Linux - Machine learning and deep learning software, self-hosted applications and practical tools.
	Saving Money with Linux - Practical ways to reduce electricity consumption and lower computing costs with Linux.
	Linux Candy - Fun, entertaining and sometimes delightfully quirky software from the lighter side of Linux.