A Preprocessing Design Scheme for Sequential Pattern Analysis of a Student Database

R. Campagni, D. Merlini, M. C. Verri

2016

Abstract

In a data mining project evolved on a relational database often a significant effort needs to be done to construct the data set for the analysis. In fact, usually the database contains a series of normalized tables that need to be joined, aggregated and processed in an appropriate way to build the data set. This process generates various SQL queries that are written independently of each other, in a disordered manner. In this way, the database grows with tables and views which are not present at the conceptual level and this can yield problems for the development of the database. In this paper we consider a typical database containing data about students, courses and exams and illustrate some SQL transformations to build a data set to perform a sequential pattern analysis eventually combined with clustering and classification. In particular, we introduce in the student database some interesting patterns representing relationship between the exams given by students in various periods and the career of each student. This is achieved by introducing a particular encoding of a the career of a student. The resulting table can be analyzed with clustering and classification algorithms. We present a case study following this organization.

Paper Citation

in Harvard Style

Campagni R., Merlini D. and Verri M. (2016). A Preprocessing Design Scheme for Sequential Pattern Analysis of a Student Database . In Proceedings of the 8th International Conference on Computer Supported Education - Volume 2: CSEDU, ISBN 978-989-758-179-3, pages 99-106. DOI: 10.5220/0005789600990106

in Bibtex Style

@conference{csedu16,
author={R. Campagni and D. Merlini and M. C. Verri},
title={A Preprocessing Design Scheme for Sequential Pattern Analysis of a Student Database},
booktitle={Proceedings of the 8th International Conference on Computer Supported Education - Volume 2: CSEDU,},
year={2016},
pages={99-106},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005789600990106},
isbn={978-989-758-179-3},
}

in EndNote Style

TY - CONF
JO - Proceedings of the 8th International Conference on Computer Supported Education - Volume 2: CSEDU,
TI - A Preprocessing Design Scheme for Sequential Pattern Analysis of a Student Database
SN - 978-989-758-179-3
AU - Campagni R.
AU - Merlini D.
AU - Verri M.
PY - 2016
SP - 99
EP - 106
DO - 10.5220/0005789600990106