Re: Snowflake on Oracle

Totally new databse which is amazing ... ie that someone would try and write a database from scratch but these aren't just anybody . The principal architects are Thierry and Benoit who were kernel architects from Oracle, so no surprise there there might be some Oracle look and feel. The other founder Marcin had worked on a few database kernels though all I see via google searches is his DB Vectorwise.

On Wed, Apr 12, 2023 at 7:44 PM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> 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-1217https://dbwhisperer.wordpress.com
>
>

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