From Traditional Data Warehouse To Real Time Data Warehouse

• Published in: Intelligent Systems Design and Applications Vol. 557; pp. 467 - 477
• Main Authors: Bouaziz, Senda, Nabli, Ahlem, Gargouri, Faiez
• Format: Book Chapter
• Language: English
• Published: Switzerland Springer International Publishing AG 2017; Springer International Publishing
• Series: Advances in Intelligent Systems and Computing
• Subjects: Artificial intelligence; Near real time extract-transform-load; Real time data warehouse; Traditional data warehouse
• ISBN: 9783319534794; 3319534793
• ISSN: 2194-5357; 2194-5365
• DOI: 10.1007/978-3-319-53480-0_46

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.