Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Abelló, A., Darmont, J., Etcheverry, L., Golfarelli, M., Mazón, J.N., Naumann, F., Pedersen, T.B., Rizzi, S., Trujillo, J., Vassiliadis, P., Vossen, G.: Fusion Cubes: Towards Self-Service Business Intelligence. IJDWM 9(2), 66–88 (2013)
Adomavicius, G., Tuzhilin, A.: Toward the Next Generation of Recommender Systems: A Survey of the State-of-the-Art and Possible Extensions. IEEE TKDE 17(6), 734–749 (2005)
Adomavicius, G., Tuzhilin, A.: Context-Aware Recommender Systems. In: Recommender Systems Handbook, pp. 217–253. Springer (2011)
Akbarnejad, J., Chatzopoulou, G., Eirinaki, M., Koshy, S., Mittal, S., On, D., Polyzotis, N., Varman, J.S.V.: SQL QueRIE Recommendations. PVLDB 3(2), 1597–1600 (2010)
Aligon, J., Golfarelli, M., Marcel, P., Rizzi, S., Turricchia, E.: Similarity Measures for OLAP Sessions. In: KAIS, pp. 1–27 (2013)
Aufaure, M.-A., Kuchmann-Beauger, N., Marcel, P., Rizzi, S., Vanrompay, Y.: Predicting Your Next OLAP Query Based on Recent Analytical Sessions. In: Bellatreche, L., Mohania, M.K. (eds.) DaWaK 2013. LNCS, vol. 8057, pp. 134–145. Springer, Heidelberg (2013)
Bellatreche, L., Giacometti, A., Marcel, P., Mouloudi, H., Laurent, D.: A Personalization Framework for OLAP Queries. In: DOLAP, pp. 9–18 (2005)
Chatzopoulou, G., Eirinaki, M., Polyzotis, N.: Query Recommendations for Interactive Database Exploration. In: Winslett, M. (ed.) SSDBM 2009. LNCS, vol. 5566, pp. 3–18. Springer, Heidelberg (2009)
Essaidi, M.: ODBIS: Towards a Platform for On-Demand Business Intelligence Services. In: EDBT/ICDT Workshops (2010)
Foshay, N., Mukherjee, A., Taylor, A.: Does Data Warehouse End-User Metadata Add Value? Commun. ACM 50(11), 70–77 (2007)
Giacometti, A., Marcel, P., Negre, E.: A Framework for Recommending OLAP Queries. In: DOLAP, pp. 73–80 (2008)
Golfarelli, M., Rizzi, S.: Expressing OLAP Preferences. In: Winslett, M. (ed.) SSDBM 2009. LNCS, vol. 5566, pp. 83–91. Springer, Heidelberg (2009)
Golfarelli, M., Rizzi, S., Biondi, P.: myOLAP: An Approach to Express and Evaluate OLAP Preferences. IEEE TKDE 23(7), 1050–1064 (2011)
Jovanovic, P., Romero, O., Simitsis, A., Abelló, A., Mayorova, D.: A Requirement-Driven Approach to the Design and Evolution of Data Warehouses. IS (2014)
Jovanovic, P., Romero, O., Simitsis, A., Abelló, A.: Integrating ETL Processes from Information Requirements. In: Cuzzocrea, A., Dayal, U. (eds.) DaWaK 2012. LNCS, vol. 7448, pp. 65–80. Springer, Heidelberg (2012)
Khoussainova, N., Balazinska, M., Gatterbauer, W., Kwon, Y., Suciu, D.: A Case for A Collaborative Query Management System. In: CIDR (2009)
Khoussainova, N., Kwon, Y., Balazinska, M., Suciu, D.: SnipSuggest: Context-Aware Autocompletion for SQL. PVLDB 4(1), 22–33 (2010)
Kimball, R., Reeves, L., Ross, M., Thornthwaite, W.: The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing, and Deploying Data Warehouses. John Wiley & Sons, Inc. (1998)
Leonard, A., Masson, M., Mitchell, T., Moss, J., Ufford, M.: Business Intelligence Markup Language. In: SQL Server 2012 Integration Services Design Patterns, pp. 301–326. Springer (2012)
Löser, A., Hueske, F., Markl, V.: Situational Business Intelligence. In: Castellanos, M., Dayal, U., Sellis, T. (eds.) BIRTE 2008. LNBIP, vol. 27, pp. 1–11. Springer, Heidelberg (2009)
Mazón, J.N., Zubcoff, J.J., Garrigós, I., Espinosa, R., Rodríguez, R.: Open Business Intelligence: On the Importance of Data Quality Awareness in User-Friendly Data Mining. In: EDBT/ICDT Workshops, pp. 144–147 (2012)
Middelfart, M., Pedersen, T.B.: The Meta-Morphing Model Used in TARGIT BI Suite. In: De Troyer, O., Bauzer Medeiros, C., Billen, R., Hallot, P., Simitsis, A., Van Mingroot, H. (eds.) ER 2011 Workshops. LNCS, vol. 6999, pp. 364–370. Springer, Heidelberg (2011)
Morton, K., Balazinska, M., Grossman, D., Mackinlay, J.D.: Support the Data Enthusiast: Challenges for Next-Generation Data-Analysis Systems. PVLDB 7(6), 453–456 (2014)
Naumann, F.: Data Profiling Revisited. SIGMOD Record 32(4) (2013)
Object Management Group: Common Warehouse Metamodel Specification 1.1, http://www.omg.org/spec/CWM/1.1/PDF/ (last accessed January 2014)
Pedersen, T.B.: Multidimensional Modeling. In: Encyclopedia of Database Systems, pp. 1777–1784. Springer US (2009)
Romero, O., Abelló, A.: On the Need of a Reference Algebra for OLAP. In: Song, I.-Y., Eder, J., Nguyen, T.M. (eds.) DaWaK 2007. LNCS, vol. 4654, pp. 99–110. Springer, Heidelberg (2007)
Sellam, T., Kersten, M.L.: Meet Charles, Big Data Query Advisor. In: CIDR (2013)
Skoutas, D., Simitsis, A.: Ontology-Based Conceptual Design of ETL Processes for Both Structured and Semi-Structured Data. IJSWIS 3(4), 1–24 (2007)
Stefanidis, K., Drosou, M., Pitoura, E.: “You May Also Like” Results in Relational Databases. In: PersDB Workshop (2009)
Yang, X., Procopiuc, C.M., Srivastava, D.: Recommending Join Queries via Query Log Analysis. In: ICDE, pp. 964–975 (2009)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
Varga, J., Romero, O., Pedersen, T.B., Thomsen, C. (2014). Towards Next Generation BI Systems: The Analytical Metadata Challenge. In: Bellatreche, L., Mohania, M.K. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2014. Lecture Notes in Computer Science, vol 8646. Springer, Cham. https://doi.org/10.1007/978-3-319-10160-6_9
Download citation
DOI: https://doi.org/10.1007/978-3-319-10160-6_9
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-10159-0
Online ISBN: 978-3-319-10160-6
eBook Packages: Computer ScienceComputer Science (R0)