Re: How to choose a database

In my opinion there are 2 consideration . Commercial rdbms are all expensive ( sqlserver, oracle db2 ), none is free of charge so if you decide to move on sql or db2 ( for me both great products ) you have to evaluate at the end how much cost you really save instead of oracle licensing. For opensource database I find mariadb or mysql great solutions for particular oltp : tables are all btree structures, pessimistic locking no parallel executions and so on. If your database is desigend for going on those engines, they work really well but they are not general porpouse, they are not a replace for oracle The only real alternative nocost that i see for a commercial database , as features is postgres. Postgres works well, it has a lot of features. it can be used for oltp and for olap but it is not oracle. The performance are different, the mvcc is done with tuple and it works in a more complex way of oracle so it is slower . Double buffering and index updating can be a pain . Postgres has no datapump and datamoving is slower and a bit complex ( try to extract a table from a full database dump for example, you can do that but you have to work a lot more ) . if you have experience on postgres and you are able to make your applications work on it , For what i have seen i would go on one of the many postgres cloud databases even if a migration is not a fast or easy task.

Il giorno dom 23 apr 2023 alle ore 20:54 Pap <oracle.developer35_at_gmail.com> ha scritto:
>
> 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