Skip to main content
Top

2020 | OriginalPaper | Chapter

Business Intelligence and Analytics: On-demand ETL over Document Stores

Authors : Manel Souibgui, Faten Atigui, Sadok Ben Yahia, Samira Si-Said Cherfi

Published in: Research Challenges in Information Science

Publisher: Springer International Publishing

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

Abstract

For many decades, Business Intelligence and Analytics (BI&A) has been associated with relational databases. In the era of big data and NoSQL stores, it is important to provide approaches and systems capable of analyzing this type of data for decision-making. In this paper, we present a new BI&A approach that both: (i) extracts, transforms and loads the required data for OLAP analysis (on-demand ETL) from document stores, and (ii) provides the models and the systems required for suitable OLAP analysis. We focus here, on the on-demand ETL stage where, unlike existing works, we consider the dispersion of data over two or more collections.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literature
1.
go back to reference Asanka, P.D.: ETL framework design for NoSQL databases in dataware housing. IJRCAR 3, 67–75 (2015) Asanka, P.D.: ETL framework design for NoSQL databases in dataware housing. IJRCAR 3, 67–75 (2015)
3.
go back to reference Baldacci, L., Golfarelli, M., Graziani, S., Rizzi, S.: QETL: an approach to on-demand ETL from non-owned data sources. Data Knowl. Eng. 112, 17–37 (2017)CrossRef Baldacci, L., Golfarelli, M., Graziani, S., Rizzi, S.: QETL: an approach to on-demand ETL from non-owned data sources. Data Knowl. Eng. 112, 17–37 (2017)CrossRef
4.
go back to reference Chevalier, M., Malki, M.E., Kopliku, A., Teste, O., Tournier, R.: Document-oriented models for data warehouses - NoSQL document-oriented for data warehouses. In: ICEIS 2016 - Proceedings of the 18th International Conference on Enterprise Information Systems, Rome, Italy, 25–28 April, vol. 1, pp. 142–149 (2016) Chevalier, M., Malki, M.E., Kopliku, A., Teste, O., Tournier, R.: Document-oriented models for data warehouses - NoSQL document-oriented for data warehouses. In: ICEIS 2016 - Proceedings of the 18th International Conference on Enterprise Information Systems, Rome, Italy, 25–28 April, vol. 1, pp. 142–149 (2016)
5.
go back to reference Chouder, M.L., Rizzi, S., Chalal, R.: Exodus: exploratory OLAP over document stores. Inf. Syst. 79, 44–57 (2019)CrossRef Chouder, M.L., Rizzi, S., Chalal, R.: Exodus: exploratory OLAP over document stores. Inf. Syst. 79, 44–57 (2019)CrossRef
6.
go back to reference Gallinucci, E., Golfarelli, M., Rizzi, S.: Schema profiling of document-oriented databases. Inf. Syst. 75, 13–25 (2018)CrossRef Gallinucci, E., Golfarelli, M., Rizzi, S.: Schema profiling of document-oriented databases. Inf. Syst. 75, 13–25 (2018)CrossRef
7.
go back to reference Gallinucci, E., Golfarelli, M., Rizzi, S.: Approximate OLAP of document-oriented databases: a variety-aware approach. Inf. Syst. 85, 114–130 (2019)CrossRef Gallinucci, E., Golfarelli, M., Rizzi, S.: Approximate OLAP of document-oriented databases: a variety-aware approach. Inf. Syst. 85, 114–130 (2019)CrossRef
8.
go back to reference Mallek, H., Ghozzi, F., Teste, O., Gargouri, F.: BigDimETL with NoSQL database. In: Knowledge-Based and Intelligent Information & Engineering Systems: Proceedings of the 22nd International Conference KES, Belgrade, Serbia, pp. 798–807 (2018) Mallek, H., Ghozzi, F., Teste, O., Gargouri, F.: BigDimETL with NoSQL database. In: Knowledge-Based and Intelligent Information & Engineering Systems: Proceedings of the 22nd International Conference KES, Belgrade, Serbia, pp. 798–807 (2018)
9.
go back to reference Souibgui, M., Atigui, F., Zammali, S., Cherfi, S.S., Ben Yahia, S.: Data quality in ETL process: a preliminary study. In: Knowledge-Based and Intelligent Information & Engineering Systems: Proceedings of the 23rd International Conference KES-2019, Budapest, Hungary, pp. 676–687 (2019) Souibgui, M., Atigui, F., Zammali, S., Cherfi, S.S., Ben Yahia, S.: Data quality in ETL process: a preliminary study. In: Knowledge-Based and Intelligent Information & Engineering Systems: Proceedings of the 23rd International Conference KES-2019, Budapest, Hungary, pp. 676–687 (2019)
10.
go back to reference Yang, Y., Meneghetti, N., Fehling, R., Liu, Z.H., Kennedy, O.: Lenses: an on-demand approach to ETL. PVLDB 8(12), 1578–1589 (2015) Yang, Y., Meneghetti, N., Fehling, R., Liu, Z.H., Kennedy, O.: Lenses: an on-demand approach to ETL. PVLDB 8(12), 1578–1589 (2015)
Metadata
Title
Business Intelligence and Analytics: On-demand ETL over Document Stores
Authors
Manel Souibgui
Faten Atigui
Sadok Ben Yahia
Samira Si-Said Cherfi
Copyright Year
2020
DOI
https://doi.org/10.1007/978-3-030-50316-1_38

Premium Partner