Blogs

Best of all worlds: A hybrid data warehouse approach that delivers cloud-like flexibility

Post Comment
Program Director for Data Warehouse Marketing, IBM

Front-running companies have a history of leveraging technical innovation to achieve their desired business outcomes. In 2014, for example, the IBM Institute for Business Value said in its “Analytics: The Speed Advantage” report that savvy companies’ ability to turn huge volumes of data into insights1 before the competition does helps them act more quickly in the marketplace than their competitors can. Similarly, in its 2016 report “The Hybrid Data Warehouse: Fluid Flexible and Formidable,” the Aberdeen Group reported that “hybrid data warehouse users saw almost twice the year-over-year increase in revenue as others.” Not surprisingly, innovative companies stand a better chance of winning in the marketplace when they leverage more data and use more flexible solutions2 than their competitors.

IBM’s data warehousing strategy is built around a hybrid data warehouse architecture. Such an architecture suits a varied data placement strategy by handling data on-premises and in the cloud, as well as in a mixture of both, and it enables management of a full range of data: structured and unstructured, at rest and in motion. Though the traditional data warehouse remains at the core of the hybrid solution, it is surrounded by next-generation technologies that offer a hybrid approach designed to meet a broadened range of analytics needs.

http://www.ibmbigdatahub.com/sites/default/files/cloud-flex-blog.jpgBringing flexibility and simplicity together

IBM is pleased to introduce dashDB Local as a deployment option for data warehousing that delivers a configured data warehouse to private clouds and software-defined infrastructures via container technology. dashDB Local became available in an early access preview in 2016 and has now reached its general availability milestone.

dashDB Local and the fully managed IBM dashDB share a common SQL engine, built-in analytics and other technology designed to provide a complete spectrum of data warehousing capabilities. dashDB Local, however, is a client-managed option that aims to deliver cloudlike flexibility and control along with the simplicity of deployment needed to help you address analytics requests as they arise.

Taking the data center to the next level of capability

One standout feature of dashDB Local is its Spark integration. dashDB Local provides embedded open-source Spark capabilities out of the box, giving users access to a secure and multitenant Spark execution environment. This, in turn, allows Spark applications to be deployed and called from inside the data warehouse itself. Like dashDB, dashDB Local includes IBM BLU Acceleration in-memory technology designed to help provide ultra-fast processing of large data sets; massively parallel processing (MPP) for scaling in, up and out, a rich set of Netezza analytics and high-performance load and unload capabilities with which to seek even deeper insights from data.

Participants in the dashDB Local preview program have reported a range of benefits, including installation times of just a few minutes as well as the ability to speedily process large volumes of data. “We are very impressed with the performance,” said one tester. “Within no time, we have grown our data set of 40 million to 200 million records (a few terabytes), and the analytics test queries run effortlessly.” Indeed, whether they use bare metal or virtualization, participants are responding favorably to the ability to take their data center infrastructure to the next level of capability.

To find out for yourself, begin your own free trial of IBM dashDB Local. When you do, be sure to register for a architect James Cho’s technical overview webcast on dashDB Local and the hybrid data warehouse solution, scheduled for 23 August 2016.

Also, be sure to register for World of Watson, your new home for putting data to work.

1Analytics: The Speed Advantage, IBM, 2014

2The Hybrid Data Warehouse: Fluid, Flexible, and Formidible, IBM, 2016