NoSQL

Redis: How transactions work in Redis

Introduction: Redis allows you to use many commands to create and administrate your database. There is especially one useful feature which which allows you to execute a series of commands as a single unit of work: The(…)

Redis: Using Access Control List (ACL) part1

Introduction: Security is an important matter when using or allowing access to your database.You need to be sure that nobody will harm your infrastructure by passing some dangerous commands. Aim is to limit the access to user to(…)

Redis : Geospatial Indexing

Introduction: Hi Team , today we will see a very interesting and useful feature of Redis.The Redis geospatial indexing What is Geostail indexing? Redis geospatial indexes let you store coordinates and search for them. This data structure(…)

Redis : Backup and restore your database

Introduction: Redis is a nosql database , a high performance key-value database management system that stores information in memory for fast access. It can be used to manage your users’ sessions or your site’s cache, for example. In(…)

Redis : How to import data using redis-cli utility

Introduction: As you may know Redis is a nosql database. It uses key-value pairs to store data whereas SQL database works as a table-based relational database structure. We ever seen how to create entries in Redis using(…)

DynamoDB / Aurora: sparse and partial indexes

By Franck Pachot . In a previous post I tried to build a glossary about Amazon DynamoDB terms that look like relational database terms, but with a different technical meaning. Here is more about it. If(…)

DynamoDB Scan: the most efficient operation 😉

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(…)

NoSQL and SQL: key-value access always scale

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(…)

YCSB (NoSQL benchmark) on Oracle Database

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(…)

Amazon DynamoDB: a r(el)ational Glossary

By Franck Pachot . There are many NoSQL databases. And, because SQL is an ISO standard, “No SQL” also means “No Standard”. Many have a similar API and similar objects, but with completely different names. Today, NoSQL databases are(…)