4 ms·
"LucidDB is the first and only open-source RDBMS purpose-built entirely for data warehousing and business intelligence. It is based on architectural cornerstone
by justin_vanw 17y ago
"LucidDB is the first and only open-source RDBMS 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 as an afterthought (if at all). 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."
Unintentional hilarity is hilarious.
- mattculbreth 17y agoWhat's hilarious about this?
- evdawg 17y agoIt is based on architectural cornerstones such as column-store, bitmap indexing, hash join/aggregation, and page-level multiversioning Meanwhile... no DBA required. Riiiiiiiiiiiiiiiiight.
- deleted 17y ago[deleted]
- pradocchia 17y agoLucidDB is the first and only open-source RDBMS purpose-built entirely for data warehousing and business intelligence. Does LucidDB predate MonetDB? Or is MonetDB considered multipurpose? It has an XML front end in addition to SQL, but the data store is still column-oriented. Not sure about the other features, like multiversioning, though that's an old technique (InterBase pioneered it) so I wouldn't be surprised either way.