Skip to main content
SpringerLink
Log in

From Traditional Data Warehouse To Real Time Data Warehouse

  • Conference paper
  • First Online:
Intelligent Systems Design and Applications (ISDA 2016)

Part of the book series: Advances in Intelligent Systems and Computing ((AISC,volume 557))

Abstract

The Traditional data warehouse did not contain data as today. Hence, it is difficult to retrieve these data and treat them. Furthermore, its content is not updated, which may lead to bad decisions. Data are typically loaded from conventional operational systems. Given that today’s decisions, in the business world, are becoming more and more in real time. Thus, the system supporting these decisions is to be held. In this paper, we are interested in giving a survey on data warehousing starting from a traditional data warehouse to a real time data warehouse. This survey, focus firstly, on data warehouse architecture. Secondly, it details the changes in the Extract-Transform-Load process to deal with real time data warehousing. Thirdly, it sketches the integration data in the real time data warehouse. Finally, a comparative study concerning the real data warehouse approaching is also presented in this paper.

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 259.00
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 329.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

Notes

  1. 1.

    https://fr.talend.com/products/real-time-big-data.

References

  1. Basu, R.: Challenges of real-time data warehousing (2003). www.dmreview.com

  2. Ferreira, N., Martins, P., Furtado, P.: Near real-time with traditional data warehouse architectures: factors and how-to. In: Proceedings of the 17th International Database Engineering & Applications Symposium, IDEAS’13, New York, NY, USA, pp. 68–75. ACM (2013). http://doi.acm.org/10.1145/2513591.2513650

  3. Langseth, J.: Real-time data warehousing: Challenges and solutions (2004). http://dssresources.com

  4. Lebdaoui, I., Orhanou, G., ElHajji, S.: Data integrity in real-time data warehousing. In: Proceedings of the World Congress on Engineering, vol. 3 (2013)

    Google Scholar 

  5. Lebdaoui, I., Orhanou, G., Elhajji, S.: An integration adaptation for real-time datawarehousing. Int. J. Softw. Eng. Appl. 8(11), 115–128 (2014)

    Google Scholar 

  6. Levy, E.: What is real-time data warehousing? (2005). www.dmreview.com

  7. Obali, M., Dursun, B., Erdem, Z., Grr, A.K.: A real time data warehouse approach for data processing. In: Signal Processing and Communications Applications Conference SIU 2013 21st, pp. 1–4 (2013)

    Google Scholar 

  8. Santos, J.R., Bernardino, J.: Real-time data warehouse loading methodology. In: Proceedings of the 2008 International Symposium on Database Engineering & Applications, IDEAS’08, New York, NY, USA, pp. 49–58. ACM (2008). http://doi.acm.org/10.1145/1451940.1451949

  9. Vassiliadis, P., Simitsis, A.: Near real time ETL, pp. 1–31. Springer, Boston (2009). http://dx.doi.org/10.1007/978-0-387-87431-9_2

  10. Wibowo, A.: Problems and available solutions on the stage of extract, transform, and loading in near real-time data warehousing. In: 2015 International Seminar on Intelligent Technology and Its Applications (ISITIA), pp. 345–350, May 2015

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. MIRACL Laboratory, Faculty of Sciences, Sfax University, BP 1171, Sfax, Tunisia

    Senda Bouaziz & Ahlem Nabli

  2. Tunisia MIRACL Laboratory, Institute of Computer Science and Multimedia, Sfax University, BP 1030, Sfax, Tunisia

    Faiez Gargouri

Authors
  1. Senda Bouaziz
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Ahlem Nabli
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Faiez Gargouri
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Senda Bouaziz .

Editor information

Editors and Affiliations

  1. Departamento de Engenharia Informática, Instituto Superior de Engenharia do Port, Porto, Portugal

    Ana Maria Madureira

  2. Scientific Network for Innovation and Research Excellence, Machine Intelligence Research Labs, Auburn, Washington, USA

    Ajith Abraham

  3. Polytechnic Institute of Porto, Felgueiras, Portugal

    Dorabela Gamboa

  4. Campus of Gualtar, University of Minho, Braga, Portugal

    Paulo Novais

Rights and permissions

Reprints and permissions

Copyright information

© 2017 Springer International Publishing AG

About this paper

Cite this paper

Bouaziz, S., Nabli, A., Gargouri, F. (2017). From Traditional Data Warehouse To Real Time Data Warehouse. In: Madureira, A., Abraham, A., Gamboa, D., Novais, P. (eds) Intelligent Systems Design and Applications. ISDA 2016. Advances in Intelligent Systems and Computing, vol 557. Springer, Cham. https://doi.org/10.1007/978-3-319-53480-0_46

Download citation

  • DOI: https://doi.org/10.1007/978-3-319-53480-0_46

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-319-53479-4

  • Online ISBN: 978-3-319-53480-0

  • eBook Packages: EngineeringEngineering (R0)

Publish with us

Policies and ethics

Search

Navigation