DataTerminology.comNEW
Flagging records as deleted without removing them to enable recovery, auditing, and compliance.
DESCRIPTION
Soft delete marks data as deleted via a flag or tombstone rather than physically removing it. It supports restoration, auditability, and retention policies, reducing accidental loss and aiding investigations. Many systems implement soft delete with versioning or delete markers. However, it increases storage use and requires careful query filtering to exclude soft-deleted data. It is common in applications, databases, object stores, and compliance-sensitive domains.
ALTERNATIVE DEFINITIONS
Microsoft Learn
Soft delete for blobs enables you to recover data when blobs or blob snapshots are accidentally deleted.
Focuses on blob storage with recovery capabilities for accidental deletion.
AWS
When you enable versioning, deleting an object does not permanently remove it. Instead, Amazon S3 inserts a delete marker.
Explains the delete marker pattern as soft deletion in object storage.
RELATED TERMS
Logical Deletion Data Retention Transaction Audit Data Tombstone Versioning Undelete Temporal Tables Compliance
COMPETING TERMS
Hard Delete
KNOWLEDGE AREAS
Data Management Data Storage & Operations Data Privacy & Compliance
TARGET AUDIENCE
Data Engineer Software Developer Data Architect Data Steward Security Architect
EXTERNAL SOURCES
- Wikipedia - Deletion (computer science)
- Microsoft - Azure blob soft delete overview
- AWS - S3 versioning and delete markers
- MySQL - Patterns for logical deletion
TOP QUESTIONS
Why use soft delete in applications?
It allows recovery from accidental deletions, supports auditing, and aligns with retention policies.
Category: Relevancy
How is soft delete implemented in databases?
Add a boolean or timestamp flag and filter queries to exclude soft-deleted records.
Category: How-To
What are risks of soft delete?
Data can persist longer than intended, increasing storage costs and privacy risks if not governed.
Category: Risks
How does soft delete work in object storage?
Versioning adds delete markers rather than removing objects, enabling restoration.
Category: Explanation
What is a tombstone record?
A marker indicating logical deletion, used to manage state and prevent resurrection conflicts.
Category: Definition
How does soft delete affect performance?
It may require additional filtering and indexing, impacting query complexity.
Category: Opinion
How to manage compliance with soft delete?
Implement retention schedules, purging policies, and audit logs to meet regulatory requirements.
Category: Compliance
What’s a common mistake with soft delete?
Failing to consistently exclude soft-deleted records in queries, causing data anomalies.
Category: Mistakes
What is the alternative to soft delete?
Hard delete permanently removes records; choose based on compliance and recovery needs.
Category: Alternatives