IDEAS home Printed from
   My bibliography  Save this paper

A relational database for bibliometric analysis


  • Mallig, Nicolai


In this article a relational database schema for a bibliometric database is developed. After the introduction explaining the motivation to use relational databases in bibliome-trics, an overview of the related literature is given. A review of typical bibliometric ques-tions serves as an informal requirement analysis. The database schema is developed as an entity-relationship diagram using the structural information typically found in scientific articles. Several SQL queries for the tasks presented in the requirement analysis show the usefulness of the developed database schema.

Suggested Citation

  • Mallig, Nicolai, 2010. "A relational database for bibliometric analysis," Discussion Papers "Innovation Systems and Policy Analysis" 22, Fraunhofer Institute for Systems and Innovation Research (ISI).
  • Handle: RePEc:zbw:fisidp:22

    Download full text from publisher

    File URL:
    Download Restriction: no

    References listed on IDEAS

    1. Yu, Hairong & Davis, Mari & Wilson, Concepción S. & Cole, Fletcher T.H., 2008. "Object-relational data modelling for informetric databases," Journal of Informetrics, Elsevier, vol. 2(3), pages 240-251.
    Full references (including those not matched with items on IDEAS)


    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.

    Cited by:

    1. Cova, Tânia F.G.G. & Jarmelo, Susana & Formosinho, Sebastião J. & de Melo, J. Sérgio Seixas & Pais, Alberto A.C.C., 2015. "Unsupervised characterization of research institutions with task-force estimation," Journal of Informetrics, Elsevier, vol. 9(1), pages 59-68.
    2. Gagolewski, Marek, 2011. "Bibliometric impact assessment with R and the CITAN package," Journal of Informetrics, Elsevier, vol. 5(4), pages 678-692.
    3. repec:spr:scient:v:95:y:2013:i:3:d:10.1007_s11192-013-0965-0 is not listed on IDEAS
    4. Guillaume Cabanac, 2012. "Shaping the landscape of research in information systems from the perspective of editorial boards: A scientometric study of 77 leading journals," Journal of the Association for Information Science & Technology, Association for Information Science & Technology, vol. 63(5), pages 977-996, May.
    5. Sicilia, Miguel-Angel & Sánchez-Alonso, Salvador & García-Barriocanal, Elena, 2011. "Comparing impact factors from two different citation databases: The case of Computer Science," Journal of Informetrics, Elsevier, vol. 5(4), pages 698-704.
    6. repec:spr:scient:v:93:y:2012:i:3:d:10.1007_s11192-012-0810-x is not listed on IDEAS
    7. repec:spr:scient:v:93:y:2012:i:3:d:10.1007_s11192-012-0732-7 is not listed on IDEAS
    8. repec:spr:scient:v:96:y:2013:i:1:d:10.1007_s11192-012-0862-y is not listed on IDEAS
    9. Magnone, Edoardo, 2013. "A scientometric look at calendar events," Journal of Informetrics, Elsevier, vol. 7(1), pages 101-108.

    More about this item


    bibliometrics; relational database; SQL;

    NEP fields

    This paper has been announced in the following NEP Reports:


    Access and download statistics


    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:zbw:fisidp:22. See general information about how to correct material in RePEc.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: (ZBW - German National Library of Economics). General contact details of provider: .

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service hosted by the Research Division of the Federal Reserve Bank of St. Louis . RePEc uses bibliographic data supplied by the respective publishers.