Compare with
Comparison of EclipseLink with H2 embedded vs DataNucleus with HSQLDB server
Each of the following tables focuses on a specific database operation, where the last table presents average results comparison.
Speed comparison of JPA database persistence operations (normalized score, higher is better)
| Transaction Size => | Few Entities | Many Entities | Average Score | |||
|---|---|---|---|---|---|---|
| EclipseLink H2 embedded | DataNucleus HSQLDB server | EclipseLink H2 embedded | DataNucleus HSQLDB server | EclipseLink H2 embedded | DataNucleus HSQLDB server | |
| Basic Person Test | 15.4 | failed | 12.9 | failed | 14.2 | failed |
| Element Collection Test | 14.1 | failed | 8.4 | failed | 11.3 | failed |
| Inheritance Test | 8.4 | failed | 9.7 | failed | 9.1 | failed |
| Indexing Test | 15.5 | failed | 14.2 | failed | 14.9 | failed |
| Graph (Binary Tree) Test | 8.5 | failed | 7.1 | failed | 7.8 | failed |
| Multithreading Test | 12.3 | failed | 0.0000 | failed | 6.1 | failed |
| All Tests | 12.4 | failed | 8.7 | failed | 10.5 | failed |
DataNucleus with HSQLDB server has failed in 12 tests (see exceptions).
Speed comparison of JPA database retrieval operations (normalized score, higher is better)
| Retrieval Size => | Few Entities | Many Entities | Average Score | |||
|---|---|---|---|---|---|---|
| EclipseLink H2 embedded | DataNucleus HSQLDB server | EclipseLink H2 embedded | DataNucleus HSQLDB server | EclipseLink H2 embedded | DataNucleus HSQLDB server | |
| Basic Person Test | 18.6 | failed | 30.2 | failed | 24.4 | failed |
| Element Collection Test | 16.3 | failed | 21.5 | failed | 18.9 | failed |
| Inheritance Test | 19.7 | failed | 27.1 | failed | 23.4 | failed |
| Indexing Test | 17.9 | failed | 29.1 | failed | 23.5 | failed |
| Graph (Binary Tree) Test | 5.9 | failed | 18.3 | failed | 12.1 | failed |
| Multithreading Test | 26.9 | failed | 39.9 | failed | 33.4 | failed |
| All Tests | 17.6 | failed | 27.7 | failed | 22.6 | failed |
DataNucleus with HSQLDB server has failed in 12 tests (see exceptions).
Speed comparison of JPA database query operations (normalized score, higher is better)
| Retrieval Size => | Few Entities | Many Entities | Average Score | |||
|---|---|---|---|---|---|---|
| EclipseLink H2 embedded | DataNucleus HSQLDB server | EclipseLink H2 embedded | DataNucleus HSQLDB server | EclipseLink H2 embedded | DataNucleus HSQLDB server | |
| Basic Person Test | 3.5 | failed | 12.2 | failed | 7.8 | failed |
| Element Collection Test | 7.6 | failed | 10.1 | failed | 8.9 | failed |
| Inheritance Test | 2.2 | failed | 12.3 | failed | 7.3 | failed |
| Indexing Test | 11.5 | failed | 21.6 | failed | 16.6 | failed |
| Multithreading Test | 3.2 | failed | 12.0 | failed | 7.6 | failed |
| All Tests | 5.6 | failed | 13.6 | failed | 9.6 | failed |
DataNucleus with HSQLDB server has failed in 10 tests (see exceptions).
Speed comparison of JPA database update operations (normalized score, higher is better)
| Transaction Size => | Few Entities | Many Entities | Average Score | |||
|---|---|---|---|---|---|---|
| EclipseLink H2 embedded | DataNucleus HSQLDB server | EclipseLink H2 embedded | DataNucleus HSQLDB server | EclipseLink H2 embedded | DataNucleus HSQLDB server | |
| Basic Person Test | 21.0 | failed | 9.3 | failed | 15.1 | failed |
| Element Collection Test | 26.7 | failed | 12.3 | failed | 19.5 | failed |
| Inheritance Test | 15.6 | failed | 14.0 | failed | 14.8 | failed |
| Indexing Test | 53.2 | failed | 12.4 | failed | 32.8 | failed |
| Graph (Binary Tree) Test | 11.4 | failed | 6.1 | failed | 8.7 | failed |
| Multithreading Test | 14.9 | failed | 6.6 | failed | 10.7 | failed |
| All Tests | 23.8 | failed | 10.1 | failed | 17.0 | failed |
DataNucleus with HSQLDB server has failed in 12 tests (see exceptions).
Speed comparison of JPA database removal operations (normalized score, higher is better)
| Transaction Size => | Few Entities | Many Entities | Average Score | |||
|---|---|---|---|---|---|---|
| EclipseLink H2 embedded | DataNucleus HSQLDB server | EclipseLink H2 embedded | DataNucleus HSQLDB server | EclipseLink H2 embedded | DataNucleus HSQLDB server | |
| Basic Person Test | 43.5 | failed | 29.0 | failed | 36.2 | failed |
| Element Collection Test | 31.5 | failed | 3.9 | failed | 17.7 | failed |
| Inheritance Test | 49.9 | failed | 20.7 | failed | 35.3 | failed |
| Indexing Test | 83.8 | failed | 15.9 | failed | 49.9 | failed |
| Graph (Binary Tree) Test | 35.3 | failed | 39.8 | failed | 37.6 | failed |
| Multithreading Test | 28.0 | failed | 0.0000 | failed | 14.0 | failed |
| All Tests | 45.3 | failed | 18.2 | failed | 31.8 | failed |
DataNucleus with HSQLDB server has failed in 12 tests (see exceptions).
Comparison of JPA/Database speed - the averages (normalized score, higher is better)
| Transaction/Retrieval Size | Few Entities | Many Entities | Average Score | |||
|---|---|---|---|---|---|---|
| EclipseLink H2 embedded | DataNucleus HSQLDB server | EclipseLink H2 embedded | DataNucleus HSQLDB server | EclipseLink H2 embedded | DataNucleus HSQLDB server | |
| Basic Person Test | 20.4 | failed | 18.7 | failed | 19.6 | failed |
| Element Collection Test | 19.2 | failed | 11.2 | failed | 15.2 | failed |
| Inheritance Test | 19.2 | failed | 16.8 | failed | 18.0 | failed |
| Indexing Test | 36.4 | failed | 18.7 | failed | 27.5 | failed |
| Graph (Binary Tree) Test | 15.3 | failed | 17.8 | failed | 16.5 | failed |
| Multithreading Test | 17.0 | failed | 11.7 | failed | 14.4 | failed |
| All Tests | 21.5 | failed | 15.7 | failed | 18.6 | failed |
Other Head to Head DBMS/JPA Comparisons
EclipseLink with H2 embedded against:
- Oracle Database 11g
- IBM DB2 10
- Microsoft SQL Server 2008
- DataNucleus with Derby embedded
- DataNucleus with H2 embedded
- DataNucleus with HSQLDB embedded
- DataNucleus with SQLite embedded
- DataNucleus with DB4O embedded
- DataNucleus with Derby server
- DataNucleus with H2 server
- DataNucleus with HSQLDB server
- DataNucleus with MySQL server
- DataNucleus with PostgreSQL server
- EclipseLink with Derby embedded
- EclipseLink with HSQLDB embedded
- EclipseLink with Derby server
- EclipseLink with H2 server
- EclipseLink with HSQLDB server
- EclipseLink with MySQL server
- EclipseLink with PostgreSQL server
- Hibernate with Derby embedded
- Hibernate with H2 embedded
- Hibernate with HSQLDB embedded
- Hibernate with Derby server
- Hibernate with H2 server
- Hibernate with HSQLDB server
- Hibernate with MySQL server
- Hibernate with PostgreSQL server
- OpenJPA with Derby embedded
- OpenJPA with H2 embedded
- OpenJPA with HSQLDB embedded
- OpenJPA with Derby server
- OpenJPA with H2 server
- OpenJPA with HSQLDB server
- OpenJPA with MySQL server
- OpenJPA with PostgreSQL server
- ObjectDB embedded
- ObjectDB server
DataNucleus with HSQLDB server against:
- Oracle Database 11g
- IBM DB2 10
- Microsoft SQL Server 2008
- DataNucleus with Derby embedded
- DataNucleus with H2 embedded
- DataNucleus with HSQLDB embedded
- DataNucleus with SQLite embedded
- DataNucleus with DB4O embedded
- DataNucleus with Derby server
- DataNucleus with H2 server
- DataNucleus with MySQL server
- DataNucleus with PostgreSQL server
- EclipseLink with Derby embedded
- EclipseLink with H2 embedded
- EclipseLink with HSQLDB embedded
- EclipseLink with Derby server
- EclipseLink with H2 server
- EclipseLink with HSQLDB server
- EclipseLink with MySQL server
- EclipseLink with PostgreSQL server
- Hibernate with Derby embedded
- Hibernate with H2 embedded
- Hibernate with HSQLDB embedded
- Hibernate with Derby server
- Hibernate with H2 server
- Hibernate with HSQLDB server
- Hibernate with MySQL server
- Hibernate with PostgreSQL server
- OpenJPA with Derby embedded
- OpenJPA with H2 embedded
- OpenJPA with HSQLDB embedded
- OpenJPA with Derby server
- OpenJPA with H2 server
- OpenJPA with HSQLDB server
- OpenJPA with MySQL server
- OpenJPA with PostgreSQL server
- ObjectDB embedded
- ObjectDB server
