Archiving data warehouse by considering the data business value as per choice of decision maker (T-0676) (MFN 3842)

Abstract

The requirement for analysis on the huge amount of data is growing knowledge in the field of research and industry. Data from a number of sources is collected and brought into the data warehouse for analysis. The retention period of this data is determined by the necessity of keeping it in context for future analysis. Data archiving approaches adopted for a source database cannot be used for data warehouse due to analytical reasons. Data warehouse data cannot be removed just between cutoff attribute values identified without doing any analysis. A number of other data warehouse archiving approaches exist in industry and research, which to some extent are successful. The main focus of this thesis is to study the business value of the data available in the data warehouse and use this value for data archiving. Data which delivered more business value in past times is to stay in the operational data warehouse for a longer period than that of less or very less business value. Unfortunately till today none of the approach is proposed to relate data of data warehouse to its business value. However every day business data is analyzed for making a number of corporate decisions which adds the business a value to its mission and goal. An approach is proposed in this thesis which will help to keep information about data queried and its business value. This information will be used to generate some statistics to discuss with a decision maker in deciding retention data period. The proposed approach is based on the Business Decision Model.