A Comparative Analysis of Traditional and Cloud Data Warehouse

Authors

  • Khawaja Ubaid ur Rehman Department of Computer Science, University of Management and Technology, Lahore, Punjab
  • Umair Ahmad Department of Computer Science, University of Management and Technology, Lahore, Punjab, Pakistan
  • Sajid Mahmood Department of Informatics and Systems, University of Management and Technology, Lahore, Punjab

DOI:

https://doi.org/10.21015/vtcs.v15i1.487

Abstract

In the age of emerging technologies, the amount of data is increasing very rapidly. With the passage of time, the methods of data handling are getting improved. Prediction analysis is quite a tough task, but it also yields interesting results. Different sectors like financial services, transportation, health and education are generating large amount of data. The emergence of web 2.0 (social web) made it possible for users and researchers to analyze and predict huge amount of data. The domain of Business Intelligence is core technology for users who want to extract useful information for decision making regarding their businesses. Data warehouse provides an insight into the business processes using the historical data. However, traditional data warehouse may not be suitable for the data analysis needs because of the evolving requirement of industry. It cannot be scaled up or down. Moreover, it cannot handle the increasing number of users. A new kind of data warehouse with design and implementation aspects has been emerged, called as cloud data warehouse. The cloud data warehouse model has evolved with the passage of time, which affects the application and business domains as well. The cloud data warehouse has evolved to control the large scale data. It can be scaled up or down at any time and also it has no limitation on increasing number of users. In this review paper, we have compared traditional and cloud data warehouse. We can conclude that the ultimate future of data warehouse is cloud data warehouse.

References

Chaudhuri, S., & Dayal, U. (1997). An overview of data warehousing and OLAP technology. ACM Sigmod record, 26(1), 65-74.

Inmon, W. H. (2005). Building the data warehouse. John wiley & sons.

El-Sappagh, S. H. A., Hendawi, A. M. A., & El Bastawissy, A. H. (2011). A proposed model for data warehouse ETL processes. Journal of King Saud University-Computer and Information Sciences, 23(2), 91-104.

Chaudhuri, S., Dayal, U., & Narasayya, V. (2011). An overview of business intelligence technology. Communications of the ACM, 54(8), 88-98.

Agrawal, D., Das, S., & El Abbadi, A. (2011, March). Big data and cloud computing: current state and future opportunities. In Proceedings of the 14th International Conference on Extending Database Technology (pp. 530-533). ACM.

Duan, L., & Da Xu, L. (2012). Business intelligence for enterprise systems: a survey. IEEE Transactions on Industrial Informatics, 8(3), 679-687.

Chen, H., Chiang, R. H., & Storey, V. C. (2012). Business intelligence and analytics: from big data to big impact. MIS quarterly, 1165-1188.

Cuzzocrea, A., Bellatreche, L., & Song, I. Y. (2013, October). Data warehousing and OLAP over big data: current challenges and future research directions. In Proceedings of the sixteenth international workshop on Data warehousing and OLAP (pp. 67-70). ACM.

Laker, K. (n.d.). (2017, March 03) Data Warehousing in the Cloud - Part 1. Retrieved from https://blogs.oracle.com/datawarehousing/data-warehousing-in-the-cloud-part-1

STEIER, T. (2018, May 25). To Cloud or Not to Cloud: Where Does Your Data Warehouse Belong? Retrieved from https://www.wired.com/insights/2013/05/to-cloud-or-not-to-cloud-where-does-your-data-warehouse-belong

Widom, J. (1995, December). Research problems in data warehousing. In Proceedings of the fourth international conference on Information and knowledge management (pp. 25-30). ACM.

Abadi, D. J. (2009). Data management in the cloud: Limitations and opportunities. IEEE Data Eng. Bull., 32(1), 3-12.

Guermazi, E., Ayed, M. B., & Ben-Abdallah, H. (2015, June). Adaptive security for Cloud data warehouse as a service. In Computer and Information Science (ICIS), 2015 IEEE/ACIS 14th International Conference on (pp. 647-650). IEEE.

Nimje, A. R. (2015). Data Analytics as a Service (DAaaS): An Arriving Technology in Cloud Computing. International Journal of Emerging Trend in Engineering and Basic Sciences, 2(1).

Kurunji, S., Ge, T., Liu, B., & Chen, C. X. (2012, December). Communication cost optimization for cloud Data Warehouse queries. In Cloud Computing Technology and Science (CloudCom), 2012 IEEE 4th International Conference on (pp. 512-519). IEEE.

Lv, H. L., Wang, F. V., Van, A. M., & Cheng, V. L. (2012). Design of cloud data warehouse and its application in smart grid.

Abdelaziz, E., & Mohamed, O. (2015, December). Optimisation of the queries execution plan in cloud data warehouses. In Information and Communication Technologies (WICT), 2015 5th World Congress on (pp. 219-133). IEEE.

Sakr, S., Liu, A., Batista, D. M., & Alomari, M. (2011). A survey of large scale data management approaches in cloud environments. IEEE Communications Surveys & Tutorials, 13(3), 311-336.

Hussain, M., Al-Haiqi, A., Zaidan, A. A., Zaidan, B. B., Kiah, M., Iqbal, S., ... & Abdulnabi, M. (2018). A security framework for mHealth apps on Android platform. Computers & Security, 75, 191-217.

Iqbal, S., Kiah, M. L. M., Dhaghighi, B., Hussain, M., Khan, S., Khan, M. K., & Choo, K. K. R. (2016). On cloud security attacks: A taxonomy and intrusion detection and prevention as a service. Journal of Network and Computer Applications, 74, 98-120.

Khan, Y. D., Ahmad, F., & Anwar, M. W. (2012). A neuro-cognitive approach for iris recognition using back propagation. World Applied Sciences Journal, 16(5), 678-685.

Khan, Y. D., Khan, S. A., Ahmad, F., & Islam, S. (2014). Iris recognition using image moments and k-means algorithm. The Scientific World Journal, 2014.

Khan, Y. D., Ahmed, F., & Khan, S. A. (2014). Situation recognition using image moments and recurrent neural networks. Neural Computing and Applications, 24(7-8), 1519-1529.

Khan, Y. D., Khan, N. S., Farooq, S., Abid, A., Khan, S. A., Ahmad, F., & Mahmood, M. K. (2014). An Efficient Algorithm for Recognition of Human Actions. The Scientific World Journal, 2014.

Khan, Y. D., Abid, A., Farooq, M. S., Abid, K., & Farooq, U. A QUALITATIVE ANALYSIS OF FEATURE EXTRACTION BASED ACTION RECOGNITION TECHNIQUES.

Abid, A., Hussain, N., Abid, K., Ahmad, F., Farooq, M. S., Farooq, U., ... & Sabir, N. (2016). A survey on search results diversification techniques. Neural Computing and Applications, 27(5), 1207-1229.

Downloads

Published

2018-03-30

How to Cite

Rehman, K. U. ur, Ahmad, U., & Mahmood, S. (2018). A Comparative Analysis of Traditional and Cloud Data Warehouse. VAWKUM Transactions on Computer Sciences, 6(1), 34–40. https://doi.org/10.21015/vtcs.v15i1.487

Issue

Vol. 6 No. 1 (2018): January-December

Section

Articles

License

Authors who publish with this journal agree to the following terms:

  1. Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License (CC-By) that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
  2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
  3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).

                                      

This work is licensed under a Creative Commons Attribution  License CC BY