Overview of IBM Db2 Warehouse on Cloud

IBM® Db2® Warehouse on Cloud is a managed public cloud service. You can set up IBM Db2 Warehouse on premises with your own hardware or in a private cloud. As a database warehouse, it includes features such as in-memory data processing and columnar tables for online analytical processing (OLAP). These deployment options have a common database engine so your data workloads can be moved and optimized with ease.

Integrated analytics

Run standard or custom predictive models. Netezza technology provides a robust set of analytics that are designed to efficiently bring the query to the data. A range of libraries and functions help you get to the precise insight you need to drive better business outcomes.

Compatibility

Oracle and Netezza compatibility options make it easy to migrate. Free tooling helps you to convert existing applications.

Administration

With Db2 managed services, IBM manages the hardware, software, availability, much of the security and more on your behalf. This allows you to focus on your business outcomes and not on the infrastructure needed to deliver those outcomes. With IBM Db2 Warehouse, you perform management tasks on the Docker-supported infrastructure of your choice, without the hassles of complex configuration.

Hybrid-ready

Achieve the efficiency of a hybrid data warehouse through a common analytics engine that can run advanced analytics against any data source, at any location, without compromising data quality or IT budgets. For example, you can write your application once on Db2 Warehouse, and then move the workload to the right location (public cloud, private cloud, or on-premises).

Speed and scale

For large data sets, the massively parallel processing (MPP) plans use multiple servers to work on the same query simultaneously. Performance increases with each new server added to the network cluster, and you can scale out by adding more servers to your cluster. Dynamic, in-memory columnar store technology minimizes I/O even further and achieves an order-of-magnitude increase in speed, compared to conventional row-store databases.

Run your own apps

In addition to the integrated tools, you can connect many popular third-party BI and visualization apps that you might already be using. For example, connect IBM InfoSphere® Data Architect to design and deploy your database schema, or connect SQL-based tools such as Watson Analytics and Cognos Analytics to manipulate or analyze your data. For the managed service, you can connect other IBM Cloud® applications.

Graphical user interface or command line

You can use the web console to perform many key tasks, such as loading data, working with tables, run SQL, and monitoring. Alternatively, you can use the command-line user interface CLPPlus to define, edit, and run statements, scripts, and commands.