IBM logo

Data Warehousing

Db2 Warehouse (formerly dashDB Local), Db2 Warehouse on Cloud (formerly dashDB for Analytics), and Db2 on Cloud (formerly dashDB for Transactions)

True business intelligence comes from the ability to glean insights from your data. To get them, you need a place where you can combine data sets from your different systems that's separate from the hardware and databases that handle transactions. That place is a data warehouse.

Db2 Warehouse on Cloud is IBM's fully-managed cloud-based data warehouse solution, built upon the warehousing technology that supports earlier big data analysis solutions, like Db2 and Netezza. Db2 Warehouse's columnar setup enables fast, in-memory processing. To help you get answers fast, Db2 Warehouse comes with a variety of embedded analytics solutions like Watson Analytics and R Studio.

Rows vs. Columns

Db2 Warehouse lets you switch your database format from column to row-based, but performance will take a hit. Row-oriented databases are great for transactional systems, but for query-intensive analytics work you want a columnar database like Db2 Warehouse. It keeps all the values of a column together, which minimizes disk seek times for queries (big performance bottlenecks) and speeds counts of matching records or other math functions across data sets. A good rule-of-thumb: use row-oriented for lots of INSERTS, and column-oriented for lots of SELECTs.

The Db2 Warehouse Family

When you need to tackle more data, more needs, and more users, the IBM Db2 Warehouse Family can help you do more business without breaking stride! Learn more about this family of database and data warehousing solutions.

Hosted vs Managed on Cloud - What does it all mean?

Watch this short video to hear about differences between hosted, managed, and on-premise product offerings. The video uses Db2 and Db2 Warehouse as an example, but the concepts are the same for other hosted and managed services. ▼More

Ready to learn more? Get started with Db2 Warehouse!


ibmcloudantdevessentialsproficiency

Earn an IBM Db2 Warehouse Badge

If you're using Db2 Warehouse on Cloud, consider earning the IBM Db2 Warehouse on Cloud Essentials or IBM Db2 on Cloud Essentials IBM Open Badge to share verified proof of your achievement.