Posted
3 months
ago
by
forsini
Kristian Wagaan and Richard Hillegas, both Apache Derby committers who also work on Java DB, recently gave some great presentations about Apache Derby and Java DB.
Kristian Wagaan presented at the 2009 OpenSQLCamp, in
... [More]
conjunction with FrOSCon 2009 in Europe.
The presentation (slides) gives a brief overview of Apache Derby, its history and the community around it. Further, it goes into the details of features that have been added in the latest releases and show how they enable powerful ways to use a relational database.
Rick Hillegas gave an introduction of Java DB / Apache Derby at The San Francisco Java User Group's Sep 8th event in San Francisco. [Less]
Posted
3 months
ago
by
forsini
Following the release of Apache Derby 10.5.3, Java DB which is Sun's supported version of this last one is also now available.
Java DB 10.5.3 is primarily a bug-fix release and inherits all the bug fixes and localized messages from
... [More]
Apache Derby 10.5.3.
Java DB offers installers for the following platforms:
Solaris
Linux
Windows
Mac OS X (newly added)
Here is a recap of all changes that are coming as part of Java DB 10.5.3:
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". Java DB
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 Java DB to fill a column with an expression
built out of other columns in the row. Java DB 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 Java DB 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.
Service tag - Introduction of the Java DB registration service (service tag).
Further details on new features, changes, and issues in this release can be found in the Release Notes. [Less]
Posted
3 months
ago
by
forsini
The Apache Derby project is pleased to announce a new bug-fix release of Derby, 10.5.3.0.
Apache Derby is a subproject of the Apache DB project. Derby is a pure
Java relational database engine which conforms to the ISO/ANSI
... [More]
SQL and
JDBC standards. Derby aims to be easy for developers and customers to
use.
Derby 10.5.3.0 can be obtained from the Apache download site:
http://db.apache.org/derby/derby_downloads.html
Derby 10.5.3.0 contains many bug fixes plus localizations for messages
added in the previous feature release, 10.5.1.1.
10.5.3.0 replaces
10.5.2.0, which introduced a query-ordering regression.
Here is the list of bug fixes addressed in 10.5.3. [Less]
Posted
6 months
ago
by
forsini
The Java DB team will be at CommunityOne and JavaOne 2009 next week.
Feel free to come and visit us at the Java DB POD and share feedback with us. You might even get a nice T-Shirt
We will show demo's of new features, including some nice JavaFX application using Java DB / Apache Derby.
Posted
6 months
ago
by
forsini
The Java DB project is pleased to announce a new feature release of Java DB 10.5.1.
Java DB is Sun's branded distribution of the Apache Derby open source database. Java DB is a pure Java relational database engine which conforms
... [More]
to the ISO/ANSI SQL and JDBC standards. Java DB aims to be easy for developers and end-users to work with.
Java DB 10.5.1 can be obtained from the Java DB download site:
http://developers.sun.com/javadb/downloads/index.jsp
Java DB 10.5.1 introduces the following new features and improvements:
In-memory databases for test rigs and transient data
Replication of Encrypted Data for failover of sensitive databases
OFFSET/FETCH FIRST for paging through query results efficiently
SQL Roles for administering fine-grained access controls
Generated Columns for speeding up queries by pre-computing results
LOB Improvements for speeding up access to large binary and text objects
Optimizer Statistics Improvements for better management of query plans
Java DB offers the following:
Installers for various platforms
Support offering (more info)
Notification of new releases and updates via registration
Native Netbeans integration
Bundled in GlassFish and Sun JDK6
If you are interested in learning more or/and sharing feedback about Java DB, please come and visit us at our POD during CommunityOne and JavaOne 2009. [Less]
Posted
7 months
ago
by
forsini
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
... [More]
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. [Less]
Posted
9 months
ago
by
forsini
Amongst the recent updates to Java DB's portal, I recommend reading these 2 great interviews of Masood Mortazavi, engineering manager for Java DB.
You can also find a various selection of technical articles, tips and
... [More]
white-papers.
If you are using Netbeans as your IDE, this article will show you how to use Java DB effectively inside it. [Less]
