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. | :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)] | * [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] |
Revision as of 11: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.
On Wikidata
- 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.