Feature spotlights

Unique in-memory data processing

IBM Db2 Warehouse on Cloud uses BLU Acceleration, IBM’s in-memory columnar processing technology. Entire datasets are not needed in-memory, no decompression is needed, and performs prefetching of data and data skipping.

Embedded IBM Netezza Analytics

IBM Netezza Analytics are built directly into Db2 Warehouse on Cloud, with multiple algorithms, including linear regression, decision tree clustering, k-means clustering and ESRI-compatible geospatial extensions.

Integrated R development and deployment

IBM Db2 Warehouse on Cloud includes integrated RStudio for development and R in-database functions, operating directly on data in a database. A web console can be used to load data and perform analytics within minutes.

Security and privacy certified for compliance

IBM Db2 Warehouse on Cloud is provided on a secure cloud platform and complies with standards such as HIPPA, ISO, and SOC. Robust security features also enable access in both a shared or multitenant environment.

Data migration, transformation and loading made easier

Whether it is structured, semi-structured, or unstructured data, Db2 Warehouse on Cloud provides many tools and APIs for data loading fast and easy. Auto schema generation and data loading is provided for Twitter, Open Data, and Cloudant JSON. Load data directly from your desktop or cloud sources in just a few clicks. For migrating data on-premises, IBM Cloud Lift offers fast data loading and IBM Cloud Data Connect for additional data preparation and integration services.

Use in-database analytics or connect to integrated tool

You can run in-database analytic functions from within SQL. These analytic functions help you accelerate your application performance when you do analytical queries. You can analyze your data by using analytics software that you connect to Db2 Warehouse on Cloud, or by running R scripts from within your environment. You can use Esri ArcGIS for Desktop to analyze and visualize geospatial data. You can run R scripts to that retrieve data from and write data to a database.

IBM Watson Analytics with Db2 makes your analysis smarter

Watson Analytics is a smart data analysis and visualization service on the cloud that helps just about anyone quickly discover patterns and meanings in their data all on their own. Guided data exploration, automated predictive analytics and cognitive capabilities, such as natural language dialogue, allow to get answers in ways they can easily understand. When using Db2 Warehouse on Cloud, you are just a few clicks away in accessing integrated Watson Analytics to get more value from your data.

How customers use it

  • Hybrid Data Warehouse

    Problem

    Get immediate access to all relevant data

    Solution

    Learn how the flexibility of a hybrid data warehouse enables IT to gain back control of the data, and enable users to gain self service access to all relevant data sources. Real life customer case studies will also be discussed.

  • Three facts to know about hybrid data warehouses

    Problem

    How can a hybrid data warehouse architecture help you?

    Solution

    Better on-time information delivery, improved data quality, and even a greater likelihood of revenue increases!