Re: How to choose a database

On 4/22/23 15:52, Pap wrote:
> 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?
>
OLTP for 100 TB scale? Are you sure that's OLTP and not a mix of OLTP and DW? 100TB looks suspiciously large for an OLTP database. As for the choice of the database, you need to use the database that your developers know how to work with. The only real issue with non-Oracle databases are global indexes on partitioned tables. In my opinion, global indexes are usually a mistake in schema design because they need to be rebuilt after every partition operation like "truncate partition".

You can replace Oracle with other databases like SQL Server, DB2, MariaDB or some Postgres compatible database (Yugabyte, CockroachDB, Vertica, EnterpriseDB) but you will have to re-engineer your application. Simple schema translation tools like ora2pg will usually not work well and the result will be less than optimal. Now, re-architecting and re-coding the existing application can be time consuming and expensive business. What you are asking is a business decision, not a technology decision: does it make sense to redo the entire application suite for the new RDBMS or is it cheaper and more convenient to continue using Oracle?

Long story short, the answer to your question is "42". Now, you have to consider the detailed specification of your application system and your database and make the decision by yourself.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

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