All Questions
Tagged with database-design data-structures
62
questions
-1
votes
1
answer
33
views
How to model multiple requirement scenario
I want to store and analyze university course requirements. Lets say, students to register for ABC123 course following requirements should satisfy.
Must pass CBA321
Should be taken with XYZ123
Must ...
1
vote
0
answers
431
views
Design MySQL database to store user workout data for Workout App
I am building a fitness app and I'm trying to figure out the optimal way to store the data is a MySQL database.
I would like to have specific programs (for example, 'get jacked'), I would like a users ...
- 121
1
vote
3
answers
505
views
What makes a data pipeline scalable? Best practices for scalable design?
I have been searching about this topic for a few days and have not yet found anything on books, courses or tutorials.
What is a way to make data pipelines more scalable, that doesn't involve NoSql or ...
- 109
0
votes
1
answer
229
views
Does it make sense to have redundant DB fields to improve query performance, programming speed and code readability?
I am a bit torn about the database design for a solution. I have the following structure: (only the relevant fields are marked with #)
+------------------+
| activities |
|------------------|
| ...
- 129
1
vote
2
answers
293
views
How should I design a database where each user can have ten lists with thousands of possible entries?
I am trying to design a database where each user can save up to ten lists of cards. Each list could theoretically have tens of thousands of items, but will likely only have hundreds.
Should I create a ...
- 21
2
votes
3
answers
909
views
Product Codes in ERP: Alphanumeric vs Numeric
Background
I'm working through creating a structure for Items in a new ERP (Cloudsuite Industrial) that I'm implementing. For Items (which can be finished goods/products or raw materials), we ...
- 131
2
votes
1
answer
100
views
Techniques for handling large reporting periods in MSSQL
We have a fairly large database with some fairly large tables (100s of millions of rows). Some of those tables are reported on.
We have indexes in place to make this as fast as possible, but still ...
- 137
2
votes
2
answers
3k
views
Is it allowed to calculate the derived attributes by using other tables' attributes directly?
I tried to build a database for Driver Booking system. Here's brief details:
Drivers have several vehicles and they offers the driving service with them
Drivers will charge different hourly rates on ...
- 31
3
votes
1
answer
185
views
Designing the schema for a database of Spanish language words?
For a project I'm working on that will help people learn Spanish, I would like to create a standalone service to handle the retrieval of data about words. For this, I've captured and codified data ...
- 49
1
vote
2
answers
156
views
How to manage item locations in an inventory
I have to manage item locations and life cycle as a new requirement. I'm not familiar in warehousing/inventory/storage systems, so maybe my question is trivial.
The task:
We have original items that ...
- 147
1
vote
3
answers
183
views
Architecture/algorithm for unusual recommendation system
There are thousands (or tens of thousands) of possible movie titles.
New user enters my website and selects hundreds of titles that he likes.
The only single goal of my website is to output the list ...
- 121
0
votes
1
answer
638
views
Encoding of timestamps over cosmological time (64-bit linear vs 32-bit logarithmic)
I understand this is the place to ask questions pertaining to software design. If my question is considered to opinion-based, is there a forum or something better suited for the discussion?
...
- 119
1
vote
1
answer
134
views
Entity Relationship Model do I have to connect a table which is not using attributes from another table?
I tried creating an Entity-Relationship-Model, but I just don't get if I have to connect some tables and if I have to connect all, how do I connect tables which don't use attributes from another table....
- 111
3
votes
1
answer
935
views
Does a microservice's individual database need to have complete data?
Say you have a Users and Orders service and they have their own database.
Since microservices need to stand on their own even if another service is unavailable, does the Orders DB need to have all ...
- 343
1
vote
1
answer
160
views
Database structure for an app used to capture data in warehouses
I am in the process of creating an android app for our clients that would replace the paper-trail in their facilities with electronic inspections.
Although I have coding experience, I have little ...
- 11