Re: How to choose a database

Thank you All.

Definitely license cost is a key factor along with technical skills of the staff as that can make and break the project. Along with this, another key factor is the performance of the databases at scale which may depend on the base architecture of the database which it operates on. And how matured the database is in terms of real life usage in handling critical business workload. And seeing multiple comparisons on the internet from the companies site is confusing a bit to decide which is the truth. So I was keen to hear that from the experts here. And yes specifically , say for example a comparison between 'cockroach, yugabyte, Aurora' for Oltp or may be 'redshift vs snowflake' for olap, what to choose if for time being, we don't consider cost as a constraint and consider AWS being the cloud provider applications want to opt for?

In general, I understand the databases can differ in terms of the features(functional feature, security feature, performance feature etc) provided, but are there any key checks one should perform which will play a significant role otherwise the application has to end up doing the coding for that and that may not be a good thing. E.g. 1) I understand, ensuring uniqueness/foreign keys in the application is not good rather making the database to do the same. 2) Certain level of isolation which a database should have or else you endup ensuring that in the application transaction management through code and it can be cumbersome. 3)As Mladen highlighted , support for global indexes in partitioned tables etc. 4)And ofcourse read/write performance is a key factor too. 5) Key security/compliance stuff like backup recovery , encryption etc.

On Mon, Apr 24, 2023 at 12:05 AM Lok P <loknath.73_at_gmail.com> wrote:

> 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