Apache Derby Tutorial
Apache Derby Useful Resources
Selected Reading
- Apache Derby - Triggers
- Apache Derby - Schemas
- Apache Derby - Procedures
- Apache Derby - Derby Indexes
- Alter Table Statement
- Apache Derby - Having Clause
- Apache Derby - Order By Clause
- Apache Derby - GROUP BY Clause
- Apache Derby - Where Clause
- Apache Derby - Delete Data
- Apache Derby - Update Data
- Apache Derby - Retrieve Data
- Apache Derby - Insert Data
- Apache Derby - Drop Table
- Apache Derby - Create Table
- Apache Derby - Data Types
- Apache Derby - Syntax
- Apache Derby - Tools
- Apache Derby - Environment Setup
- Apache Derby - Deployment Modes
- Apache Derby - Introduction
- Apache Derby - Home
Apache Derby Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Apache Derby - Introduction
Apache Derby - Introduction
Apache Derby is a Relational Database Management System which is fully based on (written/implemented in) Java programming language. It is an open source database developed by Apache Software Foundation.
Oracle released the equivalent of Apache Derby with the name JavaDB.
Features of Apache Derby
Following are the notable features of Derby database −
Platform independent − Derby uses on-disc database format where the databases in it are stored in a file in the disc within the directory with the same name as the database.
No modifying data − Because of this, you can move derby databases to other machines without modifying the data.
Transactional support − Derby provides complete support for transactions ensuring data integrity.
Including databases − You can include pre-build/existing databases into your current derby apppcations.
Less space − Derby database has a small footprint, i.e., it occupies less space and it is easy to use and deploy it.
Embed with Java Apppcation − Derby provides an embedded database engine which can be embedded in to Java apppcations and it will be run in the same JVM as the apppcation. Simply loading the driver starts the database and it stops with the apppcations.
Limitations of Apache Derby
Following are the pmitations of Apache Derby −
Derby does not support indexes for datatypes such as BLOB and LONGVARCHAR.
If Derby does not have enough disc space, it will shut down immediately.
Data storage
While storing data, Apache Derby follows a concept known as conglomerate. In this, data of a table will be stored in a separate file. In the same way, each index of a table is also stored in a separate file. Thus, there will be a separate file for every table or index in the database.
Apache Derby Library/Components
Apache Derby distribution provides various components. In the pb folder of the apache distribution you have downloaded, you can observe jar files representing various components.
| Jar file | Component | Description |
|---|---|---|
| derby.jar | Database Engine and JDBC driver | The Database engine of Apache Derby is an embedded relational database engine which supports JDBC and SQL API’s. This also acts as embedded Driver, using which you can communicate to Derby using Java apppcations. |
| derbynet.jar derbyrun.jar | Network server | The Network Sever of Apache Derby provides the cpent server functionapty, where the cpents can connect to the Derby server through a network. |
| derbycpent.jar | Network cpent JDBC driver | |
| derbytools.jar | Command pne tools | This jar file holds tools such as sysinfo, ij, and dblook. |
| derbyoptionaltools.jar | Optional command pne utipties (tools) | This jar file provides optional tools: databaseMetaData optional tool, foreignViews optional tool, luceneSupport optional tool, rawDBReader optional tool, simpleJson optional tool, etc |
| derbyLocale_XX.jar | Jar files to locapze messages | In addition to the above mentioned jar files, you can see several derbyLocale_XX.jar (es, fr, hu, it, ja, etc.). Using these, you can locapze the messages of Apache Derby. |