Modelagem de dados com Data Warehouse e OLAP: um estudo de caso

Authors

  • Everton Castelão Tetila Universidade Federal da Grande Dourados

Keywords:

Knowledge discovery. Data warehouse. OLAP

Abstract

Data warehouses offer data access to complex analysis, knowledge
discovery and decision making. The multidimensional data model used in the
data warehouses provide decision makers information on the correct level of
detail, based on organization and appropriate perspective. Moreover, it is a go‐
od choice for Online Analytical Processing (OLAP). In this sense, this paper pro‐
poses create a knowledge base, to investigate the potential causes of problems
in the Baccalaureate in Information Systems course of the UFGD, such as, high
rate of school failure, dropout and low graduation rate. For this research, the
MySQL Community Server 5.6.21, MySQL Workbench 6.2.3 and Pentaho BI Ser‐
ver CE‐4.8.0 applications were used.

Downloads

Download data is not yet available.

Author Biography

Everton Castelão Tetila, Universidade Federal da Grande Dourados

Faculdade de Ciências Exatas e Tecnologia - FACET/UFGD.

Área de Ciência da Computação, com ênfase em Banco de Dados, atuando principalmente nos temas: Data mining, Data warehouse, ETL e OLAP.

 

References

ELMASRI, R.; NAVATHE, S. B. Sistemas de Banco de Dados. 6ª ed., Addison Wesley, 2011. 788p.

GIL, A. C. Como elaborar projetos de pesquisa? 5. ed., São Paulo: Atlas, 2010. 200 p.

INMON, W. H. Como construir o Data Warehouse. 2ª ed. Rio de Janeiro: Campus, 1997.

KIMBALL, Ralph. Data Warehouse Toolkit. Tradução Mônica Rosemberg; Revisão Técnica Ronal Stevis Cassiolato. São Paulo: Makron Books, 1998.

MYSQL COMMUNITY SERVER. Versão 5.6.21, 2014. Disponível em:

http://dev.mysql.com/downloads/mysql/. Acesso em: 26/09/2014.

MYSQL WORKBENCH. Versão 6.2.3, 2014. Disponível em: http://dev.my‐sql.com/downloads/workbench/. Acesso em: 26/09/2014.

PENTAHO. Pentaho Open Source Business Intelligence. Versão 4.8.0.stable, 2014. Disponível em: http://ufpr.dl.sourceforge.net/project/pentaho/Business%20Intelligen‐

ce%20Server/4.8.0‐stable/biserver‐ce‐4.8.0‐stable.zip. Acesso em: 26/09/2014.

PINHEIRO, C. A. R. Inteligência Analítica: Mineração de Dados e Descoberta do Conhecimento. Rio de Janeiro: Ciência Moderna. 2008.

REDE GLOBO DE TELEVISÃO. Setor de tecnologia da informação tem déficit de 115 mil trabalhadores. 2012. Disponível em: http://g1.globo.com/jornal‐/noticia/2012/05/setor‐de‐tecnologia‐da‐informacao‐tem‐deficit‐de‐115‐mil‐traba‐lhadores.html. Acesso em: 13/08/2013.

Downloads

Published

2014-11-06

How to Cite

Tetila, E. C. (2014). Modelagem de dados com Data Warehouse e OLAP: um estudo de caso. EaD & Tecnologias Digitais Na Educação, 2(3), 20–29. Retrieved from https://ojs.ufgd.edu.br/ead/article/view/3514

Issue

Vol. 2 No. 3 (2014)

Section

Artigos

License

Authors who publish in this journal agree with the following terms:

  1. The authors retain copyright and grant the journal the right of first publication, with the work simultaneously licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License which allows the sharing of work with recognition of authorship and initial publication in this journal.
  2. Authors are authorized to assume additional contracts separately, for non-exclusive distribution of the version of the work published in this journal (eg: publishing in an institutional repository or as a book chapter), with acknowledgment of authorship and initial publication in this journal.
  3. Authors are allowed and encouraged to publish and distribute their work online (eg, in institutional repositories or on their personal page) at any point before or during the editorial process, as this can generate productive changes, as well as increase the impact and citation of the published work, but invariably with the acknowledgment of authorship and initial publication in this journal.