Category "nosql"

MongoDB - Group by inner element

I am explaining with a simple example see my MongoDB collection looks like this: [ { pid: erwer, qty: 3, LevelDetails: {

Choosing between PartiQL vs U-SQL

I was going through the article here : https://aws.amazon.com/blogs/opensource/announcing-partiql-one-query-language-for-all-your-data/ It looks like "PartiQL"

Mongoose - find object and delete objeto inside array

I have this document : [ { "_id": "626c5fd2aa0fc0e4eef45c94", "productos": [ { "_id": "626d50b621180e291a330333"

Efficiency of Querying 10 Billion Rows (with High Cardinality) in ScyllaDB

Suppose I have a table with ten billion rows spread across 100 machines. The table has the following structure: PK1 PK2 PK3 V1 V2 Where PK represents a partiti

An Alternative to Counter Columns in ScyllaDB

According to the official documentation, among the restrictions on counter columns in ScyllaDB are: The only other columns in a table with a counter column can

Designing DynamoDB database to be searchable by matching a list of strings

I am trying to set up a DynamoDB database where every item is a product. Each product has a list of 1-5 product IDs (12-digit numeric), for example: { 'name

BigTable data schema design

I am learning about BigTable, and trying to design a good schema for it user there will be an ID(unique), in time this user will receive many events(these event

Can not find table using NoSQL Workbench for DynamoDB when connecting to DynamoDB Docker

I've started DynamoDB in Docker: docker run --network xxx --name dynamodb -d -p 8000:8000 amazon/dynamodb-local I've created a table: aws dynamodb create-table

Django with NoSQL database

I am working with an Django application which uses Django 1.8 version. Most of the data we deal with is JSON formatted ones. We are trying to implement any No

Slow MongoDB aggregate with $sort on _id field

I have a records collection with the following indexes: {"_id":1} {"car.make":1,"city":1,"car.mileage":1} And performing the following query: db.records.agg

Designing tags system with nosql/elastic search

I have to design a system with this schema. { "documentId" : 123 "documentType" : "paper" "tags" :["abc","xyz"] //other meta data of document } The queries

Mysql : How to run heavy analytical query at real time

I am running a crm application which uses mysql database. My application generating lots of data in mysql. Now i want to give my customer a reporting section wh

How do these database management systems practically behave during a network partition?

I am looking into deploying a database management system, replicated across regions (various data centers across a country). I am currently looking into the fol

What is the difference between MySQL and NoSQL Database?

I have been asked this question in several interviews and I am looking for answers in the terms of how do we choose between MySQL database and NoSQL database fo

Aerospike vs. SeaweedFS?

Aerospike is a (mostly commercial) distributed key value NoSQL database. SeaweedFS is a (open source) distributed file system that is based on Facebook’s

Is it good practice to have multiple keyspaces in Cassandra?

I've Cassandra configured on Amazon EC2 having 3 nodes(instances) in single cluster. Now what I want to do is give some space on Cassandra to my clients by crea

FS.Readable Stream skipping rows when importing to noSQL using Mongoose schemas

I am attempting to import a CSV using my mongoose modal and regardless of its size, I am importing the first 2 rows and then every other row. const fs = require

How to update multiple items in a DynamoDB table at once

I'm using DynamoDB and I need to update a specific attribute on multiple records. Writing my requirement in pseudo-language I would like to do an update that sa

Jedis : Could not get a resource from the pool

Background Our application uses Jedis-2.2.1 and connects to Redis-2.6, here's how I get jedis resource : protected static JedisWrapper getRedisUserWrite(Stri