How many projects at each repository share URL's? (05-2011)

AttachmentSize
Image icon 05-11-url-to.png8.81 KB
Image icon 05-11-url-from.png15.12 KB

Description

This chart shows the number of projects at each repository that share URL's as of May 2011.

Visualization

URL-to

URL-from

SQL Script

RF-FM

SELECT COUNT( r.proj_unixname )
FROM rf_projects r
WHERE r.real_url LIKE "%freshmeat%"
AND datasource_id= <current>;

RF-OW

SELECT COUNT( r.proj_unixname )
FROM rf_projects r
WHERE r.real_url LIKE "%objectweb%"
AND datasource_id= <current>;

RF-FSF

SELECT COUNT( r.proj_unixname )
FROM rf_projects r
WHERE r.real_url LIKE "%fsf%"
AND datasource_id= <current>;

FM-RF

SELECT COUNT( f.project_id )
FROM fm_project_homepages f
WHERE f.real_url_homepage LIKE "%rubyforge%"
AND datasource_id= <current>;

FM-OW

SELECT COUNT( f.project_id )
FROM fm_project_homepages f
WHERE f.real_url_homepage LIKE "%objectweb%"
AND datasource_id= <current>;

FM-FSF

SELECT COUNT( f.project_id )
FROM fm_project_homepages f
WHERE f.real_url_homepage LIKE "%fsf%"
AND datasource_id= <current>;

OW-RF

SELECT COUNT( o.proj_unixname )
FROM ow_projects o
WHERE o.real_url LIKE "%rubyforge%"
AND datasource_id= <current>;

OW-FM

SELECT COUNT( o.proj_unixname )
FROM ow_projects o
WHERE o.real_url LIKE "%freshmeat%"
AND datasource_id= <current>;

OW-FSF

SELECT COUNT( o.proj_unixname )
FROM ow_projects o
WHERE o.real_url LIKE "%fsf%"
AND datasource_id= <current>;

FSF-RF

SELECT COUNT( proj_unixname )
FROM fsf_projects
WHERE real_url LIKE "%rubyforge%"
AND datasource_id= <current>;

FSF-FM

SELECT COUNT( proj_unixname )
FROM fsf_projects
WHERE real_url LIKE "%freshmeat%"
AND datasource_id= <current>;

FSF-OW

SELECT COUNT( proj_unixname )
FROM fsf_projects
WHERE real_url LIKE "%objectweb%"
AND datasource_id= <current>;

Data Resources: