LucidDB Roadmap
Current Release
The current open-source release (0.7.4) of LucidDB is available for
download. It is packed with advanced
features; there are also some limitations you should be aware of:
- support for correlated subqueries is still under development
(uncorrelated subqueries are now fully optimized via constant reduction)
- security features are incomplete
- writers never block readers, but writers block other writers on
the same table
- all transactions are autocommit
- any join condition is now supported for LEFT/RIGHT OUTER JOIN, but
FULL OUTER JOIN support is limited to equijoins
- one single database-wide auto-extend tablespace
- FOREIGN KEY and CHECK constraints are not supported
- a limited number of system views and management procedures are available
- only single-byte character sets are supported; collation is always
case-sensitive
- no support for timezones and time intervals
- no ODBC driver is provided (JDBC must be used to connect to LucidDB)
- external user-defined routines are written in Java
Planned for Follow-on Releases
(Let us know if you're interested in contributing, either to projects
listed here or items of your own.)
- complete subquery support
- tablespaces and hot/incremental backup
- point-in-time queries
- robust security
- optimizer improvements and executor performance enhancements,
including parallelism
- more management views and functions
- UNICODE, collations, timezones, and time intervals
- SQL/J support
- ALTER TABLE
- materialized views
- tighter Mondrian and J2EE integration
- more connectors (e.g. XLS via POI) and ETL functions
Eventually...
- SQL/OLAP
- user-level transactions
- FOREIGN KEY and CHECK constraints
- ODBC driver
- fully cost-based optimization
- user-defined types
- bulk write to external systems
- clustering
- support for both row-store and column-store tables in the same database
- support for arbitrary FULL OUTER JOIN conditions
Maybe One Day...