Cloud Data Warehouses

By Daniel A.

Data warehouses are quickly being prioritized as one of the forms for data which compromises of data marts, quality of data, and a great amount of information the user needs. There are many benefits to data warehousing and of course, there are many issues that come with data warehousing. The greatest benefit of data warehousing is the use for analysis of information and decision-making purposes.

One of the company’, Dah Sing Life Assurance Company uses eBaoTech’s data warehouse. The company, eBaoTech, helps to “support decision making for daily operation of its middle and senior management.” (Dah Sing). Because of this, the cost and difficulty will be reduced when needing in integrate the aforementioned data. With the company’s new solution, the newly acquired information which consists of, premiums, claims, finances and so forth, can now be used for analytical reports for various areas. Which “will help insurers in decision making by enabling them to identify market opportunities, solve management issues, and optimize operation process” (Dah Sing). By replacing their old system, they are now more productive and increases cooperation within the company.

Amazon, in 2013, announced the making of Redshift, a “cloud-based data warehousing service” (Ingrid Lunden). This service allows other companies who are looking to store their data for their services. Amazon teaming up with other third parties has allowed the integration of newer and wider information technology services “by also offering analytics and other services on top of it” (Lunden). Through their pricing, they mention that a terabyte’s worth of data will be less than a thousand dollars. While the “equivalent data warehousing solution was $19,000-$25,000 per terabyte” (Lunden). Amazon has created a service which allows large companies to analyze a greater amount of their data and smaller companies a cheaper and more rapid data warehousing technology.

Microsoft has also gone into the data warehousing industry by creating the new Azure SQL (Standard Query Language) Data Warehouse. This will “give businesses access to an elastic petabyte-scale, data warehouse-as-a-service offering that can scale according to their needs” (Frederic Lardinois). Companies will be charged with the amount of storage being used and the “hourly compute rate they incur while working with the data” (Lardinois). Not only are they saving companies storing the data, but it will also be saving them time. According to Azure, “other data warehouses can take hours or days to resize, while SQL Data Warehouse can adjust to a user’s needs in minutes” (Lardinois).

Data warehouses are constantly getting bigger and bigger, and as they get bigger, more resources are needed in order to keep up with the rising surge in data. With new data warehouse services becoming cheaper and providing analytical services with it, companies are now able to spend less and do more with these new services.



Works Cited

Dah Sing Life Assurance Company selects eBaoTech’s data warehouse solution. (2015, April       21). Progressive Media Group.

Lunden, I. (2013, February 13). Amazon Takes Redshift, Its Cloud-Based Data Warehouse          Killer, Global. Retrieved January 20, 2016, Retrieved from      warehouse-killer-global/

Lardinois, F. (2015, April 29). Microsoft Introduces Azure SQL Data Warehouse. Retrieved        from    January 20, 2016, from      azure-sql-data-warehouse/#.bwm5hx4:OXej