WikiOlapBase: A collaborative tool for open data processing and integration

  • Pedro M. Bernardo CEFET-MG
  • Ismael S. Silva CEFET-MG
  • Glívia A. R. Barbosa CEFET-MG
  • Flávio R. S. Coutinho CEFET-MG
  • Evandrino G. Barros CEFET-MG


The technological advances have made data sharing and knowledge generation possible in several areas. In order to support information extraction and knowledge generation, several datasets have been made publicly available, giving rise to the concept of open data. However, while such data are available, the processing, visualization, and analysis of them by society, in general, can be considered difficult tasks. Data are available to a great volume, in different files and formats, making it difficult to cross-reference and analyze them to obtain relevant information without the support of appropriate tools. Inspired by this scenario, this paper presents WikiOlapBase, a collaborative tool capable of processing, integrating and making feasible the analysis of open data from different sources, even by people without technical knowledge. WikiOlapBase contributes to the expansion of open data analysis, since it favors a greater information sharing and knowledge dissemination.


De Diana, M. and Gerosa, M. A. (2010). Nosql na web 2.0: Um estudo comparativo de bancos não-relacionais para armazenamento de dados na web 2.0.

Ding, L. et al. (2010). Data-gov wiki: Towards linking government data. Graves, A. and Hendler, J. (2013). Visualization tools for open government data. In Proceedings of the 14th Annual International Conference on Digital Government Research, dg.o ’13, pages 136–145, New York, NY, USA. ACM.

Gupta, P. et al. (2012). Utilizing mvc in web development courses. J. Comput. Sci. Coll., 27(3):10–14.

Hilbert, M. (2013). Big data for development: From information-to knowledge societies.

Hoxha, J. and Brahaj, A. (2011). Open government data on the web: A semantic approach. In Emerging Intelligent Data and Web Technologies (EIDWT), 2011 International Conference on, pages 107–113. IEEE.

Kolaczkowski, P. (2014). Lightning fast cluster computing with spark and cassandra. Presentation at the CodeMesh-London event, available at, visited in 18-October-2016.

Maleshkova, M. et al. (2010). Investigating web apis on the world wide web. In Web Services (ECOWS), 2010 IEEE 8th European Conference on, pages 107–114.

Moniruzzaman, A. and Hossain, S. A. (2013). Nosql database: New era of databases for big data analytics-classification, characteristics and comparison. arXiv preprint arXiv:1307.0191.

Nielsen, J. (1994). Usability inspection methods. In Conference companion on Human factors in computing systems, pages 413–414. ACM.

Nielsen, J. (2000). Why you only need to test with 5 users. [Online; visited 23-October-2016].

Plekhanova, J. (2009). Evaluating web development frameworks: Django, ruby on rails and cakephp. Institute for Business and Information Technology.

Rubin, J. and Chisnell, D. (2008). Handbook of usability testing: how to plan, design and conduct effective tests. John Wiley & Sons.

Sagiroglu, S. and Sinanc, D. (2013). Big data: A review. In Collaboration Technologies and Systems (CTS), 2013 International Conference on, pages 42–47. IEEE.

Sorjonen, S. (2012). Olap query performance in column oriented databases.

Tang, D. et al. (2004). Design choices when architecting visualizations. Information Visualization, 3(2):65–79.

Turner, T. (2002). What is metadata. Kaleidoscope, 10(7):1–3.

Vaz, J. C. et al. (2010). Dados governamentais abertos e seus impactos sobre os conceitos e práticas de transparência no brasil. Cadernos ppg-au/ufba, 9(1).

Viegas, F. B. et al. (2007). Manyeyes: A site for visualization at internet scale. IEEE Transactions on Visualization and Computer Graphics, 13(6):1121–1128.
Como Citar

Selecione um Formato
BERNARDO, Pedro M.; SILVA, Ismael S.; BARBOSA, Glívia A. R.; COUTINHO, Flávio R. S.; BARROS, Evandrino G.. WikiOlapBase: A collaborative tool for open data processing and integration. In: SIMPÓSIO BRASILEIRO DE SISTEMAS COLABORATIVOS (SBSC), 14. , 2017, São Paulo. Anais [...]. Porto Alegre: Sociedade Brasileira de Computação, 2017 . p. 1429-1443. ISSN 2326-2842. DOI: