Re: Snowflake on Oracle

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 12 Apr 2023 22:43:20 -0400
Message-ID: <521e0625-afb6-24f7-eecd-905908ca6413_at_gmail.com>

On 4/12/23 19:50, Alan Sterger wrote:
> So the question, does anyone know if Snowflake is built on top of Oracle?

Snowflake is a columnar store database, not meant for OLTP. The data is stored in a series of columns, with compression, of course. It is not related to Oracle in any shape or form. Having said that, they're both RDBMS-es which run on Linux. That's as far as the similarity goes. Snowflake is written completely anew, so it's not a derivative of any other database. It supports ANSI 2000 SQL without anything resembling

PL/SQL. However, SF is a data warehouse software so it doesn't need 
PL/SQL. If you need something to compare SF to, think Vertica, not 
Oracle. SF isn't PostgreSQL compatible but the rest is quite similar: 

compression, columnar store and optimization for math.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 13 2023 - 04:43:20 CEST