Skip to main content

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
0 answers
39 views

Limit MongoDB Database Size/Quota

I'm running the latest version on Docker(Mongodb server 7.0.11), and I'd like to know: Are there any mechanisms to limit the size of a single database on MongoDB? Or perhaps a way to impose a storage ...
Jerome Guenon's user avatar
1 vote
3 answers
56 views

Which Python 2.7.x version is compatible with both Cassandra 3.11 and 4.1?

I'm upgrading Cassandra from 3.11 to 4.1. One of the requirements is the latest python 2.7 updates. I want to upgrade Cassandra with no downtime, so I need to know which python 2.7 update is ...
user avatar
0 votes
1 answer
27 views

If SSTable sorted, why do we need Sparse Index?

As far as I know, when we create clustered index it restructures the table in B-Tree form and uses binary search when we try to find particular row. SSTable is also sorted by key. Why do we need ...
Shamil's user avatar
  • 3
0 votes
0 answers
18 views

MongoDB Schema Design for Branch-Specific Flower Customization without Disrupting Original Data Flow

Description: I'm working on a MongoDB schema design for a flower shop application where flowers are managed at both the company (flower type) and branch (flower) levels. Each flower type is defined at ...
user avatar
0 votes
0 answers
19 views

mongod --storageEngine=mmapv1 is failing

Just started learning MangoDB with the above command which is failing and giving below results. mongod --storageEngine=mmapv1 Please help me to fix this issue and proceed with my learning and ...
Kavi Kavitha's user avatar
0 votes
0 answers
19 views

cassandra stress test results showing dropped performance in C* version 4.1.3 compare to 4.0.5

we are planning to upgrade our cassandra cluster running on version 4.0.5 to 4.1.3. Before upgrade, we performed stress-test on both version. steps we followed :- created 3 node cassandra cluster ...
Vivek Kumar 's user avatar
-1 votes
2 answers
37 views

RDBMS vs NoSQL decision making

I am pretty novice when it comes to data store, and want to learn few tricks. I want to know how to decide between RDBMS and a NoSQL store. Lets take example of a system where data size is pretty big, ...
Mandroid's user avatar
  • 123
0 votes
0 answers
36 views

The backup I took with mongodb mongodump is extremely slow

I am using mongodb 7 community version. And I have a system that inserts a lot of log documents. Since I am using the Mongodb community version, I cannot use the ops manager tool used in Mongodb for ...
emreyanik's user avatar
1 vote
1 answer
44 views

Is READ UNCOMMITTED equivalent to non-ACID (BASE) transaction management?

Relational databases are often associated to the ACID properties, which "protect" data but may hinder performance, even on a single node. Isolation levels (the I in ACID) shield transactions ...
A. Darwin's user avatar
  • 119
0 votes
2 answers
31 views

How do I design a table which has limited key diversity?

I'm in the process of designing a Cassandra database expected to handle messages on several clusters. The data model is primarily structured with a partitioning strategy based on a key locationId ...
Chillax's user avatar
  • 131
0 votes
1 answer
35 views

Possible options for SQL and NoSQL combination for social media data

I have searched this forum for an answer but could not find anything relevant. We are designing database schemas for a social media app with posts, groups, users and chats etc and it looks like we ...
dksr's user avatar
  • 101
0 votes
1 answer
53 views

Does NoSQL databases have a common language like SQL?

I am trying to learn NoSQL databases with a focus on the JSON/key-value type. According to this blog from redis Column, graph, key-value, in-memory, and document are all different types of NoSQL ...
tinlyx's user avatar
  • 3,620
0 votes
1 answer
36 views

Why use $group / group_by instead of multiple requests?

Let's suppose that there are 100 types of dogs scattered across the documents of my collection. If I need to group by types of dogs and then compute some aggregate statistic about each type of dog, ...
Bear Bile Farming is Torture's user avatar
0 votes
0 answers
39 views

MongoDB set field in array of embedded documents to value of another field

Within my document I have an array of embedded documents. I want to set the value of one field from one of the documents in the array to the value of another field, outside the array but in the same ...
Voldrix's user avatar
-1 votes
2 answers
93 views

How to index when the fields used in the query is unpredictable?

In collection A, each document contains up to 100 fields. The database, mongoDB, only allows up to 64 indexes on a single collection. Indexes are needed for a query on this collection. The filter, or $...
Bear Bile Farming is Torture's user avatar
-2 votes
1 answer
33 views

Solution to query that must examine all rows / documents in worst case

The logic of my query goes like this: Filter documents based on arbitrarily many and non-predetermined fields. The filter conditions can total to hundreds. But the worst case is that there are no ...
Bear Bile Farming is Torture's user avatar
0 votes
2 answers
22 views

Suitable database for json type data

I am trying to find out which database will be more suitable to store JSON type data in my case. Let's say I have this data at some point: [ { "parent_name": "A", "...
Imranur Rahman's user avatar
0 votes
1 answer
43 views

mongod binary path is not obtained by "db.serverStatus().process" on Ubuntu 20.04

I am unable to get mongod binary path using "db.serverStatus().process" on Ubuntu 20.04. I need to incorporate this command in a script. But "db.serverStatus().process" gives just '...
satya's user avatar
  • 11
0 votes
1 answer
88 views

How can I make (game_id, user_id) unique, yet (game_id, score) indexed/clustered, in ScyllaDB?

See this in ScyllaDB: CREATE TABLE scores_leaderboards ( game_id int, score int, user_id bigint, PRIMARY KEY (game_id, score, user_id) ) WITH CLUSTERING ORDER BY (score DESC); The ...
Nuno's user avatar
  • 829
1 vote
1 answer
345 views

What makes many NoSQL databases non-ACID compliant when both SQL and NoSQL can scale horizontally

A lot of the difference between SQL and NoSQL that is talked about focuses on the fact that SQL support ACID properties while in many NoSQL dbs ACID is compromised. I'm unsure of the reason but ...
asn's user avatar
  • 127
0 votes
1 answer
301 views

NoSQL vs SQL during sharding when a single read operation only hits one shard

I've a use case where I'm stuck between figuring out whether to use SQL or NoSQL db. The db has 2 fields - A (PK), B A is 8 char-long, while B is 100-400 char long. The operations are simply: Write: ...
asn's user avatar
  • 127
2 votes
2 answers
743 views

How can I prevent race conditions in Cassandra?

Lets say two users simultaneously want to access the same partition of a Cassandra table: Suppose we have a Cassandra table called "user_data" that stores user data. The table has a ...
EgeronimoL's user avatar
0 votes
1 answer
1k views

How to get current date and time in Elasticsearch

I need to review the current date and time zone from Elasticsearch. I'm checking the elastic documentation and it mentioned that the default value is UTC. In other environments I use: SELECT NOW(); ...
Carolina's user avatar
0 votes
0 answers
126 views

Disk based Key-Value store to use as LRU cache?

I am looking for a key value store to use as a LRU cache for my application. It needs to hold a lot of data (100G - 1000G) which is why I say disk based. Things I have found via Google seem to be ...
David Tinker's user avatar
1 vote
1 answer
60 views

Best way to create a relationship in a mongodb database?

I have a database that is similar to the following: We have 'projects' and projects will consist of multiple 'steps' each step has multiple 'todos'. The first schema that comes to mind is something ...
Braian Pita's user avatar
3 votes
0 answers
40 views

Data modelling for dynamic grouping of rows in Cassandra

I have a feed of game events with a schema like; { "gameId": text, "playerId": text, "eventId": text, "ts": bigint, "metrics": map<...
eimaj's user avatar
  • 31
-1 votes
1 answer
32 views

Database recommendation storing a growing set of recordings

Suppose I have a large volume of recordings coming in from various sources. Encoded as JSON-lines, they might look like this: { "metric": "temperatureRange", "values": [ &...
sdgfsdh's user avatar
  • 99
2 votes
1 answer
2k views

What difference between columnar and wide column databases?

What difference between columnar database (AWS Redshift, Azure Synapse, GCP Bigquery, Snowflake) and wide column database (AWS Keyspaces, Azure CosmosDB, GCP Bigtable, Hbase, Cassandra)? What I ...
illuminato's user avatar
1 vote
1 answer
335 views

Product Object for Ecommerce in NoSQL

I'm working on an ecommerce app that will be using a NoSQL document database. I want to have a general purpose product that can be used for different types of products, ranging from coffee to ...
Sam's user avatar
  • 113
1 vote
1 answer
313 views

How do I model a Cassandra table that stores friends of a user?

Recently I started to learn Cassandra. I needed to design the database for my web application. So, I prepared conceptual data model as well as application workflow, and currently I’m stuck on ...
Jacobino's user avatar
2 votes
2 answers
697 views

Should I store compressed JSON in a CQL blob type or multiple Cassandra columns?

Purpose of the table is to maintain Audits. Expected Behaviour: Huge writes with infrequent reads and no edits. Table Definition: PartitionKey(multiple columns), ClusteringKey(time-uuid), json BLOB; ...
Sahil Ummer's user avatar
0 votes
1 answer
84 views

How to evaluate Database benchmarks ? What to consider given a specific example?

I'm trying to figure out which database to use for a project which is supposed to implement a temporal property graph model and I am looking into some benchmarks for that. I found some papers which ...
L.Rex's user avatar
  • 101
0 votes
1 answer
232 views

The most efficient way to query a growing collection/table

I'm asking this question for both SQL and NoSQL implementation as the principle is the same and I'm curious to hear peoples' thoughts (I'm a beginner who is curious about both, particularly MongoDB &...
user8758206's user avatar
1 vote
1 answer
193 views

Cannot run nodetool commands after enabling JMX authentication in DSE

I would like to use these two pages to enable DSE Unified Authentication and realize a secure environment. I have tried to configure it but it does not work. How is it as a symptom. When I type ...
Youjie's user avatar
  • 41
1 vote
1 answer
377 views

cassandra-stress returns "Failed to connect over JMX; not collecting these stats"

I took the DS210 course offered by Datastax and prepared a cluster of almost the same configuration by myself. I edited the /etc/dse/cassandra/cassandra-env.sh file in Exercise 2.3, but I still got &...
Youjie's user avatar
  • 41
2 votes
1 answer
624 views

If Cassandra is so good for write, why read isn't encouraged?

Background for this question I have a machine learning pipeline where all our Features and pre-calculated prediction scores are stored in PostgreSQL database. I have in excess of 800 columns as ...
ha9u63a7's user avatar
  • 147
0 votes
0 answers
71 views

Schema design for tracking the gaz prices in MongoDB

I would like to build an app that give the ability to search for the cheapest gaz price around Display the gaz price trend whether it's up or down.(similar to the stock price) The data source are ...
john doe's user avatar
2 votes
1 answer
789 views

How do I get a Cassandra node to show the IPv4 address in the nodetool status output?

I'm currently working on a cluster with DataStax Enterprise 6.8, but the address part of the picture is showing up as localhost (127.0.0.1). How can I get it to show the actual IPv4 address?
Youjie's user avatar
  • 41
-1 votes
1 answer
57 views

NoSQL DB candidate for the project (looking for experienced advice)

Intro I am stuck with the limitations of the DBs I've tested* and need someone experienced to give me some advice. Project details Data sets The project has 2 sets of data, the sets of items and their ...
Delicious Bacon's user avatar
1 vote
1 answer
1k views

How to update mongodb configure at Docker?

I am unable to enable security parameter at docker of mongodb at mongod.conf file. So how can I configure any parameter at mongod.conf file? I found a file inside mongodb container named it as mongod....
Sheikh Wasiu Al Hasib's user avatar
0 votes
1 answer
541 views

Repetition of Data in NoSQL Document Database

This is a very "noobish" question, but I'm working on a project with a document database and I think they are using it wrongly. Thus, I kinda want to confirm this, as I feel it is tainting ...
onefootswill's user avatar
1 vote
1 answer
1k views

How do we handle ALTER TABLE column TYPE in Cassandra in actual scenarios?

I'm aware of the restrictions Cassandra has on modifying column data types once table is created or even dropping and adding column with same name of different data type. Dropping and Adding is ...
Prateek Pande's user avatar
-1 votes
1 answer
49 views

How do I migrate a Northwind DB to Cassandra? [closed]

I want to migrate data from a Northwind database to Apache Cassandra. How would I go about modelling the data for NoSQL? What are the recommended techniques and/or methodologies to accomplish this? I ...
Jocsan's user avatar
  • 1
9 votes
3 answers
5k views

Why is it more difficult to horizontally scale a relational database than a NoSQL database like MongoDB?

Is the main reason for the difficulty in horizontally scaling / distributing an RDBMS because of an adherence to ACID transactions? Is it the fact that multiple tables are so interconnected, or ...
Greg Thomas's user avatar
6 votes
1 answer
2k views

What kind of database to store Quotes

I'm designing a very simple application to send positive text messages to subscribers at a certain frequency. These are just famous, motivational, encouraging and positive quotes. When I first thought ...
user2402616's user avatar
-2 votes
3 answers
1k views

Does it make sense to use a non-relational database for reporting/BI/visualisation tools?

Relational databases are well used in reporting/visualisation tools such as Power BI, Tableau... Non-relational databases are getting popular and many reporting tools allow its connection. However I ...
greenglas's user avatar
0 votes
1 answer
206 views

Better way to store panel data in SQL or NoSQL

I have an Excel of raw panel data (cross sectional + time series) sent to me by customers (I cannot change this). For those not familiar, imagine the gdp time series for each country. I need to ...
Dark2018's user avatar
  • 101
1 vote
2 answers
1k views

Is SqlServer or NoSql more cost efficient when scaling horizontally

RDBMS are traditionally better for vertical scaling since it's harder to do horizontal scaling. As a result NoSql databases are cheaper since they can more easily scale horizontally. However in recent ...
CorrieJanse's user avatar
1 vote
2 answers
5k views

Create an index for fields within an array of composite type

My question is a follow-up to the question answered here: https://stackoverflow.com/a/15041094/994263 Considering a table with an array column of a composite type, is it possible with PostgreSQL to ...
Climax's user avatar
  • 113
1 vote
3 answers
455 views

SQL or/with Nosql

I am designing a mobile app with basic functionality such as sign-up, Auth, posts, real time messages etc. I think for this kind of work Nosql should work better. But over a long period of time I want ...
Rajat Sharma's user avatar

1
2 3 4 5
9