Flashback Data Archive

Maclean Liu(刘相兵

Data History and Retention

Data retention and change control requirements are growing
Regulatory oversight and Compliance
Sarbanes-Oxley, HIPAA, Basel-II, Internal Audit
Business needs
Extract “temporal” dimension of data
Understand past behavior and manage customer relationships profitably
Failure to maintain appropriate history & retention is expensive
Legal risks
Loss of Reputation
Current approaches to manage historical data are inefficient and often ineffective


Introducing Flashback Data Archive

Transparently tracks historical changes to all Oracle data in a highly secure and efficient manner
Historical data is stored in the database and can be retained for as long as you want
Special kernel optimizations to minimize performance overhead of capturing historical data
Historical data is stored in compressed form to minimize storage requirements
Automatically prevents end users from changing historical data
Seamless access to archived historical data
Using “AS OF” SQL construct
Extremely easy to set up
enable history capture in minutes!
Completely transparent to applications
Centralized and automatic management
policy-based
multiple tables can share same Retention and Purge policies
automatic purge of aged history
11g_high_availability.ppt (1.52 MB, 下载次数: 5, 售价: 19 金钱)

2012-2-29 00:07 上传

点击文件名下载附件
售价: 19 金钱  [记录]