From Eigenpedia

Revision as of 22:05, 5 January 2012 by Smoodoo (Talk | contribs)
(diff) ←Older revision | Current revision (diff) | Newer revision→ (diff)
Jump to: navigation, search

This is the main index page for documentation about the LucidDB open-source project, a DBMS optimized for business intelligence. LucidDB is part of The Eigenbase Project.


LucidDB User Documentation

Getting Started

LucidDB Server
A graphical browser-based frontend from DynamoBI specifically built for LucidDB

External Software
Squirrel SQL client running on Windows 7
Squirrel SQL client running on Windows 7
A graphical SQL client for accessing many database platforms, including LucidDB
A data modeling tool

User Guides

Labels allow users to have read-only query access to a snapshot of the database at an earlier point in time. Snapshots are accessible regardless of concurrent activities on other connections, like ETL, preparing new data.

Administrator Guides

LucidDB is designed to require as little administration as possible, so we hope this section can remain short :)

  • Memory Management
    • Buffer Pool Sizing
      You should also increase the buffer pool sizing to increase the amount of memory that LucidDB uses to "run queries"
      (the Java adjustments will only increase the catalog/parsing/optimizer memory settings but not the actual execution engine).
  • System Procedures
Useful for: Backup/Restore, Generating DDL for tables and other objects, managing sessions.
Useful information about tweaking: Memory usage, network settings, execution, and storage functionality.
The DBA views defined by LucidDB provide a global picture of the contents of the system catalog (tables, columns, etc) and the volatile state of the system (sessions, cache utilization, etc).

Function and SQL Language Reference Guides

Connectors to External Data Sources (SQL/MED) (Management of External Data)

See more general information about connectors here [].
See more general information about connectors here [].

These connectors wrap up external datasources and allow them to present their data as foreign tables inside of LucidDB. Connectors are an adapters that generally allow normal SQL queries to be run against datasources that may not support the SQL language directly.

Benchmark Studies

Commercial Support

Quick, reliable service and support is available to you from DynamoBI, the commercial sponsor of LucidDB.

DynamoBI Global Headquarters

42nd Floor
601 Union Street
Two Union Square
Seattle, WA 98101 USA
Tel. +1 888 LucidDB (582-4332)
Time Zone: PDT
Business Hours: 8-6 PDT
[Contact us!]

Community Involvement

LucidDB is one of the best databases in the world because of the people, not just the technology.

  • Community Support Forum
Please visit, ask questions and help others

  • Chat with us online
Many LucidDB users hang out on an Internet Relay Chat channel (IRC) called ##luciddb, using Freenode's [3] servers.
We would love to answer your questions and help you get up and going using LucidDB.
When you connect to or other freenode server near your country, be sure to use the command /join ##luciddb to actually join the chat channel for LucidDB.

Software Name Platform Download Location
qwebircWeb-based client
ChatZillaFirefox Add-on
mIRCMS Windows
X-ChatMS Windows
X-Chat AquaMac OS
ColloquyApple iPad & iPhone
Android - Internet Relay ChatGoogle Android

  • Bug and Feature Tracking
Make a feature request or report a problem you have experienced.

Presentations / Blogs

Demonstrates loading data, defining an OLAP cube, and browsing the cube with Pentaho, Jaspersoft, SpagoBI and Saiku which all use Mondrian to drive their OLAP functionality.
Webex Presentation and PDF of slides presenting benefits and features of LucidDB 0.9.3 in conjunction with Pentaho's BI Suite.
DynamoBI (Commercial Sponsor of LucidDB) - CEO Nick Goodman - shares vision about how LucidDB forms an information hub from which many different data sources can be presented and queried through normal SQL.

Tutorial Videos and Screencasts

This is an approach that may also work well on Windows. There is another approach, which is shorter and easier using the BASH shell under Linux. Documentation for both approaches can be found at LucidDbAsDaemonService.
  • Moving tables from one database to LucidDB
Using Pentaho Data Integration to generate SQL for moving tables from an external database to LucidDB
This link is actually to a document about upgrading version to version of LucidDB, but because a PDI transformation file is used to generate SQL for the transition, the process can be generalized as moving from an external database to LucidDB with only minor modifications to the transformation.


LucidDB does not currently support DDL for automatic horizontal partitioning of tables. Although LucidDB's column-store architecture implements automatic vertical partitioning, horizontal partitioning is still a useful technique for scaling up to very large data volumes, so this page describes some manual approaches which can be used for very simple schemas.
The main client API for LucidDB is JDBC. This page discusses some options for overcoming the obstacle of developing an application in a language other than Java.
Description of how to make use of some of the diff-based testing frameworks built into LucidDB for the purpose of test-driven ETL script development.
Walk-through document showing how to combine LucidDB with Apache Hadoop's Hive.

Frequently Asked Questions

Frequently Asked Questions

LucidDB Developer Documentation

LucidDB Design Documentation

Trademark Notice

LucidDB and the LucidDB logo are trademarks of DynamoBI Corporation.

Personal tools
Product Documentation