Db2 Warehouse Overview
Making analytics secure, collaborative, and real-time across any cloud
Our cloud-native data warehouse is built on IBM® Db2® expertise in data governance and security, responsible data sharing, advanced in-memory processing at massive scale. From a single platform data engineers and data scientists can analyze and predict business outcomes across a variety of data sources. Whether your data is unstructured, or resides in your data lake, it is when analytical data is unified, accessible and scalable that you can speed decision-making and innovation across your organization.
IBM Db2 Warehouse and machine learning with Apache Spark (09:06)
Why IBM Db2 Warehouse?
Enable real-time decisions
Connect dashboards and reports with the power of fast ingest and querying for real-time insights.
Manage costs at scale
Enable high performance and cost predictability with elastic scale and a cloud-native architecture based on object storage.
Collaborate responsibly
Encrypt, secure and share governed data across your organization, third parties and cloud providers.
Db2 Warehouse in action
A single platform for your data needs
Machine learning and AI
Machine learning and AI
Create and predict with high-performance machine learning models inside your data warehouse. Integrate with IBM Watson® Studio for additional ML capabilities.
Reporting and business intelligence
Reporting and business intelligence
Build reports and dashboards quickly by seamlessly integrating Db2 with a variety of BI tools including IBM Cognos® Analytics, Tableau, Microsoft PowerBI, Google Looker and more.
Secure data sharing
Secure data sharing
Grant access and distribute data among users and third parties without data duplication. Integrate with IBM Watson Knowledge Catalog for additional data governance, quality, and compliance.
Features
Fast and simple hybrid data warehousing
Fast query processing
Apache Spark and IBM BLU® Acceleration in-memory SQL columnar processing with an MPP cluster architecture speed up complex queries and predictive model building, testing and deployment.
In-memory data processing
IBM BLU Acceleration eliminates the need for entire data sets and decompression in-memory. Includes pre-fetching of data and data skipping.
Automatic schema generation, data loading
In a few clicks, unstructured data — such as that from Twitter or geospatial programs — is automatically transformed into a structured format for analysis.
Common SQL engine
A common SQL analytics engine works across public and private clouds and on-premises data warehouses, so you can move workloads to the right location easily.
Compatibility with Db2, PDA and Oracle
Supported Db2 drivers and compatibility with Db2, PDA and Oracle accelerate migration. Deploy as a stand-alone cloud data warehouse, or integrate with an on-premises data warehouse.
Embedded Apache Spark engine
Db2 Warehouse and Spark deliver higher performance than Spark alone, providing a better data exploration experience.
Product images
Console dashboard
Console dashboard
The console dashboard gives you a view of hardware and software issues, database alerts, storage usage and a database time breakdown.
Monitoring overview
Monitoring overview
The monitoring overview shows the database time breakdown in more detail, including SQL execution, input/output, lock waits and other processing.
Spark analytics
Spark analytics
Db2 Warehouse offers multiple choices for Sparks analytics, including Juypter Notebooks, developing application code and running Spark applications.
R analytics
R analytics
RStudio is integrated so you can develop applications that run R code and R packages.
Resources
Documentation & support
Webinar
Use cases for a hybrid data warehouse
Hear from IDC and BPM Northwest experts on how a hybrid data warehouse architecture enables IT to regain control of data.
Additional resources
Cloud data management buyer’s guide
Distinguish between different cloud vendor offerings so you can make an informed choice.
Analyst report: Hybrid data warehouses
Learn from Aberdeen Group why top companies are seeing value with hybrid data warehousing.
Brief: Db2 Warehouse on Cloud
Learn how a fully managed, elastic data warehouse can reduce analytics costs while delivering deep insights.
Data sheet: IBM Common SQL Engine
Learn the benefits of IBM Common SQL Engine, which lets you write a query once and run it anywhere.
Related products
IBM Db2 Warehouse on Cloud
An elastic cloud data warehouse built for high-performance analytics
IBM Db2 Big SQL
An enterprise SQL-on-Hadoop engine for advanced big data queries