Data classification and management in very large data warehouses
K. Chelluri, V. Kumar · 2002
A data warehouse mainly deals with historical data and specialized retrieval. In this research, we classify historical data and present a scheme for its efficient handling. Our classification of historical data is based on its inherent properties and frequency of use, which involves time. We have used a multi-dimensional grid file organization for storing historical data and supporting its efficient management. We have defined operations, such as merge, split, reorganize, etc., which are essential for managing the storage organization. The dynamic nature of the multi-dimensional grid file is used to identify and archive stale data and to optimize storage usage.