LucidDB
The topic of this article may not meet Wikipedia's notability guidelines for products and services. (October 2017) |
| LucidDB | |
|---|---|
| Developer | Eigenbase Foundation |
| Stable release | 0.9.4[1]
/ 2012-01-05 |
| Repository |
|
| Written in | Java, C++ |
| Engine | |
| Type | Database, Business intelligence, Data Warehouse |
| License | GPL 2 |
| Website | luciddb |
LucidDB is an open-source database purpose-built to power data warehouses, OLAP servers and business intelligence systems. According to the product website, its architecture is based on column-store, bitmap indexing, hash join/aggregation, and page-level multiversioning.[2]
Overview
[edit | edit source]Purpose-built for data warehousing, OLAP, and business intelligence, LucidDB is a "columnar Business Intelligence database".[3][4] 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.[3] It can also be used for enterprise information integration.[3] LucidDB uses the Optiq query planning and execution framework.[5]
LucidDB achieves high performance by automatically identifying required indexes and creating them on the fly without the need for manual intervention.[6] It includes a bulk loader that permits merge and update operations as well as insert.[3]
LucidDB server is licensed under GPL, while LucidDB client is licensed under LGPL.[7]
Current status
[edit | edit source]It appears that LucidDB is no longer being maintained based on its GitHub entry.[8] 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 disappear [sic] 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 checkout [sic] the Optiq project.[9]
Connectors
[edit | edit source]- JDBC driver
- ADO.NET provider[10]
References
[edit | edit source]- ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
- ^ From LucidDB Web Site
- ^ a b c d Casters, Matt; Bouman, Roland; van Dongen, Jos (2010) Pentaho Kettle Solutions: Building Open Source ETL Solutions with Pentaho Data Integration, John Wiley & Sons, Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value)., pp. 10, 249
- ^ Bulusu, Lakshman (2012) Open Source Data Warehousing and Business Intelligence, CRC Press, Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value)., p. 56
- ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
- ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
- ^ Khosrow-Pour, Mehdi (2010) Information Resources Management: Concepts, Methodologies, Tools and Applications, Engineering Science Reference, Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value)., p. 632
- ^ Lua error in Module:Citation/CS1/Configuration at line 2172: attempt to index field '?' (a nil value).
- ^ [1]
- ^ ADO.NET provider for LucidDB
External links
[edit | edit source]Lua error in mw.title.lua at line 392: bad argument #2 to 'title.new' (unrecognized namespace name 'Portal').
- Lua error in Module:Official_website at line 94: attempt to index field 'wikibase' (a nil value).
- Eigenbase Foundation