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
| Popular series | |
|---|---|
 | The largest compilation of the best free and open source software in the universe. Each article is supplied with a legendary ratings chart helping you to make informed decisions. |
 | Hundreds of in-depth reviews offering our unbiased and expert opinion on software. We offer helpful and impartial information. |
 | The Big List of Active Linux Distros is a large compilation of actively developed Linux distributions. |
 | Replace proprietary software with open source alternatives: Google, Microsoft, Apple, Adobe, IBM, Autodesk, Oracle, Atlassian, Corel, Cisco, Intuit, and SAS. |
 | Awesome Free Linux Games Tools showcases a series of tools that making gaming on Linux a more pleasurable experience. This is a new series. |
 | Machine Learning explores practical applications of machine learning and deep learning from a Linux perspective. We've written reviews of more than 40 self-hosted apps. All are free and open source. |
 | New to Linux? Read our Linux for Starters series. We start right at the basics and teach you everything you need to know to get started with Linux. |
 | Alternatives to popular CLI tools showcases essential tools that are modern replacements for core Linux utilities. |
 | Essential Linux system tools focuses on small, indispensable utilities, useful for system administrators as well as regular users. |
 | Linux utilities to maximise your productivity. Small, indispensable tools, useful for anyone running a Linux machine. |
 | Surveys popular streaming services from a Linux perspective: Amazon Music Unlimited, Myuzi, Spotify, Deezer, Tidal. |
 | Saving Money with Linux looks at how you can reduce your energy bills running Linux. |
 | Home computers became commonplace in the 1980s. Emulate home computers including the Commodore 64, Amiga, Atari ST, ZX81, Amstrad CPC, and ZX Spectrum. |
 | Now and Then examines how promising open source software fared over the years. It can be a bumpy ride. |
 | Linux at Home looks at a range of home activities where Linux can play its part, making the most of our time at home, keeping active and engaged. |
 | Linux Candy reveals the lighter side of Linux. Have some fun and escape from the daily drudgery. |
 | Getting Started with Docker helps you master Docker, a set of platform as a service products that delivers software in packages called containers. |
 | Best Free Android Apps. We showcase free Android apps that are definitely worth downloading. There's a strict eligibility criteria for inclusion in this series. |
 | These best free books accelerate your learning of every programming language. Learn a new language today! |
 | These free tutorials offer the perfect tonic to our free programming books series. |
 | Linux Around The World showcases usergroups that are relevant to Linux enthusiasts. Great ways to meet up with fellow enthusiasts. |
 | Stars and Stripes is an occasional series looking at the impact of Linux in the USA. |