View Single Post
  #1  
Old 01-29-2002, 10:05 AM
Keefe Keefe is offline
Administrator
 
Join Date: May 2002
Location: Wisconsin
Posts: 2,337
Send a message via ICQ to Keefe Send a message via AIM to Keefe Send a message via MSN to Keefe Send a message via Yahoo to Keefe
Default Term of the Day: active archiving

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.
__________________
It's crazy I'm thinking, just knowing that the world is round.
-http://www.techwarepc.com/ - The Technology Experts
Reply With Quote