Database archiving solutions mostly concentrate on removing selected data records from transactional and operational databases especially which are rarely referenced, and storing them in an archive from where the records can be retrieved again, as necessary. Database archiving software is crucial for large enterprises to improve on system performance, meet compliance regulations, and indirectly save on time and money. The principles of database archiving are as under:
• Assess: Determine which applications and versions are most in need of archiving, grouping them into categories based on your business requirements.
• Classify: Document functional business rules and data retention policies to govern active, inactive and compliance-managed data.
• Archive: Segregate historical business objects or transaction records from current activity. Safely move them to a secure archive.
• Store: Store archived historical records securely and cost-effectively, according to the evolving business value.
• Access: Apply service levels that provide decision makers with access to the historical records they need, when and how they need them.
• Tune: Monitor operations to verify that archive operations continue to support desired service levels and access requirements.
• Dispose: Prevent information assets from becoming information liabilities by deleting historical records after they are no longer required for compliance or business purposes.
The Sarbanes-Oxley Act, HIPAA and BASEL II are some of the laws and regulations related to data retention. It has been estimated that there are over 150 federal and state laws which elaborate extensively on the subject of data retention in the US. Today, the retention period is basically determined by the government itself. The data retention period which ranged from five to seven years are now crossing the barriers of 20 to 70 years.
Database Archiving solutions involve plucking out of selected records from operational databases which are not to be used quite often. The archived data is then stored in a non-erasable format like XML files where they can be searched and retrieved if needed.
Most database archiving solutions help in migrating data from live production databases to database archives, while managing the integrity and accessibility. Enterprises focus on satisfying three core objectives viz. Resource Management, Storage and Data Protection and Compliance with external regulations and internal policies. It is also useful for customers with applications running on Oracle or SQL Server databases that experience difficulties related to unbridled data growth, performance degradation and increased downtime.
0 comments:
Post a Comment