Transaction-time temporal databases are inherently append-only resulting, over time, in a large historical sequence of database states. Data vacuuming allows for a strategic, and irrevocable, deletion of obsolete data.
The term vacuuming was first used in relation to databases in the Postgres database system as a mechanism for moving old data to archival storage . It was later refined by Jensen and Mark in the context of temporal databases to refer to the removal of obsolete information  and subsequently developed into a comprehensive and usable adjunct to temporal databases [6, 8, 11]. Data expiration has also been investigated in the context of data warehouses by Garcia-Molina et al.  and others .
In many applications, data about the past needs be retained for further use. This idea can be formalized, at least on the conceptual level, in terms of an append-only transaction-time temporal database or a history...
- 2.Garcia-Molina H, Labio W, Yang J. Expiring data in a warehouse. In: Proceedings of the 24th International Conference on Very Large Data Bases; 1998.p. 500–11.Google Scholar
- 5.Schmidt A, Jensen C, Saltenis S. Expiration times for data management. In: Proceedings of the 22nd International Conference on Data Engineering;2006. p. 36.Google Scholar
- 6.Skyt J. Specification-based techniques for the reduction of temporal and multidimensional data [PhD thesis]. Aalborg: Aalborg University; 2001.Google Scholar
- 7.Skyt J, Jensen CS. Vacuuming temporal databases. TimeCenter technical report TR-32, Aalborg University; 1998.Google Scholar
- 9.Skyt J, Jensen CS, Pedersen TB. Specification-based data reduction in dimensional data warehouses. In: Proceedings of the 18th International Conference on Data Engineering; 2002. p. 278.Google Scholar
- 10.Stonebraker M, Rowe L. The design of POSTGRES. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1986.p. 340–55.Google Scholar
- 11.Toman D. Expiration of historical databases. In: Proceedings of the 8th International Symposium on Temporal Representation and Reasoning; 2001. p. 128–35.Google Scholar
- 13.Toman D. On incompleteness of multi-dimensional first-order temporal logics. In: Proceedings of the 10th International Symposium on Temporal Representation and Reasoning/4th International Conference on Temporal Logic; 2003. p. 99–106.Google Scholar
- 14.Toman D. On construction of holistic synopses under the duplicate semantics of streaming queries. In: Proceedings of the 14th International Symposium on Temporal Representation and Reasoning; 2007. p. 150–62.Google Scholar