Extending ER models to capture database transformations to build data sets for data mining
| hal.structure.identifier | Department of computer Science [Houston] | |
| dc.contributor.author | ORDONEZ, Carlos | |
| hal.structure.identifier | Laboratoire Bordelais de Recherche en Informatique [LaBRI] | |
| hal.structure.identifier | Algorithmics for computationally intensive applications over wide scale distributed platforms [CEPAGE] | |
| dc.contributor.author | MAABOUT, Sofian | |
| hal.structure.identifier | Department of computer Science [Houston] | |
| dc.contributor.author | MATUSEVICH, David Sergio | |
| hal.structure.identifier | Department of computer Science [Houston] | |
| dc.contributor.author | CABRERA, Wellington | |
| dc.date.accessioned | 2024-04-15T09:41:49Z | |
| dc.date.available | 2024-04-15T09:41:49Z | |
| dc.date.created | 2013-08-22 | |
| dc.date.issued | 2013-12-19 | |
| dc.identifier.issn | 0169-023X | |
| dc.identifier.uri | https://oskar-bordeaux.fr/handle/20.500.12278/197632 | |
| dc.description.abstractEn | In a data mining project developed on a relational database, a significant effort is required to build a data set for analysis. The main reason is that, in general, the database has a collection of normalized tables that must be joined, aggregated and transformed in order to build the required data set. Such scenario results in many complex SQL queries that are written independently from each other, in a disorganized manner. Therefore, the database grows with many tables and views that are not present as entities in the ER model and similar SQL queries are written multiple times, creating problems in database evolution and software maintenance. In this paper, we classify potential database transformations, we extend an ER diagram with entities capturing database transformations and we introduce an algorithm which automates the creation of such extended ER model. We present a case study with a public database illustrating database transformations to build a data set to compute a typical data mining model. | |
| dc.language.iso | en | |
| dc.publisher | Elsevier | |
| dc.title.en | Extending ER models to capture database transformations to build data sets for data mining | |
| dc.type | Article de revue | |
| dc.identifier.doi | 10.1016/j.datak.2013.11.002 | |
| dc.subject.hal | Informatique [cs]/Base de données [cs.DB] | |
| bordeaux.journal | Data and Knowledge Engineering | |
| bordeaux.page | 38-54 | |
| bordeaux.volume | 89 | |
| bordeaux.hal.laboratories | Laboratoire Bordelais de Recherche en Informatique (LaBRI) - UMR 5800 | * |
| bordeaux.institution | Université de Bordeaux | |
| bordeaux.institution | Bordeaux INP | |
| bordeaux.institution | CNRS | |
| bordeaux.peerReviewed | oui | |
| hal.identifier | hal-00940778 | |
| hal.version | 1 | |
| hal.popular | non | |
| hal.audience | Internationale | |
| hal.origin.link | https://hal.archives-ouvertes.fr//hal-00940778v1 | |
| bordeaux.COinS | ctx_ver=Z39.88-2004&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.jtitle=Data%20and%20Knowledge%20Engineering&rft.date=2013-12-19&rft.volume=89&rft.spage=38-54&rft.epage=38-54&rft.eissn=0169-023X&rft.issn=0169-023X&rft.au=ORDONEZ,%20Carlos&MAABOUT,%20Sofian&MATUSEVICH,%20David%20Sergio&CABRERA,%20Wellington&rft.genre=article |
Fichier(s) constituant ce document
| Fichiers | Taille | Format | Vue |
|---|---|---|---|
|
Il n'y a pas de fichiers associés à ce document. |
|||