Application of Data Wherehouse & Mining Exploitation for Supporting the Plan of Highter Education System in Sri Lanka

Abstract

The topic of data warehousing encompasses architectures, algorithms, and tools for brining together selected data from multiple databases or other information sources into a single repository called a data warehouse, suitable for direct querying and analysis. We have designed a data warehouse for the Sri Lanka education system and applied basic data mining techniques (i.e. data cleaning, data integration, data selection, data transformation, data mining, pattern evaluation, knowledge representation) to support decision making activities. For this we have built an integrated data warehouse consisting data from Dept. of Examination, University Grants Commission, School Census data, national population data and University student’s information. This paper highlights how the data warehouse was built for the Sri Lanka education system and how it was used to create data summary cubes for data analysis and mining process. At present using this developed system, basic level of summaries and analysis can be performed to obtain for decision support information. Further applying data mining techniques and advanced queries, we can obtain the necessary knowledge for policy marking as well.