warning: Creating default object from empty value in /var/www/drupal/modules/taxonomy/taxonomy.pages.inc on line 33.

email

LKML (email) study: data/paper available

We presented this paper at the 2016 OpenSym this week.

Schneider, D., Spurlock, S., and M. Squire. (2016). Differentiating Communication Patterns of Leaders on the Linux Kernel Mailing List. In Proceedings of the 12th International Symposium on Open Collaboration (OpenSym 2016).

Biblio
PDF
Slides (Google Docs)
Data Available (Torvalds & Kroah-Hartman emails, source code removed): data dump, request MySQL database access

What is the ratio of senders to messages in Alioth mailing lists? (07-2011)

Description

This graph shows the ratio of senders to email messages in Alioth project mailing lists.

Visualization:

The first number shown when hovering over a dot is the number of senders. The second number is the number of messages for each sender count.


SQL Script

SELECT mailing_list, COUNT(DISTINCT sender), COUNT(DISTINCT message_id)
FROM al_messages
GROUP BY mailing_list;

How many senders are there on mailing lists in Alioth projects? (07-2011)

Description

This graph shows the number of mailing lists with each count of email senders in Alioth.

Visualization:

The first number shown when hovering over a dot is the number of senders. The second number is the number of mailing lists with that sender count.



SQL Script

Use the results from the following query to create a temp table.

SELECT mailing_list AS List, COUNT(DISTINCT sender) AS Senders
FROM al_messages
GROUP BY List
ORDER BY Senders DESC;

Use the temp table for the following query.

SELECT sender_count AS Sender Count, COUNT(mailing_list) AS Frequency
FROM al_temp_table
GROUP BY Sender Count
ORDER BY Frequency DESC;

What time of the day is email communication highest in Alioth projects? (07-2011)

Description

This chart shows the hourly breakdown of email communication in select Alioth projects. The projects shown had the highest total number of emails in their mailing lists.

Visualization:



SQL Script

SELECT COUNT(m.message_id), hour(m.date_sent)
FROM al_messages m
INNER JOIN al_mailing_lists l
ON l.mailing_list = m.mailing_list
WHERE l.project = 'project_name'
AND l.datasource_id = <current>
GROUP BY HOUR(m.date_sent)

Syndicate content