Database archiving solutions are springing up with every coming day, but not at the pace at which information is just piling up in several enterprises. The consistent gigantic growth in the size and space of databases is known all over, but the integration of database archives into ILM strategies poses an overwhelming challenge for many database administrators. What once was measured in megabytes and gigabytes, have now given way to terabytes and petabytes. Storage is also a critical issue from the legal point of view because the latest rules and regulations for compliance have stressed that the organization must retain data for several years and availed at will for inspection.
What Enterprises Need
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.
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.
According to Enterprise Strategy Group estimates, the number of primary databases is escalating at the rate of 25 % annually, with a subsequent boost to secondary databases as well. Database archiving solutions are expected to improve performance which is a prime concern for database administrators who handle bulky databases. Though enterprises bring up their own custom database archiving tools in the event of loss of performance or rising storage costs, the process actually becomes a little more complex. Integration with the database, having efficient storage software and seamless integration with the supposed application complicates things. Hence it is best left to database archiving solution vendors who are experts in their field.
Legal Implications
The legal implications of not pursuing data retention policies and database archiving solutions in enterprises can create huge problems. Additionally there are the needs of the company as it also needs the rare referential data for use at some point of time or another. Apart from the problem of depleting disk space, companies have reported problems such as total system outages during the processing in the database. Problems also include backup failures when there's huge data to be backed up and time-out of transactions while scouring through millions and millions of records.
0 comments:
Post a Comment