Re: Snowflake on Oracle

Have they added Correlated sub-queries yet ?

DougD

On Wed, Apr 12, 2023, 9:31 PM 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-1217https://dbwhisperer.wordpress.com
>>
>>

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