Re: How to choose a database

Don't want to distract this thread but just want to share some points here. There is another topic going on below figures from Oracle. And the figures are really mind boggling like 1million txn/sec and 2.5 petabytes size database. And it says sharding behind the scene makes it happen. But yes sharding an existing application is not a straightforward option and may be quite complex, it asks for application code change or may be a bigger design change. This shrading may not be an easy option when someone builds a new application which operates for a handful of users at first. But the databases which OP highlighted like yugabyte and cockroachDB(I am not sure of Aurora) I believe are by default sharding the tables throughout the distributed nodes and that is a help for app developers to not worry about how to shard and thus scale resources in future etc.

https://blogs.oracle.com/database/post/oracle-bluekai-data-management-platform-scales-to-1-million-transactions-per-second-with-oracle-database-sharding-deployed-in-oracle-cloud-infrastructure

And i think finally the OP is asking about, if we consider choosing a database for a brand new application which is going to be hosted on cloud (say e.g. AWS), how should one choose between cockroach, yugabyte, and aurora for OLTP/RDBMS OR between Snowflake and Redshift for OLAP app?

On Sun, Apr 23, 2023 at 11:17 PM Mark W. Farnham <mwf_at_rsiz.com> wrote:

> I was not asking the meaning of monolith. I was asking what Pap meant by
> monolith.
>
>
>
> mwf
>
>
>
> (what’s 6 times 9? … 42 … so the mice use an implicit base of 13).
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Mladen Gogala
> *Sent:* Sunday, April 23, 2023 1:23 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* Re: How to choose a database
>
>
>
> On 4/23/23 09:05, Mark W. Farnham wrote:
>
> I may not correct what you mean by “monolith.”
>
> Now, that is easy: monolith is a large, rectangular object, produced by an
> advanced extraterrestrial civilization, which has brought intelligence to
> the earthly primates and made one primate use a pig bone as a weapon, with
> "Also Sprach Zaratustra" by Richard Strauss as the sound background.
> Fortunately, that was recorded on camera:
>
> https://www.youtube.com/watch?v=zmX7K8noikE
>
> --
>
> Mladen Gogala
>
> Database Consultant
>
> Tel: (347) 321-1217
>
> https://dbwhisperer.wordpress.com
>
>

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