Skip to content

Apache Derby

August 7, 2009
tags:

Apache Derby is an open source DB from Apache. It is a relational database management system implemented entirely in java. Apache Derby is developed as an open source project under the Apache 2.0 license.

Apache Derby originated at Cloudscape in 1996, and then it was acquired by Informix Software. In 2001 it was acquired by IBM. In August 2004 IBM contributed the code to the Apache Software Foundation as Derby, an incubator project sponsored by the Apache DB project. In July 2005 the Derby project graduated from the Apache incubator and is now being developed as a sub-project of the DB Top Level Project at Apache. Prior to Derby’s graduation from incubation, Sun joined the Derby project with an intent to use Derby as a component in their own products and with the release of Java 6 in December 2006, Sun started packaging Derby in the JDK branded as Java DB.

Derby Embedded Database Engine

The core of the technology, Derby￯﾿ᄁ￯ᄒタ￯ᄒルs database engine is a full functioned relational embedded database engine. JDBC and SQL are the programming APIs. The Derby network server increases the reach of the Derby database engine by providing traditional client server functionality. The network server allows clients to connect over TCP/IP using the standard DRDA protocol. The network server allows the Derby engine to support networked JDBC, ODBC/CLI, Perl and PHP.

The following are the advantages of the Apache Derby

*    Derby has Small foot print — about 2 megabytes for the base engine and embedded
JDBC driver.

*    Derby is based on the Java, JDBC, and SQL standards.

*    Derby provides an embedded JDBC driver that lets you embed Derby in any Java-
based solution.

*    Derby also supports the more familiar client/server mode with the Derby Network
Client JDBC driver and Derby Network Server.

*    Derby is easy to install, deploy, and use.

The latest release of Apache Derby is Derby 10.3.2.1

Advertisements
No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: