Apache Derby is developed as an open source project under the Apache 2.0 license. For a time, Oracle distributed the same binaries under the name Java 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, an Oakland, California, start-up founded in 1996 by Nat Wyatt and Howard Torf 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.[4] 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 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 the Apache DB project.[5] 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,[6] and with the release of Java 6 in December 2006, Sun started packaging Derby in the JDK 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.
Technologies
Derby embedded database engine
The core of the technology, Derby's database engine, is a full-functioned relational embedded database-engine, supporting JDBC and SQL as programming APIs. It uses IBM Db2SQL syntax.
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.
Embedded Network Server
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.[8]
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.
^"Why IBM is open sourcing Cloudscape as Derby". IBM.
^"Apache Derby graduates with Sun onboard". CNET news.com.
^"Changes in Cloudscape Availability and Support". IBM.
^see Embedded Server Example in http://db.apache.org/derby/docs/10.4/adminguide/
Bibliography
Zikopoulos, Paul C.; Baklarz, George; Scott, Dan (November 6, 2005). (First ed.). IBM Press. p. 600. ISBN0-13-185525-5. Archived from the original on February 15, 2009.
External links
Official website
Internals of Derby, An Open Source Pure Java Relational Database Engine deployable in an embedded OSGi environment
Oracle Java DB Site
Why IBM is open sourcing Cloudscape as Derby, IBM developerWorks site
Apache Derby performance results in the JPA Benchmark
Compliance matrix with SQL 2003
Configure and Install Derby Database
January 31, 2023
apache, derby, previously, distributed, cloudscape, relational, database, management, system, rdbms, developed, apache, software, foundation, that, embedded, java, programs, used, online, transaction, processing, disk, space, footprint, original, author, cloud. Apache Derby previously distributed as IBM Cloudscape is a relational database management system RDBMS developed by the Apache Software Foundation that can be embedded in Java programs and used for online transaction processing It has a 3 5 MB disk space footprint 1 Apache DerbyOriginal author s Cloudscape Inc Later IBM Developer s Apache Software FoundationStable release10 16 1 1 May 19 2022 8 months ago 2022 05 19 RepositoryDerby RepositoryWritten inJavaOperating systemCross platformTypeRelational Database Management SystemLicenseApache License 2 0Websitedb wbr apache wbr org wbr derby wbr Apache Derby is developed as an open source project under the Apache 2 0 license For a time Oracle distributed the same binaries under the name Java DB 2 In June 2015 they announced that for JDK 9 they would no longer be doing so 3 Contents 1 History 2 Technologies 2 1 Derby embedded database engine 2 2 Derby Network Server 2 3 Embedded Network Server 2 4 Database utilities 3 See also 4 References 5 Bibliography 6 External linksHistory EditApache Derby originated at Cloudscape Inc an Oakland California start up founded in 1996 by Nat Wyatt and Howard Torf 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 4 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 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 the Apache DB project 5 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 6 and with the release of Java 6 in December 2006 Sun started packaging Derby in the JDK 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 Technologies EditDerby embedded database engine Edit The core of the technology Derby s database engine is a full functioned relational embedded database engine supporting JDBC and SQL as programming APIs It uses IBM Db2 SQL syntax Derby Network Server Edit 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 Embedded Network Server Edit 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 8 Database utilities Edit 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 See also Edit Free and open source software portalList of relational database management systems Comparison of relational database management systems H2 HSQLDBReferences Edit Apache Derby Apache org Java DB FAQs Is Java DB a fork of Apache Derby Deferring to Derby in JDK 9 Informix Completes Acquisition of Cloudscape Inc Business Wire Berkshire Hathaway October 11 1999 Archived from the original on March 9 2000 Retrieved October 12 2019 via Yahoo com Why IBM is open sourcing Cloudscape as Derby IBM Apache Derby graduates with Sun onboard CNET news com Changes in Cloudscape Availability and Support IBM see Embedded Server Example in http db apache org derby docs 10 4 adminguide Bibliography EditZikopoulos Paul C Baklarz George Scott Dan November 6 2005 Apache Derby Off to the Races Includes Details of IBM Cloudscape First ed IBM Press p 600 ISBN 0 13 185525 5 Archived from the original on February 15 2009 External links EditOfficial website Internals of Derby An Open Source Pure Java Relational Database Engine deployable in an embedded OSGi environment Oracle Java DB Site Why IBM is open sourcing Cloudscape as Derby IBM developerWorks site Apache Derby performance results in the JPA Benchmark Compliance matrix with SQL 2003 Configure and Install Derby Database Retrieved from https en wikipedia org w index php title Apache Derby amp oldid 1112542759, wikipedia, wiki, book, books, library,
