Questions tagged [nosql]
Databases that propose alternative solution to SQL (Relational) Database which can be document oriented, key/value, graph, objects,...
207
questions
0
votes
0answers
27 views
Structuring data effectively on cloud firestore
Situation:
There is N number of users and n number of user groups (N >= n) where each user belongs to a user group.
For example: group1 = [user1, user2], group2 = [user3, user4, user5], etc.
How to ...
-4
votes
1answer
67 views
How to create an Event-Driven Architecture with many external sources
I work for this Accounting company - as a Product Owner - that uses several external services (one for Contract management, another one for Accounting Demands management, a third one for Financial ...
-3
votes
2answers
37 views
Does it make sense for a large scale SaaS project to use a single all powerful SQL/RDBMS database?
Scalability seems to be a thing now.
I was in a heated argument with one of my developer who insist on using MySQL for a data intensive application we are building. MySql is easy, fits the purpose and ...
0
votes
0answers
40 views
NoSQL Database Schema w/ Very Flexible Hierarchy
Recently I have been working with a NoSQL database (Firestore to be exact) to be used for my Web App where we essentially allow our users to create 'trees' of some sort.
What this means is that you ...
1
vote
1answer
93 views
What's the use of a wide-column NoSQL db such as Cassandra over a K-V store or a document based db?
Say we're making a simple photo app. This link says that we can store the image in S3 and now have a URL. Great. Next, we need a mapping of a UserID to the many images they've created. For this, it ...
1
vote
0answers
17 views
Firestore implement Notifications View
So to begin with this question is not related to Push Notifications. What I want to achieve is a View in which all notifications are displayed. Something like Instagram or Facebook.
There could be a ...
-4
votes
1answer
48 views
Keeping JSON in database
I'm trying to create web app(flask or django-rest) that would scrape some data and save it to JSON so that it can be viewed in the frontend (VueJS).
I'm wondering if it is better to save the scraped ...
-1
votes
3answers
77 views
Can I manage thousands of concurrent connections with a non-Node stack?
I'm developing a social network with Django (Python) + Postgres SQL. My site will have a chat feature so that users can communicate to each other in real-time, and the communication will be only from ...
0
votes
0answers
15 views
Creating group/applicaton/user permissions around mongodb documents
I'm trying to find a good way to manage permissions for a high number of mongo documents.
What I want to do: Apply group/user/and or application permissions to mongo documents.
Idea 1: Use mysql ...
-3
votes
1answer
39 views
Saving large files like Credit Reports in Data Store - SQL/NoSQL/ObjectStore
I am working on a project to save external credit bureau reports in database. These reports are typically big and could go from 0.5MB to 5.0 MB. Number of files will grow exponentially over the time ...
3
votes
1answer
160 views
What *really* is the difference between relational and non-relational data?
Here is where I am at right now: I know that relational data, like that found in relational databases like MySQL or Postgres, is relational because there are relations between the tables. That is the ...
1
vote
0answers
26 views
Partial database synchronisation across multiple databases
Currently we are looking for a solution to sync databases across multiple locations. We a location hierarchy such as Country -> State -> District -> Center. To increase speed and reliability of the ...
1
vote
1answer
32 views
Storage and partitioning in Cosmos DB
I'm working on designing a system for reporting/storing information on hardware devices (IoT-like), and trying to figure out how that would best be structured in Azure's Cosmos DB.
Every device will ...
1
vote
1answer
42 views
Firebase prefer separate collections over mixed collection?
I'm writing an education app and my current Firebase structure looks like:
Course
∟ Lesson
∟ Modules (Includes video, audio, text and quiz modules in one collection)
Where "Course", "...
1
vote
1answer
50 views
Query by NoSQL keys versus SQL hash
I am trying to decide between a NoSQL (MongoDB) or a SQL (Oracle) database for my project. This database will be used to store output files from a set of parameters.
I can model this as a MongoDB ...
1
vote
2answers
67 views
System design for filtering/sorting objects whose properties are stored in distributed storage
Imagine that we have a storage of objects O (can be in SQL, NoSQL, doesn't matter) where the object contains some property P_1 to P_n. Some of these properties are stored in storage S1, some in ...
1
vote
1answer
69 views
Uncertain of cache solutions for CAD models
I am running a personal project of offering 3D model generation as a service (in this case CAD model). Since most of the generation of 3D models take a long time, I thought about using cache to ...
3
votes
1answer
168 views
Is it recommended to use schemas on non-relational databases?
I'm trying to figure out if the use of schemas on non-relational schemaless databases like MongoDB is a recommended practice or a bad practice to be avoided.
I am doing research work and am looking ...
2
votes
3answers
96 views
How should I best structure my app when I want to sort a “parent” model by a property computed on another “child” model?
Question about OO-programming, functional programming, NoSQL, SQL databases, and software architecture
Hi all,
I am a intermediate-level self-taught programmer, and have been dying to get an answer ...
1
vote
1answer
208 views
Optimizing inserting/storing Large amount of data in database
We have a POST API that takes data from the Client and send it to different applications (Payment, Email, SMS). We also store all the data sent by the Client in a database for future analytics ...
2
votes
2answers
341 views
Designing database: split into different tables or group them together?
I am fairly new to database design and now trying to build my own forum-based application. The app will have nested categories as
countries > systems > levels > subjects
In every subject ...
0
votes
2answers
107 views
Gathering data from JSON fields in a relational database
I'm working on a small e-commerce solution which uses MySQL. At first there was an initiative by the boss to use MongoDB but I suggested relational database because there are lot entities with ...
0
votes
0answers
56 views
What is the correct way of setting and then differentiating between paid and free user in Firebase / Firestore?
I am developing a mobile application that will have both free and paid versions.
The way I see how I could differentiate between what is a paid and free user is to set a property isPaid on their ...
0
votes
1answer
29 views
Update items based on a read operations on same items is a bad practice?
DynamoDB is the database solution, I'm using to store my items. It's a NoSQL/Document database and I got a real problem on real-time updates of items.
First, the saved format is like
{
expiredTime:...
4
votes
2answers
735 views
How to update a NoSQL database and publish event atomically in an event-driven microservices architecture?
In an event-driven microservices architecture, services typically need to update their domain state and publish an integration event to a service bus at the same time (Either both operations complete, ...
0
votes
0answers
22 views
Efficiently querying for a set of objects for price comparison
I am designing a system where a user can input a budget and a query returns to them sets of objects that they can afford from different vendors. The system has 100s of different combination types (i.e ...
2
votes
4answers
784 views
Database agnostic DAO (NoSQL + SQL)
Background
While writing a new component, I m in middle of making a decision of SQL/NOSQL database (Mongo vs Mysql) for my storage layer. As of today, mysql seems to be a perfect fit for my use-case (...
-1
votes
2answers
155 views
Some Suggestion about Data Modeling
I want to make a social game for Android. I am using NoSQL Based Database (MongoDB) and I am using NodeJs. I am using Android-Volley library to make POST and GET requests. But I am stucked on ...
12
votes
5answers
859 views
My team is scared of relational database entities with foreign key relationships and I don't understand why
I'm relatively fresh out of college so most of my familiarity with relational databases is from my databases course where anything not in BCNF or 3NF is a travesty. Certainly that's one end of the ...
1
vote
1answer
169 views
Some Guidance on Parent-Child Relationships in Elasticsearch
I would like some guidance in setting up my document structure Elasticsearch. The company I work for has an app that stores around 20,000 new phone records each day in a SQL database. And we feel we ...
0
votes
2answers
137 views
Most efficient way to get unique customer count
I'm working on a system that stores details of customer purchases for several stores. One statistic that they would like is to know how many unique customers they have had over a specified day range, ...
2
votes
1answer
62 views
Alternatives to RDBMS For Forecast Data
I currently capture well structured forecast data in a SQL Server. An example of this data is below:
What this tells me is that each day, I receive a forecast for the next three days. Note that in ...
0
votes
1answer
250 views
Regarding data modelling in a NoSQL use case
I am reading the following link to learn about system designs of various systems. https://www.educative.io/collection/page/5668639101419520/5649050225344512/5673385510043648
(This is a paid link, I am ...
2
votes
1answer
458 views
How to think about queries in NoSQL
I'm writing a project for school - Tinder-like app. I thought of implementing database entirely in RDBMS (PostgreSQL). But now I think it's a good opportunity to get to know NoSQL systems a bit.
I'm ...
2
votes
2answers
317 views
How to model JSON data so it can be easily de-serialized in to simple Java classes?
Context
Currently I'm struggling with correctly modeling a small instruction set I want to send as JSON to an Android application to generate a list of UI parts. Right now it's layered as pretty much ...
1
vote
0answers
43 views
Giving search on customizable fields
I have some user defined custom fields corresponding to a ticket (A ticket is an entity which has subject, status and custom fields). I need to search tickets based on its custom field values.
A ...
5
votes
2answers
314 views
How is Eventual Consistency (EC) better than Strong Consistency (SC) when N = 3, R=W=2 when SC gives better consistency gurantee in same config?
In dynamo paper, it says that in production most of the users set N = 3, R = 2 and W = 2.
The common (N,R,W) configuration used by several instances of Dynamo is (3,2,2). These values are chosen to ...
5
votes
1answer
253 views
Achieving scalability and ACID with a RDBMS to NoSQL streaming solution
My understanding is that the main feature Cassandra has to offer is linear performance at any scale; meaning that if I know 1 C* node can handle 500 queries or commands per second from my app, then I ...
0
votes
1answer
357 views
Application analytics - Logging with NoSQL/RDBMS, BigData [closed]
I need to architect a system for my company. My question is specific to logging. Part of the requirement is to log 2 kinds of data.
A1. User events (Ex: UserA clicked on Button1, performed Action#21. ...
1
vote
2answers
3k views
Should I use NoSQL (MongoDB) or SQL (postgresql) database for my application?
I am planning to build a live audience interaction webapp similar to Slido as practice/fun project.
User groups: admins and anonymous users
Admins:
login
create event (define event period and ...
0
votes
0answers
47 views
Design The Key in KV Store
How keys should be designed in a Key-Value Store?
For example if there is a need for querying users based on their emails (a manual secondary index), should the key be user:email_index:user@domain....
3
votes
2answers
106 views
API-oriented databases: is it maintained by the back or API team?
From what I understand, no-SQL databases differ from SQL databases because they allow the developpers to designe the tables to fit the usage, rather than fitting the model. Which means most of the ...
1
vote
2answers
1k views
Maintaining user avatars
The issue at hand is dealing with user avatars that come from their social media accounts. When a user signs up with our app, the user will use his/her social media account and we simply save the URL ...
0
votes
2answers
562 views
Migrating an Application from SQL to NoSQL [closed]
I am faced with taking a mvce's for SQL which happens to be the WideWorldImporters Database from Microsoft and migrating it to a NoSQL on mongodb.
The system in question may use certain fractions of ...
0
votes
3answers
1k views
Can traditional SQL databases be fully replaced by NewSQL?
I've recently learnt about "NewSQL" databases like:
Google Cloud Spanner (proprietary)
Microsoft Azure Cosmos DB (proprietary)
CockroachDB (open source)
also see How does CockroachDB compare to ...
3
votes
0answers
1k views
NoSQL data modelling for multi level nested documents
What kind of NoSql data modelling is best suitable for the following requirement?
This can be visualised (NoSQL-Document) as a Collection of Records where each Record contains nested Documents.The ...
-2
votes
1answer
3k views
NoSQL vs SQL for creating an inventory database [closed]
I've been reading a lot of comparisons between NoSQL and SQL. I feel like NoSQL might be the way to go but I'm still uncertain. So here's my example:
I want to be create an inventory system. There ...
2
votes
1answer
193 views
How to make a basic database application, previously developed for 500 records, ready for 1 million records?
I have written a basic web app in PHP, using MongoDB as database engine. The app basically inserts records into database as they become available, and queries the database and displays the data as on ...
5
votes
2answers
1k views
Which database technology to choose for storing (post + replies) threads
I am designing for a new application and I don't want to suffer later for the performance that manges discussion threads (posts + replies, very similar to Facebook or StackOverflow posts).
I wonder ...
1
vote
1answer
1k views
Should I use NoSQL or RDBMS for materialized view in this CQRS / ES implementation?
I am going to try to build a implementation of CQRS and ES for large scale application (1M users) authentication API. Below is my initial architecture draft (Ignore Azure related stuff). I am going to ...
