Development of a back- end tool for loading data into data warehouse using open-source technology

Chapter 1: Introduction 2 1.1 Overview 2 1.2 Background and Present State of the Problem 2 1.3 Objectives 3 1.4 Organization of the Report 3 Chapter 2: Literature Review 4 2.1 Data Warehouse 4 2.2 Data Warehouse Related Terms and Definition 5 2.2.1 Measure Attribute, Dimension Attribute and Multidimensional Data 5 2.2.2 Fact Table, Star Schema and Data Mart 5 2.3 Operational Database versus Data Warehouse 6 2.4 Data Warehousing Activities 6 2.5 Back-End Tools and Utilities 7 2.5.1 Data Cleaning 7 2.5.2 Data Loading 8 2.5.3 Data Refreshing 9 2.6 Vendor Provided Back-End Tools and Utilities 9 2.7 Open-source Technology 2.7.1 Open Source Database Management System Chapter 3: Analysis and Design of the Back-End Tool 3.