Data warehouses increasingly are being deployed in the cloud. But both on-premises and cloud data warehouses have pluses and minuses to consider, as explained here.
"Data warehouses are widely used by organizations of all sizes to ingest, store and process large amounts of data for BI and analytics applications," writes Chris Foot in SearchDataManagement.
"They emerged in the 1990s and are a mature, mainstream technology. Nowadays, though, one of the big decisions for an organization that's looking to deploy a data warehouse is whether to put it on premises or in the cloud.
As with other types of IT systems, a cloud data warehouse offers various benefits over an on-premises installation -- for example, easy scalability, more flexibility and less routine management work for database administrators (DBAs)..."
Read More ...