OSS Snapshots

From Open Source Software Research
Jump to: navigation, search
Top Links
• Query the Archive
• Schema Browser
• Research Data
• Making Queries
• Resources
• Papers
• Contact
• FAQ
• Schemas
• All tables
• Finding data
• ER diagrams

Creating snapshots from OSS project database schemas

Sample Output for sf0106 which shows the number of developers on p projects:

 num_proj_per_user | num_users
-------------------+-----------
                 1 |    136480
                 2 |     27322
                 3 |      9234
                 4 |      3893
                 5 |      1834
                 6 |       977
                 7 |       596
                 8 |       331
                 9 |       226
                10 |       122
                11 |        76
                12 |        55
                13 |        31
                14 |        29
                15 |        19
                16 |        18
                17 |        15
                18 |         9
                19 |        12
                20 |         3
                21 |         7
                22 |         2
                23 |         2
                24 |         1
                25 |         1
                27 |         2
                31 |         1
                32 |         2
                34 |         1
                35 |         1
                52 |         1
(31 rows)

Query using SRDA query interface

  • For the number of developers on P projects:
SELECT:
np, COUNT(user_id)
FROM:
(SELECT user_id, COUNT(group_id) AS np from schema.user_group GROUP BY user_id) as t GROUP BY t.np ORDER BY np
  • this should give you results like the following:
1:118573:
2:22215:
3:7078:
4:2761:
5:1348:
6:692:
7:362:
8:203:
9:130:
10:75:
11:50:
12:27:
13:26:
14:16:
15:11:
16:10:
17:11:
18:9:
19:8:
20:1:
21:2:
23:2:
24:1:
28:2:
31:1:
34:1:
50:1:

where the first column represents the number of projects per developer while the second column is the number of developers


Related Links
Making Queries | Sample DataSet Snapshots