Is Snowflake an MPP database?
MPP stands for Massively Parallel Processing, and is a database architecture successfully deployed by Teradata and Netezza. Unlike traditional Symmetric Multi-Processing (SMP) hardware which runs a number of CPUs in a single machine, the MPP architecture deploys a cluster of independently running machines, with data distributed across the system. In addition to the ability to handle massive data volumes, this means it supports a scale out architecture, as additional nodes can be added to the cluster, although this can take from hours to days to deploy.
EPP stands for Elastic Parallel Processing, and was pioneered by Snowflake Computing. This uses a number of independently running MPP clusters connected to a shared data pool. This architecture has the advantage that new clusters can be started within seconds, to elastically grow or shrink resources as needed.
Watch video Is Snowflake an MPP database? online, duration hours minute second in high quality that is uploaded to the channel IDWBI 20 November 2022. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 4,387 times and liked it 30 visitors.
