Apache Derby 10.5.1.1 Feature Release is now available!

The Apache Derby project is pleased to announce a new GA feature release
of Derby, 10.5.1.1.

Apache Derby is a sub-project of the Apache DB project. Derby is a pure
Java relational database engine which conforms to the ISO/ANSI SQL and
JDBC standards. Derby aims to be easy for developers and end-users to
work with.

Derby 10.5.1.1 can be obtained from the Derby download site:
http://db.apache.org/derby/derby_downloads.html.

It contains the following new features:
  • SQL Roles - SQL roles (as described in SQL 2003 and errata) are useful for administering privileges for groups of users. Administering roles is generally less error-prone than administering privileges for individual users. SQL Roles are defined in Feature T331 "Basic roles" and Feature T332 "Extended roles". Derby 10.5 implements a subset of T331, plus support for CURRENT_ROLE, which is a part of T332.
  • Generated Columns - Generated Columns is a feature which instructs Derby to fill a column with an expression built out of other columns in the row. Derby constructs these column values at INSERT and UPDATE time. The user declares indexes on these columns. This in turn improves SELECT performance since it lets users declare indexes on pre-computed pieces of the WHERE clause. This feature satisfies support for SQL Feature T175.
  • LOB Improvements - There were many performance and usability improvements for BLOBs and CLOBs.
  • Replication of encrypted databases - With 10.5 it is possible to replicate encrypted databases.
  • OFFSET/FETCH FIRST - SQL 2008 has added new syntax to support a direct way to limit the returned set of rows in a result set, through the fetch first and offset clauses.
  • In-Memory back end - Initial implementation of a storage engine for Derby where all data is kept in memory. There is no documentation for this feature. This functionality itself is not yet fully implemented, but users are welcome to experiment with it. For details, see the Primer for In-memory Back Ends.
  • Standard ALTER COLUMN syntax - Allow standard SQL "SET" keyword in ALTER COLUMN syntax, like so: "ALTER TABLE ALTER COLUMN columnname SET DEFAULT default-value"
  • SYSCS_UTIL.SYSCS_UPDATE_STATISTICS - New system procedure that updates cardinality statistics (or creates them if they do not exist) for a table's index or for all the indexes on a table, allowing a user to ensure that a query plan based on the most recent state of the table can be created.

In addition, Derby 10.5.1.1 contains many bug and documentation fixes.

Java DB, which is Sun's distribution of Apache Derby should be available as a 10.5.1.1 release level very soon.

Comments:

[Trackback] Now, a new release of Apache/Derby is out. Francois Orsini has a more detailed note on this. (See my previous release about this cauldron where Java DB is forged!)...

Posted by Masood Mortazavi's Blog on May 01, 2009 at 04:38 PM PDT #

[Trackback] Now, a new release of Apache/Derby is out. Francois Orsini has a more detailed note on this. It is great to see that many of the features listed are developed by our small but amazing team of Java DB engineers....

Posted by Masood Mortazavi's Blog on May 01, 2009 at 04:39 PM PDT #

Thanks for adding OFFSET/FETCH FIRST! That was a functionality very much needed in the direction to make Apache Derby production quality ready.

Now, Apache Derby just needs to fix some mayor and critical bugs to be production quality ready.

Posted by Juan on May 01, 2009 at 11:16 PM PDT #

Thanks Juan,
Apache Derby (formerly Cloudscape) saw its first incarnation 10 years ago, so it has been production ready for quite some time (albeit some issues which have been fixed over the years) ;-) We would be interested to know more about the major and critical bugs you're inferring to. Cheers.

Posted by Francois Orsini on May 02, 2009 at 04:41 AM PDT #

Post a Comment:
Comments are closed for this entry.
About

forsini

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today
Bookmarks