Re: How to choose a database

Thank you all for the guidance here. These points really helped me to clarify many aspects of the current discussion. I will try to get more details around the requirement and accordingly the points which you guys have suggested like cost and the business problem which would be addressed by this. Need to get involved with the project teams to better understand these problems. And then perhaps we have to start with the databases discussed over here and test the feasibility.

For now, I am only aware that the database requirement was for a financial services project which would be hosted on AWS cloud and one RDBMS for storing and processing live users transaction data(retention upto ~3months and can go ~80TB+ in size, ~500million transaction/day) and another OLAP database for doing reporting/analytics on those and persisting those for longer periods(many years, can go till petabytes).

Thanks Lok, for listing out the features in one place, I was not aware about many of them and putting it side by side really helps in understanding their core properties better. Really appreciate your help on this. Having a yugabyte DB in the same table would have been great but anyway I will try to find out.

On Tue, Apr 25, 2023 at 3:45 AM Clay Jackson <dmarc-noreply_at_freelists.org> wrote:

> Mladen, Mark and others articulated what I’ve also been thinking.
>
>
>
> Picking a database based first on specifications or “benchmarks” of the
> database is completely “bass-ackwards” and will at best result in
> “technology/vendor lock” at some point in the future, hopefully long after
> those making the decision makers have departed for “greener pastures”.
> And that’s the BEST case – ask the US Veterans Administration about their
> EMR rollout.
>
>
>
> The FIRST questions to ask are:
>
> - What business “problem” are we trying to solve?
> - How will this piece of technology improve our business bottom line?
>
>
>
> THEN, and ONLY THEN, can you compile a list of desired features to compare
> against CURRENT feature lists from the CURRENT “major vendors” taking into
> account things like:
>
> - As with all technology, if you can buy it, it’s obsolete.
> - Any “feature comparisons” you find are out of date.
> - The “coolest new technology” might not stand “the test of time”.
> How many ADA or SmallTalk programmers do you know?
> - “There’s No Such Thing As a Free Lunch” – This applies to the
> “things” from vendors as well as to most “advice” (Other than that which
> you have received here on Oracle-L, of course 😊).
>
>
>
> As Maya Angelou said, “Nothing will work unless you do”
>
>
>
> *Clay Jackson*
>
> *(The grumpy old guy)*
>
>
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
> Behalf Of *Mladen Gogala
> *Sent:* Monday, April 24, 2023 12:50 PM
> *To:* Lok P <loknath.73_at_gmail.com>; Pap <oracle.developer35_at_gmail.com>
> *Cc:* Mark W. Farnham <mwf_at_rsiz.com>; dbakevlar_at_gmail.com; Oracle L <
> oracle-l_at_freelists.org>
> *Subject:* Re: How to choose a database
>
>
>
> *CAUTION:* This email originated from outside of the organization. Do not
> follow guidance, click links, or open attachments unless you recognize the
> sender and know the content is safe.
>
>
>
> On 4/24/23 12:27, Lok P wrote:
>
> Hope below comparison helps to some extent in taking the decision in
> regards to AWS offering prospect. And ofcourse this has to be thought
> through along with the type of business one deals with, say for example,
> you said financial transaction which must consider consistency as key
> feature etc. I am, not sure of yugabyte db feature details but it would be
> great if anybody can add to that and any other databases. And any
> additional features can be added if missed. And ofcourse these are all not
> the hard liners and can change with future developments but just to provide
> some idea about the offerings. And not to mention, please correct me if any
> of the features has been wrongly put.
>
> https://gist.github.com/oraclelearner/16c9191822601936c3f4b179f4523f7a
>
>
>
>
>
> Nope, it doesn't help. It just lists some features from several databases.
> People usually don't go shopping for their next RDBMS, based on feature
> lists on the web. People usually test. the software for their particular
> purpose. The most important question is: what exactly do you need and how
> much money are you willing to invest.
>
> --
>
> Mladen Gogala
>
> Database Consultant
>
> Tel: (347) 321-1217
>
> https://dbwhisperer.wordpress.com
>
>

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