Apache Derby DBMS
Derby is an effort being undertaken by the Apache Software Foundation. The Derby
project develops open source database technology that is (1) pure Java,
(2) small footprint, (3) easy-to-use, (4) standards-based, and (5)
secure. Below are general, introductory articles on the Derby database
that you might find useful.
Java databasing with Derby (2006-11-08 RegDeveloper)
" If you add to its simplicity of setup, ease of use, and small footprint,
the fact that Derby supports referential integrity and ACID-compliant
transactions, you have a pretty powerful database tool for your Java
applications."
Try on Derby for size (2006-09-29 JavaWorld)
"
Apache Derby is a lightweight, pure-Java relational database that can
be embedded directly into Java applications and/or accessed remotely
by multiple users connected to Derby's network server. Apache Derby
provides a simple execution model that makes it ideal for application
resource management tasks, as well as relational data storage for simple
to moderately-complex distributed systems."
Mustang
now packaged with Java DB (2006-06-16 Amit Handa's Blogs)
"
Mustang is now packaged with Java DB 10.2 aka Apache Derby, a pure
java standards based database. This holds significance as Java DB implements
all new features of JDBC 4.0 Specification. Among them are the Ease
of Development and new JDBC driver loading mechanism to play with.
This packaging will provide out of box database with a jdk release
for the first time."
Make
Java DB Your Client-side Portable Database (2006-05-12 DevX.com)
"
What can be accomplished with an embedded Java database is left to
the imaginations of software architects and developers. I am sure that
a few years from now we will see many Java DB-backed interactive applications
with zero downtime. Currently, plans are in the works to use Java DB
as a repository for office productivity documents in Microsoft Office
and OpenOffice, and in many of the new breed of AJAX-driven offerings.
More importantly, Java DB addresses many of the functionality problems
for mobile applications such as data replication."
Java
DB Overview (Sun Microsystems)
"Java DB is Sun's supported distribution of the open source Apache Derby
100% Java technology database. It is fully transactional, secure, easy-to-use,
standards-based -- SQL, JDBC API, and Java EE -- yet small, only 2MB.
The Apache Derby project has a strong and growing community that includes
developers from large companies such as Sun Microsystems and IBM as
well as individual contributors."
Using
Java DB in Desktop Applications (2006-03 Sun Microsystems)
"
Working with Java DB is easy and fun. Java DB makes it possible to
create and distribute an embedded database with minimal effort."
Java
DB Overview (Sun Microsystems)
"
Java DB is a 100% Java database, based on the Apache Derby project,
and supported by Sun. It is fully transactional, secure, and standards
compliant - JDBC, J2EE, and SQL -- yet small: only 2MB. The Apache
Derby project has a strong and growing community that includes over
50 developers from Sun, IBM, other organizations, and individual contributors."
Using
Java DB in Desktop Applications (2006-03 Sun Microsystems)
"
Working with Java DB is easy and fun. Java DB makes it possible to
create and distribute an embedded database with minimal effort."
Introduction
to Apache Derby (2006-02-14 IBM developerWorks)
"
Working with a database system doesn't have to be difficult. By using
Apache Derby, you can quickly begin working with a full-featured database
system. And because Apache Derby is a standards-compliant database,
applications developed using it can be easily migrated to a more powerful
database system as the situation warrants."
Sun
Microsystems Incorporates Open Java DB Into Java Enterprise
System (2005-12-13 Sun Microsystems Press Release)
"
Sun Microsystems Inc. ... [announced] the incorporation of the open
source Java DB, the Sun supported distribution of the Apache Derby
Project, into the Sun Java Enterprise System. Sun also announced additional
support for the database with a new plug-in to be included in the upcoming
NetBeans IDE 5.0, a complete open source development environment for
building and deploying Java applications."
Advancements
in SQL/XML (2004-09 SIGMOD Record)
"
In addition, we discuss the new features being added to SQL/XML for
its second edition. As a matter of fact, the first official ballot
of the second edition is already under way (belying the popular misconception
that standards processes inherently operate in geologic time). Publication
of the second edition of SQL/XML is anticipated in late 2005."
Use
Derby in a J2EE Server environment (2005-09-29
IBM developerWorks)
"
Most J2EE applications need to store data, and the most common method
used to manage data is with a JDBC-compliant database. Any database
with a JDBC driver interface can be integrated with the Server to create
what J2EE terms a "resource
manager" (RM). The Derby engine is ideally suited to the role of resource manager. It
is designed to be a relational database component of a larger system,
which is what is meant by the term "embedded database" commonly used to describe Derby."
Cloudscape
Version 10: A technical overview (13 Aug 2004, Updated 18 Aug 2005
IBM developerWorks)
"
The core of IBM Cloudscape™ is the Apache Derby open source database.
Derby's lightweight, embeddable architecture makes it the ideal database
engine for deploying database-driven Java™ applications. With Derby,
the database engine becomes part of the application, so the user never
has to install or manage it. This article provides an overview of Derby
technical features."
Apache
Derby Status Update (2005 OSCON)
Apache Derby graduates with Sun onboard (2005-08-04
CNET News.com)
"Sun
said it plans to embed Derby as a database with its Java application
server and portal server as well as its open-source NetBeans Java developmental
tool. Derby is specifically designed to be embedded within other Java
software products, rather than a fully featured relational database."
Double
Take: A guide to understanding the open-source Apache Derby and its
supported twin IBM Cloudscape. (DB2 Magazine 2005)
"
Both the Apache Derby and IBM Cloudscape database products are free
to download and use, but you can purchase a support contract from IBM
for the IBM Cloudscape product. Some customers and independent software
vendors (ISVs) who rely on this database technology prefer to have
a contract that covers support and problem resolution."
Flying
out of the gate with Derby (VSj 2005-06-30)
"
Derby is a feature-rich relational database system that can be integrated
into your projects today. The flexibility to support both embedded
mode and client-server mode of operation allows it to adapt to diverse
deployment scenarios. Its 100% Java orientation provides straightforward
code integration, and enjoys the same ‘deploy anywhere’ benefit as
your Java application. Its speedy execution on production data volume,
together with support for advanced features such as referential integrity
and stored procedures, makes it ideal even for sophisticated data access
requirements. Last but not least, its liberal Apache license lets you
bundle it freely into your products."
IBM's
Cloudscape Versus MySQL (DevX.com
2005-06-28)
"
Another important advantage of Cloudscape/Derby over MySQL is in its
security encryption capabilities. Cloudscape offers the option to encrypt
an entire database, which provides an extra layer of security by protecting
both the file system and database schema. In other words, no data exists
in clear-text form in the database files. This is especially important
for remotely deployed databases or mobile databases on notebook computers
that are in danger of being hacked into if the notebook computer is
stolen."
Cloudscape
Version 10: A technical overview (IBM developerWorks2004-08-13)
"
Derby provides developers with a small footprint, standards-based Java
database that can be tightly embedded into any Java-based solution.
With its combination of robust SQL features, support for Java technology,
security, and embeddable, pure Java architecture, Derby is the data
management product of choice for data-driven Java applications. The
value that the IBM Cloudscape commercial offering adds makes it easier
than ever for Java developers to deploy their Java-based solutions."
Meet
the Experts: Why IBM is open
sourcing Cloudscape as Derby (IBM developerWorks
2004-10-14)
"
Developers recognize good code. When we acquired Cloudscape code along
with Informix®, our internal development community started talking
about it and working with it. So much so, in fact, that today there
are already 70 projects within IBM -- many shipping to marketplace,
such as WebSphere® Application Server, WebSphere Portal, and IBM Workplace
-- using Cloudscape within their offerings. So we knew we had an interesting
technology that could become part of the Java stack. We saw a linkage
between the Java database and the Java work being done by Apache, and
came to realize this is a tremendous project to open source."
Open-source
contribution brews stronger
Java (SearchWebServices.com 2004-08-12)
" 'With Cloudscape, IBM is primarily addressing the competition between
Java and Microsoft .NET
.NET tends to appeal to low-end users, who do not necessarily have a lot of
administrative resources that they
can dedicate to maintaining
databases, and they value the ease-of-use of Microsoft products,' he said.
By providing a database that optimizes
for ease-of-use, IBM will
make Java (and WebSphere) more attractive for users that might otherwise have
chosen .NET."
IBM
to make Java database
open source (CNET News.com 2004-07-30)
" As a Java-only database, it does not compete directly against mainstream
relational database servers,
such as DB2, Oracle or Microsoft's SQL Server, according to industry
executives. Still, the move to make its
database products open
source deepens IBM's commitment to the open-source development model.
With its multibillion-dollar investment in Linux,
Big Blue is credited
with having made open-source technology more palatable to corporate
customers."
Open-Source
Community Eager for
Cloudscape Code (eWEEK.com 2004-08-05)
" 'With Derby, applications can ship with a database preconfigured,
and then people who wish to use an external database,
such as MySQL, DB2, Oracle or PostgreSQL can migrate from Derby to the external
database,'
he said. 'But it permits applications
to count on the functionality of a real database from the get-go.'"
Additional Information:
* IBM Integration plug-in for Derby
* Securing Data with Apache Derby (presentation pdf)
* Initial XML Support
* Introducing Apache Derby (presentation pdf)
* Apache Derby and JDO
