loading
Documents

Research.Publish.Connect.

Paper

Paper Unlock

Authors: R. Campagni ; D. Merlini and M. C. Verri

Affiliation: Università di Firenze, Italy

ISBN: 978-989-758-179-3

ISSN: 2184-5026

Keyword(s): Educational Data Mining, Sequential Pattern Analysis, SQL Preprocessing.

Related Ontology Subjects/Areas/Topics: Computer-Supported Education ; Learning/Teaching Methodologies and Assessment ; Metrics and Performance Measurement ; Project Based Learning and Engineering Education

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 a nd 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. (More)

PDF ImageFull Text

Download
CC BY-NC-ND 4.0

Sign In Guest: Register as new SciTePress user now for free.

Sign In SciTePress user: please login.

PDF ImageMy Papers

You are not signed in, therefore limits apply to your IP address 35.172.233.2

In the current month:
Recent papers: 100 available of 100 total
2+ years older papers: 200 available of 200 total

Paper citation in several formats:
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, ISSN 2184-5026, pages 99-106. DOI: 10.5220/0005789600990106

@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},
}

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

Login or register to post comments.

Comments on this Paper: Be the first to review this paper.