Apache Derby

Apache Derby
Apache Derby
The Apache Derby Project
Original author(s) Cloudscape Inc (Later IBM)
Developer(s) Apache Software Foundation
Stable release 10.8.1.2 / April 29, 2011; 6 months ago (2011-04-29)
Development status Active
Written in Java
Operating system Cross-platform
Type Relational Database Management System
License Apache License 2.0
Website db.apache.org/derby/

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 2 MB disk-space footprint.[1]

Apache Derby is developed as an open source project under the Apache 2.0 license. Oracle distributes the same binaries as Java DB.[2]

Contents

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 DB2 SQL 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 and PHP.

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.[3]

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 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. 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.[4] 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,[5] 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.[6]

Comparison to other embedded SQL Java databases

In terms of execution speed, Derby has not performed well in some comparisons to other embedded SQL databases such as the also free and open source H2 database.[7][8][9]

Derby does not support Multiversion concurrency control (MVCC) while its main competitors HyperSQL and H2 support it.

See also

References

Bibliography

External links


Wikimedia Foundation. 2010.

Игры ⚽ Нужен реферат?

Look at other dictionaries:

  • Apache Derby — Тип Реляционная СУБД Автор Cloudscape Inc (а затем IBM) Разработчик …   Википедия

  • Apache Derby — Saltar a navegación, búsqueda Apache Derby Desarrollador Apache Software Foundation Sitio web Información general …   Wikipedia Español

  • Apache Derby — Première version 1997 Environnements Multiplate forme Type …   Wikipédia en Français

  • Apache Derby — Maintainer Knut Anders Hatlen et al. Entwickler Apache Software Foundation Aktuelle Version 10.8.2.2 (24. Okto …   Deutsch Wikipedia

  • Apache OFBiz — Screenshot  …   Wikipedia

  • Derby — steht im Sport für: Derby (Pferdesport), 1780 nach Lord Derby benanntes Pferderennen und weitere Pferdesportveranstaltungen Derby (Mannschaftssport), Wettkampf, bei dem zwei meist rivalisierende Sportvereine einer Region aufeinander treffen… …   Deutsch Wikipedia

  • Apache Geronimo — Standard Startseite des Apache Geronimo Basisdaten Entwickler …   Deutsch Wikipedia

  • Derby (disambiguation) — Derby is the county town of Derbyshire, England and includes: Derby Midland railway station Derby Works, railway locomotive works Derby Carriage and Wagon Works, railway works Derby may also refer to: Contents 1 Places 2 People 3 Sports …   Wikipedia

  • Derby (desambiguación) — Saltar a navegación, búsqueda Derby es un municipio que se encuentra en el condado de Derbyshire. Derby también puede referirse a: En lugares: Australia Derby (Tasmania) Derby (Australia) Sudáfrica Derby (Sudáfrica) Reino Unido Derby Road… …   Wikipedia Español

  • Derby (homonymie) — Derby Cette page d’homonymie répertorie les différents sujets et articles partageant un même nom. Derby est le nom de plusieurs localités à travers le Monde : Derby, en Angleterre. Derby, paroisse canadienne du Nouveau Brunswick. Derby dans… …   Wikipédia en Français

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”