A DATA WAREHOUSE ARCHITECTURE FOR BRAZILIAN SCIENCE AND TECHNOLOGY ENVIRONMENT

André Luís Andrade Menolli, Maria Madalena Dias

Abstract

Science and technology in Brazil are areas that have few available resources and many times these scarce resources are badly used. The data warehouse is a tool that can make possible a better distribution of these resources. In this article are considered some issues in the development of a data warehouse for Science & Technology management. The paper describes the necessity of a supporting system to the decision taking regarding the distribution of the resources destined to Science & Technology in Brazil, and also shows a data warehouse architecture that is being developed to support this system. data modeling characteristics defined for the proposed data warehouse architecture are presented too.

References

  1. Axel, M., & Song, Y. (1997). Data Warehouse Design for Pharmaceutical Drug Discovery Research. Proceedings of 8th International Conference and Workshop on Database and Expert Systems Applications (DEXA97), 644-650, Toulouse, France.
  2. Dias, M. M., Mattos, M. M., Romão, W., Todesco, J. L., & Pacheco, R. C. S. (1998). Data Warehouse -Presente e Futuro. Proceedings of Revista Tecnológica, 7, 59- 73, Brazil.
  3. Demarest, M. (1997). The politics of data warehousing. Retrieved September 10, 2003, from http://www.dmreview.com/whitepaper/wid293.pdf
  4. Dinter, B., Sapia, C., Hofling, G., & Blaschka, M. (1998). The OLAP Market: State of the Art and Research Issues. Proceedings of Int'lWorkshop on Data Warehousing and OLAP, 22-27, Washington, USA.
  5. Dumoulin, R. (2003). Architecting Data Warehouses for Flexibility, Maintainability, and Performance. Retrieved August 9, 2003, from http://www.olap.it/Articles.htm
  6. Kimball, R., Reeves, L., Ross, M., & Thornthwaite, W. (1998). The Data Warehouse Lifecycle Toolkit. New York: John Wiley & Sons, Inc.
  7. Krippendorf, M., & Song, Y. (1997). Translation of Star Schema into Entity-Relationship Diagrams. Proceedings of 8th International Conference and Workshop on Database and Expert Systems Applications (DEXA97), 390-395, Toulouse, France.
  8. Lehner, W., Albrecht, J., & Wedekind, H. (1998). Normal Forms for Multidimensional Databases. Proceedings of SSDBM, 63-72.
  9. Meyere, D., & Cannon, C. (1998). Building a Better Data Warehouse. Prentice-Hall.
  10. Pedersen, T. B., & Jensen, C. S. (1999). Multidimensional Data Modeling for Complex Data. Proceedings of 15th ICDE, 336-345, Sidney, Australia.
  11. Romão, W. (2002). Descoberta de conhecimento interessante em banco de dados sobre ciência e tecnologia. Doctoring Thesis. Retrieved May 24, 2003, from Santa Catarina Federal University, Production Engineering Postgraduation Program Web site: http://teses.eps.ufsc.br/defesa/pdf/3079.pdf
  12. Song, Y., Rowen, W., Medsker, & C., Ewen, E. (2001). An Analysis of Many-to-Many Relatioships Between Fact and Dimension Tabels in Dimensional Modeling. Proceedings of Int'lWorkshop on Design and Management of Data Warehouse(DMDW2001), Interlaken, Switzerland.
  13. Theodoratos, D., & Sellis, T. (1998). Data Warehouse Schema and Instance Design. Proceedings of 17th International Conf. On Conceptual Modeling (ER98), 363-376, Singapore.
  14. Tombros, D., & Häberli, C. (2001). A Data Warehouse Architecture for MeteoSwiss: An Experience Report. Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW2001), Interlaken, Switzerland.
  15. Vassiliadis, P. (2000). Guliver in the land of data warehousing: pratical experiences and observations of a researcher. Proceedings of the International Workshop on Design and Management of Data Warehouses (DMDW'2000), Stockholm, Sweden.
Download


Paper Citation


in Harvard Style

Luís Andrade Menolli A. and Madalena Dias M. (2004). A DATA WAREHOUSE ARCHITECTURE FOR BRAZILIAN SCIENCE AND TECHNOLOGY ENVIRONMENT . In Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-00-7, pages 522-525. DOI: 10.5220/0002604305220525


in Bibtex Style

@conference{iceis04,
author={André Luís Andrade Menolli and Maria Madalena Dias},
title={A DATA WAREHOUSE ARCHITECTURE FOR BRAZILIAN SCIENCE AND TECHNOLOGY ENVIRONMENT},
booktitle={Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2004},
pages={522-525},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002604305220525},
isbn={972-8865-00-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - A DATA WAREHOUSE ARCHITECTURE FOR BRAZILIAN SCIENCE AND TECHNOLOGY ENVIRONMENT
SN - 972-8865-00-7
AU - Luís Andrade Menolli A.
AU - Madalena Dias M.
PY - 2004
SP - 522
EP - 525
DO - 10.5220/0002604305220525