Workshop Notes (February 1, 2017): IBM dashDB Local MPP Proof of Technology
IBM Technical Exploration Center
February 1, 2017
9:00 AM – 5:00 PM
From the promotional materials:
IBM dashDB Local MPP Proof of Technology
IBM dashDB Local is a next-generation data warehousing and analytics technology for use in private clouds, virtual private clouds and other container-supported infrastructures. It is ideal when you must maintain control over data and applications, yet want cloud-like simplicity.
dashDB Local is part of a family that shares a common SQL engine and other database technologies across different deployments so you can place the right workload on the right platform—and move between them without application change.
It includes in-memory processing for delivering insanely fast answers to queries, as well as MPP for scale out and scale up capabilities as data grows. It also provides scale-in capabilities to free resources after peak workloads complete.
Agenda:
- Setup and Introduction – Introduction to dashDB Local
- GPFS FPO – Create GPFS FPO feature for clustered file system
- dashDB MPP Installation – Installation of Docker containers for dashDB in MPP deployment
- dashDB and Docker Administration – dashDB and Docker administration for day-to-day work
- dashDB Web Console – Use of dashDB web Console for data load, administration of tables, Run SQL
- Query Monitoring – Comprehensive monitoring of Analytics workload
My key takeaways:
- Vikram Khatri was the presenter. He works for IBM out of North Carolina.
- This workshop was the second stop in a 4 to 5 stop roadshow which started in New York.
- For the workshop, he wrote a detailed (roughly 100 page) tutorial that contains step by step instructions as well as dozens of SQL and Docker scripts which he plans to distribute (the Docker portion is of value for non-related work as well).