Application examples¶
The source distribution examples
directory contains proof-of-concept
studies that were conducted with alexandria3k as examples of its use.
They are structured to use Makefiles based on
simple-rolap for
orchestrating the queries (it is installed automatically) and
rdbunit for unit testing
them (it needs to be manually installed for running the tests). Running
(GNU) make
in a directory will produce the expected results in a
reports
sub-directory. Many of the studies can take hours or days to
run. When running the scripts on a shared Unix/Linux computer, running
make as nohup nice make
will log the operation in the file
nohup.out
(use tail -f nohup.out
to view it), prevent the
command from terminating when a session is disconnected, and decrease
the priority of the tasks to minimize their burden on interactive users.
When modifying existing studies or creating one ones, run make help
in a study directory to see some potentially useful make targets.
The
common
directory contains Makefile rules for satisfying data dependencies
common to more than one study. It also hosts downloaded data sets to
minimize useless replication. The Makefile
residing in it can be
used to tailor the running of all other studies.
Examples by directory¶
The following examples are available.
Templates¶
Data source examples and metric measurements¶
Published results¶
The following queries have been used to publish derived figures and tables.
Yearly availability of Crossref elements derived from
Number and properties of Crossref records derived from graph/metrics.sql
Number of ORCID records derived from graph/metrics.sql
Evolution of scientific publishing metrics in the post-WW2 period derived from
Number of research synthesis studies published each year in the period 1971–2021 derived from research-synthesis/a3k-queries/research-synthesis.sql
Evolution of subject coverage and publications 1945–2021 derived from graph/general-field-publications-list.sql
Citations from COVID research to COVID research over time derived from covid/inner-citations.sql