International Journal of
Computer Engineering Research

  • Abbreviation: Int. J. Comput. Eng. Res.
  • Language: English
  • ISSN: 2141-6494
  • DOI: 10.5897/IJCER
  • Start Year: 2010
  • Published Articles: 28

Full Length Research Paper

Issues in a transactional database emanating from data warehouse project

José A. Z. M.
  • José A. Z. M.
  • Institute of Technology of San Luis Potosí, Tecnológico av. s/n Col. UPA, Soledad de Graciano Sanchez San Luis Potosí, México.
  • Google Scholar
Beatriz R. R.
  • Beatriz R. R.
  • Institute of Technology of San Luis Potosí, Tecnológico av. s/n Col. UPA, Soledad de Graciano Sanchez San Luis Potosí, México.
  • Google Scholar
Hugo de la R. C.
  • Hugo de la R. C.
  • Institute of Technology of San Luis Potosí, Tecnológico av. s/n Col. UPA, Soledad de Graciano Sanchez San Luis Potosí, México.
  • Google Scholar
Patricia R. A.
  • Patricia R. A.
  • Institute of Technology of San Luis Potosí, Tecnológico av. s/n Col. UPA, Soledad de Graciano Sanchez San Luis Potosí, México.
  • Google Scholar


  •  Received: 06 November 2014
  •  Accepted: 31 December 2015
  •  Published: 29 February 2016

Abstract

When a data warehouse (DW) is built, typical extraction, transformation, and loading operations are made, including cleaning tasks of the data, conflicts resolution, inconsistencies identification, and constrains checking, among others. In this work, two databases (DB) were combined to obtain indexes approved and failing course in basic sciences area (Mathematics, Physics, Chemistry) of the Institute of Technology of San Luis Potosí (ITSLP for their initials in Spanish). The database table intermediate of the transactional database was used to calculate dimensions and fact database tables of one warehouse. Stored data in DW are the input to Data Mining Algorithms and validation information process. This benefit was not expected. At last, the combined database was divided into a transactional database and historical database, to avoid redundancy, inconsistency, incongruity, and other integrity issues and to prepare the historical database to update DW. This DW will be suitable to carry out statistical queries in diverse areas and faculties. The final divisions of mixed database and alternative uses of intermediate tables are some non-awaiting results of original planning of project.

Key words: Data bases, data mining, basic sciences, data warehouse, inconsistency.