Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 157 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

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 articles and data dumps, or the author has other private information that can only come from the horse mouth?

share|improve this question
The link appears to be broken. – scunliffe Mar 9 '14 at 4:39
up vote 8 down vote accepted

Yes to both. The author (Brent Ozar) did some work for the SO team and does have special knowledge of the real schema. However, this article specifically targets the monthly data dump.

share|improve this answer
"Special knowledge", I like that. I'm going to have to use that in my slide deck intros. "Ladies and gentlemen, I have Special Knowledge." ;-) – Brent Ozar Jan 21 '10 at 12:54
Oh, and yes, Joel's answer is right. The article just talks about the monthly data dump. When I wrote that article, I did get some of the field sizes from the actual database, but only so I could make sure the exports didn't overflow when I inserted 'em into a new database. The real database schema doesn't match up with the export. – Brent Ozar Jan 21 '10 at 12:56

Reading the article, it sounds like it's just talking about the public dumps. Following the 'data mining the so database' link leads to a description of downloading the dump.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .