RE: How to choose a database
Date: Mon, 24 Apr 2023 22:14:31 +0000
Message-ID: <CO1PR19MB49847AA21D5FBFAFABD3C6E29B679_at_CO1PR19MB4984.namprd19.prod.outlook.com>
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:
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 Maya Angelou said, “Nothing will work unless you do”
Clay Jackson
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
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:
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<https://dbwhisperer.wordpress.com/>
(The grumpy old guy)
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
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
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 25 2023 - 00:14:31 CEST