a relational database for bibliometric analysis：一个关系数据库的文献计量分析.pdfVIP

Journal of Informetrics 4 (2010) 564–580 Contents lists available at ScienceDirect Journal of Informetrics j o u rn al h omepage: w w w. elsev /locate/joi A relational database for bibliometric analysis Nicolai Mallig Fraunhofer Institute for Systems and Innovation Research, Breslauer Straße 48, 76189 Karlsruhe, Germany a r t i c l e i n f o a b s t r a c t Article history: In this article a relational database schema for a bibliometric database is developed. After Received 22 December 2009 the introduction explaining the motivation to use relational databases in bibliometrics, Received in revised form 18 June 2010 an overview of the related literature is given. A review of typical bibliometric questions Accepted 21 June 2010 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. Keywords: Several SQL queries for the tasks presented in the requirement analysis show the usefulness Bibliometrics Relational database of the developed database schema. SQL © 2010 Elsevier Ltd. All rights reserved. 1. Introduction Nowadays a widespread use of bibliometric indicators can be observed. Probably the ease of using web-based bibliographical databases is boosting this trend. Unfortunately, there is some evidence that