User:Daniel/Queries: Difference between revisions

Revision as of 12:01, 16 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.

zbMATH-related queries

On Wikidata

Author name strings common on works that have either a zbMATH work ID (P894) or an author with a zbMATH author ID (P1556)

The results here are dominated by astronomy, which rarely uses full names, so author disambiguation is harder. Let's filter this to exclude strings with initials.

Common author name strings (without single-letter initials) on works that have either a zbMATH work ID (P894) or an author with a zbMATH author ID (P1556)

@@ Line 25: / Line 25: @@
 :The results here are dominated by astronomy, which rarely uses full names, so author disambiguation is harder. Let's filter this to exclude strings with initials.
 * [https://query.wikidata.org/#%23title%3A%20Common%20author%20name%20strings%20%28without%20single-letter%20initials%29%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%20%20%23%20remove%20single-letter%20initials%0A%20%20%20%20FILTER%28%21regex%20%28LCASE%28%3Fauthorstring%29%2C%20%22%5E.%2a%3F%28%28%5C%5Cb%5C%5Cw%7B1%7D%5C%5Cb%29%7C%5B.%5D%29.%2a%24%22%29%29.%0A%20%20%7D%0A%20%20%20%20LIMIT%2010000%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%0ALIMIT%20200 Common author name strings (without single-letter initials) on works that have either a zbMATH work ID (P894) or an author with a zbMATH author ID (P1556)]
+== Q & A tools ==
+* [https://templet.dcc.uchile.cl/ templet]
+* [http://qawiki.org/ QAwiki]
+* [http://wikiask.org/ WikiAsk]