search

CUB-Libraries-CTA / counter-data-loader

Loads COUNTER database from JR1 report spreadsheets
1 stars 2 forks source link

Split title report table #40

Closed ghost closed 2 years ago

ghost commented 2 years ago

Split the title_report table in two tables: title_report_journal and title_report_book.

This will simplify how data is queried in Django. The use of mviews (and normal views) can be discontinued.

ghost commented 2 years ago

Initial attempt at splitting the title_report table introduced an undesirable side effect. With separate tables for books and journals, while maintaining a single metric table, the FK constraint on the metric table is problematic. A single FK constraint on a child table cannot be enforced when there are two parent tables. Consequently, splitting the title_report table is not feasible without introducing separate metric tables. In lieu, an index on the title_type column will be added for UI performance reasons. No further action therefore is required on this issue.