| CARVIEW |
Select Language
HTTP/2 200
date: Sun, 27 Jul 2025 20:36:51 GMT
content-type: text/html; charset=utf-8
cf-ray: 965eee6d9dacc1b0-BLR
cf-cache-status: DYNAMIC
cache-control: private
set-cookie: prov=6cfdac1d-246a-4063-a8d2-497705ba0d02; expires=Mon, 27 Jul 2026 20:36:51 GMT; domain=.stackexchange.com; path=/; secure; httponly
strict-transport-security: max-age=31536000; includeSubDomains
vary: Accept-Encoding
content-security-policy: upgrade-insecure-requests; frame-ancestors 'self' https://stackexchange.com
x-clacks-overhead: GNU Terry Pratchett
x-frame-options: SAMEORIGIN
x-request-guid: c69eaba5-f79d-4476-abd6-14d0fdd2f2db
x-worker-origin-response-time: 415000000
x-dns-prefetch-control: off
set-cookie: prov=6cfdac1d-246a-4063-a8d2-497705ba0d02; Path=/; HttpOnly; Domain=stackexchange.com
set-cookie: __cf_bm=e_LDM_pn6bcQQrHDD1tMhkk1C1DRSZpPMKATXCatXoo-1753648611-1.0.1.1-9fbDJ1Pp5N8P_ZtqEN0EJ4sVvlkFq_o.IEwaesOD8HJB8AsgtD.qghgqWT2CfL6eSvUu2VuUjDsMCCBvOPH7IClrEZhN_WkTgl0DU7ScDVc; path=/; expires=Sun, 27-Jul-25 21:06:51 GMT; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
set-cookie: _cfuvid=mYbVNgOx2mGXibGh8ENSdTWzSd.Kl1QqCV2_X4g6rpU-1753648611888-0.0.1.1-604800000; path=/; domain=.stackexchange.com; HttpOnly; Secure; SameSite=None
server: cloudflare
content-encoding: gzip
Newest 'database-design' Questions - Software Engineering Stack Exchange
Skip to main content
Stack Exchange Network
Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about TeamsQuestions 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,347 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
112
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
134
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.
...
-1
votes
1
answer
52
views
Cassandra + ElasticSearch VS PostgreSQL or MySQL [closed]
Assuming we want to build a shop like Amazon with millions of products in dozens of different categories, where each category has its own specific properties but also shares some common properties, I ...
1
vote
2
answers
294
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, ...
3
votes
2
answers
129
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 ...
5
votes
3
answers
379
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
141
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 ...
1
vote
0
answers
176
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&...
0
votes
1
answer
144
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 ...
3
votes
3
answers
221
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 ...
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 ...
2
votes
2
answers
335
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 ...
2
votes
3
answers
355
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-...
1
vote
3
answers
220
views
How to implement an DB index to allow intersection queries on a database which does not support compound keys?
I am creating a DB that indexes JSONs on top of a key value storage engine (LMDB or somewhat similar).
When a new JSON needs to be indexed, I will create an entry for each field (AKA, JSON key), for ...
6
votes
9
answers
713
views
If services own their data, how do you deal with relations?
I've been studying different flavors of Service Oriented Architecture (SOA), Event-Driven Architecture (EDA), micro-services and related topics for the past few days.
I see it often recommended that ...
- The Overflow Blog
-
-
- Featured on Meta
-
-
-
Related Tags
database × 459
relational-database × 229
design × 141
sql × 132
mysql × 96
architecture × 88
design-patterns × 80
nosql × 65
data-structures × 64
postgres × 51
sql-server × 51
mongodb × 42
c# × 41
database-development × 38
normalization × 36
data-modeling × 34
web-applications × 32
java × 29
schema × 29
data × 25
php × 25
object-oriented × 22
api-design × 21
microservices × 21
more related tags
Hot Network Questions
- How should one pronounce plural French-derived German words?
- Balancing a Holy Water Bomb
- I don't have enough alive employees to start the day. What now?
- Easy ways to draw vector diagrams in TikZ?
- Interface boundary condition and displacement current between two media
- What Isp can be gotten from a napthalene (mothball) hot gas thruster? Did it work in space?
- I don't understand Photos Library.photoslibrary
- edge to curve endpoint move/transform to normal direction
- What were the two colored keys on a MUPID for?
- When was the last time all humans were on the ground not in the air?
- Is there such a thing as 'aerospace grade software'?
- How to extend an MDF shelf?
- Extensions of diagonalizable, respectively multiplicative-type, groups
- Dynamics from iterated averaging
- Will this work as an XOR gate?
- "I met a monk and philosopher." How many people did I meet?
- Are you required to protect trade secrets revealed to you even if you didn't sign an NDA?
- Were the Fantastic Four the only superheroes on Earth-828 in The Fantastic Four: First Steps?
- Class for validating code in different Conda environments with PyTorch
- Meaning of 芭蕉 in Tang age
- Algebraic independence of even polynomials
- Why aren't there baleen whales at about the size of a dolphin?
- Math bolder than surrounding text in footnotes
- Why is 0.0 printed as 0.00001 when rounding upward?