Integração de um Banco de Dados e um Data Warehouse sobre um Sistema de Arquivos Paralelos

• José Craveiro da Costa Neto UFMS
• Hélio Crestana Guardia UFSCar
• Liria Matsumoto Sato USP

DOI: https://doi.org/10.5753/wscad.2001.19130

Resumo

Nowadays, there is an increasing demand for data warehousing systems, which are computational systems to support decision making based on information stored in a data warehouse. In order to provide such systems with high performance, a concurrent database system, called CDBS, has been proposed, CDBS integrates parallel database and warehousing technologies, and contains a data definition and manipulation function library that makes it possible to create, modify, and search on parallel databases and warehouses. In order to guarantee high performance, CDBS uses a parallel file system, called NPFS, which organizes data in such a way that its data manipulation functions can be executed rapidly. In this paper, we describe CDBS and present a case study in which the use of parallelism in databases and warehousing systems is required in order to achieve high performance. Resides, we discuss future rescarch opportunities related to the specification, design and implementation of new CDBS library functions, as well as the main contributions of this work.

Palavras-chave: bancos de dados paralelos, data warehousing, sistemas de arquivos paralelos

Referências

Costa Neto, J. C. Considerações sobre a Integração de um Banco de Dados e um Data Warehouse sobre um Sistema de Arquivos Paralelos. Tese de doutorado, Escola Politécnica da Universidade de São Paulo, 2001.

DeWitt, D.; Gray, J. Parallel Database Systems: the Future of High Performance Database Systems, CACM, 35(6), junho/1992, 85-98.

Ehnasri, R.; Navathe, S. R. Fundamentais of Database Systems. Addison Wesley, 30 ed., 2000.

Garcia-Molina, H.; Labio, W. J.; Wiener, J. L.; Zhuge, Y. Distributed and Parallel Computing lssues in Data Warehousing, 1999.

Garcia-Molina, H.; Ullman, J. D.; Widom, J. Database System lmplementation. Prentice Hall, 2000.

Graefe, G. Query Evaluation Techniques for Large Databases, ACM Computing Surveys, 25(2), junho/1993, 73-170.

Guardia, H. C. Considerações sobre as Estratégias de um Sistema de Arquivos Paralelos Integrado ao Processamento Distribuído. Tese de doutorado, Escola Politécnica da Universidade de São Paulo, 1999.

Gupta, A.; Harinarayan, V.; Quass, O. Aggregate-Query Processing in Data Ware housing Enviroments. in Proceedings of the 21st VLBD Conference, Zurique, Suíça, 1995.

Kim, W. (ed.) Modem Database Systems: The Object Model, lnteroperability, and Beyond. Reading, MA, Addison Wesley/ACM Press, 1995.

Kimball, R. The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses. John Wiley & Sons, 1996.

Oldfield, R.; Kotz, D. Applications of Parallel I/O. Technical Report PCS-TR98-337 (suplemento ao PCS-TR96-297), Computer Science, Dartmouth College, agosto/1998.

Quass, D.; Widom, J. On-line Warehouse View Maintenance for Batches Upadates. In Proceedings of the ACM SIGMOD International Conference on Management of Data, Tucson, Arizona, maio/97.

Rao, J.; Ross, K. A. Cache Conscious lndexing for Decison-Suport in Main Memory, Columbia University, in Proceedings of the 25th VLDB Conference, Edimburgo, Escócia, 1999.

Valduriez, P. Parallel Database Systems: Open Problems and New lssues, Distributed and Parallel Databases, 1(2), abril/1993, 137-165.

Widom, J. Research Problems in Data Warehousing. In Conference on lnformation and Knowledge Management, 1995. Ver: <http://db.stanford.edu/> pub/widom/1995/warehouse-research.ps.

Yu, C. T.; Meng, W. Principies of Database Query Processing for Advanced Applications. Morgan Kaufmann Publishers, Inc., 1998.