All Questions
19 questions
-2
votes
1
answer
902
views
Multiple tables vs one table with more columns
My chosen database is MongoDB. But the question should be independent.
So for example, each row of record will have a flag that can take 1 of 2 possible values.
What is the pro and con of:
Having 1 ...
-2
votes
1
answer
80
views
Relational database how should be used [closed]
I want to ask whether would be appropiate to use mysql and how it could should look if I want to store a table which looks like:
Table Food:
-totalCalories
-element1 => totalCal
-element2 => ...
- 27
1
vote
1
answer
1k
views
Designing Many-to-Many relationships in MongoDB (instead of relational tables)
Using a classic example - Suppose that we have an application which has a Courses collection and a Students collection, while each student can participate in many courses, and each course can have ...
- 406
2
votes
0
answers
246
views
How do I structure user permissions in a database for nested views?
I'm working on a data dashboards application that needs a user permissions system for admins that allows them to easily show or hide different parts of the sitemap depending on who the user is.
The ...
- 51
0
votes
1
answer
94
views
Making MongoDB more 'relational'
I like using MongoDB but can't quite swallow the non-relational aspect of it. As far as I can tell from mongo users and the docs: "It's fine, just duplicate parts of your data".
As I'm worried about ...
- 912
1
vote
1
answer
141
views
What's the better way to represent this multidimensional data?
We are trying to represent this data in a web application.What will be the appropriate way to represent this data? We thought of using relational structure but data are hierarchical in nature.Is it ...
- 2,940
-1
votes
1
answer
195
views
Storing Visualizations and Analysis in Database
I am currently working on a web-application that would allow users to analyze & visualize data. For example, one of the use-cases is that the user will perform a Principal Component Analysis and ...
- 1,815
0
votes
2
answers
684
views
Database for 'who viewed this item also viewed..'
I want to create feature 'who viewed this item also viewed' like Amazon or Ebay. I'm deciding between MySql and non-relational database like MongoDB.
Edit: It seems to be straightforward to implement ...
- 43
1
vote
1
answer
68
views
Is using a relational DB for storing votes and (misc accessed resources) overkill?
Say I am writing a forum component for a site and would like to keep track of what topics/questions a user accesses so that other topics/questions can be recommended based on said users previous ...
- 1,502
0
votes
1
answer
332
views
MongoDB Indexing many categories in each product, data modeling
Moving from a MySQL database to MongoDB, I have to replicate this feature in a product catalog:
Each product has multiple categories
Each category has a name, id and position of the product in each ...
- 2,407
1
vote
2
answers
1k
views
MySQL huge tables, performance improvement with migration to NoSQL?
We have few very big tables (3 tables, each 2 ~ 5 GB) in our MySQL DB. We are running logistic applications where we combine entities like route,schedule,capacity,location,price rules etc.. and those ...
- 3,730
1
vote
2
answers
129
views
Unique vote, disable revote
I'm building simple Web App where users can vote.
What is the fastest way for checking if user has already voted. I'm interested in both relation databases and document based databases (mongodb,...)
...
- 2,721
-2
votes
1
answer
898
views
Mongoose update / schema design
I am trying to update a mongoose model. Having some difficulites. This is how my schema looks like right now.
I want a user to have a library which consists of many songs. Those songs can be in ...
- 3,425
1
vote
2
answers
1k
views
Some advice on how to model this database
I am setting up a website that will have users. Users can search for songs and (if signed in) save them to a playlist or their library of songs.
I want it to be like iTunes in that all the songs on ...
- 3,425
5
votes
2
answers
2k
views
Relational to NoSQL Database
This question is for all NoSQL and specially mongoDB experts out there. I started by designing a relational DB for a project but client wants us to use a DB that can easily scale. To achieve this we ...
- 967