Rank Authors by # of Articles Written

Help
Medblue
2008-05-24
2013-05-28
  • Medblue
    Medblue
    2008-05-24

    We just installed RefBase (previously loyal to EndNote and Reference Manager).

    In RefBase, are we able to rank authors by the number of articles written?

    So, for example, in our list of references, let's say Bob wrote 10 articles, Tina 2 articles, Mark 7 articles, and Sherry 1 article. So, a search that ranked authors by the number of articles written would produce a list of references in the following order from highest to lowest....

    Bob
    Mark
    Tina
    Sherry

    Any help is appreciated.

    Thanks!

    CG

     
    • Hi,

      > are we able to rank authors by the number of articles written?

      AFAIK, this is currently not possible, sorry.

      There is an unfinished feature (called "Browse view") which would let you browse your reference database by a chosen field, and list only distinct values from this field ranked by number of occurrence. Here's an example for the 'type' field:

      http://beta.refbase.net/show.php?submit=Browse&by=type

      You can enable this feature for a given user (in this example, the user with user ID=2) by issuing following SQL query (when logged in as admin, or from the SQL command line prompt):

      UPDATE user_permissions SET allow_browse_view = "yes" WHERE user_id = 2;

      To play with this, you could also login as admin at:

      http://beta.refbase.net/

      where I've (temporarily) enabled the feature. See the links under "Browse all database entries by" on the main page.

      That all being said, it won't yet work for the 'author' field (or any other field that has sub-items such as the 'keywords' field), since the field contents aren't yet splitted into sub-items. Here's a (not yet really working) example for the 'author' field:

      http://beta.refbase.net/show.php?submit=Browse&by=author

      Also, you'd rather like to see a ranked list of citations instead, right?

      Maybe you could generate a custom table for statistics, and include it as a JOIN (with a GROUP BY clause) when doing your refbase query. But I need to think about this more.

      Matthias

       
    • Medblue
      Medblue
      2008-05-26

      > Also, you'd rather like to see a ranked list of citations instead, right?
      Correct -- a ranked list of citations.

      Perhaps a little background will help you see why this type of ranking might be helpful...

      We see a lot of patients with very rare diseases. Often we need to identify a medical expert who can help with diagnosis and treatment. After completing a literature search on the specific disease, we like to see which authors have written the most on the topic. Thus, we need to rank the authors by the number of articles that they have written. We typically take the top 3 experts (based on how much they have written) and contact them.

      Because the diseases that we see are so rare, very few publications are identified initially. Thus, we have to expand the scope of the search and this leads to a lot of results. For example, there are few articles on the neurological complications of complex III cytochrome disorders in children. So, in order to identify more articles (and potential experts) we would expand this search to find articles on the neurological complications of inherited metabolic disorders. This is where the ability to rank the authors by the number of articles written is key.

      CG