4 ms·
Every database architecture that exists today is designed with the deep assumption that scalable fine-grained deletion will never be required, largely because w
by solipsism 8y ago
Every database architecture that exists today is designed with the deep assumption that scalable fine-grained deletion will never be required, largely because we don't have good computer science for how to do it
Can you explain this? Are you talking about something different from deleting individual rows?
- jandrewrogers 8y agoA "row" is a logical abstraction. It doesn't exist as a physical thing in many database systems, especially modern ones. Furthermore, "delete" is commonly defined as "will not be returned in a future selection operation" -- there is no implication that any data is physically deleted and permanently inaccessible. Avoiding physical deletion is done for very good technical reasons to support features and performance that everyone is accustomed to in a database.