Enabling Self-Service BI on Document Stores

Mohamed Lamine Chouder, Stefano Rizzi, Rachid Chalal
2017 International Conference on Extending Database Technology  
The growing use of document stores has resulted in vast amounts of semi-structured data holding precious information, which could be profitably integrated into existing BI systems. Unfortunately, due to their schemaless nature, document stores are hardly accessible via direct OLAP querying. In this paper we propose an interactive, schema-on-read approach for finding multidimensional structures in document stores aimed at enabling OLAP querying in the context of self-service BI. Our approach
more » ... s in three steps: multidimensional enrichment, querying, and OLAP enabling; the validation of user queries and the detection of multidimensional structures is based on the mining of approximate functional dependencies from data. The efficiency of our approach is discussed with reference to real datasets.
dblp:conf/edbt/ChouderRC17 fatcat:bj7zlof3u5cvfdyc2w5iumdwm4