Flashback Management for Reconstructing the Database Image

Security, integrity, and data consistency are integral parts of relational database systems. Transaction management allows you to transfer the database from one consistent image to another. It must be ensured that any change in the confirmed transaction is consistent, satisfying all integrity rules and constraints. Some rules do not need to be applied immediately during the operation’s execution typically related to referential integrity. However, to reach COMMIT (transaction approval), all data constraints must be passed.

In this chapter, we will look at how transaction logs can be used to retrieve historical versions of objects. We looked at the Flashback data archive in Chapter 10. Now, we will discuss Flashback technology, with which it is possible to reconstruct states that were valid in the past. Flashback operations can be applied at multiple levels, from the whole database to attributes defined by the queries...