Derby is a lightweight relational database implemented completely in Java. Using the JDBC driver provided, Derby can be embedded in any Java applications.[05][06]
- Source Code
- https://github.com/apache/derby[02]
- Developer
- Country of Origin
- US
- Start Year
- 1997 [07]
- Former Names
- JBMS, Cloudscape, Java DB
- Acquired By
- Project Type
- Open Source
- Written in
- Java
- Supported Languages
- Java
- Derived From
- Aerospike
- Operating System
- All OS with Java VM
- License
- Apache v2
History[07]
In 1997, Cloudscape Inc., a start-up in Oakland, California, developed a database engine called JBMS, which was later renamed as Cloudscape. From 1999 to 2001, Cloudscape was acquired first by Informix Software, and by IBM, and its name was changed to IBM Cloudscape. In 2004, IBM contributed the code to the Apache Software Foundation as Derby. In 2005, Derby became a Apache DB subproject.
Foreign Keys[08]
Foreign key is implemented as one of the CONSTAINT clauses. There are two levels of CONSTAINTS, column level and table level. Foreign key constraint in a column level enforces that the values in the column must corresponds to the values in the referenced column marked as primary key or unique key. Table level constraint works similarly, but it is for multiple columns.
Insert, update or delete instructions will be rejected with a statement exception if the foreign key constraint is violated. The constraint check can be at statement execution or commit depending on the constraint mode. (IMMEDIATE or DEFERRED).
Splice Machine
Citations
8 sources- Apache Derby apache.org
- GitHub - apache/derby: Mirror of Apache Derby · GitHub github.com
- Apache Derby: Documentation apache.org
- Apache Derby - Wikipedia wikipedia.org
- https://wiki.apache.org/db-derby/ apache.org
- Apache Derby apache.org
- Apache Derby Project Charter apache.org
- CONSTRAINT clause apache.org