Source: dzone.com
To Delete or to Soft Delete, That is the Question!Category: Database, Data
by It allows you to mark some records as deleted without actual erasure from the database.
Consider the following requirements in addition to “simple data restore” before making a decision on using soft deletion in your project: If you see that your business requirements match the list above, it means that you may need to implement the “Soft Delete” feature in your application.
You just add the “Is_Deleted” or “Delete_Date” column to your tables (or attributes to your Document) and replace all delete statement invocations in your application code to updates.
To comply with this you still need to implement a “purge” process in addition to soft delete.
Consider the following requirements in addition to “simple data restore” before making a decision on using soft deletion in your project: If you see that your business requirements match the list above, it means that you may need to implement the “Soft Delete” feature in your application.
You just add the “Is_Deleted” or “Delete_Date” column to your tables (or attributes to your Document) and replace all delete statement invocations in your application code to updates.
To comply with this you still need to implement a “purge” process in addition to soft delete.
Related Articles
Community Partners
DevOps Careers