Abstract
Analytical Information Systems (AIS) enable analysts to visualize and analyze large amounts of data. They are based on a Data Warehouse in whose context typically various types of metadata are used. Often these metadata slightly consider additional information especially concerning the Multidimensional Data Model (MDM) like definitions, business rules, terminology or background information. By adding this metadata, particularly regarding the linked data movement, a significant improvement in the domain of AIS can be achieved. Our approach suggests a semantic metadata layer that enhances the AIS to allow modeling additional information in form of real-world entities. These entities correlate with MDM elements and are derived and integrated from various external structured sources. As a prototype we show the feasibility of this approach through a filter component that filters classification nodes with information not covered by the MDM.
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
Auth, G.: Prozessorientierte Organisation des Metadatenmanagements für Data-Warehouse-Systeme. Books on Demand, Norderstedt (2004)
Bauer, A., Günzel, H.: Data Warehouse Systeme – Architektur, Entwicklung, Anwendung, 3. Auflage edition. dpunkt, Heidelberg (2009)
Bizer, C., Heath, T., Berners-Lee, T.: Linked Data: Principles and State of the Art. In: World Wide Web Internet and Web Information Systems (April 2008)
Blunschi, L., Jossen, C., Kossmann, D., Mori, M., Stockinger, K.: Data-Thirsty Business Analysts need SODA – Search Over Data Warehouse. In: Proceedings of the 20th ACM International Conference on Information and Knowledge Management, CIKM 2011, pp. 2525–2528. ACM, New York (2011)
Berthold, H., Rösch, P., Zöller, S., Wortmann, F., Carenini, A., Campbell, S., Bisson, P., Strohmaier, F.: An Architecture for Ad-hoc and Collaborative Business Intelligence. In: Proceedings of the 2010 EDBT/ICDT Workshops, EDBT 2010, pp. 13:1–13:6. ACM, New York (2010)
Diamantini, C., Potena, D.: Semantic Enrichment of Strategic Datacubes. In: DOLAP 2008: Proceeding of the ACM 11th International Workshop on Data Warehousing and OLAP, pp. 81–88. ACM, New York (2008)
Imhoff, C., White, C.: Self-Service Business Intelligence – Empowering Users to Generate Insights. Tdwi best practices report, TDWI (2011)
Kemper, H.-G., Baars, H., Mehanna, W.: Business Intelligence – Grundlagen und praktische Anwendungen, 3. Auflage edition. Vieweg+Teubner, Wiesbaden (2010)
Mertens, M., Krahn, T.: Knowledge Based Business Intelligence for Business User Information Self-Service. In: Brüggemann, S., d’Amato, C. (eds.) Collaboration and the Semantic Web, pp. 271–296. IGI Global, Hershey (2012)
ONeil, B.: Semantics and Business. The Data Administration (2007)
Spahn, M., Kleb, J., Grimm, S., Scheidl, S.: Supporting business intelligence by providing ontology-based end-user information self-service. In: OBI, p. 10 (2008)
Teiken, Y., Rohde, M., Mertens, M.: MUSTANG: Realisierung eines Analytischen Informationssystems im Kontext der Gesundheitsberichtserstattung. In: Informatik 2010: Service Science – Neue Perspektiven für die Informatik. CEUR Workshop Proceedings, pp. 53–68 (2010)
Xie, G.T., Yang, Y., Liu, S., Qiu, Z., Pan, Y., Zhou, X.: EIAW: Towards a Business-Friendly Data Warehouse Using Semantic Web Technologies. In: Aberer, K., et al. (eds.) ISWC/ASWC 2007. LNCS, vol. 4825, pp. 857–870. Springer, Heidelberg (2007)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Mertens, M., Krahn, T., Appelrath, H.J. (2013). Utilizing Structured Information from Multiple External Sources in the Context of the Multidimensional Data Model. In: Abramowicz, W. (eds) Business Information Systems. BIS 2013. Lecture Notes in Business Information Processing, vol 157. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-38366-3_8
Download citation
DOI: https://doi.org/10.1007/978-3-642-38366-3_8
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-38365-6
Online ISBN: 978-3-642-38366-3
eBook Packages: Computer ScienceComputer Science (R0)