LucidDB
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:
- 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
- Unser-defined transformations
- Modify the system without compiling or reviewing the
source code
- Standards:
- SQL:2003
- JDBC
- UNICODE
- J2EE
Return
to Relational Databases Home Page | Return
to Data Warehouse Software Home Page
Last Updated Saturday, April 06 2013 @ 10:17 AM EST
| 
