Re: Database comparison

Thank you mladen.

My apology. Actually I have zero experience on snowflake but came across that blog so thought of checking around that.with the experts if some have experience around that or similar stuff. I have only worked in Oracle databases throughout my career, so no handson around other database technologies.

  Thank you for the details. I was not aware about TPC-H benchmark before but as i went through it seems a common standard measurement for DB performances and as you rightly pointed out it has zero information around snowflake which makes it questionable.

And out of curiosity , We are coming across multiple database technologies, So I was also trying to search for a common place which could provide us information around different database technologies and their best use cases or what they are best suited for. Is there any such? Or TPC-H is the right place to see basic comparisons?

And yes i agree that Oracle has 30 years of its invention fed into that product so it must not be that easy for anybody to make it within a short time. But few things I do see, that when we try to scale it at some point just adding additional storage cells is not helping much.

Regards
Pap

On Sun, Apr 18, 2021 at 9:08 AM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> Pap, do you work for Snowflake? From your discussions I know you to be a
> competent Oracle DBA and yet, you bring up a crappy propaganda like
> this? You haven't even mentioned TPC-H and its results:
>
> http://tpc.org/tpch/
>
> No Snowflake in TPC-H 3.0 despite the database itself mentioning the
> schema:
>
> https://docs.snowflake.com/en/user-guide/sample-data-tpch.html
>
> So there is that magical database which doesn't need indexes,
> administration, compression and is scalable up to effing infinity but
> they don't do TPC-H? And you bring up for discussion something that is
> obviously a Snowflake sales pitch, full of half truths and downright
> lies. What's the motive behind that? Do you work for Snowflake? Are you
> on commission? Snowflake is being sold as a magical solution for all
> things data warehouse, but they haven't bother to produce even a single
> benchmark that would help me rate them. They are selling very
> aggressively and this is not the first time I hear about them. Even
> Oracle is playing nice with them and has created GG adapter for Snowflake:
>
>
> https://www.snowflake.com/blog/continuous-data-replication-into-snowflake-with-oracle-goldengate/
>
> Yet virtually nothing about this database is known. There is no free
> stuff that can help you learn it. No explanation for the outrageous
> claims ("no indexes"). As of now, I regard Snowflake as MIPS ("Marketing
> Invention for Pushing Sales"). And yet you bring up such a low quality
> laughable "comparison" despite being a competent Oracle DBA. Why is that?
>
> If you want a huge cloud based DW database, try Microsoft Data Lake. I
> have some good experiences with that. That is a real DB, SQL Server on
> steroids, and it needs a DBA, indexes and the whole nine yards. It is
> based on proven and rock solid SQL Server data warehouse reputation. For
> now, Snowflake looks more like a data whorehouse product.
>
> On 4/17/21 2:36 AM, Pap wrote:
> > I understand this list group is mainly expert around
> > oracle databases, but assuming that some must have explored other
> > databases options or get a chance to work on other databases, are
> > these points all true and Snowflake is currently the best
> > warehouse/analytics database in the market now or any other databases
> > are there proven record?
> >
> > https://www.analytics.today/blog/oracle-vs-snowflake
> > <https://www.analytics.today/blog/oracle-vs-snowflake>
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
> https://dbwhisperer.wordpress.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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