Resources

From Open Source Software Research
Revision as of 23:57, 22 September 2008 by Mvanantw (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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

Data Warehouse Table Definitions

Deprecated Tables and Relations

  • Table "SCHEMA.audit_trail_group_data" - Deprecated, Dec. 2004
  • Table "SCHEMA.people_skill" - Deprecated, Nov. 2004
  • View "SCHEMA.artifact_file_user_vw" - Deprecated, Aug. 2005
  • View "SCHEMA.artifact_history_user_vw" - Deprecated, Aug. 2005
  • View "SCHEMA.artifactperm_artgrouplist_vw" - Deprecated, Aug. 2005
  • View "SCHEMA.artifactperm_user_vw" - Deprecated, Aug. 2005
  • Table "SCHEMA.audit_trail_group_data" - Deprecated, Dec. 2004
  • Table "SCHEMA.foundry_data" - Deprecated, Aug. 2005
  • Table "SCHEMA.foundry_news" - Deprecated, Aug. 2005
  • Table "SCHEMA.foundry_preferred_projects" - Deprecated, Aug. 2005
  • Table "SCHEMA.foundry_project_downloads_agg" - Deprecated, Aug. 2005
  • Table "SCHEMA.foundry_project_rankings_agg" - Deprecated, Aug. 2005
  • Table "SCHEMA.foundry_projects" - Deprecated, Aug. 2005
  • Table "SCHEMA.frs_dlstats_file_agg" - Deprecated, Aug. 2005
  • Table "SCHEMA.frs_dlstats_filetotal_agg" - Deprecated, Aug. 2005
  • Table "SCHEMA.frs_dlstats_group_agg" - Deprecated, Aug. 2005
  • Table "SCHEMA.frs_dlstats_grouptotal_agg" - Deprecated, Aug. 2005
  • Table "SCHEMA.groups_moorman" - Deprecated, Aug. 2005
  • Table "SCHEMA.pgstattuple_type" - Deprecated, Aug. 2005
  • Table "SCHEMA.project_metric" - Deprecated, Aug. 2005
  • Table "SCHEMA.project_weekly_metric" - Deprecated, Aug. 2005
  • Table "SCHEMA.search_data_groups" - Deprecated, Aug. 2005
  • Table "SCHEMA.stats_agg_logo_by_day" - Deprecated, Aug. 2005
  • Table "SCHEMA.stats_agg_logo_by_group" - Deprecated, Aug. 2005
  • Table "SCHEMA.stats_agg_pages_by_day" - Deprecated, Aug. 2005
  • Table "SCHEMA.stats_agg_site_by_group" - Deprecated, Aug. 2005
  • Table "SCHEMA.stats_ftp_downloads" - Deprecated, Aug. 2005
  • Table "SCHEMA.stats_http_downloads" - Deprecated, Aug. 2005
  • Table "SCHEMA.stats_project" - Deprecated, Aug. 2005
  • Table "SCHEMA.stats_project_developers" - Deprecated, Aug. 2005
  • Table "SCHEMA.stats_project_developers_last30" - Deprecated, Aug. 2005
  • Table "SCHEMA.stats_project_last_30" - Deprecated, Aug. 2005
  • Table "SCHEMA.stats_project_metric" - Deprecated, Aug. 2005
  • Table "SCHEMA.stats_project_months" - Deprecated, Aug. 2005
  • Table "SCHEMA.stats_site" - Deprecated, Aug. 2005
  • View "SCHEMA.stats_site_all" - Deprecated, Aug. 2005
  • Table "SCHEMA.stats_site_last_30" - Deprecated, Aug. 2005
  • Table "SCHEMA.stats_site_months" - Deprecated, Aug. 2005
  • Table "SCHEMA.stats_site_pages_by_day" - Deprecated, Aug. 2005
  • View "SCHEMA.stats_site_pages_by_month" - Deprecated, Aug. 2005
  • Table "SCHEMA.stats_subd_pages" - Deprecated, Aug. 2005
  • Table "SCHEMA.tsdebug" - Deprecated, Aug. 2005

(Not a comprehensive list)

SourceForge.net ER-Diagram

Schemas Currently Available

January 2003 (sf0103) - present

Schemas follow the format sfmmyy.

See the schema browser for detailed information on each schema and its tables.

See Schemas for a comprehensive list of all available schemas.

Related Links
About the OSSR Dataset | Making Queries | List of Schemas