The delete operation terminates the validity of a given tuple. It stores the information in the database that a certain item is no longer valid. This operation can either be of physical or logical nature. A physical delete operation removes an item from the database so that it is no longer physically accessible. In contrast, a logical delete operation only terminates the validity of an item in the dataset, but keeps the tuple still available for temporal queries [Pla09].
- [Pla09]H. Plattner, A common database approach for OLTP and OLAP using an in-memory column database, in SIGMOD, pp. 1–2, 2009Google Scholar