`ImportDB.wos` imports tables from remote DataBase Management System (DBMS)...

ImportDB.wos(dbname, label = dbname, drv = RSQLite::SQLite(), ...)

Arguments

dbname

The path to the database file.

label

character string describing the data.

drv

DBMS driver (e.g., `RSQLite()`, `MySQL()`, `PostgreSQL()`...)

...

authentication arguments needed by the DBMS instance; these typically include `user`, `password`, `host`, `port`, etc. For details see the appropriate DBIDriver.

Value

An S3 object of class

wos.db. A list with the folowing data.frames:

Docs

Authors AutDoc Categories CatDoc Areas AreaDoc Addresses AddAutDoc Sources

Examples

db <- CreateDB.wos(wosdf)
str(db, 1)
#> List of 11
#>  $ Docs      :'data.frame':	856 obs. of  25 variables:
#>   ..- attr(*, "variable.labels")= Named chr [1:62] "Publication type" "Author" "Book authors" "Editor" ...
#>   .. ..- attr(*, "names")= chr [1:62] "PT" "AU" "BA" "BE" ...
#>  $ Authors   :'data.frame':	4053 obs. of  4 variables:
#>  $ AutDoc    :'data.frame':	5511 obs. of  2 variables:
#>  $ Categories:'data.frame':	189 obs. of  2 variables:
#>  $ CatDoc    :'data.frame':	1495 obs. of  2 variables:
#>  $ Areas     :'data.frame':	121 obs. of  2 variables:
#>  $ AreaDoc   :'data.frame':	1364 obs. of  2 variables:
#>  $ Addresses :'data.frame':	3655 obs. of  5 variables:
#>  $ AddAutDoc :'data.frame':	7751 obs. of  3 variables:
#>  $ Sources   :'data.frame':	520 obs. of  14 variables:
#>  $ label     : chr ""
#>  - attr(*, "variable.labels")= Named chr [1:62] "Publication type" "Author" "Book authors" "Editor" ...
#>   ..- attr(*, "names")= chr [1:62] "PT" "AU" "BA" "BE" ...
#>  - attr(*, "class")= chr "wos.db"
print(db)
#> List of 11
#>  $ Docs      :'data.frame':	856 obs. of  25 variables:
#>   ..- attr(*, "variable.labels")= Named chr [1:62] "Publication type" "Author" "Book authors" "Editor" ...
#>   .. ..- attr(*, "names")= chr [1:62] "PT" "AU" "BA" "BE" ...
#>  $ Authors   :'data.frame':	4053 obs. of  4 variables:
#>  $ AutDoc    :'data.frame':	5511 obs. of  2 variables:
#>  $ Categories:'data.frame':	189 obs. of  2 variables:
#>  $ CatDoc    :'data.frame':	1495 obs. of  2 variables:
#>  $ Areas     :'data.frame':	121 obs. of  2 variables:
#>  $ AreaDoc   :'data.frame':	1364 obs. of  2 variables:
#>  $ Addresses :'data.frame':	3655 obs. of  5 variables:
#>  $ AddAutDoc :'data.frame':	7751 obs. of  3 variables:
#>  $ Sources   :'data.frame':	520 obs. of  14 variables:
#>  $ label     : chr ""
#>  - attr(*, "variable.labels")= Named chr [1:62] "Publication type" "Author" "Book authors" "Editor" ...
#>   ..- attr(*, "names")= chr [1:62] "PT" "AU" "BA" "BE" ...
#>  - attr(*, "class")= chr "wos.db"
summary(db)
#> Number of documents: 856 
#> Authors: 4053 
#> Period: 2015 
#> 
#> Document types:
#>                            Documents
#> Article                          618
#> Article; Proceedings Paper        28
#> Book Review                        7
#> Correction                         4
#> Editorial Material                22
#> Letter                            24
#> Meeting Abstract                 114
#> News Item                          2
#> Review                            37
#> 
#> Number of authors per document:
#>    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
#>   1.000   3.000   5.000   6.438   8.000  98.000 
#> 
#> Number of documents per author:
#>    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
#>    1.00    1.00    1.00    1.36    1.00   16.00 
#> 
#> Number of times cited:
#>    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
#>   0.000   0.000   1.000   2.071   3.000  28.000 
#> 
#> Indexes:
#>  H  G 
#> 14 17 
#> 
#> Top Categories:
#>                                           Documents
#> Rheumatology                                     48
#> Cardiac & Cardiovascular Systems                 40
#> Environmental Sciences                           39
#> Engineering, Civil                               35
#> Plant Sciences                                   31
#> Surgery                                          31
#> Oncology                                         26
#> Respiratory System                               26
#> Chemistry, Analytical                            25
#> Computer Science, Artificial Intelligence        25
#> Others                                         1169
#> 
#> Top Areas:
#>                                    Documents
#> Engineering                               87
#> Chemistry                                 84
#> Computer Science                          65
#> Environmental Sciences & Ecology          50
#> Rheumatology                              48
#> Cardiovascular System & Cardiology        43
#> Mathematics                               38
#> Biochemistry & Molecular Biology          32
#> Business & Economics                      32
#> Plant Sciences                            31
#> Others                                   854
#> 
#> Top Journals:
#>                               Documents
#> Arthritis Rheumatol.                 21
#> Osteoarthritis Cartilage             14
#> PLoS One                             10
#> Rev. Esp. Cardiol.                   10
#> Inorg. Chem.                          9
#> J. Heart Lung Transplant.             9
#> Commun. Soil Sci. Plant Anal.         9
#> Eur. J. Phycol.                       9
#> Constr. Build. Mater.                 8
#> Sci. Total Environ.                   6
#> Others                              751
#> 
#> Top Countries:
#>             Documents
#> Spain             855
#> USA                71
#> UK                 62
#> France             51
#> Portugal           49
#> Italy              38
#> Germany            34
#> Belgium            24
#> Netherlands        23
#> Brazil             15
#> Others            236