Principles of transaction-oriented database recovery

Haerder, Theo; Reuter, Andreas

doi:10.1145/289.291

Cited by 913 publications

(351 citation statements)

References 17 publications

Supporting

Mentioning

342

Contrasting

Unclassified

Order By: Relevance

“…In principle, recovery demands needed to guarantee ACID behavior for transaction processing [11] may interfere with the optimization objectives P1 -P3. To achieve write avoidance and clustered writes to the maximum possible extent, the buffer manager should not be burdened with conflicting update propagation requirements.…”

Section: Independence Of Transaction Managementmentioning

confidence: 99%

“…To achieve write avoidance and clustered writes to the maximum possible extent, the buffer manager should not be burdened with conflicting update propagation requirements. Fortunately, our CFDC approach implies a NoForce/Steal policy for the logging&recovery component providing maximum degrees of freedom [11]. NoForce means that pages modified by a transaction do not have to be forced to disk at its commit, but only the redo logs.…”

Section: Independence Of Transaction Managementmentioning

confidence: 99%

“…As outlined, CFDC pe se is not constrained by recovery provisions, in particular, properties such as NoSteal or Force [11]. Such constraints could occur if orthogonality to other components would be violated.…”

Section: Further Performance Considerationsmentioning

confidence: 99%

See 2 more Smart Citations

CFDC: A Flash-Aware Buffer Management Algorithm for Database Systems

Härder

Jin

2010

Advances in Databases and Information Systems

View full text Add to dashboard Cite

Abstract. Classical buffer replacement policies, e.g., LRU, are suboptimal for database systems having flash disks for persistence, because they are not aware of the distinguished characteristics of those storage devices. We present CFDC (Clean-First Dirty-Clustered), a flash-aware buffer management algorithm, which emphasizes that clean buffer pages are first considered for replacement and that modified buffer pages are clustered for better spatial locality of page flushes. Our algorithm is complementary to and can be integrated with conventional replacement policies. Our DBMS-based performance studies using both synthetic and real-life OLTP traces reveal that CFDC significantly outperforms previous proposals with a performance gain up to 53%.

show abstract

Section: Independence Of Transaction Managementmentioning

confidence: 99%

Section: Independence Of Transaction Managementmentioning

confidence: 99%

See 1 more Smart Citation

CFDC: A Flash-Aware Buffer Management Algorithm for Database Systems

Härder

Jin

2010

Advances in Databases and Information Systems

View full text Add to dashboard Cite

show abstract

“…Traditional systems apply ACID (Atomicity, Consistency, Isolation, Durability) transactions [16], requiring that all four properties are met. Replication ("R") can synchronously be bound to transactions.…”

Section: Relationship To the Concept Of Transactionsmentioning

confidence: 99%

Middleware Support for Adaptive Dependability

Froihofer¹,

Goeschka²,

Osrael³

2007

Lecture Notes in Computer Science

View full text Add to dashboard Cite

Abstract. Generic middleware can often not provide satisfactory solutions, but neither is it acceptable to let the application developer reinvent the wheel each time. Therefore, middleware shall support reuse of infrastructural services while leaving the application in control. In particular, we contribute with a middleware approach to support adaptive dependability by balancing integrity and availability in distributed systems. To achieve this goal, we add a new middleware service for explicit runtime management of data integrity constraints. In order to provide the desired balancing with respect to an application's requirements and environment conditions, our approach supports the application developer with explicit interaction between middleware, application, and metadata. Based on our prototype implementation, we show how adaptive balancing of integrity and availability improves the overall dependability. The performance impairments of our approach are typically worth their costs in systems where the read-to-write ratio is high or write performance is not a limiting factor.

show abstract

“…The model also assumes that the system follows the STEALINO FORCE protocol [6]. As a result, it keeps both Undo and Redo type log records.…”

Section: Assumptionsmentioning

confidence: 99%

Reorganization of the Database Log for Information Warfare Data Recovery

Sobhan

Panda

2002

Database and Application Security XV

View full text Add to dashboard Cite

Abstract:Using traditional logs that contain only before and after images of data items and record neither any of the read operations nor actual mathematical or logical operations associated with an update, a complete damage assessment and repair of the database is not possible in the post Information Warf are scenario. In this research, a new logging protocol is proposed which records all appropriate information required for the complete repair of a database that was updated by committed but affected transactions. This information includes various predicates and statements used in the transaction. An algorithm to incorporate these in the log is offered. Based on this new log, a method to perform damage assessment and recovery is presented.

show abstract

Principles of transaction-oriented database recovery

Cited by 913 publications

References 17 publications

CFDC: A Flash-Aware Buffer Management Algorithm for Database Systems

CFDC: A Flash-Aware Buffer Management Algorithm for Database Systems

Middleware Support for Adaptive Dependability

Reorganization of the Database Log for Information Warfare Data Recovery

Contact Info

Product

Resources

About