 | |
| Original author(s) | Cloudscape Inc (LaterIBM) |
|---|---|
| Developer(s) | Apache Software Foundation |
| Stable release | 10.17.1.0 / November 14, 2023; 16 months ago (2023-11-14) |
| Repository | Derby Repository |
| Written in | Java |
| Operating system | Cross-platform |
| Type | Relational Database Management System |
| License | Apache License 2.0 |
| Website | db |
Apache Derby (previously distributed asIBM Cloudscape) is arelational database management system (RDBMS) developed by theApache Software Foundation that can be embedded inJava programs and used foronline transaction processing. It has a 3.5MB disk-space footprint.[1]
Apache Derby is developed as anopen source project under theApache 2.0 license. For a time,Oracle distributed the same binaries under the nameJava DB.[2] In June 2015 they announced that for JDK 9 they would no longer be doing so.[3]
Apache Derby originated at Cloudscape Inc, anOakland,California, start-up founded in 1996 by Nat Wyatt and Howard Torf to develop Javadatabase 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.[4] In 2001IBM acquired the database assets of Informix Software, including Cloudscape. The database engine was re-branded to IBM Cloudscape and releases continued, mainly focusing 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 theApache DB project.[5] In July 2005 the Derby project graduated from the Apache incubator and is now being developed as a sub-project of theDB 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,[6] and with the release of Java 6 in December 2006, Sun started packaging Derby in theJDK branded as Java DB.
In March 2007, IBM announced that they would withdraw marketing and support for the Cloudscape product, but would continue to contribute to the Apache Derby project.[7]
The Java DB database is Oracle's supported distribution of Apache Derby.[8]
The core of the technology, Derby's database engine, is a full-functioned relational embedded database-engine, supportingJDBC andSQL as programming APIs. It usesIBM Db2SQL syntax.
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 standardDRDA protocol. The network server allows the Derby engine to support networked JDBC,ODBC/CLI,Perl.
An embedded database can be configured to act as a hybrid server/embedded RDBMS; to also accept TCP/IP connections from other clients in addition to clients in the same JVM.[9]
