DataChange Logo DataChange Case Files

Data Ownership

Cases about definition gaps, ownership drift, and ambiguous business rules in database schema evolution.

Data Ownership in Schema Evolution

Data ownership determines who is responsible for defining, maintaining, and approving changes to a data element. When ownership is clear, schema changes follow a predictable approval path. When ownership is ambiguous or absent, changes are deployed without review, definitions drift across teams, and the database becomes a source of conflicting business metrics rather than a shared source of truth.

This section of the archive collects case files where the central issue is not the technical execution of a change but the question of who had the authority to make it, who should have been consulted, and what happened when no one was. These cases are particularly valuable for organizations establishing data governance frameworks or migrating to distributed ownership models.

Definition Gaps

A definition gap occurs when a column or field has no documented business meaning. The database stores a value, applications read and write it, but no team can articulate what the value represents in business terms. Definition gaps are often discovered during schema changes, when engineers attempt to modify a field and realize they cannot determine the correct migration logic without knowing the original intent.

Cases in this category document the investigation process used to reconstruct field meanings from application code, historical commit messages, and stakeholder interviews. They also record the documentation artifacts created to close the gap and prevent recurrence.

Ownership Drift

Ownership drift happens when responsibility for a data element moves from one team to another without formal handoff. A field originally maintained by the platform team becomes critical to the analytics team, but the platform team continues to modify it without notifying downstream consumers. Over time, the field serves multiple masters with conflicting requirements, and changes that benefit one team break workflows for another.

The archive records cases where ownership drift was identified only after a change caused downstream failures. Each case traces the historical path of responsibility transfer and documents the governance structure implemented to make ownership explicit going forward.

Ambiguous Business Rules

Business rules encoded in database structures are not always as unambiguous as the schema suggests. A boolean flag named is_active may mean "logged in within 30 days" to the product team, "has a valid subscription" to the billing team, and "appears in the customer directory" to the marketing team. When the definition changes, each team experiences a different impact.

Cases in this category examine the consequences of modifying fields with multiple competing interpretations. They document the cross-team negotiation process, the compromise decisions reached, and the technical safeguards implemented to prevent silent metric shifts.

Organizational Cost of Unowned Data

  • Delayed changes. When no owner can approve a modification, changes stall in review limbo while teams negotiate responsibility.
  • Silent metric corruption. Unowned fields change without notification, causing downstream reports to shift meaning without any visible trigger.
  • Duplicate field proliferation. Rather than resolving ownership disputes, teams create parallel fields with slightly different definitions, increasing maintenance burden and data inconsistency.
  • Erosion of trust. Repeated incidents of unowned data causing downstream failures lead stakeholders to distrust the database as a source of truth.

Reading Guidance

Data ownership cases are inherently cross-functional and are best read alongside the Reporting Impact archive, since ownership failures frequently manifest as metric discrepancies. Readers responsible for data governance initiatives should focus on the final decision and review sections, which document the governance structures established after each incident.

Note: Cases in this section focus on ownership and definition issues as the primary subject. Incidents where ownership was a contributing factor but not the main trigger are referenced within cases in other categories.