The process of removing a precise set of infrequently used reference data from an overloaded relational database and keeping it active in an archive where it can be easily and quickly retrieved when needed.
For example, a credit card company acquires large amounts of mission-critical data on its customers - names, addresses, balances, account numbers, interest rates. This information is critical to the company's daily operation. When a monthly bill is issued, that data can be put into an active archive because the company does not need that information unless there are questions about the bill. So the data is taken out of the relational database where it would slow the system down but left available so that it can be quickly accessed when needed.
Featured Partners Sponsored
- Increase worker productivity, enhance data security, and enjoy greater energy savings. Find out how. Download the “Ultimate Desktop Simplicity Kit” now.»
- Find out which 10 hardware additions will help you maintain excellent service and outstanding security for you and your customers. »
- Server virtualization is growing in popularity, but the technology for securing it lags. To protect your virtual network.»
- Before you implement a private cloud, find out what you need to know about automated delivery, virtual sprawl, and more. »