闪回数据存档.pdf
Oracle Database 11g 中的闪回数据归档特性克服了大部分这些限制。它会自动跟踪对存储在数据库中的数据的每次更改,从而维护安全、高效且易于访问的历史数据存档。只要业务需要,捕获的历史数据就会保留,并且可以使用标准 SQL 结构轻松访问。可以立即为现有表和新表启用历史数据跟踪,更重要的是,以对应用程序完全透明的方式启用。闪回数据归档在数据库中本地实施,它提供了一个高性能、存储优化的解决方案和一个集中的管理界面,以满足企业数据保留和更改控制的需求。使用 Flashback Data Archive 进行历史记录跟踪的主要优点包括:
(The flashback data archiving feature in Oracle Database 11g overcomes most of these limitations. It automatically tracks every change to the data stored in the database, thus maintaining a secure, efficient, and easily accessible historical data archive. As long as the business needs, the captured historical data will be retained and can be easily accessed using the standard SQL structure. Historical data tracking can be enabled immediately for existing and new tables, and more importantly, in a way that is completely transparent to the application.
Implemented locally in the database, flashback data archiving provides a high-performance, storage optimized solution and a centralized management interface to meet the needs of enterprise data retention and change control. The main advantages of using flashback data archive for history tracking include:)
页:
[1]