Web-oriented business intelligence solution based on Associative Query Logic

Authors:
P. Sendín-Raña;E. Rodríguez-Fernández;F. J. González-Castaño_aff1n2;E. Costa-Montenegro;P. S. Rodríguez-Hernández;J. M. Pousada-Carballo;J. C. Burguillo-Rial
Affiliations:
af1 Departamento de Ingeniería Telemática, Universidad de Vigo, Vigo, Spain;af1 Departamento de Ingeniería Telemática, Universidad de Vigo, Vigo, Spain;af2 Galician Research & Development Center in Advanced Telecommunications, ETSI Telecommunicacion, Campus, 36310 Vigo, Spain;af1 Departamento de Ingeniería Telemática, Universidad de Vigo, Vigo, Spain;af1 Departamento de Ingeniería Telemática, Universidad de Vigo, Vigo, Spain;af1 Departamento de Ingeniería Telemática, Universidad de Vigo, Vigo, Spain;af1 Departamento de Ingeniería Telemática, Universidad de Vigo, Vigo, Spain
Venue:
Software—Practice & Experience
Year:
2010

Citing 13
Cited 0

View maintenance in a warehousing environment

SIGMOD '95 Proceedings of the 1995 ACM SIGMOD international conference on Management of data
An overview of data warehousing and OLAP technology

ACM SIGMOD Record
Maintenance of data cubes and summary tables in a warehouse

SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
Working Knowledge: How Organizations Manage What They Know

Working Knowledge: How Organizations Manage What They Know
Realizing active data warehouses with off-the-shelf database technology

Software—Practice & Experience
Database Technology for Decision Support Systems

Computer
Aggregate-Query Processing in Data Warehousing Environments

VLDB '95 Proceedings of the 21th International Conference on Very Large Data Bases
On the Computation of Multidimensional Aggregates

VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
Providing OLAP Interoperability with OLAPWare

SCCC '02 Proceedings of the XII International Conference of the Chilean Computer Science Society
On-Line Analytical Processing on Large Databases Managed by Computational Grids

DEXA '04 Proceedings of the Database and Expert Systems Applications, 15th International Workshop
Modeling and querying multidimensional data sources in Siebel Analytics: a federated relational system

Proceedings of the 2005 ACM SIGMOD international conference on Management of data
An open source and web based framework for geographic and multidimensional processing

Proceedings of the 2006 ACM symposium on Applied computing
Improving the performance and functionality of Mondrian open-source OLAP systems

Software—Practice & Experience

Quantified Score

Hi-index	0.01

Visualization

Abstract

In this paper we present our experience in the development of a web-based business intelligence tool according to the Associative Query Logic paradigm, which can represent large amounts of data in a way that allows extremely fast queries. It has been developed as an open-source, multi-platform software, relying on data compression techniques for the storage of large amounts of data in the main memory. The performance of our solution in terms of compression, load time and response time is close to that of the commercial tool of reference, QlikView. Moreover, we provide solutions to some open problems in QlikView published description, which may be beneficial to assist in the development of other open or proprietary tools. Copyright © 2010 John Wiley & Sons, Ltd.