LucidDB is an

open-source Open source is source code that is made freely available for possible modification and redistribution. Products include permission to use and view the source code, design documents, or content of the product. The open source model is a decentrali ...

database In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and a ...

purpose-built to power

data warehouse In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for Business intelligence, reporting and data analysis and is a core component of business intelligence. Data warehouses are central Re ...

OLAP In computing, online analytical processing (OLAP) (), is an approach to quickly answer multi-dimensional analytical (MDA) queries. The term ''OLAP'' was created as a slight modification of the traditional database term online transaction processi ...

servers and

business intelligence Business intelligence (BI) consists of strategies, methodologies, and technologies used by enterprises for data analysis and management of business information. Common functions of BI technologies include Financial reporting, reporting, online an ...

systems. According to the product website, its architecture is based on column-store,

bitmap index A bitmap index is a special kind of database index that uses bitmaps. Bitmap indexes have traditionally been considered to work well for ''low-cardinality columns'', which have a modest number of distinct values, either absolutely, or relative to ...

ing,

hash join The hash join is an example of a join algorithm and is used in the implementation of a relational database management system. All variants of hash join algorithms involve building hash tables from the tuples of one or both of the joined relations ...

/aggregation, and page-level multiversioning.

Overview

Purpose-built for

data warehousing In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for Business intelligence, reporting and data analysis and is a core component of business intelligence. Data warehouses are central Re ...

, and

, LucidDB is a "columnar Business Intelligence database".Casters, Matt; Bouman, Roland; van Dongen, Jos (2010) ''Pentaho Kettle Solutions: Building Open Source ETL Solutions with Pentaho Data Integration'', John Wiley & Sons, , pp. 10, 249Bulusu, Lakshman (2012) ''Open Source Data Warehousing and Business Intelligence'', CRC Press, , p. 56 It handles ETL functionality using extensions to ANSI SQL, by using 'wrappers' around a range of data sources (databases, text files, Web services, etc.), allowing them to be queried as though they were all databases. It can also be used for

enterprise information integration Enterprise information integration (EII) is the ability to support a unified view of data and information for an entire organization. In a data virtualization application of EII, a process of information integration, using data abstraction to ...

. LucidDB uses the Optiq query planning and execution framework. LucidDB achieves high performance by automatically identifying required indexes and creating them on the fly without the need for manual intervention. It includes a bulk loader that permits merge and update operations as well as insert. LucidDB server is licensed under

GPL The GNU General Public Licenses (GNU GPL or simply GPL) are a series of widely used free software licenses, or ''copyleft'' licenses, that guarantee end users the freedom to run, study, share, or modify the software. The GPL was the first c ...

, while LucidDB client is licensed under LGPL.

Current status

It appears that LucidDB is no longer being maintained based on its GitHub entry. The SourceForge page has not been updated since 2010.

LucidDB has had a long run as the first pure play open source column store database. However, with no commercial sponsors and no ongoing community activity it's time to OFFICIALLY shut the doors. There will be no future code, or binary releases (this repository may at some point) of luciddb. All assets (wiki, issues, etc) will likely start coming down as well over the course of 2014. Appreciate all the effort by all those involved with LucidDB. Optiq, has given home and new life to portions of the LucidDB codebase. If you're interested in speaking SQL to NoSQL sources please the Optiq project.

Connectors

*JDBC driver *ADO.NET providerADO.NET provider for LucidDB
/ref>

References

External links

*{{Official website
Eigenbase Foundation
Client-server database management systems Free database management systems Free software programmed in Java (programming language) Free software programmed in C++