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@xxxxxxxxx>
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
--
//www.freelists.org/webpage/oracle-l
