Skip to main content

Thinking the Incorporation of LOD in Semantic Cubes as a Strategic Decision

  • Conference paper
  • First Online:

Part of the book series: Lecture Notes in Computer Science ((LNPSE,volume 11815))

Abstract

With the advent of Linked Open Data (LOD) initiatives, organizations have seen the opportunity of augmenting their internal data cube systems with these external data. While IT actors manage technical issues of internal and external sources, a new actor has emerged “the Chief Data Officer” (CDO), the role of which is to align and prioritize data activities with key organizational priorities and goals. Existing literature managing the incorporation of LOD in internal Data cubes mainly focus on technical aspects of the LOD source and ignores the CDO role in this strategy. In this paper, we claim that technical actions should be conducted by the managerial level, which is reflected through the goals of the organization data cube and their related Key Performance Indicators (KPIs). For doing this, we first propose a metamodel aligning the three models: the data-flow model, the goal model and the KPI model. Then, we propose a process for specifying KPIs into Sparql language, the standard language for querying LOD sources. Experiments are conducted to measure the impact of the decision of integrating external LOD sources at KPI/goal level and on the technical data level. A case tool dedicated to the CDO is implemented to conduct the proposed approach.

This is a preview of subscription content, log in via an institution.

Buying options

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 EPUB and 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

Learn about institutional subscriptions

Notes

  1. 1.

    https://www.w3.org/DesignIssues/LinkedData.html.

  2. 2.

    http://wiki.dbpedia.org/.

  3. 3.

    https://www.ibm.com/downloads/cas/MQBM7GOW.

  4. 4.

    https://www.dataversity.net/chief-data-officer-challenge-build-data-strategy/.

  5. 5.

    https://www.ibm.com/downloads/cas/MQBM7GOW.

  6. 6.

    https://www.tamr.com/blog/three-generations-of-ai/.

  7. 7.

    https://aws.amazon.com/fr/blogs/machine-learning/tuning-your-dbms-automatically-with-machine-learning/.

  8. 8.

    http://qweb.cs.aau.dk/qboairbase/.

  9. 9.

    https://www.w3.org/Submission/SWRL/.

  10. 10.

    http://qweb.cs.aau.dk/qboairbase/.

  11. 11.

    https://www.eea.europa.eu/data-and-maps/data/airbase-the-european-air-quality-database-8.

References

  1. Abelló Gamazo, A., Gallinucci, E., Golfarelli, M., Rizzi Bach, S., Romero Moral, O.: Towards exploratory OLAP on linked data. In: SEBD, pp. 86–93 (2016)

    Google Scholar 

  2. Baldacci, L., Golfarelli, M., Graziani, S., Rizzi, S.: Qetl: an approach to on-demand etl from non-owned data sources. DKE 112, 17–37 (2017)

    Article  Google Scholar 

  3. Barone, D., Jiang, L., Amyot, D., Mylopoulos, J.: Reasoning with key performance indicators. In: Johannesson, P., Krogstie, J., Opdahl, A.L. (eds.) PoEM 2011. LNBIP, vol. 92, pp. 82–96. Springer, Heidelberg (2011). https://doi.org/10.1007/978-3-642-24849-8_7

    Chapter  Google Scholar 

  4. Berkani, N., Khouri, S., Bellatreche, L.: Value-driven approach for designing extended data warehouses. In: DOLAP (2019)

    Google Scholar 

  5. Ciferri, C., Ciferri, R., Gómez, L., Schneider, M., Vaisman, A., Zimányi, E.: Cube algebra: a generic user-centric model and query language for olap cubes. Int. J. Data Warehouse. Min. (IJDWM) 9(2), 39–65 (2013)

    Article  Google Scholar 

  6. Deb Nath, R.P., Hose, K., Pedersen, T.B.: Towards a programmable semantic extract-transform-load framework for semantic data warehouses. In: DOLAP, pp. 15–24 (2015)

    Google Scholar 

  7. Djilani, Z.: Donner une autre vie à vos besoins fonctionnels : une approche dirigée par l’entreposage et l’analyse en ligne. (Give Another Life to Your Functional Requirements : An Approach Drvicen by Warehousing and Online Anaysis). Ph.D. thesis, École nationale supérieure de mécanique et d’aérotechnique, France (2017)

    Google Scholar 

  8. Etcheverry, L., Vaisman, A.: Querying semantic web data cubes. In: AMW, pp. 11–23 (2016)

    Google Scholar 

  9. Etcheverry, L., Vaisman, A., Zimányi, E.: Modeling and querying data warehouses on the semantic web using QB4OLAP. In: Bellatreche, L., Mohania, M.K. (eds.) DaWaK 2014. LNCS, vol. 8646, pp. 45–56. Springer, Cham (2014). https://doi.org/10.1007/978-3-319-10160-6_5

    Chapter  Google Scholar 

  10. Gallinucci, E., Golfarelli, M., Rizzi, S., Abell, A., Romero, O.: Interactive multidimensional modeling of linked data for exploratory olap. Inf. Syst. 77, 86–104 (2018)

    Article  Google Scholar 

  11. Gray, C.S.: Modern Strategy, vol. 42. Oxford University Press, Oxford (1999)

    Google Scholar 

  12. Horkoff, J., et al.: Strategic business modeling: representation and reasoning. SSM 13(3), 1015–1041 (2014)

    Google Scholar 

  13. Khouri, S., Aouimer, Y., Bellatreche, L., Ghomari, A.R.: Intgrer les LOD dans un cube de données : transformer une action technique en une dcision organisationnelle. In: To appear in Journes Entrepts de Donnes et Analyse en ligne (EDA 2019). RNTI (2019)

    Google Scholar 

  14. Khouri, S., Semassel, K., Bellatreche, L.: Managing data warehouse traceability: a life-cycle driven approach. In: Zdravkovic, J., Kirikova, M., Johannesson, P. (eds.) CAiSE 2015. LNCS, vol. 9097, pp. 199–213. Springer, Cham (2015). https://doi.org/10.1007/978-3-319-19069-3_13

    Chapter  Google Scholar 

  15. Maté, A., Trujillo, J., Mylopoulos, J.: Conceptual modeling for indicator selection. Conceptual Modeling Perspectives, pp. 55–68. Springer, Cham (2017). https://doi.org/10.1007/978-3-319-67271-7_5

    Chapter  Google Scholar 

  16. Maté, A., Trujillo, J., Mylopoulos, J.: Specification and derivation of key performance indicators for business analytics: a semantic approach. DKE 108, 30–49 (2017)

    Article  Google Scholar 

  17. Matei, A., Chao, K.-M., Godwin, N.: OLAP for multidimensional semantic web databases. In: Castellanos, M., Dayal, U., Pedersen, T.B., Tatbul, N. (eds.) BIRTE 2013-2014. LNBIP, vol. 206, pp. 81–96. Springer, Heidelberg (2015). https://doi.org/10.1007/978-3-662-46839-5_6

    Chapter  Google Scholar 

  18. Rizzi, S., Abelló, A., Lechtenbörger, J., Trujillo, J.: Research in data warehouse modeling and design: dead or alive? In: DOLAP, pp. 3–10 (2006)

    Google Scholar 

  19. Saad, R., Teste, O., Trojahn, C.: OLAP manipulations on RDF data following a constellation model. In: 1st International Workshop on Semantic Statistics (2013)

    Google Scholar 

  20. Silva Souza, V.E., Mazn, J.N., Garrigs, I., Trujillo, J., Mylopoulos, J.: Monitoring strategic goals in data warehouses with awareness requirements. In: ACM SAC, pp. 10–75 (2012)

    Google Scholar 

  21. Tort, F., Teulier, R., Grosz, G., Charlet, J.: Ingénierie des besoins, ingénierie des connaissances: similarités et complémentarités des approches de modélisation. In: Journées francophones d’ingénierie des connaissances, pp. 263–275 (2000)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Selma Khouri .

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Khouri, S., Ghomari, A.R., Aouimer, Y. (2019). Thinking the Incorporation of LOD in Semantic Cubes as a Strategic Decision. In: Schewe, KD., Singh, N. (eds) Model and Data Engineering. MEDI 2019. Lecture Notes in Computer Science(), vol 11815. Springer, Cham. https://doi.org/10.1007/978-3-030-32065-2_20

Download citation

  • DOI: https://doi.org/10.1007/978-3-030-32065-2_20

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-030-32064-5

  • Online ISBN: 978-3-030-32065-2

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics