search

OpenAPC / openapc-olap

Small OLAP server (based on cubes) to provide an efficient querying tool for the OpenAPC data and a backend for the OpenAPC treemaps presentation
MIT License
2 stars 3 forks source link

Facilitate use of ISSNs? #15

Open bmkramer opened 2 years ago

bmkramer commented 2 years ago

The OLAP server is very useful to access OpenAPC data programmatically, thanks for making it available!

One thing that would be great to have is the ability to drill down/cut on ISSNs rather than (or in addition to) journal title. Is this something that would be worth adding to the database?

cbroschinski commented 2 years ago

That's no big issue, I just added the issn field as a separate OLAP dimension. It is now available on the live system: https://olap.openapc.net/cube/openapc/aggregate?drilldown=issn It should be noted, however, that the OpenAPC dataset contains 4 different types of ISSN: issn, issn_print, issn_electronic and issn_l. The first 3 originate from crossref (with issn being the primary identifier), while issn_l is the Linking ISSN provided by the ISSN organization. Unfortuately the relation between those is not always consistent, issn is sometimes the same as the print version, sometimes the same as the electronic version and in rare cases even something completely different. Let me know if this is sufficient for you or if I should add the other ISSN fields as well.

bmkramer commented 2 years ago

Thanks for the quick implementation @cbroschinski! For optimal matching, it would indeed be good to have all ISSN fields if that's possible.

This will be very useful, so thanks again!