Unified Data Layers: A New Era for Scalable Analytics, Search, and AI v 1.1Table of Contents Introduction 1. The Interconnection of Analytics, Search, and AI 2. What is a Real-Time Unified Data Layer unprecedented volumes of data across a growing number of sources and formats, data engineering and architecture teams must design systems that not only scale but also deliver real-time access and insights. personalize experiences and ensure performance. 32. The Interconnection of Analytics, Search, and AI Analytics, search, and AI are deeply interconnected in how they process, interpret, and extract value

Categorical Variables Pivot Stemming Sept 2017 Graph All Pairs Shortest Path (APSP) Breadth-First Search Average Path Length Closeness Centrality Graph Diameter In-Out Degree PageRank Single Source Summary InferenDal StaDsDcs • Hypothesis Tests Probability FuncDons Supervised Learning Neural Networks Support Vector Machines (SVM) Regression Models • Clustered Variance • Cox-ProporDonal

Recommendations 300 Master 300 Segments 301 Greenplum Database Concepts 302 About the Greenplum Architecture 302 About the Greenplum Master 304 Master Redundancy 305 About the Greenplum Segments 305 338 Getting Started 339 VMware Greenplum on vSphere Architecture 339 VMware Greenplum 6 Documentation VMware by Broadcom 16 Layered Architecture 339 Provider Layer 340 Infrastructure Layer 340 Virtual Planning for a Deployment 343 Single-Tier Architecture 344 Deployment Examples 344 10 TiB Database 344 100 TiB Database 345 1 PiB Database 345 Two-Tier Architecture 346 Deployment Examples 346 10 TiB

Recommendations 287 Master 287 Segments 287 Greenplum Database Concepts 288 About the Greenplum Architecture 288 About the Greenplum Master 290 Master Redundancy 291 About the Greenplum Segments 291 Greenplum on vSphere 324 Overview 324 Getting Started 325 VMware Greenplum on vSphere Architecture 325 Layered Architecture 325 VMware Greenplum 6 Documentation VMware, Inc. 15 Provider Layer 326 Infrastructure Sizing the Greenplum Virtual Machine 330 Putting It All Together 330 Dell EMC VxRail Reference Architecture 331 Next Steps 331 Greenplum Storage Sizer for Two-Tiered Architectures 331 Prerequisites 332

Recommendations 269 Master 269 Segments 269 Greenplum Database Concepts 270 About the Greenplum Architecture 270 About the Greenplum Master 272 Master Redundancy 273 About the Greenplum Segments 273 vSphere 306 Overview 306 Getting Started 307 VMware Tanzu Greenplum on vSphere Architecture 307 Layered Architecture 307 Provider Layer 308 Infrastructure Layer 308 Virtual Machine Cluster Layer Sizing the Greenplum Virtual Machine 312 Putting It All Together 312 Dell EMC VxRail Reference Architecture 313 Next Steps 313 Prerequisites 313 Greenplum Cluster 314 VMware vSphere 314 Network 314

Recommendations 261 Master 261 Segments 261 Greenplum Database Concepts 262 About the Greenplum Architecture 262 About the Greenplum Master 264 Master Redundancy 265 VMware Tanzu Greenplum 6 Documentation Platforms 295 Overview 296 Getting Started 297 VMware Tanzu Greenplum on vSphere Architecture 297 Layered Architecture 297 Provider Layer 297 Infrastructure Layer 297 Virtual Machine Cluster Layer Sizing the Greenplum Virtual Machine 301 Putting It All Together 302 Dell EMC VxRail Reference Architecture 302 Next Steps 303 Prerequisites 303 Greenplum Cluster 303 VMware vSphere 303 Network 304

Recommendations 257 Master 257 Segments 257 Greenplum Database Concepts 258 About the Greenplum Architecture 258 About the Greenplum Master 260 Master Redundancy 261 About the Greenplum Segments 261 vSphere 291 Overview 291 Getting Started 292 VMware Tanzu Greenplum on vSphere Architecture 292 Layered Architecture 292 Provider Layer 293 Infrastructure Layer 293 Virtual Machine Cluster Layer Sizing the Greenplum Virtual Machine 297 Putting It All Together 297 Dell EMC VxRail Reference Architecture 298 Next Steps 298 Prerequisites 299 Greenplum Cluster 299 VMware vSphere 299 Network 299

Database Concepts 154 VMware Greenplum 7 Documentation VMware by Broadcom 4 About the Greenplum Architecture 154 About the Greenplum Coordinator 156 Coordinator Redundancy 156 About the Greenplum Segments Managing Schemas 320 The Default “Public” Schema 321 Creating a Schema 321 Schema Search Paths 321 Setting the Schema Search Path 321 Viewing the Current Schema 322 Dropping a Schema 322 System Schemas Broadcom 26 Using Full Text Search 643 About Full Text Search 644 What is a Document? 646 Basic Text Matching 647 Configurations 649 Comparing Greenplum Database Text Search with VMware Greenplum Text

Recommendations 233 Master 233 Segments 233 Greenplum Database Concepts 234 About the Greenplum Architecture 234 About the Greenplum Master 236 Master Redundancy 237 About the Greenplum Segments 237 Platforms 264 Overview 265 Getting Started 265 VMware Tanzu Greenplum on vSphere Architecture 266 Layered Architecture 266 Provider Layer 266 Infrastructure Layer 266 Virtual Machine Cluster Layer Sizing the Greenplum Virtual Machine 270 Putting It All Together 270 Dell EMC VxRail Reference Architecture 271 Next Steps 271 Prerequisites 271 Greenplum Cluster 271 VMware vSphere 271 Network 272

Graph 398 Graph Modules 400 All Pairs Shortest Path (APSP) 400 Breadth-First Search 400 Hyperlink-Induced Topic Search (HITS) 401 PageRank and Personalized PageRank 401 Single Source Shortest Path Checking the PostGIS Version 415 Notes 416 Text Analytics and Search 416 Text Analytics and Search 0 Greenplum Database Full Text Search 416 Tanzu Greenplum Text 416 Procedural Languages 416 Procedural Language 417 PL/Container Language 0 About the PL/Container Language Extension 417 PL/Container Architecture 417 About PL/Container 3 Beta 418 Install PL/Container 419 Prerequisites 419 VMware Greenplum