RE: Database comparison

Mladen was uncharacteristically mild in this thread. He did not even mention my favorite: https://www.youtube.com/watch?v=b2F-DItXtZs (NOT SAFE FOR WORK!)  

But seriously, evaluation of RDBMS and non-R DBMS systems is extremely prone to cherry picking and niche case analysis.  

In 1985 the genius who wrote the error routines for the LEM guessed correctly that Oracle would be successful and the most portable. I’ve primarily used Oracle ever since.  

I would claim that the appropriate test for any proposed datastore building built to serve some application function is to compare 1) Oracle configured as well as it can be at a reasonable configuration cost for that purpose, 2) Some other product that claims to be best of breed for that application function, 3) something like MySql to see if “free” is good enough.  

Then, if Oracle is NOT the winner but is the only current DBMS in the company culture, factor in the cost of adding support for a new DBMS. In that cost factor calculation give “SQL” databases a slight edge over non-“SQL” databases in case you outgrow them, because the transition to Oracle is easier than going from, say, key-value store databases.  

Good luck. Not even a company like Forrester really gets this right across the board consistently.  

mwf  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Pap Sent: Sunday, April 18, 2021 6:53 AM
To: gogala.mladen_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: 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