CFP last date
20 May 2024
Reseach Article

Survey on Data Warehouse from Traditional to Realtime and Society Impact of Real Time Data

by Farhad Alam, Neel Kamal
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 177 - Number 9
Year of Publication: 2019
Authors: Farhad Alam, Neel Kamal
10.5120/ijca2019919463

Farhad Alam, Neel Kamal . Survey on Data Warehouse from Traditional to Realtime and Society Impact of Real Time Data. International Journal of Computer Applications. 177, 9 ( Oct 2019), 20-24. DOI=10.5120/ijca2019919463

@article{ 10.5120/ijca2019919463,
author = { Farhad Alam, Neel Kamal },
title = { Survey on Data Warehouse from Traditional to Realtime and Society Impact of Real Time Data },
journal = { International Journal of Computer Applications },
issue_date = { Oct 2019 },
volume = { 177 },
number = { 9 },
month = { Oct },
year = { 2019 },
issn = { 0975-8887 },
pages = { 20-24 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume177/number9/30925-2019919463/ },
doi = { 10.5120/ijca2019919463 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-07T00:45:24.502300+05:30
%A Farhad Alam
%A Neel Kamal
%T Survey on Data Warehouse from Traditional to Realtime and Society Impact of Real Time Data
%J International Journal of Computer Applications
%@ 0975-8887
%V 177
%N 9
%P 20-24
%D 2019
%I Foundation of Computer Science (FCS), NY, USA
Abstract

The traditional data-warehouse don’t have real-data or near to real-data or today-data. Generally, the data loading into traditional-data warehouse from operation sources whether its single or multiple and its scheduled on weekly bases or nightly bases. And these kinds of data is hard to think to make some decision and to do some prediction and treat them. As todays to make some conclusions in the corporate world become more and more real-time or near to real-time systems for end-users. It is only natural that data-warehouse business intelligence bi decision support and olap systems rapidly start to incorporate real-time data. 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 and what is the society impact of real-time data. this survey is also focus on data-warehouse architecture. It details the changes in the extract-transform-load process to deal with real time data-warehousing. 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.

References
  1. Ravi, J., 2007. Real-Time Data Streaming Tools and Technologies – An Overview.
  2. Xenon StackInnovator:www.xenonstack.com/insights/real-time-data-streaming.
  3. Isaac, S., 2018. Real-time data processing with data streaming: new tools for a new era.
  4. Ricardo, J., Santos, J. B. and Marco, V., 2012. Leveraging 24/7 Availability and Performance for Distributed Real-Time Data Warehouses. Conference: COMPSAC 2012 - IEEE Signature Conference on Computer Software & Applications and DOI: 10.1109/COMPSAC.2012.92
  5. AttunityADivisionofQlik:www.attunity.com/solutions/data-warehousing/real-time-data-warehousing.
  6. DatawarehouseBlogs:http://blogsofdatawarehousing.blogspot.com/2017/02/federated-data-warehouse-architecture.html.
  7. Isaac, S., 2018. Real-time data processing with data streaming: new tools for a new era.
  8. Babak,Y., Seyedfaraz, Y., Nasseh, T., 2017. Developing a Real-Time Data Analytics Framework for Twitter Streaming Data.Published in IEEE International Congress on Big Data and DOI:10.1109/bigdatacongress.2017.49.
  9. Jukic, N., 2006. Modeling strategies and alternatives for data warehousing projects. Communications of the ACM, 49(4), pp.83-88.
  10. Kimball, R. and Ross, M., 2011. The data warehouse toolkit: the complete guide to dimensional modeling. John Wiley & Sons.
  11. Cuzzocrea, A., Song, I.Y. and Davis, K.C., 2011, October. Analytics over large-scale multidimensional data: the big data revolution!. In Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP (pp. 101-104). ACM.
  12. Golfarelli, M., Rizzi, S. and Cella, I., 2004, November. Beyond data warehousing: what's next in business intelligence?. In Proceedings of the 7th ACM international workshop on Data warehousing and OLAP (pp. 1-6). ACM.
  13. Jarke, M., Lenzerini, M., Vassiliou, Y., Vassiliadis, P., 2003. Fundamentals of Data Warehouses, second ed. Springer-Verlag.
  14. Felix, G. and Norbert, R., 2016. Scalable data management: NoSQL data stores in research and practice. In Conference: 2016 IEEE 32nd International Conference on Data Engineering (ICDE) and DOI: 10.1109/ICDE.2016.7498360.
  15. Wolfram, W., 2017. A Real-Time Database Survey: The Architecture of Meteor, RethinkDB, Parse & Firebase.
Index Terms

Computer Science
Information Sciences

Keywords

Traditional Data Warehouse (DWH) OR Enterprise data-warehouse (EDW) Real Time Data Warehous(RTDW Near to Real Time Extract-Transform-Load Real Time Data Society Impact.