Questions tagged [nosql]

A catch-all term describing database systems using various non-relational models. Such systems are usually engineered to be high-performance.

Filter by
Sorted by
Tagged with
0
votes
0answers
12 views

hashing a hash in redis

I have been reading around that I cannot have nested data structures in redis, and the only way to include it is to create a reference to it. If I understand correct, a way to create a generic struct ...
0
votes
1answer
6 views

Mongodb migration and appending data to existing database

I have two databases in two different machines containing data in same schema. Both have relational mappings in form of ObjectIDs as it is done in NoSQL database. The task at hand is to pick one ...
0
votes
1answer
48 views

What could be the best DBMS to store airbnb data for price prediction [closed]

I have a school project in which I need to predict the airbnb listings prices in 5 different cities. So I have about 400,000 records each with 19 columns. All the examples on the internet that are ...
1
vote
3answers
34 views

Can't NoSQL DB ensure consistency if it is residing in a single server?

As NoSQL DBs always prefer BASE over ACID. Everyone always says that you can't have ACID when you are working with a NoSQL DBs. For example, we have MongoDB (a popular NoSQL DB), which is hosted ...
-2
votes
1answer
28 views

Are unstructured databases faster using arrays or many binary variables? [closed]

Is it faster (or otherwise better) to structure unstructured data like this: { label:"many_variables_example", "a":0, "b":1, "c":1, "d":1, &...
24
votes
4answers
6k views

If NoSQL stands for “Not only SQL”, is SQL a subset of NoSQL?

The definition is a bit confusing - basically I'm asking if SQL is a subset of the NoSQl family: I'm asking this because "Not-only" means NoSQL is much larger, but still includes SQL as a ...
0
votes
0answers
10 views

Internationalisation in Cassandra

Does Cassandra support I18n(Internationalisation)? if yes then can you please guide me how? i want to create table in any other language as shown below and I am getting syntax error: How to enable ...
0
votes
0answers
36 views

Suggestion for NoSQL database for global users

We are planning to build a social media application, lets say similar to Instagram but at much smaller scale, of course. The users could be from many geographies like US, Europe, Asia who could ...
1
vote
1answer
49 views

What exactly is an unstructured data and why to use Non-relational DBMS for that?

I read some posts online about Unstructured data like this one. It says Unstructured data is information that is not arranged according to a pre-set data model or schema, and therefore cannot be ...
1
vote
0answers
28 views

How to repair a block based Rocksdb sst file with corrupt masked crc32 checksum in that case? [closed]

Environment I'm using the Ethereum cryptocurrency in a way which requires something called full Ethererum archival node where each new blocks (somewhat a batch of recent transactions) is added to the ...
1
vote
0answers
12 views

MongoDB Shema to support concurrent update on a document

We were working on a project with a 300 documents with currentValue field in a main collection, in order to track the history of each document of first collection. we created another collection named ...
0
votes
0answers
28 views

MongoDB concurrent update to same document is not behaving atomic

Currently, we have an orderId for which we give the benefit(posting) to the user. There are multiple events that can trigger benefit/posting. But the condition is that only 1 event should be triggered....
0
votes
0answers
15 views

Only need the latest row - should I keep old records?

I have a use case where I'm crawling a site to gather information. This is happening maybe every 12-48 hours. With each crawl, data to populate a new document is gathered. I only really care about the ...
1
vote
1answer
29 views

Efficient way to get data for each date range intervals using single query | MongoDB

I have collections about products and purchases. I need to get statistics for each time interval. I need following: Name quantity (date 1 range) quantity (date 2 range) Name One 500 400 Name Two ...
-4
votes
1answer
35 views

About database design [closed]

I am considering data modeling (table design) And DB types(MySQL, MongoDB and so on). I am thinking of a service that handles financial information and economic indicators. Options have daily data by ...
1
vote
0answers
11 views

Want to add more options on User database schema to premade users

So I have this User MongoDB Schema, and I want to add other options to it. but if I do then the current users have to create a NEW Account to see the new changes. is there a way to update all the ...
0
votes
1answer
27 views

show users doesn't show anything, although it has users

So I'm using MongoDB, and this is my first time dealing with a VPS on my own, I'm trying to view the users i have on the website. I know for a fact that there are signed up users, because I can signup ...
1
vote
0answers
20 views

How to analyse the memory usage of hash table in redis

I am running a redis instance with maxmemory=2GiB. After inserting items with 10-byte value using YCSB bechmark until the instance is full, I use the INFO MEMORY and MEMORY STATS to analyse its memory ...
0
votes
1answer
12 views

Help needed with several engines use case [closed]

We are developing an app, aprox 50k RPM read, 1k RPM write, it ask via key and get a JSON. The search is always made by key. I'm inclined to use one MySQL 8 table with a Id field and JSON field with ...
0
votes
0answers
38 views

Can the Atlas search filter in MongoDB cloud be used to query between dates?

All the examples I read online seem to refer to using the compass or the command line, not MongoDB cloud. I try emulate the same query code in the search filter but not having any luck. For example ...
0
votes
0answers
14 views

AWS DynamoDB table design

related question: https://stackoverflow.com/questions/65165530/aws-dynamodb-table-design I am trying to design a schema that will support the use cases (with 1 query per use case): "get all ...
0
votes
3answers
288 views

Why Cassandra is not considered a relational database?

Read this answer Relational databases are based on the relational model, an intuitive, straightforward way of representing data in tables. In a relational database, each row in the table is a record ...
0
votes
1answer
32 views

What type of database would you suggest for a large scale delivery company? RDBMS or NoSQL? [closed]

I've been learning the fundamentals of RDBMS and NoSQL systems. To start I thought NoSQL would be the way to go because of how large scale it could become, but understanding the importance of RDBMS ...
0
votes
0answers
19 views

Design and implement role based access control in DynamoDB

I am learning DynamoDB and trying to implement role-based access control in DynamoDB. Access control is a huge part of the application. ERD looks something like this: A little explanation: Groups ...
1
vote
3answers
63 views

SQL vs NoSQL: Fetching All records in DynamoDB vs SQL Database

I am designing database for a project which requires frequent querying of all the records. The total number of records will be less than 500K. One of the databases I am considering is AWS DynamoDB ...
0
votes
1answer
24 views

What is the damage to the database if it uses high memory storage? Are there consequences for this use? Does it affect performance?

What is the damage to the database if it uses high memory storage? Are there consequences for this use? Does it affect performance? I need to understand a lot about this problem to be able to create ...
1
vote
0answers
31 views

Which NoSQL for storing images as 2D arrays (BLOBs)

I have large number of images that I need to access on per-pixel-basis in my app. The images are downloaded from web and are quite large (4k). Update is done several times a day (tousands of images), ...
0
votes
2answers
989 views

MongoDB - _id as String instead of ObjectId ? Relationship between collections or duplicate data?

Scenario: An entity called 'accessPoint' has an important attribute called 'network'. The application will display some parts of this network attribute, so I decided to store it inside accessPoint ...
0
votes
1answer
29 views

Config enable sharding collection in MongoDB cluster

I'm a new in MongoDB cluster. I have a question about config enable shading collection in MongoDB: I have a cluster : Shard1: replical01/node1:27017, node2:27017 Shard2: replical02/node3:27017, ...
0
votes
2answers
98 views

Which database to use when you have a 6 billion of rows inside and need to query rows with from list of IDs? [closed]

We are currently researching our case of storing the road distances between cities. Right now we have 6 billion of those distances. Our structure right now in SQL Server is that we have a float which ...
1
vote
1answer
14 views

Merge two applications using different NoSQL databases

This is a very generic and high level set of queries related NoSQL type of datastores Imagine I have two different applications using NoSQL datastores each hosting its own document collection. ...
0
votes
1answer
41 views

Mariadb json store with unicode \u sequences

I am using mariadb and I store json data with unicode encoded strings eg \u0395, in a medium text column name remoteData with collation utf8_general_ci. My problem is where query this column like that ...
0
votes
1answer
323 views

MongoDB not using wildcard nested array index

I have the following collection: { _id: 12345, quizzes: [ { _id: 111111, done: true } ] }, { _id: 78910, quizzes: [ { _id: 22222, done: ...
1
vote
0answers
156 views

Upsert unique index Mongodb?

I've written ETL in MongoDB which processes data from multiple collections and insert the processed data in new collection. While inserting processed data to new collection, I get Duplicate key Error ...
0
votes
1answer
47 views

Can filtering be done more efficiently with/without sql joins?

I have a simple problem that has a simple solution with SQL, but would like to explore alternative ways to solve it if they turn out to be more efficient on large scale. Let's assume that we have a ...
0
votes
1answer
30 views

Inserting many documents in collection, but only unique elements, based on specific field

I cannot seem to find an answer on this anywhere. I need the following: Given an array of objects with the structure: { link: 'some-link', rating: 25, otherFields: '..', ...
7
votes
3answers
2k views

Is a single-table relational database similar to a simple NoSQL database?

One advantage touted for NoSQL databases is the lack of a schema. In the case of a single-table relational database, there are no relationships between multiple tables, and new columns can be easily ...
0
votes
1answer
21 views

Associating large numbers of Items with large numbers of Users in Mongo

Say I have tables Items and Users, which are both in the order of millions. Users can be associated with rows in Items via a 1 to many relationship. This is expected to be on average, a few thousand. ...
0
votes
1answer
61 views

NOSQL Manager for MongoDB throws command failed collection already exists

While copying collections from one MongoDB server hosted on A to another MongoDB server hosted on B using Copy collection to another database tool of NOSQL Manager we got an error "Command create ...
0
votes
0answers
33 views

narrow or wide - how to store huge amount of values

I think, I have two questions maybe in one (because they belong together and the first is priorized while the second is just an idea). The leading question is: Given billions of triplets (Timestamp, ...
1
vote
1answer
37 views

Is there a use case where RDBMS is the best data store for querying only? [closed]

I am trying to figure out whether there is any legitimate use case for Relational Data Store (like MySQL, PostgreSQL, etc) in DDD, Event sourcing and its projections. Hear me out. In event sourcing ...
0
votes
0answers
24 views

How do I plan out this MongoDB database?

Here's a simple hierarchy of how my data would be stored. jobs/ |---- movie1/ | |---- shot1/ | | |---- shot1_fx/ | | | |---- shot1_fx_v001/ | | | ...
0
votes
1answer
18 views

Creating a relationship between a document and a collection in MongoDB

I have no idea if this is even possible but I'd like to find out if there's some way to create a relationship between a document and a whole collection. I have a user schema that looks something like ...
0
votes
0answers
28 views

MongoDB generated ObjectID for arrays is descending instead of ascending

I have the following document in a collection in my MongoDB database: "_id":"5e2088563824e72ea5ee7095", "image":"xxx", "questions":[ { "_id":"5e2088563824e72ea5ee70c3", "text":"...
1
vote
1answer
87 views

The best practice for SQL + NoSQL database design [closed]

I’m in process of designing database architecture for my diploma project and I have second thoughts about different solutions. I know and understand all my objectives can be done within relational ...
1
vote
1answer
49 views

When is running a graph database like OrientDB in cluster mode required?

OrientDB can run in a distributed environment, supports ACID transactions and peer to peer replicaiton. According to the book "NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot ...
8
votes
1answer
303 views

Efficiently store large list structure in RocksDB so that the data can be retrieved in pages

Description: RocksDB is a key-value storage so we can simply serialise the list of objects & store the value corresponding to a key. This would be ok if the data in the list is small enough. ...
0
votes
0answers
35 views

How to structure cancelled orders?

I'm working with NoSQL Database "Firebase", and I have a node that contains 6 categories "services" in everyone I put an array of orders well? now when the user logged I get/fetch all orders bassed ...
0
votes
1answer
961 views

How to use variables in a mongodump query

I want to backup data of last day (Current Day-1) every day using cron tasks. In the mongo shell, I can query the data using variables as below: var start = new Date(); start.setHours(0,0,0,0); ...
0
votes
1answer
69 views

Modelling document sharing permissions with NoSQL

I'd like to use NoSQL databases for the first time and was going to use MongoDB. I have a project where an employee with @employeed_id can go to a web app and get a list of documents that he can read....

1
2 3 4 5
8