Re: Snowflake on Oracle
From: Jon Crisler <joncrisler_at_gmail.com>
Date: Thu, 13 Apr 2023 12:12:05 -0400
Message-Id: <90DB723D-753D-453A-A522-683CEB4084F2_at_gmail.com>
>> On Wed, Apr 12, 2023 at 7:44 PM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:
>> 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
Date: Thu, 13 Apr 2023 12:12:05 -0400
Message-Id: <90DB723D-753D-453A-A522-683CEB4084F2_at_gmail.com>
> On Apr 13, 2023, at 12:31 AM, kyle Hailey <kylelf_at_gmail.com> wrote: > > > > 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-1217
>> https://dbwhisperer.wordpress.com
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 13 2023 - 18:12:05 CEST