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?
Ready to learn more? Get started with dashDB!
Earn an IBM dashDB Badge