IBM Developer Advocacy

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.

dashDB 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. dashDB’s columnar setup enables fast, in-memory processing. To help you get answers fast, dashDB comes with a variety of embedded analytics solutions like Watson Analytics and R Studio.

Rows vs. Columns
dashDB 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 dashDB. 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 dashDB Family

When you need to tackle more data, more needs, and more users, the IBM dashDB 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 dashDB as an example, but the concepts are the same for other hosted and managed services. ▼More

Ready to learn more? Get started with dashDB!


Earn an IBM dashDB Badge

If you’re using dashDB for Analytics, consider earning the IBM dashDB for Analytics Essentials or IBM dashDB for Transactions Essentials IBM Open Badge to share verified proof of your achievement.

blog comments powered by Disqus