MLS - Variables database

Variables from Mailing Lists diagram:

 MLS variables diagram

Tables description

All the fields of these tables are also described in a socio-economic context in MLS_COMBINED__METRICS

The next table summarises the different tables available for the current version of this database.

Table name Metric description Type
agg_authors_per_time Aggregated number of authors per unit of time authors
agg_authors_per_time Aggregated number of authors per unit of time authors
agg_messages_per_author_per_time Aggregated number of messages per author and per unit of time messages_authors
agg_messages_per_time Aggregated number of messages up to time messages
agg_replies_per_author_per_time Aggregated number of replies per author and per unit of time messages_authors
authors_per_time Number of distinct authors per unit of time authors
avg_messages_per_author_over_all Average number of messages per author over all authors messages_authors
avg_replies_per_author_over_all Average number of replies per author over all authors messages_authors
max_messages_per_author_over_all Maximum number of messages per author over all authors messages_authors
max_replies_per_author_over_all Maximum number of replies per author over all authors messages_authors
messages_per_author Total number of messages per author messages_authors
messages_per_author_per_time Number of messages per author and per unit of time messages_authors
messages_per_time Number of messages per unit of time messages
min_messages_per_author_over_all Minimum number of messages per author over all authors messages_authors
min_replies_per_author_over_all Minimum number of replies per author over all authors messages_authors
new_authors_per_time Number of new authors per unit of time authors
replies_per_author Total of number of replies per author messages-authors
replies_per_author_per_time Number of replies per author and per unit of time messages-authors
mls_summary Minimum number of new authors per unit of time authors
mls_summary Average number of new authors per unit of time authors
mls_summary Total number messages messages
mls_summary Maximum number of messages per unit of time messages
mls_summary Minimum message size messages
mls_summary Maximum message size messages
mls_summary Maximum number of distinct authors per unit of time authors
mls_summary Average message size messages
mls_summary Total number of threads threads
mls_summary Total number of distinct authors authors
mls_summary Average number of messages per unit of time messages
mls_summary Maximum number of new authors per unit of time authors
mls_summary Minimum number of new authors per unit of time messages
mls_summary Average number of distinct authors per unit of time authors
mls_summary Minimum number of distinct authors per unit of time authors
 
variables_database_for_mls.txt · Last modified: 2009/12/10 19:44 by matinte
 
Except where otherwise noted, content on this wiki is licensed under the following license:CC Attribution-Share Alike 3.0 Unported
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki