As the time goes on any database system can suffer from performance issues due to large volume of data. Once data volume is high, it uses more resources hence system performance get dropped. To avoid such cases, data which is no longer used by the system should be removed from the database and kept in a separate place for later references. During archiving, data is automatically compressed by up to a factor of 5.
This process is known as Archiving.
Advantages of database archiving
• Resolves storage space and performance problems caused by large volumes of transaction data
• Makes master data easier to handle and to keep up to date
• Ensures statutory data retention rules are observed
• Ensures that data can be re-used at a later date, for example in new product development.
Happy Reading!!
Please feel free to post your suggestions, feedback and comments!
Please feel free to post your suggestions, feedback and comments!
No comments:
Post a Comment