Apache Derby is an open source relational database implemented in java
It uses SQL standard
Why and when to choose Apache Derby
It has a small footprint of 3.5 mb for base engine and embeded JDBC driver
Supports Embeded Derby as well as Client and Network Server.
Easy to deploy install and use.
The on-disk database format used by Derby is portable and platform-independent.
Standard base : Derby adheres to database standards such as JDBC and the ANSI/ISO SQL specification. This means that Derby provides modern relational database functionality, including SQL syntax, transaction management, concurrency, triggers, and online backups. It also means that developers can migrate easily to other databases later on.
Secure : Derby provides secure data management appropriate to the environment where the engine runs. While traditional enterprise database systems rely on machines being physically isolated in a locked room, Derby databases often reside on unprotected laptops and other unattended hardware.
What is Embedded Derby ?
When an application accesses a Derby database using the Embedded Derby JDBC driver, the Derby engine does not run in a separate process, and there are no separate database processes to start up and shut down. Instead, the Derby database engine runs inside the same Java Virtual Machine (JVM) as the application. So, Derby becomes part of the application just like any other jar file that the application uses.
Derby Network Server Architecture
What is an IJ Server ?
a tool that allows SQL scripts to be executed against any JDBC database, including non-Derby databases.
ij is an interactive SQL scripting tool that comes with Derby. It can be used with the Derby Embedded JDBC driver or with a client JDBC driver, such as the Derby Network Client.
What is a dblook tool?
a schema extraction tool for a Derby database.
What is a sysinfo tool?
a utility to display version numbers and class path
What is Derby Engine?
There are four main code areas: JDBC, SQL, Store and Services.
What is Derby Network Client ?
The Derby network server provides traditional client/server access to the Derby engine. The network server lets clients connect over TCP/IP using a subset of the DRDA protocol. The network server supports connections from networked JDBC, ODBC/CLI, Perl, and PHP clients.
