aboutsummaryrefslogtreecommitdiffstats
path: root/notes/indexing_pipeline.md
diff options
context:
space:
mode:
Diffstat (limited to 'notes/indexing_pipeline.md')
-rw-r--r--notes/indexing_pipeline.md48
1 files changed, 48 insertions, 0 deletions
diff --git a/notes/indexing_pipeline.md b/notes/indexing_pipeline.md
new file mode 100644
index 0000000..f891d27
--- /dev/null
+++ b/notes/indexing_pipeline.md
@@ -0,0 +1,48 @@
+
+## Prototype Pipeline
+
+Requires staff credentials in environment for `internetarchive` python library.
+
+TODO: pass these credentials via ansible/dotenv
+
+Generate complete SIM issue database:
+
+ ia search "collection:periodicals collection:sim_microfilm mediatype:collection" --itemlist | rg "^pub_" > data/sim_collections.tsv
+ ia search "collection:periodicals collection:sim_microfilm mediatype:texts" --itemlist | rg "^sim_" > data/sim_items.tsv
+
+ cat data/sim_collections.tsv | parallel -j4 ia metadata {} | jq . -c | pv -l > data/sim_collections.json
+ cat data/sim_items.tsv | parallel -j8 ia metadata {} | jq . -c | pv -l > data/sim_items.json
+
+ python -m fatcat_scholar.issue_db init_db
+ cat data/sim_collections.json | pv -l | python -m fatcat_scholar.issue_db load_pubs
+ cat data/sim_items.json | pv -l | python -m fatcat_scholar.issue_db load_issues
+ python -m fatcat_scholar.issue_db load_counts
+
+Create QA elasticsearch index (localhost):
+
+ http put ":9200/qa_scholar_fulltext_v01?include_type_name=true" < schema/scholar_fulltext.v01.json
+ http put ":9200/qa_scholar_fulltext_v01/_alias/qa_scholar_fulltext"
+
+Fetch "heavy" fulltext documents (JSON) for full SIM database:
+
+ python -m fatcat_scholar.sim_pipeline run_issue_db | pv -l | gzip > data/sim_intermediate.json.gz
+
+Re-use existing COVID-19 database to index releases:
+
+ cat /srv/fatcat_covid19/metadata/2020-06-24/fatcat_hits.enrich.json \
+ | jq -c .fatcat_release \
+ | rg -v "^null" \
+ | parallel -j8 --linebuffer --round-robin --pipe python -m fatcat_scholar.work_pipeline run_releases \
+ | pv -l \
+ | gzip > data/work_intermediate.json.gz
+
+ => 48.3k 0:17:58 [44.8 /s]
+
+Transform and index both into local elasticsearch:
+
+ zcat data/work_intermediate.json.gz data/sim_intermediate.json.gz \
+ | parallel -j8 --linebuffer --round-robin --pipe python -m fatcat_scholar.transform run_transform \
+ | esbulk -verbose -size 100 -id key -w 4 -index qa_scholar_fulltext_v01 -type _doc
+
+ => 132635 docs in 2m18.787824205s at 955.667 docs/s with 4 workers
+