Abstract
While the Self-Service Business Intelligence (BI) becomes an important part of organizational BI solutions there is a great need for new tools allowing to construct ad-hoc queries by users with various responsibilities and skills. The paper presents a Semantic Model for Analytical Queries – SMAQ allowing to construct queries by users familiar with business events and terms, but being unaware of database or data warehouse concepts and query languages such as MDX or SQL. The key idea of SMAQ is to provide a reference model that allows building user interfaces, even those based on natural language, independently on data models and query languages.
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.
Similar content being viewed by others
References
Baader, F., Calvanese, D., McGuinness, D.L., Nardi, D., Patel-Schneider, P.F.: The Description Logic Handbook: Theory, Implementation, Applications. Cambridge University Press (2003)
Brogden, J., Sinkwitz, H., Holden, M., Marks, D., Orthous, G.: SAP BusinessObjects Web Intelligence: The Comprehensive Guide, 2nd edn. Galileo Press (2012)
Corr, L., Stagnitto, J.: Agile Data Warehouse Design Collaborative Dimensional Modeling from Whiteboard to Star Schema. DecisionOne Press (2013)
Gruber, T.R.: A Translation Approach to Portable Ontology Specification. Knowledge Acquisition 5(2), 199–220 (1993)
Horrocks, I., Kutz, O., Sattler, U.: The even more irresistible SROIQ. In: Proc. of the 10th Int. Conf. on Principles of Knowledge Representation and Reasoning (KR 2006), pp. 57–67. AAAI Press (2006)
Loshin, D.: Business Intelligence The Savvy Manager’s Guide, 2nd edn. Morgan Kaufmann (2013)
Luo, S.Y., Wang, Y.L., Guo, J.: Research on Ontology-Based Usable User Interface Layout Approach. In: Computer Sciences and Convergence Information Technology (ICCIT), vol. 1, pp. 234–238 (2009)
Microsoft Corporation and Hyperion Solutions Corporation: XML for Analysis Specification, version 1.1 (November 2002), http://xml.coverpages.org/xmlaV11-20021120.doc
Mundy, J.: Making sense of the semantic layer, http://www.kimballgroup.com/2013/08/05/design-tip-158-making-sense-of-the-semantic-layer
Myers, P.: Introducing the BI Semantic Model in Microsoft SQL Server (October 2012), http://msdn.microsoft.com/en-us/library/jj735264.aspx
Nebot, V., Berlanga, R., Pérez, J.M., Aramburu, M.J., Pedersen, T.B.: Multidimensional integrated ontologies: A framework for designing semantic data warehouses. In: Spaccapietra, S., Zimányi, E., Song, I.-Y. (eds.) Journal on Data Semantics XIII. LNCS, vol. 5530, pp. 1–36. Springer, Heidelberg (2009)
Niemi, T., Niinimäki, M.: Ontologies and summarizability in OLAP. In: Proceedings of SAC 2010. pp. 1349–1353 (March 2010)
Oracle Corp.: Oracle Business Intelligence Foundation Suite (2013), http://www.oracle.com/technetwork/middleware/bi/bi-foundation-suite-wp-215243.pdf?ssSourceSiteId=ocomen
Pardillo, J., Mazón, J.: Using Ontologies for the Design of Data Warehouses. International Journal of Database Management Systems (IJDMS) 3(2), 73–87 (2011)
Prat, N., Akoka, J., Comyn-Wattiau, I.: Transforming multidimensional models into OWL-DL ontologies. In: Proceedings of the 2012 Sixth International Conference on Research Challenges in Information Science (RCiS), pp. 1–12. IEEE Computer Society Press (2012)
Prat, N., Comyn-Wattiau, I., Akoka, J.: Combining objects with rules to represent aggregation knowledge in data warehouse and OLAP systems. Data and Knowledge Engineering 70, 732–752 (2011)
Shahzad, S.K., Granitzer, M., Helic, D.: Ontological Model Driven GUI Development: User Interface Ontology Approach. In: Computer Sciences and Convergence Information Technology (ICCIT), pp. 214–218 (2011)
Tudorache, T., Noy, N.F., Falconer, S.M., Musen, M.A.: A knowledge base driven user interface for collaborative ontology development. In: Proceedings of the 16th International Conference on Intelligent User Interfaces, pp. 411–414 (February 2011)
W3C Recommendation: Mathematical Markup Language (MathML) Version 3.0 (October 2010), http://www.w3.org/TR/MathML3/
W3C Recommendation: OWL.: 2 Web Ontology Language (December 2012), http://www.w3.org/TR/owl-overview
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., Choi, K.-S., Noy, N., Allemang, D., Lee, K.-I., Nixon, L.J.B., Golbeck, J., Mika, P., Maynard, D., Mizoguchi, R., Schreiber, G., Cudré-Mauroux, P. (eds.) ASWC 2007 and ISWC 2007. LNCS, vol. 4825, pp. 857–870. Springer, Heidelberg (2007)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer International Publishing Switzerland
About this paper
Cite this paper
Zawadzka, T. (2014). SMAQ – A Semantic Model for Analytical Queries. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds) Beyond Databases, Architectures, and Structures. BDAS 2014. Communications in Computer and Information Science, vol 424. Springer, Cham. https://doi.org/10.1007/978-3-319-06932-6_13
Download citation
DOI: https://doi.org/10.1007/978-3-319-06932-6_13
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-06931-9
Online ISBN: 978-3-319-06932-6
eBook Packages: Computer ScienceComputer Science (R0)