Skip to content

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

  1. Explicit Schema Migrations: All DDL changes must be committed as versioned Flyway migration scripts (V<SemVer>__description.sql).
  2. Read-Only Transactions: Use @Transactional(readOnly = true) for service read queries to avoid unnecessary Hibernate dirty-checking overhead.
  3. Constructor Injection: Never use @Autowired field injection in entities, mappers, or repositories.