An open source and web based framework for geographic and multidimensional processing

Authors:
Joel da Silva;Valéria C. Times;Ana Carolina Salgado
Affiliations:
Federal University of Pernambuco, Cidade, Universitária, Recife - PE, Brazil;Federal University of Pernambuco, Cidade, Universitária, Recife - PE, Brazil;Federal University of Pernambuco, Cidade, Universitária, Recife - PE, Brazil
Venue:
Proceedings of the 2006 ACM symposium on Applied computing
Year:
2006

Citing 10
Cited 8

Providing better support for a class of decision support queries

SIGMOD '96 Proceedings of the 1996 ACM SIGMOD international conference on Management of data
GeoMiner: a system prototype for spatial data mining

SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
A powerful and SQL-compatible data model and query language for OLAP

ADC '02 Proceedings of the 13th Australasian database conference - Volume 5
A pictorial query language for querying geographic databases using positional and OLAP operators

ACM SIGMOD Record
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals

Data Mining and Knowledge Discovery
Database Technology for Decision Support Systems

Computer
Spatial SQL: A Query and Presentation Language

IEEE Transactions on Knowledge and Data Engineering
SQL/SDA: A Query Language for Supporting Spatial Data Analysis and Its Web-Based Implementation

IEEE Transactions on Knowledge and Data Engineering
Querying Multidimensional Databases

DBLP-6 Proceedings of the 6th International Workshop on Database Programming Languages
A Filter Flow Visual Querying Language and Interface for Spatial Databases

Geoinformatica

A set of aggregation functions for spatial measures

Proceedings of the ACM 11th international workshop on Data warehousing and OLAP
Especificação e avaliação de algoritmos para processamento multidimensional-geográfico

SBBD '08 Proceedings of the 23rd Brazilian symposium on Databases
Improving the performance and functionality of Mondrian open-source OLAP systems

Software—Practice & Experience
A spatial bitmap-based index for geographical data warehouses

Proceedings of the 2009 ACM symposium on Applied Computing
Spatial aggregation: Data model and implementation

Information Systems
What Is Spatio-Temporal Data Warehousing?

DaWaK '09 Proceedings of the 11th International Conference on Data Warehousing and Knowledge Discovery
Modelling and querying geographical data warehouses

Information Systems
Web-oriented business intelligence solution based on Associative Query Logic

Software—Practice & Experience

Quantified Score

Hi-index	0.00

Visualization

Abstract

The development of Business Intelligence (BI) systems has been the destination of high investments made by several enterprises. The motivation is because an efficient decision support environment brings them several business world advantages, mainly if it provides integrated functionalities for the geographical and/or multidimensional processing. The intended goal is to provide users with a system capable of processing both geographic and multidimensional data in a seamless way, by abstracting the complexity of separately querying and analyzing these data in a decision making process. However, this integration may not be fully achieved yet or may be built using proprietary technologies. This paper presents an open source and web based framework for geographic and multidimensional decision support. Our approach uses a geographical data warehouse, a metadata source, a query language and a geographical and multidimensional engine for processing queries sent by a web based client application.