ADR-004 — SQL based data store
Table of Contents
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
-
There is no low level efficiency optimization to our queries.
-
The restrictions of spring-data-jpa apply.