started |
|||
Line 16: | Line 16: | ||
== Maintenance queries == | == Maintenance queries == | ||
''These queries help maintain or improve data quality, e.g. by checking for consistency or gaps.'' | ''These queries help maintain or improve data quality, e.g. by checking for consistency or gaps.'' | ||
=== zbMATH-related queries === | |||
==== On Wikidata ==== | |||
* [https://query.wikidata.org/#%23title%3A%20Author%20name%20strings%20common%20on%20works%20that%20have%20either%20a%20zbMATH%20work%20ID%20%28P894%29%20or%20an%20author%20with%20a%20zbMATH%20author%20ID%20%28P1556%29%0ASELECT%0A%23%20Number%20of%20works%20with%20the%20author%20name%20string%20that%20have%20either%20a%20zbMATH%20work%20ID%20%28P894%29%20or%20an%20author%20with%20a%20zbMATH%20author%20ID%20%28P1556%29%0A%3Fcount%0A%0A%23%20Total%20number%20of%20works%20with%20the%20author%20name%20string%0A%3Fcount1%0A%0A%23%20Author%20as%20a%20string%0A%3Fauthorstring%0A%0A%23%20Build%20URL%20to%20the%20Author%20disambiguator%20tool%0A%28CONCAT%28%0A%20%20%27https%3A%2F%2Ftools.wmflabs.org%2Fauthor-disambiguator%2Fnames_oauth.php%3Fname%3D%27%2C%0A%20%20ENCODE_FOR_URI%28%3Fauthorstring%29%29%20AS%20%3Fresolver_url%29%0AWITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fwork%20%3Fauthorstring%20WHERE%20%7B%0A%20%20%20%20%7B%0A%20%20%20%20%20%20SERVICE%20bd%3Asample%20%7B%20%3Fwork%20wdt%3AP894%20%5B%5D%20.%20bd%3AserviceParam%20bd%3Asample.limit%20100000%20%7D%20%20%20%0A%20%20%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthorstring%20.%0A%20%20%20%20%7D%0A%20%20%20%20UNION%0A%20%20%20%20%7B%0A%20%20%20%20%20%20SERVICE%20bd%3Asample%20%7B%20%3Fauthor%20wdt%3AP1556%20%5B%5D%20.%20bd%3AserviceParam%20bd%3Asample.limit%20100000%20%7D%20%20%20%0A%20%20%20%20%20%20%3Fauthor%20%5Ewdt%3AP50%20%3Fwork%20.%0A%20%20%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthorstring%20.%0A%20%20%20%20%7D%0A%20%20%7D%0A%20%20%20%20LIMIT%2050000%0A%7D%20AS%20%25works%0AWITH%20%7B%0A%20%20SELECT%0A%20%20%28COUNT%28DISTINCT%20%3Fwork%29%20AS%20%3Fcount%29%0A%20%20%28COUNT%28DISTINCT%20%3Fwork1%29%20AS%20%3Fcount1%29%0A%20%20%3Fauthorstring%0A%20%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25works%0A%20%20%20%20%20%20%20%20%20%20%20%20%3Fwork1%20wdt%3AP2093%20%3Fauthorstring%20.%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Fauthorstring%0A%7D%20AS%20%25result%0AWHERE%20%7B%0A%20%20INCLUDE%20%25result%0A%7D%0AORDER%20BY%20DESC%28%3Fcount%29%20DESC%28%3Fcount1%29 Author name strings common on works that have either a zbMATH work ID (P894) or an author with a zbMATH author ID (P1556)] |
Revision as of 23:33, 3 December 2022
About
This page assists with the creation, curation and maintenance of queries related to mathematical content here on the MaRDI portal or in other knowledge bases, especially in Wikidata.
Content queries
These are queries aimed at gathering content from one or more knowledge bases.
Demo queries
These are queries that highlight some particular aspect of the data or the associated technical contexts.
Editing queries
These queries generate commands that can be used to make additional edits.
Maintenance queries
These queries help maintain or improve data quality, e.g. by checking for consistency or gaps.