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.
