Re: Database comparison
Date: Sun, 18 Apr 2021 01:50:11 +0530
Message-ID: <CAEjw_fjfWaHhp641cAwxXyamrUE6iB7Vi9uDet1Hhv-cQ6WZPA_at_mail.gmail.com>
Yes there may be more which i am not aware of. So wanted to know views of experts who already get to work on both of these.
I understand it's not easy to master all of these though :), but Is there any good place/docs to see comparison of these top database technologies to understand pros/cons and best usage etc?
On Sun, Apr 18, 2021 at 1:47 AM Lok P <loknath.73_at_gmail.com> wrote:
> What about yugabyte?
>
> On Sat, Apr 17, 2021 at 12:06 PM Pap <oracle.developer35_at_gmail.com> wrote:
>
>> I understand there are multiple arguable topics on what is best what not.
>> We are currently using Oracle Exadata X7 and planning for migration to X8.
>> But yes we do see at times , cell I/O saturation (mainly when heavy cell
>> smart scans from multiple places) and other types of memory related
>> contentions and it's mostly because of the way Oracle architectured making
>> memory a lot busier or a hotspot while we just simply push the concurrent
>> workload beyond a certain limit.
>>
>> While googling around the data warehouse/analytics databases i came
>> across a blog as below saying how snowflake is superior to Oracle( or maybe
>> Exadata). Some of the points it says like no indexes, no partitioning, no
>> statistics gathering, linearly scaling, auto compressing seems interesting.
>>
>> I understand this list group is mainly expert around oracle databases,
>> but assuming that some must have explored other databases options or get a
>> chance to work on other databases, are these points all true and Snowflake
>> is currently the best warehouse/analytics database in the market now or any
>> other databases are there proven record?
>>
>> https://www.analytics.today/blog/oracle-vs-snowflake
>>
>> Regards
>> Pap
>>
>>
>>
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Apr 17 2021 - 22:20:11 CEST