Database & Persistence Architecture¶
The CIS platform relies on Oracle Database 23 as its primary system of record for transactional cadastral land management, workflow tracking, and identity metadata.
Documentation Guides¶
- Oracle Flyway Baseline: Database schema migration conventions, baseline script naming, and execution standards.
- Mapper Constructor Injection: Architectural pattern deprecating field injection in MapStruct mappers in favor of constructor injection for immutability and testability.
- Persistence Package Audit: Complete audit of JPA entities, query bottlenecks, and N+1 query remediations.
Best Practices¶
- Explicit Schema Migrations: All DDL changes must be committed as versioned Flyway migration scripts (
V<SemVer>__description.sql). - Read-Only Transactions: Use
@Transactional(readOnly = true)for service read queries to avoid unnecessary Hibernate dirty-checking overhead. - Constructor Injection: Never use
@Autowiredfield injection in entities, mappers, or repositories.