Cloud Data Warehousing for SMEs

Sérgio Fernandes, Jorge Bernardino

2016

Abstract

The emergence of cloud computing caused a revolution in the universe of Information Technology. With cloud computing solutions it is possible to access powerful features, hardware and software in less time and with considerably lower costs by using the model "pay-as-you-go". At the same time, this turnover increased information, and data warehouses must respond to this new reality. Small and medium enterprises (SMEs) were deprived of owning a traditional data warehouse due to the costs involved, but the cloud has made it possible to overcome this barrier. This paper provides an overview of Data Warehouse (DW) in the cloud and presents the main characteristics of the following solutions: Amazon Redshift, IBM dashDB, Snowflake, Teradata Active Data Warehouse Private Cloud, Treasure Data, and Microsoft Azure.

References

  1. Malliga, P., “Database Services for Cloud Computing - An Overview” International Journal of Computers & Technology, Volume 2 No. 3, June, 2012.
  2. Redshift [online] http://aws.amazon.com/pt/redshift/ (Accessed June 2015).
  3. Dashdb [online] http://www-01.ibm.com/software/data/da shdb/what-is.html (Accessed February 2016).
  4. Snowflake [online] http://www.snowflake.net/ (Accessed February 2016).
  5. Teradata [online] http://www.teradata.com/Teradata-ADW -Private-Cloud/ (Accessed February 2016).
  6. Treasure [online] https://www.treasuredata.com/ (Accessed February 2016).
  7. Microsoft Azure [online] https://azure.microsoft.com/ (Accessed February 2016).
  8. Kaur, Harjeet, Agrawal, Prateek and Dhiman, Amita, “Visualizing Clouds on Different Stages of DWH - An Introduction to Data Warehouse as a Service”, 2012 Int. Conference on Computing Sciences.
  9. DB-Engines Ranking [online] http://db-engines.com/en/ ranking (Accessed February 2016).
  10. Pathak, A. R., “Survey of Confidentiality and Integrity in Outsourced Databases” Int. Journal of Scientific Engineering and Technology, 1 April 2013.
  11. Showflake Computing: A New Take on a Data Warehousing in the Cloud [online] http://tdwi.org/ articles/2015/02/17/snowflake-computing.aspx (Accessed February 2016).
  12. Henschen, D., “5 Analytics, BI, Data Management Trends For 2015” [online] https://www.ironsidegroup.com/20 15/02/02/top-5-trends-in-cloud-data-warehousing-andanalytics-for-2015/ (Accessed March 2016).
  13. Lock, M., “Rapid Insight with Results: Harnessing Analytics in the Cloud”, June 2014.
  14. Deployment Options for Cloud Computing [online] http://www.b-eye-network.com/blogs/eckerson/archiv es/2011/07/deployment_opti.php (Accessed March 2016).
  15. Teradata Turns to the Cloud, Offers Data Warehouse as a Service [online] http://www.cio.com/article/2381531/b usiness-intelligence/teradata-turns-to-the-cloud--offers -data-warehouse-as-a-service.html (Accessed March 2015).
  16. Microsoft Corporation, “The Microsoft Modern Data Warehouse”, 2013. (Accessed March 2016) Available http://download.microsoft.com/download/c/2/d/c2d2d 5fa-768a-49ad-8957-1a434c6c8126/the_microsoft_mo dern_data_warehouse_white_paper.pdf.
  17. Abramova, V. and Bernardino, J., 2013. NoSQL databases: MongoDB vs Cassandra. In International C* Conference on Computer Science and Software Engineering (C3S2E 7813). ACM, New York, USA.
  18. Neves, P. C. and Bernardino, J.. Big Data in the Cloud: A Survey. Open Journal of Big Data (OJBD) Vol 1 (2), pp. 1-18, 2015.
Download


Paper Citation


in Harvard Style

Fernandes S. and Bernardino J. (2016). Cloud Data Warehousing for SMEs . In Proceedings of the 11th International Joint Conference on Software Technologies - Volume 1: ICSOFT-EA, (ICSOFT 2016) ISBN 978-989-758-194-6, pages 276-282. DOI: 10.5220/0005996502760282


in Bibtex Style

@conference{icsoft-ea16,
author={Sérgio Fernandes and Jorge Bernardino},
title={Cloud Data Warehousing for SMEs},
booktitle={Proceedings of the 11th International Joint Conference on Software Technologies - Volume 1: ICSOFT-EA, (ICSOFT 2016)},
year={2016},
pages={276-282},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005996502760282},
isbn={978-989-758-194-6},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 11th International Joint Conference on Software Technologies - Volume 1: ICSOFT-EA, (ICSOFT 2016)
TI - Cloud Data Warehousing for SMEs
SN - 978-989-758-194-6
AU - Fernandes S.
AU - Bernardino J.
PY - 2016
SP - 276
EP - 282
DO - 10.5220/0005996502760282