Stack Exchange Network

Stack Exchange network consists of 174 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

Questions tagged [database-design]

The tag has no usage guidance.

0
votes
1answer
46 views

Where To Ask - Informal Question About A Database

I know about the DBA Stack Exchange, but I want to know if my specific question is too simple to ask there. I want to know how to deal with a record storing an ID pointing to a list of items (that ...
2
votes
1answer
85 views

Does Stack Exchange use event sourcing?

This is a more technical question. I just found that I can browse the history of all my actions. Does Stack Exchange use event sourcing and store all my actions in the database? I wonder if CQRS is ...
3
votes
1answer
90 views

How does a post end up in the review queue?

I've read about Review Tasks here and examined the tables here. My questions are: What kinds of posts get to the review table? (E.g., questions, answers,..) What is the qualifying factor? Who/what ...
0
votes
0answers
58 views

Would SE communities Database perform better under MongoDB?

The EER Model of SE communities has lots of denormalisation rules, which is why I ask if the queries would perform better under MongoDB using the exact same model? What would be the things to ...
8
votes
1answer
445 views

Why does Stack Exchange use separate databases for each network site?

There are reasonable reasons for why separate sites are appropriate for Stack Exchange according to what it aims to be, and some of them are discussed here : Why is Stack Exchange split into multiple ...
3
votes
0answers
148 views

Where are the user's notifications stored?

Looking at the Stackoverflow's DB architecture, I wonder where does each user's notification get stored? For instance, someone answers a post I created, I am notified about it thanks to the top-bar ...
3
votes
1answer
187 views

Does Stack Overflow use EventSourcing to keep tracking of each change on a post edit?

I'm curious to know how does Stack Overflow store the revisions/versions of each post edition in the database? Does it represent each edition version in the database, following the Temporal Pattern? ...
19
votes
0answers
157 views

Data Explorer execution plans are no longer available because SHOWPLAN permission is denied [closed]

I noticed after a recent maintenance downtime that now I get the following message when trying to include an execution plan with a query: SHOWPLAN permission denied in database 'StackOverflow'. Was ...
4
votes
0answers
213 views

How are votes calculated on Stack Overflow

As far as I understand SO keeps votes in a separate table and calculates the post votes based on that data. So DB query can look like this assuming votes can be 1/-1. SELECT SUM(value) FROM votes ...
0
votes
1answer
106 views

Can we ask for reviews of data models or ER diagrams on Stack Overflow?

Is it OK to ask questions concerning the data model of a specific system on Stack Overflow?
7
votes
1answer
124 views

How does Stack Overflow find 'Linked' questions?

How does Stack Overflow find 'Linked' questions? Does it store a list of links somewhere in the DB? Or does it extract them from posts/comments dynamically?
14
votes
1answer
6k views

Stack Overflow database model

I'm currently involved in a project to design and implement an in-house question-and-answer community for our university. We've explored some open source frameworks such as OSQA, but we are also ...
2
votes
0answers
55 views

How are network site user profiles linked?

This is a technical question aimed at the Stack Exchange developers I'm wondering about the database storage of each Stack Exchange site. Is each site stored in it's own database? Mainly however, ...
0
votes
2answers
107 views

How can SO figure out the last active user on a post?

Does SO store post activity in a table? I'm asking because I notice, on the main page, the owner of the last activity is listed instead of the owner of the question. The posts table, as far as I can ...
6
votes
1answer
198 views

How does SO store revisions?

How does SO store its revisions in the database? Does it use diffs? If so, what algo does it use?
11
votes
1answer
923 views

The Real SO Database Schema (Not Public Dump)

Is there any way (or real chance) to see the real SO database schema (not public dump)? I'm curious on how SO manages to scale so well. Does it use multiple databases? Or any kind of sharding ...
1
vote
2answers
752 views

The Article “Understanding the StackOverflow Database Schema”— Is it An Officially Sanctioned Article?

I found that there is an article entitled Understanding the StackOverflow Database Schema, I wonder how and where did the author get the source of information? Is it from public SO blog posts and ...
2
votes
1answer
380 views

Why did Stack Overflow put questions and answers in the same database table? [duplicate]

Possible Duplicate: Why does SO store questions and answers in the same table? I took a look at SO's HTML. I noticed that the ID number of a given question was very close to its answers' ID ...
37
votes
3answers
2k views

Stack Overflow database design join issues

There are many questions already on meta-stackoverflow regarding the database schema, but here is another, that I don't think is a duplicate, so please read on. I read a description of the schema ...