Skip to main content
SpringerLink
Log in

SMAQ – A Semantic Model for Analytical Queries

  • Conference paper
Beyond Databases, Architectures, and Structures (BDAS 2014)

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 424))

  • 1337 Accesses

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

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Baader, F., Calvanese, D., McGuinness, D.L., Nardi, D., Patel-Schneider, P.F.: The Description Logic Handbook: Theory, Implementation, Applications. Cambridge University Press (2003)

    Google Scholar 

  2. Brogden, J., Sinkwitz, H., Holden, M., Marks, D., Orthous, G.: SAP BusinessObjects Web Intelligence: The Comprehensive Guide, 2nd edn. Galileo Press (2012)

    Google Scholar 

  3. Corr, L., Stagnitto, J.: Agile Data Warehouse Design Collaborative Dimensional Modeling from Whiteboard to Star Schema. DecisionOne Press (2013)

    Google Scholar 

  4. Gruber, T.R.: A Translation Approach to Portable Ontology Specification. Knowledge Acquisition 5(2), 199–220 (1993)

    Article  Google Scholar 

  5. 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)

    Google Scholar 

  6. Loshin, D.: Business Intelligence The Savvy Manager’s Guide, 2nd edn. Morgan Kaufmann (2013)

    Google Scholar 

  7. 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)

    Google Scholar 

  8. Microsoft Corporation and Hyperion Solutions Corporation: XML for Analysis Specification, version 1.1 (November 2002), http://xml.coverpages.org/xmlaV11-20021120.doc

  9. Mundy, J.: Making sense of the semantic layer, http://www.kimballgroup.com/2013/08/05/design-tip-158-making-sense-of-the-semantic-layer

  10. Myers, P.: Introducing the BI Semantic Model in Microsoft SQL Server (October 2012), http://msdn.microsoft.com/en-us/library/jj735264.aspx

  11. 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)

    Chapter  Google Scholar 

  12. Niemi, T., Niinimäki, M.: Ontologies and summarizability in OLAP. In: Proceedings of SAC 2010. pp. 1349–1353 (March 2010)

    Google Scholar 

  13. Oracle Corp.: Oracle Business Intelligence Foundation Suite (2013), http://www.oracle.com/technetwork/middleware/bi/bi-foundation-suite-wp-215243.pdf?ssSourceSiteId=ocomen

  14. 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)

    Article  Google Scholar 

  15. 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)

    Google Scholar 

  16. 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)

    Article  Google Scholar 

  17. 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)

    Google Scholar 

  18. 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)

    Google Scholar 

  19. W3C Recommendation: Mathematical Markup Language (MathML) Version 3.0 (October 2010), http://www.w3.org/TR/MathML3/

  20. W3C Recommendation: OWL.: 2 Web Ontology Language (December 2012), http://www.w3.org/TR/owl-overview

  21. 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)

    Chapter  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Software Engineering, Gdańsk University of Technology, ul. Gabriela Narutowicza 11/12, 80-233, Gdańsk, Poland

    Teresa Zawadzka

Authors
  1. Teresa Zawadzka
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Teresa Zawadzka .

Editor information

Editors and Affiliations

  1. Silesian University of Technology Inst. Computing Science, Gliwice, Poland

    Stanislaw Kozielski

  2. Silesian University of Technology Institute of Informatics, Gliwice, Poland

    Dariusz Mrozek

  3. Silesian University of Technology, Gliwice, Poland

    Pawel Kasprowski

  4. Silesian University of Technology, Gliwice, Poland

    Bożena Małysiak-Mrozek

  5. Silesian University of Technology, Gliwice,, Poland

    Daniel Kostrzewa

Rights and permissions

Reprints 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)

Publish with us

Policies and ethics

Search

Navigation