Web-oriented business intelligence solution based on Associative Query Logic

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.

[1]  Jeffrey F. Naughton,et al.  On the Computation of Multidimensional Aggregates , 1996, VLDB.

[2]  Michael Schrefl,et al.  Realizing active data warehouses with off‐the‐shelf database technology , 2002, Softw. Pract. Exp..

[3]  Surajit Chaudhuri,et al.  An overview of data warehousing and OLAP technology , 1997, SGMD.

[4]  Inderpal Singh Mumick,et al.  Maintenance of data cubes and summary tables in a warehouse , 1997, SIGMOD '97.

[5]  Surajit Chaudhuri,et al.  Database Technology for Decision Support Systems , 2001, Computer.

[6]  Marco Vieira,et al.  The OLAP and data warehousing approaches for analysis and sharing of results from dependability evaluation experiments , 2003, 2003 International Conference on Dependable Systems and Networks, 2003. Proceedings..

[7]  Jennifer Widom,et al.  View maintenance in a warehousing environment , 1995, SIGMOD '95.

[8]  Thomas H. Davenport,et al.  Book review:Working knowledge: How organizations manage what they know. Thomas H. Davenport and Laurence Prusak. Harvard Business School Press, 1998. $29.95US. ISBN 0‐87584‐655‐6 , 1998 .

[9]  Valéria Cesário Times,et al.  Providing OLAP Interoperability with OLAPWare , 2002, SCCC.

[10]  Peter Drucker,et al.  A Brief History of Decision Support Systems , 2006 .

[11]  Efraim Turban,et al.  Business Intelligence: Second European Summer School, eBISS 2012, Brussels, Belgium, July 15-21, 2012, Tutorial Lectures , 2013 .

[12]  Francisco J. González-Castaño,et al.  Improving the performance and functionality of Mondrian open-source OLAP systems , 2009 .

[13]  Donovan A. Schneider,et al.  Modeling and querying multidimensional data sources in Siebel Analytics: a federated relational system , 2005, SIGMOD '05.

[14]  Peter Brezany,et al.  On-line analytical processing on large databases managed by computational grids , 2004 .

[15]  Ashish Gupta,et al.  Aggregate-Query Processing in Data Warehousing Environments , 1995, VLDB.

[16]  Valéria Cesário Times,et al.  An open source and web based framework for geographic and multidimensional processing , 2006, SAC '06.