Learn · CERN

Talk12 min

Things you can do dumping your Invenio database into a flat file

Ferran Jorba · CERN

Watch At CERN

About

Invenio database design and interfaces are optimized for fast end user search and retrieval. As administrators, we can add indexes at will and use them via web or API. However, many maintenance tasks are not well covered with those indexes.

For most of those cases, reading the records sequentialy is the optimal solution. However, if the database is large enough, reading them via Invenio API may take hours, while the system slows down and it may become unresponsive.

In this presentation I'll show a small Python tool that uses Invenio API and a SQLite database as cache to keep an up to date flat file with your bibliographic records.

We'll see how whith this flat file it is much faster and easier to do tasks like generate specialised statistics, quality control, automatic record enrichment or cleaning, or even creating exotic indexes or counters..

0:00:00 Slide 1

0:00:25 Slide 2

0:01:24 Slide 3

0:02:20 Slide 4

0:02:36 Slide 5

0:03:35 Slide 6

0:04:07 Slide 7

0:04:45 Slide 8

The talk

  1. Things you can do dumping your Invenio database into a flat file 2017-03-22 · 12 min · CERN's player

Credits and licence

Institution
CERN
Department
Invenio User Group Workshops
Speaker
Ferran Jorba
Year
2017
Language
English
Source
CERN
Licence
CERN, as CERN states it. CERN's terms
Attribution
© CERN. CERN provides its audiovisual media free of charge for educational and informational use, credited to CERN; this lecture is shown in CERN's own player.
Who can watch
CERN gives no rating. Invisible Network shows it to Teens profiles and older, judged from what the source says about it. How courses are placed