![](bg4.png)
the same dimension, according to what was
proposed with the use of the DW Bus architecture
matrix.
The use of the star schema altogether with many-
to-many techniques of modeling between facts and
dimensions and among multivalued dimensions, it is
expected to obtain a simplified and denormalized
dimensional model, improving the inquiry
processing of final users and raising the
performance.
5 CONCLUSIONS
In this project it was defined a DW architecture
giving support to the decision taking in Science &
Technology in Brazil. This architecture is divided
into diverse independent layers, facilitating the
resolution of problems in each one of the DW
development stages. In this architecture, diverse DW
technologies and classical relational database
technologies are used. The DW data modeling was
defined considering that the knowledge to be
obtained is related, mainly, to the Brazilian
researchers scientific production .
It is expected that with the proposed DW in the
project, it is possible to minimize existing problems
in the resources distribution destined to the Science
& Technology in Brazil.
REFERENCES
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.
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.
Demarest, M. (1997). The politics of data warehousing.
Retrieved September 10, 2003, from
http://www.dmreview.com/whitepaper/wid293.pdf
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.
Dumoulin, R. (2003). Architecting Data Warehouses for
Flexibility, Maintainability, and Performance.
Retrieved August 9, 2003, from
http://www.olap.it/Articles.htm
Kimball, R., Reeves, L., Ross, M., & Thornthwaite, W.
(1998). The Data Warehouse Lifecycle Toolkit. New
York: John Wiley & Sons, Inc.
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.
Lehner, W., Albrecht, J., & Wedekind, H. (1998). Normal
Forms for Multidimensional Databases. Proceedings
of SSDBM, 63-72.
Meyere, D., & Cannon, C. (1998). Building a Better Data
Warehouse. Prentice-Hall.
Pedersen, T. B., & Jensen, C. S. (1999). Multidimensional
Data Modeling for Complex Data. Proceedings of
15th ICDE, 336-345, Sidney, Australia.
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
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.
Theodoratos, D., & Sellis, T. (1998). Data Warehouse
Schema and Instance Design. Proceedings of 17th
International Conf. On Conceptual Modeling (ER98),
363-376, Singapore.
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.
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.
A DATA WAREHOUSE ARCHITECTURE FOR BRAZILIAN SCIENCE AND TECHNOLOGY ENVIRONMENT
525