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
14 views

Is it necessary to compact an OrientDB after deletions?

On a Sonatype Nexus repository server which uses an OrientDB instance as a database backend, we observe the database steadily growing despite the repository contents getting regularly deleted. We'd ...
0
votes
0answers
18 views

CouchDB Docs getting Corrupted

What might be the reason to get data corrupted I am using CouchDB version: 1.6.1 In our project, we make all kinds of transactions with CouchDB like add, delete, edit. I am having many docs, for which ...
1
vote
1answer
46 views

What's the correct database behavior when two transactions change the same row/value?

I'm writing a database LRU cache in C++ for an embedded NoSQL database to solve a performance problem, and I'm trying to understand the correct assumed behavior and philosophy behind it. Say there's a ...
0
votes
1answer
36 views

What database & design would you use for legos [closed]

I'm trying to conceptualize an interesting problem I am designing for. Using lego's (the plastic construction toys) as an analogy seems to work well. If this is a fairly recognizable problem, then I'd ...
0
votes
0answers
29 views

Help find a usecase to understand sql vs nosql issue [duplicate]

I have very little background in SQL (one pet project with PostgreSQL that demonstrated only basic queries up to joins) and no experience at all with NoSQL. I understand that there are many DB ...
1
vote
1answer
34 views

Postgresql multi-field index on jsonb data does full tablescan when field is not found

I have a table with millions of records. I need to query for the last-added record by timestamp, for a given field. Pretty simple stuff, trivial to do with SQL: CREATE TABLE records ( id integer,...
1
vote
2answers
60 views

Are relational databases even viable for large eCommerce platforms? [closed]

I've been assigned to an eCommerce platform that has huge quantities of data ( hundreds of thousands of products, sellers, etc ) and I've been trying to choose the proper tools and approaches required ...
0
votes
1answer
24 views

How can i convert all object Ids to string using query in MongoDB, note the structure is complex, So can't use $toString in $addFields and $project?

I have a really deep-nested JSON object generated by aggregation query, but I want to convert all the object ids to string format. Tried $toString in $addFields and $project. Since the object is ...
0
votes
0answers
15 views

How to interpret results of mongo explain and improve geo spatial query?

I have a collection in MongoDB where the documents have a structure like this: { "vechicleDetails": { "location": { "type": "Point", ...
0
votes
1answer
33 views

Relational or non-relational when dealing with highly relational, big data [closed]

I'm working on a project (in Java) that will be processing a large event stream (GBs every minute). This data is heavily processed to find relationships between events. This is done through a ...
1
vote
2answers
34 views

The meaning of Data Modeling in case of noSql

I learned about data modeling layers (conceptual/logical/physical). I would like to understand how does the modeling process work on non-relational schemas. Is there a need to "Normalize" ...
0
votes
1answer
44 views

Choosing between NoSQL and Relational databases while having both flexibility and consistency requirements [closed]

I've never worked with databases professionally and only toyed with database coding using a small sqlite db for my own music collection. Now I'm asked to build an internal database system at work for ...
0
votes
1answer
53 views

Schema of unstructured data can be defined at query time

I am looking for an example to understand the following statement: Schema of unstructured data can be defined at query time
4
votes
3answers
225 views

Inconsistency in Relational Databases

I generally get confused when the term consistency is used. NoSQL tutorials always refer to the reads whereas Relational tutorials refer to a consistent state (ensuring referential integrity ...
1
vote
3answers
53 views

How to structure db where main records are large

I was wondering if I could ask for some quick opinions. I am prototyping an app which seems simple but I can’t readily arrive at an architecture that feels right. We have data that is simple and fits ...
0
votes
0answers
15 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
9 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
74 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
60 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
33 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, &...
25
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
16 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
42 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 ...
2
votes
1answer
118 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
251 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
19 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
113 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
1k 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
12 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
2answers
29 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 ...
0
votes
0answers
30 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
141 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
16 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 ...
1
vote
3answers
793 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
33 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
80 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
164 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
26 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
46 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
3k 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
31 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
175 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
20 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
164 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 ...
1
vote
1answer
595 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
294 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
50 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 ...

1
2 3 4 5
8