Re: How to choose a database

One factor that may be missing from this conversation is overall cost and the technical skill set investment. In the age of cloud and the economic downturn, this has been a primary motivator that we techies forget, (but may also keep our skills more essential than ever.)

I love Oracle, but the high licensing costs will drive a business, (yes, even the Fortune 500 and up) to look for cheaper solutions. From the technical aspect, this may seem like the wrong decision driver, but I am seeing open source features built by those same individuals who built Oracle, (as well as new tech) driving capabilities and having challenges just means the business will need to invest in deeper technical expertise.

The environments that have the largest technical challenges and most technical debt often are those that were too platform feature dependent. There technical resources lacked the skills or the know how to navigate challenges unless the platform addresses it. You can’t be agile and pivot when the time comes if your base is locked into one direction only.

I believe cost and investment in technical resources, due to these factors, becomes part of the decision factors in the end.

Cheers,
Kellyn

On Sat, Apr 22, 2023 at 11:49 PM Pap <oracle.developer35_at_gmail.com> wrote:

> You may correct me if wrong, but what I mean is monolith is something
> which is not horizontally scalable which means the same box has to be
> replaced with higher cpu, memory or IO power rather adding more number of
> same memory , cpu, IO power boxes horizontally to cope up with the
> increased load. And thus , these distributed databases can adopt to a
> higher load and can 'scale in' or 'scale out' easily without downtime.
>
> And to my understanding distributed databases are meant to cater that
> need. And I believe sharding is critical for these systems but again manual
> sharding not always an easy option always.
>
>
> On Sun, 23 Apr, 2023, 2:51 am Mark W. Farnham, <mwf_at_rsiz.com> wrote:
>
>> what do you mean by monolith?
>>
>>
>>
>>
>>
>>
>>
>> *From:* oracle-l-bounce_at_freelists.org [mailto:
>> oracle-l-bounce_at_freelists.org] *On Behalf Of *Pap
>> *Sent:* Saturday, April 22, 2023 4:28 PM
>> *To:* yudhi s
>> *Cc:* Oracle L
>> *Subject:* 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
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> --

*Kellyn Gorman*
DBAKevlar Blog <http://dbakevlar.com>
about.me/dbakevlar

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