Integrity by Design – Data-Engineering und Governance einer Drei-Mandanten-Migration auf eine Multi-Tenant-Plattform
摘要
Live multi-tenant platform migrations create integrity and audit risks because legacy systems, the migration process, and the target platform mutate state concurrently. Yet migration is often treated as a one-off data move rather than a repeatable process with explicit integrity gates. Based on a case with three tenants, this paper develops Integrity by Design: tenant-specific logic is encapsulated via the Strategy Pattern, while orchestration, metadata, audit trails, and rollback centrally enforce integrity. Migration state is persisted in a lakehouse, including old-to-new primary key mappings. A global assertion over monetary states acts as a per-batch release gate. The paper specifies a reference architecture for the MigrationService that couples transformation and orchestration through Design by Contract and operationalizes integrity as a design principle. It further articulates governance as the coupling of control objectives, technical mechanisms, and a staged rollout.