I intend to analyze data derived from the user behavior on Stack Overflow (i.e. the number of questions asked in the last five years, upvotes, number of users common to "Android" and "iOS" dev environments, etc.). I have to use the data retrieved to create models depicting the manner in which these two technologies have grown over time. It would really help me if someone (who has prior experience with deriving data from Stack Exchange) could give some inputs on this.
-
1Do you have a specific question? Are you stuck with some part of the process? Try to add more detail so people can give you specific advice.– PekkaCommented Mar 5, 2013 at 21:16
-
5When it comes back online, you can get all your data from data.stackexchange.com, I'm sure.– Martijn PietersCommented Mar 5, 2013 at 21:16
-
2The box is back up and we're copying databases across the network now, ETA to it being usable again is about 30 min– Nick CraverCommented Mar 5, 2013 at 21:17
-
For starters, there doesn't seem to be any resource that I could use to get started with [link](data.stackexchange.com). I'm not at all aware of the underlying schema of this database and I suppose that I would have to query it to get the needed details. If you know of any online resource that I could use, I'd be obliged.– r2j2Commented Mar 5, 2013 at 21:19
-
1@r2j2 - the schema is listed on the right-hand side as part of the data explorer. Additionally, we are preparing a data dump based on that very data now...the hardware upgrade we just performed was partially for a fully automated data dump we try and provide on a regular basis...automating it should make it regular again.– Nick CraverCommented Mar 5, 2013 at 21:54
Add a comment
|
1 Answer
Here are some queries to get you started:
- The number of questions asked in the last five years
- upvotes
- number of users common to "Android" and "iOS" dev environments (415,220 at the time of posting)
More ready-made queries can be found in What SEDE examples would be most useful to new users?
The explanation of the schema can be found in Database schema documentation for the public data dump and SEDE and The Data Explorer as a FAQ for itself. The database is hosted in a SQL Server instance so you can use most of the T-SQL statements.
In this answer of mine you'll find an ERD model.
