PostGeoOlap: an Open-Source Tool for Decision Support
Resumo
This work describes PostGeoOlap, a decision support tool that integrates OLAP (On-Line Analytical Processing) and GIS (Geographical Information System) technologies in a single application. PostGeoOlap is an open source and a general-purpose tool to be used by application developers to easily develop their decision support applications. This tool works on the PostGreSQL DBMS using its spatial extensions (PostGIS) and performs the analytical and geographical functionalities using data warehouses.
Palavras-chave:
Open-source, Decision support, OLAP, GIS
Referências
Almeida, E. (2004) “Estudo de Viabilidade de uma Plataforma de Baixo Custo para Data Warehouse”. Master Thesis. Curitiba: Universidade Federal do Paraná.
BizGres (2005) “BizGres”. http://www.bizgres.org
Colonese, G. (2004) “Uma Ferramenta Aberta de Desenvolvimento Integrado de Sistemas de Informação para Processamento Analítico e Geográfico”. Master Thesis. Campos dos Goytacazes: Universidade Candido Mendes.
Ferreira, A.; Campos, M.; Tanaka, A. (2001) “An Architecture for Spatial and Dimensional Analysis Integration”. In: Proceedings of World Multiconference on Systemics, Cybernetics and Informatics (SCI 2001). Vol. XIV Computer Science Engineering. Part II. p.392-395. Orlando, Florida, EUA: SCI.
Fidalgo, R.; Times, V.; Souza, F. (2001) “GOLAPA: Uma Arquitetura Aberta e Extensível para Integração entre SIG e OLAP”. GeoInfo 2001, III Workshop Brasileiro de Geoinformática, p. 111-118. Rio de Janeiro: IME.
Han, J.; Stefanovic, N.; Koperski, K. (1998) “Selective Materialization: An Efficient Method for Spatial Data Cube Construction”. In: Proceedings of PAKDD’98.
JUMP (2005) “The JUMP Project” http://www.jump-project.org/
Kouba, Z.; Matoušek, K.; Mikšovský, P. (2000) “On Data Warehouse and GIS Integration”. In: Proceedings of DEXA2000. Greenwich: DEXA2000.
Papadias, D.; Kalnis, P; Zhang, J; Tao, Y. (2001) “Efficient OLAP Operations in Spatial Data Warehouses”. In: Proceedings of the 7th International Symposium on Advances in Spatial and Temporal Databases. p.443-459. ACM Records.
PostGreSQL. (2005) “PostGreSQL”. http://www.postgresql.org/
PostGIS. (2005) “PostGIS” http://postgis.refractions.net/
Shekar, S. et al. (2001) “Map Cube: A Visualization Tool for Spatial Data Warehouse”. http://www.cs.umn.edu/research/shashi-group/mapcube.htm
Stefanovic, N. (1997) “Design and Implementation of On-Line Analytical Processing (OLAP) of Spatial Data”. Master Thesis. Simon Fraser University.
Trujillo, J. et al. (2001) “Designing Data Warehouses with OO Conceptual Models”. P.66-75. IEEE Computer.
BizGres (2005) “BizGres”. http://www.bizgres.org
Colonese, G. (2004) “Uma Ferramenta Aberta de Desenvolvimento Integrado de Sistemas de Informação para Processamento Analítico e Geográfico”. Master Thesis. Campos dos Goytacazes: Universidade Candido Mendes.
Ferreira, A.; Campos, M.; Tanaka, A. (2001) “An Architecture for Spatial and Dimensional Analysis Integration”. In: Proceedings of World Multiconference on Systemics, Cybernetics and Informatics (SCI 2001). Vol. XIV Computer Science Engineering. Part II. p.392-395. Orlando, Florida, EUA: SCI.
Fidalgo, R.; Times, V.; Souza, F. (2001) “GOLAPA: Uma Arquitetura Aberta e Extensível para Integração entre SIG e OLAP”. GeoInfo 2001, III Workshop Brasileiro de Geoinformática, p. 111-118. Rio de Janeiro: IME.
Han, J.; Stefanovic, N.; Koperski, K. (1998) “Selective Materialization: An Efficient Method for Spatial Data Cube Construction”. In: Proceedings of PAKDD’98.
JUMP (2005) “The JUMP Project” http://www.jump-project.org/
Kouba, Z.; Matoušek, K.; Mikšovský, P. (2000) “On Data Warehouse and GIS Integration”. In: Proceedings of DEXA2000. Greenwich: DEXA2000.
Papadias, D.; Kalnis, P; Zhang, J; Tao, Y. (2001) “Efficient OLAP Operations in Spatial Data Warehouses”. In: Proceedings of the 7th International Symposium on Advances in Spatial and Temporal Databases. p.443-459. ACM Records.
PostGreSQL. (2005) “PostGreSQL”. http://www.postgresql.org/
PostGIS. (2005) “PostGIS” http://postgis.refractions.net/
Shekar, S. et al. (2001) “Map Cube: A Visualization Tool for Spatial Data Warehouse”. http://www.cs.umn.edu/research/shashi-group/mapcube.htm
Stefanovic, N. (1997) “Design and Implementation of On-Line Analytical Processing (OLAP) of Spatial Data”. Master Thesis. Simon Fraser University.
Trujillo, J. et al. (2001) “Designing Data Warehouses with OO Conceptual Models”. P.66-75. IEEE Computer.
Publicado
26/10/2005
Como Citar
COLONESE, Giovanni; MANHÃES, Rodrigo Soares; GONZÁLEZ, Sahudy Montenegro; DE CARVALHO, Rogério Atem; TANAKA, Asterio Kiyoshi.
PostGeoOlap: an Open-Source Tool for Decision Support. In: SIMPÓSIO BRASILEIRO DE SISTEMAS DE INFORMAÇÃO (SBSI), 2. , 2005, Florianópolis.
Anais [...].
Porto Alegre: Sociedade Brasileira de Computação,
2005
.
p. 127-134.
DOI: https://doi.org/10.5753/sbsi.2005.14976.