Daffodil software has announced the release of v4.0 of its open source
java database One$DB. It is an open source database designed to handle
complex computing environments that demand a robust, scalable and
high-performance RDBMS that can operate across platforms. The new
version (v4.0) enhances speed and adds key features such as support for
updatable views, scalar sub-query and scalar functions.

One$DB users can now update views using update query. Updation will be
performed on the base table of the view. Support for scalar sub-query
in select list of select query has also been introduced. Scalar
sub-query is a query that returns a single column with one single row.
Sub-query column can be sorted using Order By clause. This version also
comes with a number of new scalar functions.

For the full list of features and functionalities download the source
code files, available at: http://sourceforge.net/projects/daffodildb/