OpenText Vertica Workshop: Architecture & Performance Deep Dive скачать в хорошем качестве

OpenText Vertica Workshop: Architecture & Performance Deep Dive

This workshop video - presented by three avatars including myself - offers a practical and performance-focused guide to OpenText Vertica, tailored for users with SQL experience. We start with Vertica's architecture and key capabilities, then dive deep into performance optimization techniques that unlock the full power of this MPP database. 📌 Recorded: July 11, 2025 🎙 Presenter: Moshe Goldberg, Principal Solutions Consultant, OpenText Vertica What You’ll Learn: Getting Started: ✅ What Vertica is and how it works ✅ Key features: projections, separation of compute/storage, deployment modes (Enterprise vs Eon) ✅ Machine learning in-database with full SQL workflow ✅ External table querying and complex data types Performance Deep Dive: ✅ Smart projection design and segmentation ✅ Vertica Database Designer (DBD) best practices ✅ Efficient encoding, memory usage, and query profiling (with qprof) ✅ Join strategies (Merge vs Hash), GROUP BY tuning, and COUNT(DISTINCT) optimization ✅ Data load fault tolerance and error handling ✅ Statistics management, tuning tips, and optimizer hints Key Slide Topics Include: 1. Vertica Projections 2. Projection Replication & Segmentation 3. Database Designer & Auto-Projection Generation 4. Best Practices for Table Design 5. Encoding Optimization 6. Query Profiling with qprof 7. Join Algorithms: Merge vs. Hash 8. GROUP BY Execution Types (Hash vs. Pipelined) 9. COUNT(DISTINCT) Performance Strategies 10. Smart SQL Practices & Error Tolerance 11. Data Loading Tips 12. Statistics Collection Triggers & Tuning 13. Quick Wins for Query Speedup 🔍 Designed for engineers and Vertica analysts who want to build fast, scalable data solutions using Vertica. #Vertica #OpenText #Analytics #SQL #DataEngineering #PerformanceTuning #DatabaseOptimization