🧹Data Deletion

NEW

Also known as: Data Removal

Removing data records from systems according to retention policies and operational needs.

DESCRIPTION

Data deletion eliminates records from active systems, either logically (soft delete) or physically (hard delete). It supports privacy rights—such as the GDPR right to erasure—and reduces storage and security exposure. Implementations vary by system: databases may mark rows as deleted, create tombstones for replication, or physically remove pages. Deletion should consider dependencies, indexes, caches, logs, and backups to ensure consistency. Clear procedures and verification prevent accidental loss and support auditability.

ALTERNATIVE DEFINITIONS

Wikipedia

File deletion is the removal of a file from a computer’s file system.

Explains deletion at the file-system level rather than at the database or application layer.

Source

General Data Protection Regulation (EU) 2016/679

The data subject shall have the right to obtain from the controller the erasure of personal data concerning him or her without undue delay.

Defines the right to erasure as a legal basis for deletion in privacy contexts.

Source

RELATED TERMS

Hard Delete Right to be Forgotten Data Retention Data Archival Tombstone Garbage Collection Backup and Recovery Data Lifecycle Management GDPR

COMPETING TERMS

Soft Delete

KNOWLEDGE AREAS

Data Management Data Privacy & Compliance Data Storage & Operations Software Engineering

TARGET AUDIENCE

Data Engineer Software Developer Data Steward Data Governance Manager DevOps Engineer Chief Information Officer

EXTERNAL SOURCES

• Wikipedia - Deletion (computing)
• PostgreSQL - SQL DELETE command documentation
• Microsoft - Considerations for deletion with encryption

TOP QUESTIONS

What is the difference between Data Deletion and Data Purging?

Deletion removes data from active use, sometimes recoverable via backups; purging irreversibly disposes of data across copies. Policies determine when each applies.

Category: Alternatives

What is Soft Delete in the context of Data Deletion?

Soft delete marks records as deleted without physically removing them, enabling recovery and audit. It’s common in SaaS and event-sourced systems.

Category: Example

How does the GDPR Right to Erasure relate to Data Deletion?

It requires controllers to delete personal data when conditions are met. Implementations must propagate deletion to downstream systems and processors.

Category: Compliance

What are common mistakes in Data Deletion?

Forgetting replicas, caches, or search indexes; deleting without verifying dependencies; and failing to update metadata or lineage are frequent missteps.

Category: Mistakes

How should backups be handled during Data Deletion?

Backups should be encrypted with rotation policies and expire per retention schedules. Some organizations employ crypto-shredding to render old backups unreadable.

Category: Management

What performance impacts can Data Deletion have?

Large deletes can cause table bloat, fragmentation, or long locks. Use partitioning, batching, and vacuum/compaction to mitigate.

Category: Risks

How do tombstones relate to Data Deletion in distributed systems?

Tombstones record deletions for eventual consistency and anti-entropy. They prevent resurrecting deleted records during replication.

Category: Example

When should logical deletion be preferred over physical deletion?

Choose logical deletion when auditability, undo capability, or referential integrity is critical. Use physical deletion for strict retention or cost optimization.

Category: Opinion

What is a hot topic in Data Deletion today?

Automating subject erasure requests across third-party SaaS and data lakes, with evidence of completion, is increasingly demanded by regulators and customers.

Category: Topic