The search of music gaps in public domain using Wikidata

Илья Вершинин

The search of music gaps in public domain using Wikidata

This article is about research of musical compositions using the knowledge base of international project called Wikidata. With the help of SPARQL queries for items classified as "musical compositions" the following were received: the list of all musical compositions, the list of musical compositions that has a composer, the bubble diagram for composers that shows composers with most compositions. Moreover, the task of searching music gaps in public domain was done and completeness of Wikidata was evaluated.

Искусство. Искусствоведение

Исследования

Вуз: Петрозаводский государственный университет (ПетрГУ)

ID: 5a391c957966e11ea24d0b49

UUID: 8c30dd60-c6f3-0135-e4dd-525400005860

Язык: Английский

Опубликовано: почти 7 лет назад

Просмотры: 7

20.3

Илья Вершинин

Петрозаводский государственный университет (ПетрГУ)

Комментировать 0

Рецензировать 0

Скачать - 304308 bytes

Поделиться работой

The search of music gaps in public domain using Wikidata Andrew Krizhanovsky Institute of Applied Mathematical Research of the Karelian Research Centre of the Russian Academy of Sciences Ilya Vershinin Petrozavodsk State University December 19, 2017 This article is about research of musical compositions using the knowledge base of international project called Wikidata. With the help of SPARQL queries for items classified as ”musical compositions” the following were received: the list of all musical compositions, the list of musical compositions that has a composer, the bubble diagram for composers that shows composers with most compositions. Moreover, the task of searching music gaps in public domain was done and completeness of Wikidata was evaluated. 1 List of musical compositions • Item: musical composition (Q207628). • Property: instance of (P31). Let’s build a list of all musical compositions. See the listing 1. 1 2 3 4 5 6 #L i s t o f a l l m u s i c a l c o m p o s i t i o n s SELECT ? c o m p o s i t i o n ? c o m p o s i t i o n L a b e l WHERE { ? c o m p o s i t i o n wdt : P31 wd : Q207628 . SERVICE w i k i b a s e : l a b e l { bd : s e r v i c e P a r a m w i k i b a s e : l a n g u a g e ” ru ” . } } Listing 1: List of all musical compositions 1

SPARQL query, 5494 records. The most complete and well-developed musical compositions on Wikidata are The Magic Flute, Für Elise, Mozart’s Requiem, Eine kleine Nachtmusik. Almost empty and uninformative musical compositions were Flight of the Bumblebee, Romeo and Juliet, Iron Foundry, Binks’ Waltz, The Rose-bud March, Leola. 2 Search music gaps in public domain The task is to find musical works the composers of which passed away more than 70 years ago and audios of which are absent from Wikimedia Commons. The list of compositions must be sorted the in ascending order by publication date. This script can be used to find musical compositions that need to be digitized and then uploaded to Wikimedia Commons. See the listing 2. 1 2 3 4 5 6 7 8 9 10 11 12 13 #S e a r c h music gaps i n p u b l i c domain SELECT ? c o m p o s i t i o n ? c o m p o s i t i o n L a b e l ? p u b l i c a t i o n WHERE { ? c o m p o s i t i o n wdt : P31 wd : Q207628 . # i n s t a n c e o f compostion ? c o m p o s i t i o n wdt : P86 ? composer . # c o m p o s i t i o n has a composer ? c o m p o s i t i o n wdt : P577 ? p u b l i c a t i o n . # c o m p o s i t i o n has a p u b l i c a t i o n date ? composer wdt : P570 ? death . # composer has a d a t e o f death MINUS {? c o m p o s i t i o n wdt : P51 [ ] } . # compositions without audio FILTER( ? death < ”1947−01−01T00 : 0 0 : 0 0 Z” ˆˆ xsd : dateTime ) # c o m p o s e r s t h a t p a s s e d away more than 70 y e a r s ago FILTER( ? p u b l i c a t i o n < ”1947−01−01T00 : 0 0 : 0 0 Z” ˆˆ xsd : dateTime ) # c o m p o s i t i o n s t h a t were p u b l i s h e d more than 70 y e a r s ago SERVICE w i k i b a s e : l a b e l { bd : s e r v i c e P a r a m w i k i b a s e : l a n g u a g e ” ru ” . } } ORDER BY ASC( ? p u b l i c a t i o n ) Listing 2: Search music gaps in public domain SPARQL query, 140 records. 3 Completeness of Wikidata Let’s analyze the completeness of Wikidata . According to Grove Dictionary of Music and Musicians[1] there are 20374 composers. According to the category ”List of composers by name” of Russian Wikipedia there are more than 6000 composers. According to the category ”List of composers by name” of English Wikipedia there are more than 5000 composers. The number of musical compositions with filled property ”composer (P86)” equals 3862, which is shown in SPARQL query, and that’s if you take into 2

account the fact that one composer could have written several musical compositions. For example Wolfgang Amadeus Mozart is the composer of 95 compositions, which decreases the number of unique composers. The number of 3862 is lower than the amount of composers from both Russian and English Wikipedia and substantially lower than the amount of composers from Grove Dictionary of Music and Musicians which confirms the incompleteness of Wikidata. SPARQL query for compositions with filled property ”composer (P86)” and property ”country of origin (P495)” with value of ”Russian Empire (Q34266)”, ”USSR (Q15180)” or ”Russia (Q159)”, gave us only 8 compositions, which means that it’s impossible to analyze Russian musical compositions due to lack of data. Let’s build the bubble diagram for composers of musical compositions. See the listing 3. 1 2 3 4 5 6 7 8 9 10 11 12 #c o m p o s e r s o f m u s i c a l c o m p o s i t i o n s #d e f a u l t V i e w : BubbleChart SELECT ? composer ? form (COUNT( ∗ ) AS ? count ) WHERE { ? c o m p o s i t i o n wdt : P31 wd : Q207628 . # i n s t a n c e o f c o m p o s i t i o n ? c o m p o s i t i o n wdt : P86 ? composer . # c o m p o s i t i o n has a composer OPTIONAL { ? composer r d f s : l a b e l ? form . FILTER ( (LANG( ? form ) ) = ” en ” ) } } GROUP BY ? composer ? form ORDER BY DESC( ? count ) ? form Listing 3: Musical compositions grouped by composer Figure 1: Musical compositions grouped by composer 3

Size of a bubble tells us about the amount of musical compositions. This diagram shows us that some composers have more compositions that the others. Top 5 includes Niels Gade (173 compositions), Johann Sebastian Bach (155 compositions), Christian Sinding (125 compositions), Johan Halvorsen (121 compositions), Alan Hovhaness (108 compositions). 4 Filling of Wikidata The decision was made to fill ”composer (P86)” property for ”musical composition (Q207628)” items to get better results while performing the query for searching music gaps in public domain. Let’s build a list of all musical compostions with filled property ”composer (P86)”. See the listing 4. 1 2 3 4 5 6 7 8 #L i s t s o f c o m p o s i t i o n s t h a t has a composer i n R u s s i a n SELECT ? c o m p o s i t i o n ? c o m p o s i t i o n L a b e l ? composer ? c o m p o s e r L a b e l WHERE { ? c o m p o s i t i o n wdt : P31 wd : Q207628 . # i n s t a n c e o f c o m p o s i t i o n ? c o m p o s i t i o n wdt : P86 ? composer . # c o m p o s i t i o n has a composer SERVICE w i k i b a s e : l a b e l { bd : s e r v i c e P a r a m w i k i b a s e : l a n g u a g e ” ru ” . } } } Listing 4: Lists of compositions that has a composer in Russian SPARQL query, 3864 records at 30/10/2017, 10:51. SPARQL query, 3965 records at 30/10/2017, 12:47. 4

References [1] Grove Dictionary of Music and Musicians. Oxford University Press, 2001. [2] Musical composition. Research in programming Wikidata // English Wikiversity. https://en.wikiversity.org/wiki/Research_in_ programming_Wikidata/Musical_Compositions, 2017. 5

Рецензии:

Авторизуйтесь, чтобы добавить рецензию

- у работы пока нет рецензий -

Отзывы:

Авторизуйтесь, чтобы оставить отзыв