Description
IBM Db2 Warehouse is an analytics data warehouse that features in-memory data processing and in-database analytics. It is client-managed and optimized for fast and flexible deployment, with automated scaling that supports analytics workloads. Based on the number of worker nodes selected, watsonx as a Service automatically creates the appropriate data warehouse environment. For a single node, the warehouse uses symmetric multiprocessing (SMP) architecture for cost-efficiency. For two or more nodes, the warehouse is deployed using a massively parallel processing (MPP) architecture for high availability and improved performance.
Integrating a Db2 Warehouse database with watsonx as a Service can be useful in the following situations:
- You have developers who need to create small-scale database management systems for development and test work. For example, if you need to test new applications and data sources in a development environment before you move them to a production environment.
- You want to accelerate line-of-business analytics projects by creating a data mart service that combines a governed data source with analytic techniques.
- You need to deliver self-service analytics solutions and applications that leverage data that is generated from new sources and is ingested directly into the private cloud warehouse.
- You want to migrate a subset of applications or data from an on-premises data warehouse to a private cloud.
- You want to save money or improve performance by migrating on-premises data marts or an on-premises data warehouse to a cloud-native data warehouse.
- You want to support data scientists who are coding and need to store data locally and need to use a logical representation.
- You want to reduce network traffic and improve analytic performance by storing your data near your analytics engine.
- You have multiple departments, and each department requires their own database management system.
This service provides a database that you can connect to from Watson Studio.
Quick links
- Use: Work with the service
- Administer: Manage and maintain the service
- Develop: Write code and build applications
- Create: Create the service instance
- Connect: Create a connection