Apache Derby is a Relational Database Management System which is completely founded on (composed/actualized in) Java programming language. It is an open source data set created by Apache Software Foundation.
Prophet delivered what might be compared to Apache Derby with the name JavaDB.
Features of Apache Derby
Following are the remarkable highlights of Derby information base −
- Stage autonomous − Derby utilizes on-circle information base arrangement where the data sets in it are put away in a document in the plate inside the catalog with a similar name as the data set.
- No changing information − Because of this, you can move derby data sets to different machines without altering the information.
- Value-based help − Derby offers total help for exchanges guaranteeing information honesty.
- Counting information bases − You can incorporate pre-form/existing data sets into your present derby applications.
- Less space − Derby information base has a little impression, i.e., it consumes less space and it is not difficult to utilize and send it.
- Implant with Java Application − Derby gives an inserted information base motor which can be installed in to Java applications and it will be run in a similar JVM as the application. Essentially stacking the driver begins the information base and it stops with the applications.
Limitations of Apache Derby
Following are the constraints of Apache Derby −
- Derby doesn't uphold records for datatypes, for example, BLOB and LONGVARCHAR.
- In the event that Derby needs more circle space, it will close down right away.
While putting away information, Apache Derby follows an idea known as combination. In this, information of a table will be put away in a different record. Similarly, each list of a table is additionally put away in a different record. Consequently, there will be a different record for each table or file in the data set.
Apache Derby Library/Components
Apache Derby dissemination gives different segments. In the lib envelope of the apache appropriation you have downloaded, you can notice container records speaking to different segments.
|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 applications.
|derbynet.jar derbyrun.jar||Network server||
The Network Sever of Apache Derby provides the client server functionality, where the clients can connect to the Derby server through a network.
|derbyclient.jar||Network client JDBC driver|
|derbytools.jar||Command line tools||This jar file holds tools such assysinfo, ij, anddblook.|
|derbyoptionaltools.jar||Optional command line utilities (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 localize 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 localize the messages of Apache Derby.