ADR-004 — SQL based data store

ADR

ADR-004

Title

SQL based data store

State

Accepted

Author

klenkes74

Decision Body

klenkes74

Valid from

2024-10-04

Expires

./.

1. Context

The default data store for the DCIS is a relational database. There are different approaches to handle RDBMs in java.

There may be other datastores (so called no-sql). These are neither handled by this ADR nor forbidden to be used in this project.

2. Decision

To handle SQL databases we use JPA. It is a quite well known standard and well supported within the java ecosystem. For spring we use the spring-data-jpa framework to handle the low level OR mapping.

3. Consequences

  1. There is no low level efficiency optimization to our queries.

  2. The restrictions of spring-data-jpa apply.