Questions tagged [database-design]
For questions about structuring the data within a database. How to lay out tables, whether to use a relational DB or not, etc.
1,348 questions
0 votes
0 answers
58 views
How to handle period resets [closed]
So I have the following structure: Campaign <--many-to-many--> buyers Buyers --has Many--> resources I want users to be able to set a resource cap on a particular Buyer-Campaign pair, so ...
- 101
2 votes
0 answers
164 views
To Soft Delete or not to Soft Delete? [closed]
I’ve worked with database schemas that often had a soft delete field indicator in tables (such as deleted_at, invalidated, and so on) to keep track of the deletion status of records. It’s obvious that ...
- 193
1 vote
1 answer
146 views
Where should authentication data be stored in a modular monolith with multiple authentication strategies? (NestJS)
I’m implementing the authentication module in a modular monolith built with NestJS. Initial Draft In the first draft, the User entity included the hashed password, refresh token, and refresh token ...
- 114
0 votes
1 answer
172 views
Optimal way to avoid iterating through each row in a dictionary of data/arrays?
I have an excel macro that imports daily share price files, and finds the highest price for a share after a given date. Each of these daily stock price files has ~1000 rows of data. Currently I have ...
0 votes
2 answers
163 views
Designing a social media notification system, would a single table with JSON column be the correct approach for data?
I am trying to create a notification system similar to Instagram, for the lack of better comparasion. The Goal: Getting user notifications in a unify way, for easy unparsing and displaying to user. ...
- 101
1 vote
2 answers
386 views
Should you ever have one-to-one relationships between entities?
One-to-one relationships occasionally evolve into one-to-many relationships. Once that happens, your team has a tricky job of refactoring the datastore, the backend to allow that change. For example, ...
- 2,030
3 votes
2 answers
163 views
How to determine which service keeps the relation to the other?
Suppose I have (micro)services: The following is simplified a lot, you may assume they're significant enough to be a micro. Reseller Service - Our code is turned into whitelabel software. This is the ...
- 757
5 votes
3 answers
455 views
When is multiple validation layers of protection necessary?
I'm having a hard time of understanding at what point is multiple layers of validation protection necessary rather than a single point of failure and if the performance hit is a concern Lets say you ...
0 votes
1 answer
170 views
Reorganize data with pattern while migrating from SQL to MongoDB
I have several tables in Oracle, in each of them are stored data about a different kind of tax declaration (house tax, hotel tax, and so on). All of them have some data in common, so I want to migrate ...
- 531
1 vote
1 answer
259 views
System design for tracking viewed posts and returning unseen posts
I came across this system design question and have been wondering what is a good approach. Requirement : We have a typical blog or a mini social media kind of website where users create "Posts&...
- 154
1 vote
1 answer
174 views
How to Design a Database for Both Flexibility and Data Isolation?
I am designing a system that serves multiple customers, providing data visualization for revenue and membership information. Currently I use a separate schema approach to isolate customer data. Each ...
- 53
3 votes
3 answers
346 views
Aligning domain model to data model. Is my data representation wrong?
Engineering Community, I am currently writing my bachelor's thesis on microservices and DDD (this is not the actual topic, but it is part of it). The language I am writing in is Rust, but that is ...
- 39
21 votes
5 answers
4k views
How manage inventory discrepancies due to measurement errors in warehouse management systems
I'm developing an enterprise-grade warehouse management application for a chemistry laboratory. A critical feature involves mixing multiple stock solutions to create new solutions based on predefined ...
- 321
2 votes
2 answers
515 views
Best design pattern to synchronize local and cloud databases?
Right now I have an edge device (resource constrained) which is processing, storing, and querying time series data using a Postgres DB. When a data collection event has ended, a simple script on the ...
- 29
2 votes
3 answers
446 views
Should I break a large user table into smaller tables for specific roles and information?
I am designing a database for a system that has a users table. Currently, the table has around 50 columns, which include: Personal information (e.g. name, email, phone_number, address, etc.) Work-...
- 131