A framework for vacuuming temporal databases
A framework for vacuuming temporal databases
Evaluation of relational algebras incorporating the time dimension in databases
ACM Computing Surveys (CSUR)
ACM SIGMOD Record
On the semantics of “now” in databases
ACM Transactions on Database Systems (TODS)
SIGMOD '85 Proceedings of the 1985 ACM SIGMOD international conference on Management of data
Evolution and change in data management — issues and directions
ACM SIGMOD Record
Using Common Subexpressions to Optimize Multiple Queries
Proceedings of the Fourth International Conference on Data Engineering
Generalization and a Framework for Query Modification
Proceedings of the Sixth International Conference on Data Engineering
VLDB '98 Proceedings of the 24rd International Conference on Very Large Data Bases
Practical Applications of Triggers and Constraints: Success and Lingering Issues (10-Year Award)
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Integrating Triggers and Declarative Constraints in SQL Database Sytems
VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
A Generalized Modeling Framework for Schema Versioning Support
ADC '00 Proceedings of the Australasian Database Conference
The POSTGRES Papers
Managing versions of web documents in a transaction-time web server
Proceedings of the 13th international conference on World Wide Web
Granularity reduction in temporal document databases
Information Systems
REERM: reenhancing the entity-relationship model
Data & Knowledge Engineering - Special issue: ER 2004
Specification-based data reduction in dimensional data warehouses
Information Systems
AuditGuard: a system for database auditing under retention restrictions
Proceedings of the VLDB Endowment
Adaptive Management of Multigranular Spatio-Temporal Object Attributes
SSTD '09 Proceedings of the 11th International Symposium on Advances in Spatial and Temporal Databases
Granularity reduction in temporal document databases
Information Systems
Trustworthy vacuuming and litigation holds in long-term high-integrity records retention
Proceedings of the 13th International Conference on Extending Database Technology
A rule-based tool for gradual granular data aggregation
Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP
XCM: conceptual modeling for dynamic domains
ER'05 Proceedings of the 24th international conference on Conceptual Modeling
Auditing a database under retention policies
The VLDB Journal — The International Journal on Very Large Data Bases
Hi-index | 0.00 |
A wide range of real-world database applications, including financial and medical applications, are faced with accountability and traceability requirements. These requirements lead to the replacement of the usual update-in-place policy by an append-only policy that retain all previous states in the database. This policy result in so-called transaction-time databases which are ever-growing. A variety of physical storage structures and indexing techniques as well as query languages have been proposed for transaction-time databases, but the support for physical removal of data, termed vacuuming, has only received little attention. Such vacuuming is called for by, e.g., the laws of many countries and the policies of many businesses. Although necessary, with vacuuming, the database's perfect recollection of the past may be compromised via, e.g., selective removal of records pertaining to past states. This paper provides a semantic foundation for the vacuuming of transaction-time databases. The main focus is to establish a foundation for the correct processing of queries and updates against vacuumed databases. However, options for user, application, and database interactions in response to queries and updates against vacuumed data are also outlined.