Chapter 2Snowflake Architecture
THE SNOWPRO CORE EXAM TOPICS COVERED IN THIS CHAPTER INCLUDE THE FOLLOWING:
Snowflake employs a hybrid architecture to solve the massively parallel processing problem, and in this chapter, you learn about that unique architecture approach. As you'll see, the architecture uses a shared-disk approach for storage but uses multiple independent compute clusters to process the data.
Traditional Database Architectures
Historically, two architecture approaches have been used for database systems. The most common is the shared-disk architecture used by most online transaction processing (OLTP)-oriented database systems. In this architecture, the database system consists of a single physical computing system where the data for the database resides on a shared disk. A CPU (or multiple CPUs) performs the data processing within the same physical computing system, sharing the same memory and the storage disk. To make it easier to understand this architecture, think of a standard database ...
Get Snowflake SnowPro Core Certification Study Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.