What is dashDB for analytics?

dashDB for analytics is a data warehousing and analytics solution. Use dashDB for analytics to store relational data, including special types such as geospatial data. Then analyze that data with SQL or advanced built-in analytics like predictive analytics and data mining, analytics with R, and geospatial analytics. You can leverage the in-memory database technology to use both columnar and row-based tables. dashDB for analytics enables you to get faster insights from your data by leveraging a cloud data warehouse with in-database analytics and massively parallel processing.

dashdb full managed

Fully managed

Manages setup, configuration and operations, so you get up and running quickly without wasting time

dashdb high performance

High performance

Designed for performance and scale, utilizing technologies including IBM's BLU Acceleration and embedded Netezza in-database analytics

dashdb integrated analytics

Integrated analytics

Run both standard and custom predictive models directly in the cloud. Open source R and RStudio are included as well

dashDB for analytics features

dashdb blu acceleration

Advanced processing with BLU Acceleration

Advanced processing: Does not require the entire data set to fit in memory, while still processing at lightning-fast speeds.

Prefetching of data: Anticipates and prefetches data just before it's needed and automatically adapts to keep necessary data in or close to the CPU.

No decompression required: Preserves the order of data and performs a broad range of operations on compressed data, drastically speeding processing.

Data skipping: Automatically determines which data would not qualify for analysis within a particular query, enabling large chunks of data to be skipped.

Learn more

dashdb and r

Open source R for predictive modeling

R is an open source programming language that was developed for advanced data analysis and visualization. It can be used to analyze data from many data sources, including external files or databases.

dashDB for analytics integrates R for predictive modeling through an R runtime alongside the data. A web console can be used to load data and perform analytics within minutes. With dashDB for analytics and open source R, your analytical options are limitless.

IBM dashDB for analytics includes RStudio, a fully integrated R development environment designed to provide quick, R-based predictive analytics.

RStudio provides an R language code completion feature, integrated help for R packages, file management capabilities and much more.

See it in action

Learn more


dashdb in-database analytics

In-database analytics

dashDB for analytics integrates IBM Netezza® Analytics - also used IBM Netezza appliances and IBM PureData for Analytics systems - for in-database advanced analytics.

Myriad predictive modeling algorithms are built directly into the database and are available whenever you want to use them.

It comes equipped with multiple algorithms, including linear regression, decision tree clustering, k-means clustering and Esri-compatible geospatial extensions.

By running the analytics natively in the database, where the data resides, you can gain huge efficiencies.

See it in action

Learn more


dashdb mmp

MPP for speed and scale with large data sets

The MPP option builds upon the benefits of the standard dashDB service, with even more speed and scale, so you can handle much larger data sets.

Multiple servers work on the same query simultaneously, and the processing of the query at each server is further parallelized across all the processors in that server.

It also leverages BLU dynamic in-memory columnar store technology, which minimizes I/O even further and achieves an order of magnitude in speed when compared to conventional row store databases.

Performance increases with each new server added to the network cluster, and scaling out is as simple as adding additional servers to your cluster.

Learn more


How to use dashDB

dashDB with IBM Cognos Business Intelligence

More than 90 percent of clients plan to augment their existing data warehouses. dashDB is well structured for this use. Through dashDB, organizations can extend on-premises data warehouse environments to the cloud. Since you only pay for the capacity you need, the platform is elastic and there when you want it. With dashDB, you're not forced into buying utility before it's required.

Integrate products with dashDB


dashDB connects seamlessly with a wide ecosystem of business intelligence toolsets including Watson Analytics and many third-party BI tools.

IBM Cloudant

 

Easily synchronize your JSON data in Cloudant with structured data in dashDB at the push of a button.

It allows for traditional BI and analytics to instantly be applied to web and mobile application data stored in the cloud.

IBM Bluemix Data Connect

 

Prepare and move data from multiple sources through IBM Bluemix Data Connect and land it in dashDB for advanced analysis.

Native integrations between dashDB and IBM Bluemix Data Connect empower your organization's cloud data ecosystem.

IBM Insights for Twitter

 

Load Twitter data directly into dashDB just like any other data source for sentiment analysis and social analytics.

Insights for Twitter access is built directly into the dashDB console for simple availability.

IBM Watson Analytics

 

Explore the data you already have in dashDB through self-serve analytics with Watson Analytics.

Load data directly from dashDB through a simple connection interface built directly into Watson Analytics.

IBM Simple Data Pipe

 

Simple Data Pipe is an open source project that is able to move data from cloud sources like Salesforce and Stripe into dashDB.

Leverage the application as it is or use our Data Connect APIs to build your own.

Get started with a dashDB trial

Get started with IBM dashDB

Client success stories

 

Avnet Services

"dashDB is helping us break down barriers to analytics, and make deep insights available to everyone."

Ted Johnson, Director of Infrastructure, Avnet Services

 Read story (PDF, 714 KB)

RSG Medias

"With IBM dashDB and Cloudant, we can leverage a modern and complete cloud-based data analytics portfolio, which allows us to accelerate our delivery of products and services for analytically savvy media companies."

Shiv Sehgal, RSG Media

Watch video

BPM Northwest

"IBM dashDB has very fast and robust analytics capabilities, which allows us to not only stage data for our clients, but also provides us with the ability to look deep into that data and form competitive insights."

Joe Mackie, Director of Business Development, BPM Northwest

Watch video

dashDB resources

 

Cloud-based data warehousing as-a- service, built for analytics

Provides the simplicity of a data warehouse appliance as a service, with the agility and simplicity of the cloud for any size organization.

 

IBM Enterprise MPP Service

Learn how this high performance, massively scalable cloud data warehouse service enables simple and speedy information management, analytics, and business intelligence operations in the cloud.

 

IBM dashDB: Cloud-based data warehousing for analytics and transaction processing

Gain a better understanding of how the IBM dashDB family can help your organization thrive in a constantly changing and competitive global business environment.

Related products

dashdb icon

IBM dashDB Local

Data warehousing and analytics technology for use in private clouds, virtual private clouds and other container-supported infrastructures. It is ideal when you must maintain control over data and applications, yet want simplicity in data warehousing.

IBM Bluemix Lift

IBM Bluemix Lift makes it easy to quickly, securely and reliably migrate your database from on-premises data centers to the IBM dashDB cloud data warehouse.
Additionally, CSV flat files can be used to load IBM dashDB.

cloudant icon

IBM Cloudant

Give your application uninterrupted data access, offline and online, anywhere in the world, with a fully managed NoSQL database service. Let IBM manage the database layer so you can build more, grow more and sleep more.

Metered - first $50 USD free

Learn more

compose icon

IBM Compose Enterprise

Run web and mobile apps on fully managed, hand-picked open source databases with an integrated database-as-a-platform service. Gain flexibility and scale without losing cycles to database management.

graph icon

IBM Graph

A cutting-edge graph database, scalable for enterprise application developers who require a database-as-a-service.