HomeCalendarFAQSearchRegisterMemberlistUsergroupsLog in

Share | 

 Oracle Databases Archiving

Go down 

Number of posts : 1850
Age : 55
Registration date : 2008-03-08

PostSubject: Oracle Databases Archiving   Sun 13 Apr - 19:45

Data growth rates are climbing at an astonishing pace. Oracle databases today are holding many terabytes and in some cases petabytes worth of data. In most cases, the data is not deleted regularly even though the new transactions continue to occur within the application. Companies either ignore this issue or resolve it temporarily by adding more space because, after all, ďdisk is cheap.Ē

Well, itís not all about saving disk space. Instead, itís about truly protecting corporate data for long periods of time in order to meet regulatory requirements. Itís also about achieving maximum performance of applications through a reduced amount of data to process. Not only will applications run faster, but utility functions such as backups, recoveries and reorganizations will execute more efficiently. Itís also about deleting any information that can be legally used against the company. As a result of these, you might also save some disk space.

Archiving data requires creating a strategy for long-term data retention. This strategy is usually determined in collaboration with IT, line of business and legal teams. This strategy could be impacted by one of two types of requirements - internal requirements, where for example a company must keep all customer records accessible and online for a period of 24 months, or requirements that stem from government regulations like Sarbanes-Oxley, HIPAA, PCI, etc. For example, HIPAA requires that medical records be retained up to two years after a personís death. Sarbanes-Oxley requires audit data be kept for seven years after the conclusion of the audit and CFR (Life Sciences) requires that pharmaceutical companies retain clinical trial data for 35 years. Requirements are extremely stringent for companies that must retain data for legal purposes, and most are not prepared to hold data for such long time frames, let alone guarantee it hasnít been altered in any way.

The life span of data in Figure 1 begins with data inserted into the operational system that is needed for regular business transactions. Later, it is used primarily for reporting purposes, where decision support and data warehousing applications come into play. This data is often ďread onlyĒ and highly summarized. When the data is no longer required for quick online accessiblity, it should be moved to a data archive. At this stage, the data can be accessed, just not typically at the same efficiency as within the application. Finally, when the data is no longer required for long-term retention, it can and should be discarded.
Back to top Go down
View user profile
Oracle Databases Archiving
Back to top 
Page 1 of 1
 Similar topics
» Companies listed under Investment Trust sector

Permissions in this forum:You cannot reply to topics in this forum
Job98456 :: Databases-
Jump to: