Abstract: A continuous set of committed transactions can be lost without destroying the integrity of the database, by deferring the writing of the database pages stored in cache to the database on stable storage. A waypoint tracks a point in the transaction log following which transactions have not been applied to the database on stable storage and thus records after the waypoint are not needed for recovery to a consistent database. When there is a failover of an active database on Node A to a passive database on Node B, log records are compared starting with the most current and moving backwards and the point at which divergence in the log occurs is determined. When the lost portion of the log occurs after the point indicated by after the waypoint, the database is recoverable by log-based incremental reseed.

Abstract: Techniques to enhance database performance are described. An apparatus may comprise an enhanced DBMS arranged to manage storage operations for tree data structures in a storage component. The enhanced DBMS may comprise a defragment detector module operative to identify a tree data structure as having a sequential data retrieval pattern. The enhanced DBMS may also comprise a defragment decision module communicatively coupled to the defragment detector module, the defragment decision module operative to determine whether to defragment the tree data structure, and output a defragment signal. The enhanced DBMS may further comprise a defragment manager module communicatively coupled to the defragment decision module, the defragment manager module operative to defragment the tree data structure in accordance with the defragment signal to reduce input/output operations for the storage component. Other embodiments are described and claimed.

Abstract: A continuous set of committed transactions can be lost without destroying the integrity of the database, by deferring the writing of the database pages stored in cache to the database on stable storage. A waypoint tracks a point in the transaction log following which transactions have not been applied to the database on stable storage and thus records after the waypoint are not needed for recovery to a consistent database. When there is a failover of an active database on Node A to a passive database on Node B, log records are compared starting with the most current and moving backwards and the point at which divergence in the log occurs is determined. When the lost portion of the log occurs after the point indicated by after the waypoint, the database is recoverable by log-based incremental reseed.