Towards Next Generation BI Systems: The Analytical Metadata Challenge

Next generation Business Intelligence (BI) systems require integration of heterogeneous data sources and a strong user-centric orientation. Both needs entail machine-processable metadata to enable automation and allow end users to gain access to relevant data for their decision making processes. Although evidently needed, there is no clear picture about the necessary metadata artifacts, especially considering user support requirements. Therefore, we propose a comprehensive metadata framework to support the user assistance activities and their automation in the context of next generation BI systems. This framework is based on the findings of a survey of current user-centric approaches mainly focusing on query recommendation assistance. Finally, we discuss the benefits of the framework and present the plans for future work.

[1]  Arnaud Giacometti,et al.  A framework for recommending OLAP queries , 2008, DOLAP '08.

[2]  Divesh Srivastava,et al.  Recommending Join Queries via Query Log Analysis , 2009, 2009 IEEE 25th International Conference on Data Engineering.

[3]  Moez Essaidi,et al.  ODBIS: towards a platform for on-demand business intelligence services , 2010, EDBT '10.

[4]  Francesco Ricci,et al.  Context-Aware Recommender Systems , 2011, AI Mag..

[5]  Torben Bach Pedersen,et al.  The Meta-Morphing Model Used in TARGIT BI Suite , 2011, ER Workshops.

[6]  Dan Suciu,et al.  SnipSuggest: Context-Aware Autocompletion for SQL , 2010, Proc. VLDB Endow..

[7]  Alberto Abelló,et al.  Integrating ETL Processes from Information Requirements , 2012, DaWaK.

[8]  Irene Garrigós,et al.  Open business intelligence: on the importance of data quality awareness in user-friendly data mining , 2012, EDBT-ICDT '12.

[9]  Matteo Golfarelli,et al.  myOLAP: An Approach to Express and Evaluate OLAP Preferences , 2011, IEEE Transactions on Knowledge and Data Engineering.

[10]  Felix Naumann,et al.  Data profiling revisited , 2014, SGMD.

[11]  Stefano Rizzi,et al.  Predicting Your Next OLAP Query Based on Recent Analytical Sessions , 2013, DaWaK.

[12]  Neoklis Polyzotis,et al.  Query Recommendations for Interactive Database Exploration , 2009, SSDBM.

[13]  Alberto Abelló,et al.  On the Need of a Reference Algebra for OLAP , 2007, DaWaK.

[14]  Umeshwar Dayal,et al.  Business Intelligence for the Real-Time Enterprise , 2009 .

[15]  Ralph Kimball,et al.  The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom , 1998 .

[16]  Magdalena Balazinska,et al.  Support the Data Enthusiast: Challenges for Next-Generation Data-Analysis Systems , 2014, Proc. VLDB Endow..

[17]  Tim Mitchell,et al.  Business Intelligence Markup Language , 2012 .

[18]  Martin L. Kersten,et al.  Meet Charles, big data query advisor , 2013, CIDR.

[19]  Neil Foshay,et al.  Does data warehouse end-user metadata add value? , 2007, CACM.

[20]  Matteo Golfarelli,et al.  Expressing OLAP Preferences , 2009, SSDBM.

[21]  Neoklis Polyzotis,et al.  SQL QueRIE recommendations , 2010, Proc. VLDB Endow..

[22]  Volker Markl,et al.  Situational Business Intelligence , 2008, BIRTE.

[23]  Gediminas Adomavicius,et al.  Toward the next generation of recommender systems: a survey of the state-of-the-art and possible extensions , 2005, IEEE Transactions on Knowledge and Data Engineering.

[24]  Marianne Winslett,et al.  Scientific and Statistical Database Management, 21st International Conference, SSDBM 2009, New Orleans, LA, USA, June 2-4, 2009, Proceedings , 2009, SSDBM.

[25]  Alberto Abelló,et al.  A requirement-driven approach to the design and evolution of data warehouses , 2014, Inf. Syst..

[26]  Michael Schrefl,et al.  Bitemporal Support for Business Process Contingency Management , 2015, ER Workshops.

[27]  Matteo Golfarelli,et al.  Similarity measures for OLAP sessions , 2013, Knowledge and Information Systems.

[28]  Dimitrios Skoutas,et al.  Ontology-Based Conceptual Design of ETL Processes for Both Structured and Semi-Structured Data , 2007, Int. J. Semantic Web Inf. Syst..

[29]  Dan Suciu,et al.  A Case for A Collaborative Query Management System , 2009, CIDR.

[30]  E. Weintraub,et al.  Recent Developments and New Directions , 1974 .

[31]  Evaggelia Pitoura,et al.  "You May Also Like" Results in Relational Databases , 2009 .

[32]  Gottfried Vossen,et al.  Towards Self-Service Business Intelligence , 2013 .

[33]  Arnaud Giacometti,et al.  A personalization framework for OLAP queries , 2005, DOLAP '05.