organize downloads of Scopus data into relational database management

Loet Leydesdorff loet at LEYDESDORFF.NET
Mon Aug 19 06:32:10 EDT 2013


Dear colleagues,

 

Scopus.exe <http://www.leydesdorff.net/scopus/scopus.exe>  enables one to
organize a file which is exported from Elsevier's Scopus database in the
format "RIS format (Reference Manager, ProCite, Endnote". The program
assumes an input file with the name "scopus.ris". (If you wish to combine
more than a single search, cut and paste the different outputs together, and
name the result "scopus.ris". ) 

 

The output is the organization of this information in files which allow for
relational database management (e.g., MS Access) or separate analysis as
spread-sheets. These files (AU.dbf; CS.dbf; CR.dbf; TI.dbf) are in the
dBase-format. Additionally, a file with the abstracts (abstract.txt) and
relational numbers is provided in ASCII format. The output is similar to
that of ISI.exe  <http://www.leydesdorff.net/software/isi/index.htm> for the
Science Citation Index at the Web-of-Science (WoS). (A number of other
programs for social and semantic network analysis available at
http://www.leydesdorff.net/indicators can use these files for further
processing (see below). 

 

ADVANTAGES: 

a.      Using au.dbf, for example, one can easily generate a co-authorship
network; 

b.      Using cs.dbf a network of international collaborations can be
constructed;

c.      The field TI in Ti.dbf can be used for semantic mapping by using,
for example, ti.exe <http://www.leydesdorff.net/software/ti> . 
See: Pajek Manual:
<http://www.leydesdorff.net/indicators/pajekmanual.2010.pdf> How to analyze
frames using semantic maps of a collection of messages?

d.      Using abstract.txt one can draw the semantic maps for the abstract
words using fulltext.exe <http://www.leydesdorff.net/software/fulltext> ;

e.      Citation analysis for evaluative purposes (e.g., in terms of
percentiles) can be based on the field TC in Ti.dbf;

f.       Differently from WoS, the citations in CR.dbf contain the titles
and all coauthors (and thus the file is suited for semantic and coauthor
mapping).

g.      A field "rpy" is added to CR.dbf for the purpose of
<http://www.leydesdorff.net/software/rpys/index.htm> "referenced publication
years spectography" (RPYS).

 

The current version is in the development phase. Please, feel free to
feedback with suggestions for improvements. I intend to develop further
interfaces between the Scopus data and other routines.

 

Loet 

 

** apologies for cross-postings

 

  _____  

Loet Leydesdorff 

Professor, University of Amsterdam
Amsterdam School of Communications Research (ASCoR)

Kloveniersburgwal 48, 1012 CX Amsterdam
 <mailto:loet at leydesdorff.net> loet at leydesdorff.net ;
<http://www.leydesdorff.net/> http://www.leydesdorff.net/ 
Honorary Professor,  <http://www.sussex.ac.uk/spru/> SPRU, University of
Sussex; Visiting Professor,  <http://www.istic.ac.cn/Eng/brief_en.html>
ISTIC, Beijing;
 <http://scholar.google.com/citations?user=ych9gNYAAAAJ&hl=en>
http://scholar.google.com/citations?user=ych9gNYAAAAJ&hl=en  



 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.asis.org/pipermail/sigmetrics/attachments/20130819/0f2df6d2/attachment.html>


More information about the SIGMETRICS mailing list