Apache Derby

From Encoresoup - The Ultimate Guide to Free/Open Source Software

Apache Derby is a Java relational database management system 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 licence. Derby was previously distributed as IBM Cloudscape. It is currently distributed as Sun Java DB.

Contents 1 Derby Technologies 1.1 Derby Embedded Database Engine 1.2 Derby Network Server 1.3 Database Utilities 2 History 3 Notes 4 See also 5 External links

[edit] Derby Technologies

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

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

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

[edit] 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 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. 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,^[2] 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.^[3]

[edit] Notes

[edit] See also

• List of relational database management systems
• Comparison of relational database management systems
• HSQLDB
• H2

[edit] External links

• Apache Derby Project
• IBM Cloudscape Site
• Internals of Derby, An Open Source Pure Java Relational Database Engine deployable in an embedded OSGi environment
• Sun Microsystems Java DB Site
• Why IBM is open sourcing Cloudscape as Derby, IBM developerWorks site
• Apache Derby SMP scalability

v • d • e Apache Software Foundation
Top level projects	ActiveMQ · Ant · Apache HTTP Server · APR · Beehive · Camel · Cayenne · Cocoon · Commons · Directory · Excalibur · Felix · Forrest · Geronimo · Gump · Harmony · HiveMind · iBATIS · Jackrabbit · James · Lenya · Maven · mod_perl · MyFaces · OFBiz · OpenEJB · OpenJPA · POI · Roller · Shale · SpamAssassin · Struts · Tapestry · Tomcat · Velocity · WebWork 2 · Wicket · XMLBeans
Other projects	Jakarta Project · Apache Lucene · Apache XML · Apache Incubator
Sub-projects	BCEL · BSF · Cactus · JMeter · Slide · Xerces · Batik · FOP · Log4j · XAP · River · ServiceMix · Log4Net · Abdera · Ivy · CXF · Hadoop
License: Apache License · Website: http://apache.org/

v • d • e Database management systems
Database models · Database normalization · Database storage · Distributed DBMS · Referential integrity · Relational algebra · Relational calculus · Relational database · Relational DBMS · Relational model · Transaction processing
Concepts	Database · ACID · Null · Candidate key · Foreign key · Primary key · Superkey · Surrogate key
Objects	Trigger · View · Table · Cursor · Log · Transaction · Index · Stored procedure · Partition
SQL	Select · Insert · Update · Merge · Delete · Join · Union · Create · Drop · Begin work · Commit · Rollback · Truncate · Alter
Implementations	Relational · Flat file · Deductive · Dimensional · Hierarchical · Network  · Document-oriented · Object-oriented · Object-relational · Temporal · XML data stores
Components	Concurrency control · Data dictionary · JDBC · ODBC · Query language · Query optimizer · Query plan
Database products: Object-oriented (comparison) · Relational (comparison)  · Document-oriented