LucidDB - RDBMS built entirely for Data Warehousing and Business Intelligence

LucidDB is the RDBMS 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. Every component of LucidDB was designed with the requirements of flexible, high-performance data integration and sophisticated query processing in mind.

Rather than throwing hardware at data warehousing problems by relying on expensive clusters or specialized "appliances", the scalability offered by LucidDB's unique architecture allows you to achieve great performance using only a single off-the-shelf Linux or Windows server. Besides keeping costs down, this also minimizes maintenance and administration hassles.

• Support of both 32 and 64 bit platforms
• Integrated with Pentaho Business Intelligence product
• Automatically adapts to either bitmap or btree representation depending on data distribution
• Versioning at page-level is much more efficient than transactional databases
• Supports incremental backup
• High performance and greater cache and disk effectiveness
• Allows flat files (e.g. BCP or CSV format) to be queried as foreign tables via LucidDB