JSW 2014 Vol.9(5): 1055-1061 ISSN: 1796-217X
doi: 10.4304/jsw.9.5.1055-1061
doi: 10.4304/jsw.9.5.1055-1061
Architecture for Near Zero Latency in Datawarehouse
Ahmed Kabiri, Dalila Chiadmi
Université Mohammed V - Agdal, Ecole Mohammadia d'ingénieurs, Rabat, Morocco Morocco
Abstract—Data warehouse (DW) has been widely recognized as an effective solution for integrating diverse information systems. In addition, DW supplies a platform for business intelligence applications which aims to improve the process of decision making. At execution level, after the first load, DW is regularly populated with fresh data by ETL (Extraction, Transformation and Loading) processes. In real setting, DW refreshment is an event managed by DW administrators. Still, non freshness of data is a drawback of classical DW system. In this paper, we suggest a solution for this issue by presenting architecture of near real time DW. We visit DW system layers and we show how they should cooperate. Finally, we define the scope and the challenge of each layer simultaneously with our suggestion to fill its mission.
Index Terms—KANTARA; Data warehouse; real time data warehouse; ETL; ALWASSIT; MDA
Abstract—Data warehouse (DW) has been widely recognized as an effective solution for integrating diverse information systems. In addition, DW supplies a platform for business intelligence applications which aims to improve the process of decision making. At execution level, after the first load, DW is regularly populated with fresh data by ETL (Extraction, Transformation and Loading) processes. In real setting, DW refreshment is an event managed by DW administrators. Still, non freshness of data is a drawback of classical DW system. In this paper, we suggest a solution for this issue by presenting architecture of near real time DW. We visit DW system layers and we show how they should cooperate. Finally, we define the scope and the challenge of each layer simultaneously with our suggestion to fill its mission.
Index Terms—KANTARA; Data warehouse; real time data warehouse; ETL; ALWASSIT; MDA
Cite: Ahmed Kabiri, Dalila Chiadmi, "Architecture for Near Zero Latency in Datawarehouse," Journal of Software vol. 9, no. 5, pp. 1055-1061, 2014.
PREVIOUS PAPER
First page
NEXT PAPER
Trust Management in Peer-to-Peer Networks
General Information
ISSN: 1796-217X (Online)
Frequency: Quarterly
Editor-in-Chief: Prof. Antanas Verikas
Executive Editor: Ms. Yoyo Y. Zhou
Abstracting/ Indexing: DBLP, EBSCO, CNKI, Google Scholar, ProQuest, INSPEC(IET), ULRICH's Periodicals Directory, WorldCat, etc
E-mail: jsweditorialoffice@gmail.com
-
Mar 01, 2024 News!
Vol 19, No 1 has been published with online version [Click]
-
Apr 26, 2021 News!
Vol 14, No 4- Vol 14, No 12 has been indexed by IET-(Inspec) [Click]
-
Nov 18, 2021 News!
Papers published in JSW Vol 16, No 1- Vol 16, No 6 have been indexed by DBLP [Click]
-
Jan 04, 2024 News!
JSW will adopt Article-by-Article Work Flow
-
Nov 02, 2023 News!
Vol 18, No 4 has been published with online version [Click]