Jump to content

Apache Derby

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by Mcaisse (talk | contribs) at 20:25, 12 July 2006. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

The Apache Derby Project
The Apache Derby Project

Apache Derby is a Java-based Relational Database Management System that can be embedded in Java programs and used for online transaction processing (OLTP). A platform-independent, small-footprint (2 MB) database, Derby integrates tightly with any Java-based solution.

Apache Derby is developed as an Open Source project with the liberal Apache 2.0 License.

Derby is also distributed as IBM Cloudscape and Sun Java DB.

Derby Technologies

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.

Derby Network Server

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.

Database Utilities

  • ij – a tool that allows SQL scripts to be executed against any JDBC database.
  • dblook – Schema extraction tool for a Derby database.
  • sysinfo – Utility to display version numbers and class path.

History

Apache Derby originated at Cloudscape Inc, an Oakland, California start-up founded in 1996 to develop Java database technology. The first release of the database engine, then called JBMS, was in 1997. Subsequently the product was renamed Cloudscape and releases were made about every six months. In 1999 Informix Software, Inc., acquired Cloudscape, Inc. In 2001 IBM acquired the database assets of Informix Software, including Cloudscape. The database engine was re-branded to IBM Cloudscape and releases continued, mainly focussing on embedded use with IBM's Java products and middleware. 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.

See also