NoSQL, SQL Server A generic jdbc tester (part III) 27.01.2023 by Oracle Team A generic utility to test JDBC connections to any RDBMS or no SQL data source whose JDBC drivers are provided. Firebird, SQL Server, HSQLDB, MongoDB, Excel, conclusion.
NoSQL REDIS STREAMS: Set up training lab for Windows using Docker 19.12.2022 by Middleware Team What is Redis streams?? (Definition from Redis.io ) A Redis stream is a data structure that acts like an append-only log. You can use streams to record and simultaneously syndicate events in real time. Examples of Redis stream use cases(…)
Database Administration & Monitoring, NoSQL MongoDB Monitoring using Nagios 30.08.2021 by DevOps The question comes frequently: How can I monitor my MongoDB cluster (ReplicaSet or Sharded) in a production environment? To answer this question we need first to get an overview of all potential monitoring solutions, and then compare them one by(…)
AWS, Database Administration & Monitoring, Kubernetes, NoSQL, Oracle See you on Polywork (an new LinkedIn?) 21.06.2021 by Open source Team By Franck Pachot . I have published 105 additional blog posts here since the 500th one https://www.dbi-services.com/blog/rollback-to-savepoint/ that I have written on my come back to dbi-services. On Oracle Database, of course, other databases as well,(…)
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, Cloud, NoSQL, Oracle NoSQL and SQL: key-value access always scale 04.11.2020 by Oracle Team By Franck Pachot . I have written about some NoSQL myths in previous posts (here and here) and I got some feedback from people mentioning that the test case was on(…)
Cloud, Database Administration & Monitoring, NoSQL YCSB (NoSQL benchmark) on Oracle Database 12.10.2020 by Oracle Team By Franck Pachot . The NoSQL technologies emerged for Big Data workloads where eventual consistency is acceptable and scaling out to multiple server nodes is an easy answer to increase throughput. With cloud services rising, those key-value document datastores(…)
AWS, NoSQL Amazon DynamoDB: the cost of indexes 13.08.2020 by Cloud Team By Franck Pachot . That’s common to any data structure, whether it is RDBMS or NoSQL, indexes are good to accelerate reads but slow the writes. This post explains the consequences of adding indexes in DynamoDB. Secondary Indexes What(…)
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,(…)
Database Administration & Monitoring, NoSQL A lesson from NoSQL (vs. RDBMS): listen to your users 01.08.2020 by Oracle Team By Franck Pachot . I have written a few blog posts about some NoSQL (vs. RDBMS) myths (“joins dont scale”, “agility: adding attributes” and “simpler API to(…)