Objectives:	Attendees will learn about ILM in general and ILM on data warehouses in particular. Optimizing data warehouse environments with ILM techniques using Oracle partitioning. Pro's and con's of current alternatives in archival-class storage for databases.
Abstract:	Information Lifecycle Management (ILM) is a set of techniques supported by the "ILM Assistant" plug-in to SQL Developer. ILM is the technique of utilizing the appropriate storage technology (i.e. fast and expensive, slower and less-expensive, etc) according to the ways that the data is accessed. These techniques are particularly appropriate for data warehouses, but can be used for any application which generates enormous volumes of data with long or undefined retention policies. The real art of ILM is enabling the long-term "tier" of storage, usually termed "archival", which stores data the longest. In the past, offline or nearline solutions were common, but COPAN Systems offers a new technology called "MAID" (massive array of idle disk) which offers an extremely simple and cost-effective storage for massive multi-petabyte volumes of data to be retained for many years. MAID is intended to completely replace tape media while maintaining archived data fully online and available.
Audiernce Focus:	Managers
Expertise:	Intermediate
Track:	Business Intelligence/Warehousing
Date:	Wednesday, April 16, 2008
Time:	3:15 PM - 4:15 PM