A relational database for bibliometric analysis

Mallig, Nicolai

doi:10.1016/j.joi.2010.06.007

Cited by 32 publications

(21 citation statements)

References 27 publications

(27 reference statements)

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…The topic of describing requirements and structural design of relational databases for bibliographic data has been addressed in detail in some previous works [44,45]. One of the most complete works in this direction is [33], where the author proposes a relational database [30] To investigate the factors and variables affecting a measure aggregation of measures by person or by institution, data transformation Multilevel models [21] To study how the indexes change over time aggregation of indices by person or by institution, selection of years Time series models [9] To study how the topics change over time extraction of topics, selection of years Dynamic topic models [4] T stands for Topic, J for Journal structure based on a detailed analysis of the main bibliometric indicators and the data required by each indicator in order to be calculated and stored. However, the work is not focused on the variability of the analysis dimensions and on the need of flexibly scaling data aggregation along an analysis dimension according to different aggregation criteria.…”

Section: Multidimensional Representation Of Textual Information and Tmentioning

confidence: 99%

“…In particular, the fundamental distinction between facts and objects makes it possible to easily derive some indicators by referring to a limited number of tables. As an example, in [33], the retrieval of the publications of authors working in the same institutions requires work on three tables, namely authorship, person, and affiliation. In relational terms, this means that two join operations are required.…”

Section: Multidimensional Representation Of Textual Information and Tmentioning

confidence: 99%

See 1 more Smart Citation

Ten challenges in modeling bibliographic data for bibliometric analysis

Ferrara

Salini

2012

Scientometrics

View full text Add to dashboard Cite

The complexity and variety of bibliographic data is growing, and efforts to define new methodologies and techniques for bibliometric analysis are intensifying. In this complex scenario, one of the most crucial issues is the quality of data and the capability of bibliometric analysis to cope with multiple data dimensions. Although the problem of enforcing a multidimensional approach to the analysis and management of bibliographic data is not new, a reference design pattern and a specific conceptual model for multidimensional analysis of bibliographic data are still missing. In this paper, we discuss ten of the most relevant challenges for bibliometric analysis when dealing with multidimensional data, and we propose a reference data model that, according to different goals, can help analysis designers and bibliographic experts in working with large collections of bibliographic data.

show abstract

Section: Multidimensional Representation Of Textual Information and Tmentioning

confidence: 99%

Section: Multidimensional Representation Of Textual Information and Tmentioning

confidence: 99%

Ten challenges in modeling bibliographic data for bibliometric analysis

Ferrara

Salini

2012

Scientometrics

View full text Add to dashboard Cite

show abstract

“…The reader interested in data processing with SQL applied to scientometrics is referred to (Wolfram 2006;Mallig 2010).…”

Section: Resultsmentioning

confidence: 99%

Experimenting with the partnership ability φ-index on a million computer scientists

Cabanac

2012

Scientometrics

View full text Add to dashboard Cite

OATAO is an open access repository that collects the work of Toulouse researchers and makes it freely available over the web where possible. This is an author-deposited version published in : http://oatao.univ-toulouse.fr/ Eprints ID : 12325 Any correspondance concerning this service should be sent to the repository administrator: staff-oatao@listes-diff.inp-toulouse.frExperimenting with the partnership ability u-index on a million computer scientists Guillaume Cabanac Abstract Schubert introduced the partnership ability u-index relying on a researcher's number of co-authors and collaboration rate. As a Hirsch-type index, u was expected to be consistent with Schubert-Glänzel's model of h-index. Schubert demonstrated this relationship with the 34 awardees of the Hevesy medal in the field of nuclear and radiochemistry (r 2 = 0.8484). In this paper, we upscale this study by testing the u-index on a million researchers in computer science. We found that the Schubert-Glänzel's model correlates with the million empirical u values (r 2 = 0.8695). In addition, machine learning through symbolic regression produces models whose accuracy does not exceed a 6.1 % gain (r 2 = 0.9227). These results suggest that the Schubert-Glänzel's model of u-index is accurate and robust on the domain-wide bibliographic dataset of computer science.

show abstract

“…Also, a Structured Query Language (SQL) code can be generated to create the database and its constraints. The ER model has also been used successfully in designing a relational database for bibliometric information [12]. The usefulness of the design scheme is experimentally proven by analyzing the execution of pregenerated SQL queries.…”

Section: Literature Reviewmentioning

confidence: 99%

Design and Analysis of a Relational Database for Behavioral Experiments Data Processing

et al. 2018

View full text Add to dashboard Cite

Abstract-This paper presents the results of a comparative analysis between different approaches to experimental data storage and processing. Several studies related to the problem and some methods for solving it have been discussed. Different types of databases, ways of using them and the areas of their application are analyzed. For the purposes of the study, a relational database for storing and analyzing specific data from behavioral experiments was designed. The methodology and conditions for conducting the experiments are described. Three different indicators are analyzed, respectively: memory required to store the data, time to load the data from an external file into computer memory and iteration time across all records through one cycle. The obtained results show that for storing a large number of records (in the order of tens of millions rows) either dynamic arrays (stored on external media in binary file format), or an approach based on a local or remote database management system can be used. Regarding the data loading time, the fastest approach was the one that uses dynamic arrays. It outperforms significantly the approaches based on a local or remote database. The obtained results show that the dynamic arrays and the local data sets approaches iterated much faster across all data records than the remote database approach.

show abstract

A relational database for bibliometric analysis

Cited by 32 publications

References 27 publications

Ten challenges in modeling bibliographic data for bibliometric analysis

Ten challenges in modeling bibliographic data for bibliometric analysis

Experimenting with the partnership ability φ-index on a million computer scientists

Design and Analysis of a Relational Database for Behavioral Experiments Data Processing

Contact Info

Product

Resources

About