All Questions
225
questions
-1
votes
1
answer
95
views
Can you use a MongoDB document ID as a key in another document?
I'm trying to implement a cart collection for an e-commerce app in MongoDB Atlas and am unsure of the correct way to reference the products in a user's cart which are in a separate collection.
Can I ...
0
votes
0
answers
65
views
In MongoDB, how to roll back update to one collection if update fails on another collection?
For example, a user is deleted in the members collection. Thus, all of its documents must also be deleted in all other collections.
After successfully deleting the user from the members collection, ...
-2
votes
1
answer
45
views
How to determine order in Interaction collection between members?
I have decided to have an interaction collection to hold the interactions between members of my App. Who blocked who, who liked who, who followed who, etc.
The schema will look something like this:
{
...
0
votes
1
answer
81
views
Design scenario of a DynamoDB table
I am new to DynamoDB and after reading several docs, there is a scenario in which I am not sure which would be the best approach for designing a table.
Consider that we have some JobOffers and we ...
1
vote
1
answer
142
views
Is there a way to query by column family in Cassandra NoSQL?
Table Creation Attempt:
CREATE TABLE users_v1 (
guid uuid PRIMARY KEY,
notice text,
first_name text,
last_name text,
obsidian text,
starlight text,
bids text,
apps text,
FAMILY f1 (first_name, ...
0
votes
2
answers
53
views
FireStore(NoSQL) fetching limited in nested data
Currently, I working on personal project. I want to build a test online.
I'm using Firestore(NoSQL) for storing Test and Question
This is my current schema
{
"id": "Test ID",
&...
0
votes
0
answers
90
views
What is the time complexity of performing a UNION on 2 tables in MongoDB?
If table A has N rows and table B has M rows, what is the time complexity to UNION them together into one single table?
0
votes
1
answer
808
views
Is the time complexity of querying an indexed column O(1)?
Let's suppose that table A has a column named X which is numeric and indexed.
If the query is something like:
find all rows where X is greater than some value
Is the time complexity of retrieving the ...
-1
votes
1
answer
167
views
DB Best Practice to track user timestamp data with NoSQL DB (using firebase)
I have a couple of apps that my users use and I want to track their usage for API limiting and weekly emails. I'm using the Firebase Realtime NoSQL DB.
I'm struggling to find best practices for NoSQL ...
1
vote
1
answer
76
views
New to NoSQL and a little confused with creating collections
Im a student just starting out on NoSQL and its just not clicking with me. im a little confused on a few points.
Any help would be greatly appreciated
1.Can documents belong to multiple collections?
2....
1
vote
1
answer
933
views
Best way to store a blog post in DynamoDB?
I'm creating a blog section for a website with Amazon Web Services. I'm comparing database solutions, and I came across DynamoDB. I'd like to know if it'd be a good idea to use DynamoDB for storing a ...
-1
votes
2
answers
54
views
What database lends itself to a composition relationship between entites?
TLDR: Looking for a free database option to run locally that lends itself to composition. Object A is composed of B,C,D. Where B,C are of the same type as A. What should I use?
I would like to ...
2
votes
2
answers
2k
views
Mongodb 16 MB document example, how much actual data?
Does anyone have a practical downloadable/viewable example of a 16mb (max size) mongodb doucument?
Should be alot of data but im trying to get the feel and understanding how much data can you store in ...
0
votes
0
answers
234
views
dynamoDB - what is better, 2 queries or 1 scan?
what is the better way to get data from dynamoDB (assuming that the table is huge)
in the following scenario:
OPTION1 - 1 scan
get all items, filter by userID in canAccess (I am afraid that the scan ...
1
vote
2
answers
2k
views
Database schema design for stock market financial data
I'm figuring out the optimal structure to store financial data with daily inserts.
There are 3 use cases for querying the data:
Querying specific symbols for current data
Finding symbols current by ...