International Journal of Computer Engineering Research
Subscribe to IJCER
Full Name*
Email Address*

Article Number - 43DC51758418


Vol.6(1), pp. 1-7 , February 2016
DOI: 10.5897/IJCER2014.0220
ISSN: 2141-6494



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

Copyright © 2016 Author(s) retain the copyright of this article.
This article is published under the terms of the Creative Commons Attribution License 4.0


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. 

Altareva E (2004). Improving integration quality for heterogeneous data sources (Doctoral dissertation, Heinrich Heine University Düsseldorf).

 

Batini C, Cappiello C, Francalanci C, Maurino A (2009). Methodologies for data quality assessment and improvement. ACM Comput. Surv. (CSUR) 41(3):16.
Crossref

 
 

De Witt JG, Hampton PM (2005). Development of a data warehouse at an academic health system: Knowing a place for the first time. Acad. Med. 80(11):1019-1025.
Crossref

 
 

Inmon WH, Rudin K, Buss CK, Sousa R (1998). Data warehouse performance. John Wiley & Sons, Inc.

 
 

Jarke M, Maurizio L, Yannis V, Panos V (2000). Fundamentals of Data Warehouses. New York: Springer. DOI 10.1007/978-3-662-04138-3.
Crossref

 
 

Kimball R (1998). The data warehouse lifecycle toolkit: expert methods for designing, developing, and deploying data warehouses. John Wiley & Sons.

 
 

México (2015). Integral information system. Obtenido de sistema integral de informacón (Spanish): 

View.

 
 

Pineda E (2015). Scholar Integration system SIS. from Villahermosa Institute of technology.

 
 

Zisman A, Kramer J (1995). Towards interoperability in heterogeneous database systems. Available at: 

View Retrieved March, 23, 2007.

 

 


APA José A. Z. M., Beatriz R. R., Hugo de la R. C., & Patricia R. A. (2016). Issues in a transactional database emanating from data warehouse project. International Journal of Computer Engineering Research, 6(1), 1-7.
Chicago Jos&e A. Z. M., Beatriz R. R., Hugo de la R. C. and Patricia R. A.. "Issues in a transactional database emanating from data warehouse project." International Journal of Computer Engineering Research 6, no. 1 (2016): 1-7.
MLA Joseacute; A. Z. M., et al. "Issues in a transactional database emanating from data warehouse project." International Journal of Computer Engineering Research 6.1 (2016): 1-7.
   
DOI 10.5897/IJCER2014.0220
URL http://academicjournals.org/journal/IJCER/article-abstract/43DC51758418

Subscription Form