Data Warehousing

WHITEPAPER: Cloud Computing Models for Data Warehousing

Grazed from Teradata. Author: Editorial Staff.

Cloud computing is creating a new era for IT by providing a set of services that appears to have infinite capacity, immediate deployment and high availability at trivial cost. It's the result of the evolution of computing and communications technology from a high-value asset to a simple commodity. In that evolution, the focus shifts from the concept of computing as a physical thing in a data center to computing as a service, like electricity, that is accessible from the nearest network connection.

Today most organizations are looking at cloud as a way to lower data center and IT provisioning costs. While cost reduction is a real benefit, there is more value in the increased speed, flexibility and ease of delivery in cloud environments. The only way to gain these advantages is by changing the approach and practices for delivering applications and data...

WhereScape Announces Automation to Fast-track Design and Development for Cloud Data Warehouse Snowflake

WhereScape today announced WhereScape automation for Snowflake, an offering created  to help IT organizations accelerate the delivery of cloud-based data infrastructure projects. This week in Anaheim, California, WhereScape will present the new offering at the TDWI Conference

WhereScape automation for Snowflake automates key development and operations workflows for Snowflake customers based on the native functions, wizards and best practices of Snowflake and incorporates data warehouse modeling methodologies such as 3NF, dimensional and Data Vault 2.0. Snowflake provides cloud-based data warehousing solutions that deliver the performance, elasticity, scalability, concurrency and simplicity needed to store and analyze all of an organization's data in one location.


Snowflake Computing raises $100 million to expand cloud data warehouse footprint

Grazed from ZDNet. Author: Editorial Staff.

Snowflake Computing, a cloud data warehouse vendor, has closed a $100 million funding round as it aims to expand internationally. The company, built on Amazon Web Services, was founded in 2012 and has raised $205 million so far. The funding round was led by ICONIQ Capital and Madrona Venture Group and included its initial venture partners. Snowflake said it will build out its engineering team as it aims to take more on-premise data warehouse workloads. CEO Bob Muglia, a former Microsoft exec, said the funding will help Snowflake scale. I caught up with Muglia to talk shop. Among the key themes:

Building on Amazon Web Services. Snowflake's cloud data warehouse service is built on AWS, which also competes via Redshift and other offerings. "AWS has treated us well. We compete with them obviously, but they are great partners," said Muglia. Translation: Netflix is built on AWS and competes with Amazon. Snowflake is a data warehouse spin on that theme...

Read more from the source @

The Data Warehouse Has Failed, Will Cloud Computing Die Next?

Grazed from Forbes. Author: Adrian Bridgwater.

There’s a trend in IT firms. CEOs and evangelists like to try and coin the next major buzz phrase with the word ‘data’ in it. There’s big data, fast data, data analytics, data provenance, time-series data and then there are data lakes, data marts and the data warehouse. TechTarget defines the data warehouse as federated repository (either physical or logical) for all the data that an enterprise's various business systems collect.

Data warehouse, in simple English

To use a simple retail analogy, specific groups of users or jobs lead to the creation of data markets (we will call them ‘data marts’)… and in the same way that markets are fed by a central distribution and storage warehouse, individual data marts all come together to reside in a bigger data warehouse...

What Should The Data Warehouse Become In The Cloud?

Grazed from Forbes. Author: Dan Woods.

Judging from the momentum from all of the big players, if you have a data warehouse, you will soon be asked if it is time to move to the cloud. This is a big decision. Most companies have been working for many years on their data warehouse, and are not going to move it anywhere or change how it works without good reason.

So, the vendors are going to have to make a strong case to justify this move. You will be provided with different reasons depending on who is doing the persuading. Some vendors will suggest you move everything to a new solution in the cloud. Others will suggest you add an outpost in the cloud. Others may suggest you move all or part of your existing data warehouse to the cloud...

Read more from the source @

Cloud data warehouse race heats up

 Grazed from ZDNet.  Author: Andrew Brust.

The notion of running a data warehouse in the cloud was a pretty novel thing when Amazon Web Services launched its Redshift service in November of 2012. Most on-premises data warehouse (DW) platforms are appliance-based, which makes them difficult to expand, and the resulting need to leave room for growth also makes them expensive to acquire.

In the cloud though, economics are better, elasticity is realistic and logistics are streamlined. Combine that with the ability to handle "big data" volumes with the familiar SQL/relational model that Redshift uses and it's hardly surprising that the service has been one of Amazon's fastest growing since its launch...

BitYota cloud data warehouse gets a boost from Microsoft Azure

Grazed from ComputerWorld.  Author: Joab Jackson.

Hoping to enlarge its pool of corporate customers to include the enterprise market, startup BitYota will soon offer its data warehouse service on the Microsoft Azure cloud, thanks to a partnership between the two companies.  "Microsoft is truly partnering with us, not just providing a compute infrastructure," said Graham Summers, BitYota chief operating officer. "There are so many parts of the organization we can tap into."

Although BitYota's early customer base has largely been small businesses and startups, traditional enterprises are increasingly considering the service for new projects, Summers said. They could use the cloud service to analyze marketing or operational data, without the need to set up all the hardware and software infrastructure to maintain a data warehouse in-house...

Snowflake's Data Warehouse Runs on Relational Database in the Cloud

Grazed from TalkinCloud. Author: Mike Vizard.

Relational databases were not designed from the ground up for the cloud or, for that matter, to handle big data. Nobody knows that better than Bob Muglia, former head of the Server and Tools division of Microsoft (MSFT). As the CEO of startup Snowflake Computing, Muglia has taken the wraps off a Snowflake Elastic Data Warehouse service in the cloud, built on top of a relational database that Snowflake developed specifically for that purpose.

In addition, Snowflake Computing announced it has picked up an additional $26 million in funding, part of which will be used to create a customer and partner ecosystem around the new cloud service. After a brief detour at Juniper Networks, Muglia is back in the software infrastructure business...

Snowflake Raises $26M, Introduces Cloud-based Elastic Data Warehouse

Grazed from Talkin Cloud. Author: CJ Arlotta.

Snowflake Computing is coming out of stealth mode with a big name CEO, new venture capital financing, and a plan to reinvent the data warehouse for the cloud. Redpoint Ventures led the Series B funding round, with participation from Sutter Hill Ventures and Wing Ventures. This round brings the company's total financing to date to $26 million.

Snowflake said it plans to use the new financing to expand its engineering and sales organization, and scale the company by putting in place the right systems and teams. "We are working closely with partners in the data warehousing space, particularly companies that provide business intelligence and extract-transform load solutions to customers," said Bob Muglia, CEO at Snowflake...

Redshift is game changer for data warehouse in the cloud

Grazed from TechTarget. Author: David Linthicum.

Data warehouses back in the day were hugely expensive. No matter which database you deployed to, you could count on a cool million-dollar minimum investment to get things up and running. A data warehouse, while often defined differently, is just a database that contains abstractions of transactional data used for making business decisions. Data analysis tools run against the data, and the output is different views of that, including reports and visualized data.

In the past, Oracle and other larger enterprise players ruled the data warehousing world. With the emergence of cloud-based solutions, such as data warehouse storage that runs on public cloud providers, the cost of building and deploying a data warehouse has been significantly reduced...