Re: How to choose a database

 Actually I was trying to understand in general for database selection process(it may be oltp/olap). But say for e.g if we take specifically distributed RDBMS/sql databases (as opposed to monolith) , and compare cockroach vs yugabyte vs aurora postgres/mysql , what would be the goto database and why?

On Sun, 23 Apr, 2023, 1:51 am yudhi s, <learnerdatabase99_at_gmail.com> wrote:

> Any specific use case or database you are comparing?
>
>
> On Sun, Apr 23, 2023 at 1:23 AM Pap <oracle.developer35_at_gmail.com> wrote:
>
>> Hello Listers, There has been a discussion recently in this forum, which
>> started with a question on "snowflake"(i.e an analytical database) and
>> ended up discussing the compute+storage architecture compared with Google
>> spanner, Yugabyte DB etc which are Relational/OLTP one. (
>> https://www.freelists.org/post/oracle-l/Snowflake-on-Oracle,8)
>>
>> I understand that people in this forum have rich database experience in
>> one of the best rdbms in the world i.e. Oracle. And thus wanted to ask,
>> have you been into situations in which somebody in your organization asks
>> to evaluate or choose another of the cloud native databases(may be OLTP or
>> OLAP) apart from Oracle. Say for example I have seen situations in which
>> companies are moving existing applications or building new applications on
>> to the AWS cloud so they don't want to be bound to Oracle rather trying to
>> utilize some databases which is native to that cloud(say RDS , Aurora,
>> redshift) or may third party databases which are available in multiple
>> clouds(Yugabyte, Cockroach, Snowflake etc ). And we know Oracle is not
>> available in Aurora and RDS has some max storage limitation for oracle and
>> additionally Oracle exadata is not available in AWS too.
>>
>> So my question is,
>> 1)Considering databases are something going to stay long and not
>> frequently changeable, how do you evaluate/choose the best goto databases
>> for OLTP(for 100's terabyte scale) and OLAP(for petabytes scale)
>> applications for your organizations(say financial industry where ACID
>> matters) at the current time when there are many databases in the market
>> and also claiming to be the best in the field?
>> 2)Many things come to mind, like we should see/test the isolation level,
>> ACID and CAP etc. But is there a quick guide/workflow available which
>> provides these accurately or we need to test these all by installing the
>> database one by one manually?
>>
>> Regards
>> Pap
>>
>>
>>
>>
>>
>>

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