Skip to content
Branch: master
Go to file
Code

README.md

OSCI Logo

OSCI, the Open Source Contributor Index

NEWS UPDATE (July 6th 2020)

The OSCI ranking has now been updated with the data for June 2020. This month we added a further 24 companies to our analysis, and this resulted in 2 new companies appearing in the top 100 - Dell and Rockchip.

The latest ranking can be viewed on the EPAM SolutionsHub OSCI page. Alternatively the updated ranking can be downloaded (Excel format) from our Archive folder: 2020.06 OSCI Ranking.xlsx.

We also updated the OSCI 2016-2019 Deep Dive to add the trends we observe in Q1 2020.

What is OSCI?

  • OSCI ranks corporate contributions to open source based on the organization’s number of Active Contributors to GitHub
  • OSCI also tracks the Total Community of open source contributors for these companies
  • The OSCI rankings are published monthly to dynamically track corporate contributions to GitHub. The latest result can be found at EPAM SolutionsHub website's OSCI page

How does OSCI work?

  • OSCI analyses push event data from GH Archive
  • The Author Email address field in the commit event data is used to identify the organization to which the commit author belongs
  • OSCI measures the Active Community (10+ commits) and the Total Community (1+ commit) at each organization
  • Analysis is done for the current year-to-date
  • OSCI’s algorithm is transparently published as an open source project on GitHub

GitHub OSCI Schematic Diagram

How did we decide on the ranking logic?

We realize that there are many approaches which could be used to develop this ranking. We experimented extensively with these before arriving at the logic now used.

We concluded the Author's Email Domain in the Push Event data is the most reliable way to identify the organization to which a commit author belongs. It is a single unambiguous identifier. It is true that many people on GitHub do not use the email address of their employer or keep it private, but it is still a more reliable single measure compared with alternatives. The org of the repo is not a good measure of the employer of an individual because the employees of most companies maintain projects in multiple GitHub orgs.

We concluded that 10+ commits in a year - while arbitrary - is a reasonable measure of whether a person is an active contributor to GitHub. It is interesting to compare this with the size of the broader community at an organization - this is why we also record the number of people with just 1 or more commits in the time period.

We decided to base the ranking on the number of people making commits, rather than the number of commits. The GitHub push event data includes large numbers of pushes made by automated processes using an email domain from an organization. Counting the number of pushes is not a good measure of the community at an organization, when the results are considerably skewed by these automated processes.

Our technical design assessed multiple source of data and we concluded that GHArchive is best suited for our needs, based on ease of access to the data, the amount of data it records, and the size of the data. GHTorrent is also very interesting for future use, since it contains a richer set of data, however the data sizes are considerably larger which drove our decision to go with GHArchive.

What does OSCI not do?

OSCI does not include educational and research institutions, contributions from free email providers, etc. The focus is on commercial organizations.

Prior work in this area

Our inspiration for OSCI is the work done earlier in the Open Source community, so we wish to give credit to these:

Where can I see the latest rankings

This project is created by EPAM Systems and the latest results are visible on the EPAM SolutionsHub OSCI page. The results will be updated and published each month.

How I can contribute to OSCI

If you would like to contribute to OSCI, please take a look at our guidelines here.

What if your think your organization is missing or you believe there is an error in our logic

This is a new project. We are more than happy to listen to any feedback which will help us improve. Contact us at OSCI@epam.com or modify the companies filter yourself.

How can I add a company which is missing from the OSCI ranking

The goal of the OSCI is to rank the GitHub contributions by companies (commercial organizations).

In order to add a company to the OSCI ranking, do the following:

  1. Check whether the organization you propose to add matches our definition of a company:
  • is not an educational, governmental, non-profit or research institution;
  • is not a free-mail, like gmail.com, yahoo.com, hotmail.com, etc;
  • is a registered, commercial company;
  • a simple "rule of thumb" - does the organization's website sell a product or service? If not, it is probably not a company by our definition.
  1. Create a new pull request.

  2. Go to https://github.com/epam/OSCI/blob/master/SQL_queries/service_queries/create_empty_tables.sql

  3. Confirm that the company you wish to add is not listed.

  4. Add the main domain of the company and the company name to the table. For example:

      ('Facebook', 'fb.com')  
    
  5. Go to https://github.com/epam/OSCI/blob/master/SQL_queries/service_queries/create_filtered_table.sql

  6. Add the company email domain in the end of the first table.

      AuthorMailDomain = 'fb.com'
    
  7. If the company has more than 1 email domain for its employees, add all of them (or at least those you are aware of). For example:

      AuthorMailDomain = 'fb.com' or AuthorMailDomain like 'facebook.com' or AuthorMailDomain = '%.facebook.com' or AuthorMailDomain = 'facebook.%'
    
  8. If the company has more than 1 domain in the company, add the main one to the mapping in the end of the table. For example:

      update AllCommits set AuthorMailDomain = 'fb.com' where AuthorMailDomain = 'facebook.com' or AuthorMailDomain = '%.facebook.com' or AuthorMailDomain = 'facebook.%'
    

We will review your pull request and if it matches our requirements, we will merge it.

Technical Note

We built OSCI this an Azure cloud environment using Azure SQL Server. The code published here on GitHub does not require the Azure cloud, however in the current version MS SQL Server is required. Our future plans include support for an open source database.

Instructions for using the OSCI code

These scripts are for downloading data from gharchive.org, processing and loading to the SQL Server.

  1. Install MS SQL Server.

  2. Create a file local.yml (by default this file added to .gitignore) in the directory configs. A sample file default.yml is included, please don't change values in this file

  3. Fill fields "year" and "month" in function "get_month_data('year', 'month')" in the file file_loader.py if you want to load data for a specific month. Use get_year('year') for loading data for whole year. For example:

     get_month_data('2019', '05')
     
     get_year('2019')
    

    If necessary, repeat this function for other months or years.

  4. Finally run script file_loader.py and wait for successful script execution. It can take some time to download and transform the data.

Once the data is prepared, you can generate reports as shown below. The reports will be generated on all the downloaded data in the AllCommits table. So to make a report for 2019 - for example - download all the 2019 data as described above.

top_employees_combined.sql - the top 50 companies ordered by employees with 10+ commits and also showing count of employees with 1+ commit. 
top_commits_ranking.sql - the count of commits per company.

License

OSCI is GNU General Public License v3.0.

About

Open Source Contributor Index

Resources

License

Releases

No releases published
You can’t perform that action at this time.