IDEAS home Printed from https://ideas.repec.org/p/zbw/fisidp/22.html
   My bibliography  Save this paper

A relational database for bibliometric analysis

Author

Listed:
  • Mallig, Nicolai

Abstract

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
    as

    Download full text from publisher

    File URL: https://www.econstor.eu/bitstream/10419/30165/1/619833866.pdf
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Marianne Gauffriau & Peder Olesen Larsen & Isabelle Maye & Anne Roulin-Perriard & Markus Ins, 2007. "Publication, cooperation and productivity measures in scientific research," Scientometrics, Springer;Akadémiai Kiadó, vol. 73(2), pages 175-214, November.
    2. Philip M. Davis & Michael J. Fromerth, 2007. "Does the arXiv lead to higher citations and reduced publisher downloads for mathematics articles?," Scientometrics, Springer;Akadémiai Kiadó, vol. 71(2), pages 203-215, May.
    3. William W. Hood & Concepción S. Wilson, 2003. "Informetric studies using databases: Opportunities and challenges," Scientometrics, Springer;Akadémiai Kiadó, vol. 58(3), pages 587-608, November.
    4. 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.
    5. Werner Marx & Hermann Schier & Michael Wanitschek, 2001. "Citation analysis using online databases: Feasibilities and shortcomings," Scientometrics, Springer;Akadémiai Kiadó, vol. 52(1), pages 59-82, September.
    6. Christoph Neuhaus & Andreas Litscher & Hans-Dieter Daniel, 2007. "Using scripts to streamline citation analysis on STN International," Scientometrics, Springer;Akadémiai Kiadó, vol. 71(1), pages 145-150, April.
    7. Linda Butler & Martijn S. Visser, 2006. "Extending citation analysis to non-source items," Scientometrics, Springer;Akadémiai Kiadó, vol. 66(2), pages 327-343, February.
    8. Anthony F. J. van Raan, 2005. "Fatal attraction: Conceptual and methodological problems in the ranking of universities by bibliometric methods," Scientometrics, Springer;Akadémiai Kiadó, vol. 62(1), pages 133-143, January.
    9. Peder Olesen Larsen, 2008. "The state of the art in publication counting," Scientometrics, Springer;Akadémiai Kiadó, vol. 77(2), pages 235-251, November.
    10. Dietmar Wolfram, 2006. "Applications of SQL for informetric frequency distribution processing," Scientometrics, Springer;Akadémiai Kiadó, vol. 67(2), pages 301-313, May.
    Full references (including those not matched with items on IDEAS)

    Citations

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


    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. Alfio Ferrara & Silvia Salini, 2012. "Ten challenges in modeling bibliographic data for bibliometric analysis," Scientometrics, Springer;Akadémiai Kiadó, vol. 93(3), pages 765-785, December.
    4. Magnone, Edoardo, 2013. "A scientometric look at calendar events," Journal of Informetrics, Elsevier, vol. 7(1), pages 101-108.
    5. Fernanda Morillo & Ignacio Santabárbara & Javier Aparicio, 2013. "The automatic normalisation challenge: detailed addresses identification," Scientometrics, Springer;Akadémiai Kiadó, vol. 95(3), pages 953-966, June.
    6. 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.
    7. 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.
    8. 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 American Society for Information Science and Technology, Association for Information Science & Technology, vol. 63(5), pages 977-996, May.
    9. Carolin Michels & Ulrich Schmoch, 2012. "The growth of science and database coverage," Scientometrics, Springer;Akadémiai Kiadó, vol. 93(3), pages 831-846, December.
    10. Guillaume Cabanac, 2013. "Experimenting with the partnership ability φ-index on a million computer scientists," Scientometrics, Springer;Akadémiai Kiadó, vol. 96(1), pages 1-9, July.
    11. Gelsomina Catalano & Gaston García López & Alejandro Sánchez & Silvia Vignetti, 2021. "From scientific experiments to innovation: Impact pathways of a Synchrotron Light Facility," Annals of Public and Cooperative Economics, Wiley Blackwell, vol. 92(3), pages 447-472, September.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Mallig, Nicolai, 2010. "A relational database for bibliometric analysis," Journal of Informetrics, Elsevier, vol. 4(4), pages 564-580.
    2. Bar-Ilan, Judit, 2008. "Informetrics at the beginning of the 21st century—A review," Journal of Informetrics, Elsevier, vol. 2(1), pages 1-52.
    3. Mehdi Rhaiem & Nabil Amara, 2020. "Determinants of research efficiency in Canadian business schools: evidence from scholar-level data," Scientometrics, Springer;Akadémiai Kiadó, vol. 125(1), pages 53-99, October.
    4. Fernanda Morillo & Ignacio Santabárbara & Javier Aparicio, 2013. "The automatic normalisation challenge: detailed addresses identification," Scientometrics, Springer;Akadémiai Kiadó, vol. 95(3), pages 953-966, June.
    5. Christoph Neuhaus & Andreas Litscher & Hans-Dieter Daniel, 2007. "Using scripts to streamline citation analysis on STN International," Scientometrics, Springer;Akadémiai Kiadó, vol. 71(1), pages 145-150, April.
    6. Peter Ingwersen & Birger Larsen, 2014. "Influence of a performance indicator on Danish research production and citation impact 2000–12," Scientometrics, Springer;Akadémiai Kiadó, vol. 101(2), pages 1325-1344, November.
    7. Fredrik Niclas Piro & Dag W. Aksnes & Kristoffer Rørstad, 2013. "A macro analysis of productivity differences across fields: Challenges in the measurement of scientific publishing," Journal of the Association for Information Science & Technology, Association for Information Science & Technology, vol. 64(2), pages 307-320, February.
    8. Pascal Cuxac & Jean-Charles Lamirel & Valerie Bonvallot, 2013. "Efficient supervised and semi-supervised approaches for affiliations disambiguation," Scientometrics, Springer;Akadémiai Kiadó, vol. 97(1), pages 47-58, October.
    9. Oguz K. Baskurt, 2011. "Time series analysis of publication counts of a university: what are the implications?," Scientometrics, Springer;Akadémiai Kiadó, vol. 86(3), pages 645-656, March.
    10. Carmen Galvez & Félix Moya-Anegón, 2007. "Standardizing formats of corporate source data," Scientometrics, Springer;Akadémiai Kiadó, vol. 70(1), pages 3-26, January.
    11. Zehra Taşkın & Umut Al, 2014. "Standardization problem of author affiliations in citation indexes," Scientometrics, Springer;Akadémiai Kiadó, vol. 98(1), pages 347-368, January.
    12. Sjoerd Hardeman, 2013. "Organization level research in scientometrics: a plea for an explicit pragmatic approach," Scientometrics, Springer;Akadémiai Kiadó, vol. 94(3), pages 1175-1194, March.
    13. Alfio Ferrara & Silvia Salini, 2012. "Ten challenges in modeling bibliographic data for bibliometric analysis," Scientometrics, Springer;Akadémiai Kiadó, vol. 93(3), pages 765-785, December.
    14. Fernanda Morillo & Javier Aparicio & Borja González-Albo & Luz Moreno, 2013. "Towards the automation of address identification," Scientometrics, Springer;Akadémiai Kiadó, vol. 94(1), pages 207-224, January.
    15. Waltman, Ludo & van Eck, Nees Jan, 2015. "Field-normalized citation impact indicators and the choice of an appropriate counting method," Journal of Informetrics, Elsevier, vol. 9(4), pages 872-894.
    16. Gauffriau, Marianne, 2017. "A categorization of arguments for counting methods for publication and citation indicators," Journal of Informetrics, Elsevier, vol. 11(3), pages 672-684.
    17. Rabishankar Giri & Sabuj Kumar Chaudhuri, 2021. "Ranking journals through the lens of active visibility," Scientometrics, Springer;Akadémiai Kiadó, vol. 126(3), pages 2189-2208, March.
    18. Domingo Docampo & Lawrence Cram, 2019. "Highly cited researchers: a moving target," Scientometrics, Springer;Akadémiai Kiadó, vol. 118(3), pages 1011-1025, March.
    19. de Oliveira, Thaiane Moreira & de Albuquerque, Sofia & Toth, Janderson Pereira & Bello, Debora Zava, 2018. "International cooperation networks of the BRICS bloc," SocArXiv b6x43, Center for Open Science.
    20. Daraio, Cinzia & Bonaccorsi, Andrea & Simar, Léopold, 2015. "Rankings and university performance: A conditional multidimensional approach," European Journal of Operational Research, Elsevier, vol. 244(3), pages 918-930.

    Corrections

    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.

    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 bibliographic 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.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: ZBW - Leibniz Information Centre for Economics (email available below). General contact details of provider: https://edirc.repec.org/data/isfhgde.html .

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

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.