Data Warehouse Hosting – a new trend

On-demand data warehousing allows you to quickly deploy a scalable, secure data warehouse and realize business benefits without spending large sums of money and lengthy project implementation that drains precious IT resources.
You simply pay on a pay-per-use basis, without having to worry about data warehouse implementation, administration, support, maintenance, etc.
CIO and IT Managers. Get the Data Warehouse that you know the business need but couldn’t afford it! Get it quickly and inexpensively.
Provide reports, analysis, and optimizations that the business desire in an expeditious manner without requiring more staff.
The Software-as-a-Service (SaaS) delivery model allows you to,very quickly implement a business solution, secondlyno upfront capital expenditure with pay-as-you-go model.
Also Drastically reduce demands on internal IT resources and most importantlyno investment in hiring for skilled resources. No on-going system administration headaches.
Many companies introduce data warehouse hosting, and an example is the Amazon.
Adding to an already considerable set of cloud IT offerings, Amazon has introduced a hosted data warehouse service called Redshift, pitching it as a lower-cost alternative to on-premise data warehouse deployments.
Redshift works with a number of business intelligence (BI) applications, including software packages from Microstrategy, SAP, IBM and Jaspersoft. Users would use one of these BI packages to parse data in the Amazon cloud, using PostgreSQL drivers along with ODBC (Open Database Connectivity) and JDBC (Java Database Connectivity) APIs.
Users can store up to 1.6 petabytes, in either 2 terabyte or 16 terabyte nodes, up to 100 nodes. The data will be stored in a columnar format so the queries will be much faster.
Amazon is not the only service offering data warehousing tools. Google also offers the capability to store large amounts of structured data for analysis through its BigQuery service. Recently, BI software provider Tableau Software released a connecter that would allow its customers to work with BigQuery through Tableau’s own software.