Database Administration & Monitoring, Database management, Oracle Oracle 21c : Two nodes Grid Infrastructure Installation 11.02.2021 by Oracle Team By Mouhamadou Diaw Oracle 21c is actually released in the cloud, and I did some tests to setup a Grid infrastructure cluster with two nodes. I used following two VM servers to test racp1vm1 racp1vm2 Below(…)
AWS, NoSQL DynamoDB Scan: the most efficient operation 😉 20.12.2020 by Open source Team By Franck Pachot . The title is provocative on purpose because you can read in many places that you should avoid scans, and that Scan operations are less efficient than other operations in DynamoDB. I(…)
AWS DynamoDB Scan (and why 128.5 RCU?) 30.11.2020 by Cloud Team By Franck Pachot . In the previous post I described the PartiSQL SELECT for DynamoDB and mentioned that a SELECT without a WHERE clause on the partition key may result in a Scan, but the(…)
AWS, NoSQL RDBMS (vs. NoSQL) scales the algorithm before the hardware 03.08.2020 by Cloud Team By Franck Pachot . In The myth of NoSQL (vs. RDBMS) “joins dont scale” I explained that joins actually scale very well with an O(logN) on the input tables size, thanks to B*Tree index access,(…)