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. Image File history File links Derby-logo. ... The Apache Software Foundation (ASF) is a non-profit corporation (classified as 501(c)3 in the United States) to support Apache software projects, including the Apache HTTP Server. ... Java is an object-oriented programming language developed primarily by James Gosling and colleagues at Sun Microsystems. ... A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by Edgar F. Codd. ... OLTP (online transaction processing) is a class of program that facilitates and manages transaction-oriented applications, typically for data entry and retrieval transactions in a number of industries, including banking, airlines, mailorder, supermarkets, and manufacturers. ... A megabyte is a unit of information or computer storage equal to one million bytes. ...

Apache Derby is developed as an Open Source project with the liberal Apache 2.0 License. Open source refers to projects that are open to the public and which draw on other projects that are freely available to the general public. ...

Derby is also distributed as IBM Cloudscape and Sun Java DB. International Business Machines Corporation (IBM, or colloquially, Big Blue) NYSE: IBM (incorporated June 15, 1911, in operation since 1888) is headquartered in Armonk, NY, USA. The company manufactures and sells computer hardware, software, infrastructure services and consulting services. ... Sun Microsystems, Inc. ...

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. Java Database Connectivity, or JDBC, is an API for the Java programming language that defines how a client may access a database. ... SQL (commonly expanded to Structured Query Language - see History for the terms derivation) is the most popular computer language used to create, modify and retrieve data from relational database management systems. ...

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. Distributed Relational Database Architecture is a database interoperability standard from The Open Group. ... Java Database Connectivity, or JDBC, is an API for the Java programming language that defines how a client may access a database. ... Open Database Connectivity (ODBC) is a standard software API for connecting to database management systems (DBMS). ... CLI is an acronym (or, strictly speaking, an initialism) for Command line interface Call Level Interface Common language interface (Commonly believed, but not official for Common Language Infrastructure) Common Language Infrastructure CLear Interrupts Composite Leading Indicator Caller Line Identification (telephony) Celebrity Love Island Critical Language Institute This page concerning a... Perl, also Practical Extraction and Report Language (a backronym, see below) is an interpreted procedural programming language designed by Larry Wall. ... PHP, short for PHP: Hypertext Preprocessor, is an open-source, reflective programming language used mainly for developing server-side applications and dynamic web content, and more recently, other software. ...

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

Cloudscape Inc, an Oakland, California start-up, was 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. View of downtown Oakland looking west across Lake Merritt. ... Official language(s) English Capital Sacramento Largest city Los Angeles Area  - Total  - Width  - Length  - % water  - Latitude  - Longitude Ranked 3rd 410,000 km² 402. ... 1996 (MCMXCVI) is a leap year starting on Monday of the Gregorian calendar, and was designated the International Year for the Eradication of Poverty. ... A database is an organized collection of data. ... 1997 (MCMXCVII) is a common year starting on Wednesday of the Gregorian calendar. ... IBM Cloudscape (now open sourced as Apache Derby) is a pure, open source-based Java Relational Database Management System that can be embedded in Java programs and used for online transaction processing (OLTP). ... 1999 (MCMXCIX) was a common year starting on Friday, and was designated the International Year of Older Persons by the United Nations. ... Informix is a family of relational database management system products from IBM, acquired in 2001 from a company (also called Informix or Informix Software) which dates its origins back to 1980. ... International Business Machines Corporation (IBM, or colloquially, Big Blue) NYSE: IBM (incorporated June 15, 1911, in operation since 1888) is headquartered in Armonk, NY, USA. The company manufactures and sells computer hardware, software, infrastructure services and consulting services. ... The Apache Software Foundation (ASF) is a non-profit corporation (classified as 501(c)3 in the United States) to support Apache software projects, including the Apache HTTP Server. ...

See also

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

// Proprietary software 4th Dimension Dataphor Daffodil database DB2 FileMaker Pro Informix InterBase Matisse [1] Microsoft Access Microsoft SQL Server Microsoft Visual FoxPro Mimer SQL Netezza NonStop SQL Oracle Progress 4GL Sand Analytic Server (formerly known as Nucleus) SmallSQL Sybase Adaptive Server Anywhere (formerly known as Watcom SQL) Sybase Adaptive Server... The following tables compare general and technical information for a number of relational database management systems. ...

External links

• IBM Cloudscape Site
• Apache Derby Project
• Why IBM is open sourcing Cloudscape as Derby, IBM developerWorks site