Analysis of the dates of space exploration in the USSR, Russia and the world

Григорий Рего

Analysis of the dates of space exploration in the USSR, Russia and the world

The article deals with the study of spacecrafts and stations based on the Wikidata international project data. For the items classified as "spacecraft and stations" the queries were performed via SPARQL and the following lists were received: the list of all spacecrafts and stations, the list of spacecrafts and stations that has been designed in the USSR and Russia, the bar chart for spaceships and stations that shows the number of designed spacecrafts for decades, in the period from 1960 to 2017. Moreover, the Wikidata were evaluated from the point of their completeness. It showed that many objects have the wrong value of property "instance of (P31)".

Астрономия

Другие учебные работы

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

ID: 5a3ea7767966e108321c8bee

UUID: 43c4b740-ca41-0135-e6dc-525400005860

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

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

Просмотры: 16

10.42

Григорий Рего

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

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

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

Скачать - 215,4 КБ

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

Analysis of the dates of space exploration in the USSR, Russia and the world Gregory Rego Petrozavodsk State University Andrew Krizhanovsky Institute of Applied Mathematical Research of the Karelian Research Centre of the Russian Academy of Sciences December 23, 2017 The article deals with the study of spacecrafts and stations based on the Wikidata international project data. For the items classified as “spacecraft and stations” the queries were performed via SPARQL and the following lists were received: the list of all spacecrafts and stations, the list of spacecrafts and stations that has been designed in the USSR and Russia, the bar chart for spaceships and stations that shows the number of designed spacecrafts for decades, in the period from 1960 to 2017. Moreover, the Wikidata were evaluated from the point of their completeness. It showed that many objects have the wrong value of property ”instance of (P31)”. 1 Examples of the object “Spacecraft and stations” • Objects: spacecraft (Q25956), spacestation (Q40218). • Property: instance of (P31). Let’s build up a list of all spacecrafts in English and Russian (listing 1). 1 2 3 4 5 6 7 #L i s t o f s p a c e c r a f t i n E n g l i s h and R u s s i a n SELECT ? s p a c e c r a f t ? l a b e l e n ? l a b e l r u WHERE { ? s p a c e c r a f t wdt : P31 wd : Q40218 . ? s p a c e c r a f t r d f s : l a b e l ? l a b e l e n f i l t e r ( l a n g ( ? l a b e l e n ) = ” en ” ) . ? s p a c e c r a f t r d f s : l a b e l ? l a b e l r u f i l t e r ( l a n g ( ? l a b e l r u ) = ” ru ” ) . 1

8 } Listing 1: List of all spacecrafts SPARQL-request, 16 objects. Let’s build up a list of all space stations in English and Russian (listing 2). 1 2 3 4 5 6 7 8 9 #L i s t o f s p a c e s t a t i o n s i n E n g l i s h and R u s s i a n SELECT ? s p a c e s t a t i o n ? s p a c e c r a f t ? l a b e l e n ? l a b e l r u WHERE { ? s p a c e s t a t i o n wdt : P31 wd : Q25956 . ? s p a c e s t a t i o n r d f s : l a b e l ? l a b e l e n f i l t e r ( l a n g ( ? l a b e l e n ) = ” en ”) . ? s p a c e s t a t i o n r d f s : l a b e l ? l a b e l r u f i l t e r ( l a n g ( ? l a b e l r u ) = ” ru ”) . } Listing 2: List of all space stations SPARQL-request, 14 objects. 2 Positive and negative objects Examples of the most fully filled in objects ”spacestation (Q40218)” are: 1. International Space Station 2. Mir 3. Tiangong-1 Examples of poorly filled in objects ”spacecraft (Q25956)” were: 1. SpaceX Dragon 2. Orion 3. Voskhod 3 The list of hierarchy and output of spacecrafts The aim was to build up a hierarchy of spacecrafts so that to obtain the final list of spacecrafts which includes transport spaceships, fictional starships, and other space transportation. The tasks were to write a script that will list all the spacecrafts on the hierarchy basis. Spacecrafts are transport (designed for people), freight, fictional, and all others. This hierarchy will be used for solving the task. The following script helps to fulfil this task:(listing 3). 2

1 2 3 4 5 6 7 8 9 #L i s t o f s p a c e c r a f t i n E n g l i s h SELECT ? s p a c e c r a f t ? label en ? label ru WHERE { {? s p a c e c r a f t wdt : P31 wd : Q40218 . } UNION #s p a c e c r a f t {? s p a c e c r a f t wdt : P31 wd : Q18039177 . } UNION #f i c t i o n a l s p a c e c r a f t {? s p a c e c r a f t wdt : P31 wd : Q402330 . } #r o b o t i c s p a c e c r a f t ? s p a c e c r a f t r d f s : l a b e l ? l a b e l e n f i l t e r ( l a n g ( ? l a b e l e n ) = ” en ” ) . } Listing 3: All spacecrafts SPARQL-request 136 spacecrafts of all types were found. 4 The search for Soviet Union and Russian spacecrafts among the objects of the Wikidata From the general list of spacecrafts we deduce those that were designed in the USSR or Russia (listing 4). 1 2 3 4 5 6 7 8 9 10 11 12 #L i s t o f s p a c e c r a f t i n E n g l i s h SELECT ? s p a c e c r a f t ? label en ? label ru WHERE { {? s p a c e c r a f t wdt : P31 wd : Q40218 . } UNION #s p a c e c r a f t {? s p a c e c r a f t wdt : P31 wd : Q18039177 . } UNION #f i c t i o n a l s p a c e c r a f t {? s p a c e c r a f t wdt : P31 wd : Q402330 . }#r o b o t i c s p a c e c r a f t {? s p a c e c r a f t wdt : P17 wd : Q15180 . } UNION #USSR {? s p a c e c r a f t wdt : P17 wd : Q159 . } #R u s s i a ? s p a c e c r a f t r d f s : l a b e l ? l a b e l e n f i l t e r ( l a n g ( ? l a b e l e n ) = ” en ” ) . ? s p a c e c r a f t r d f s : l a b e l ? l a b e l r u f i l t e r ( l a n g ( ? l a b e l r u ) = ” ru ” ) . } Listing 4: Spacecrafts designed in the USSR or Russia SPARQL-request 103 spacecrafts found 5 Analysis of Wikidata completeness At the moment the analysis was conducted there were too few Wikidata in the field of spacecrafts and stations. The requests on all the spacecrafts and stations showed 48 results all in all, and only 3 of them were withdrawn on the request for Russian and Soviet Union spacecrafts. At the same time the data in the article Soviet space program, the English Wikipedia, showed 42 spacecrafts designed in the USSR, which indicates the fact that the data in Wikidata are being far from complete. The website “Encyclopedia of the Winged Space” [1] describes 39 spacecrafts developed in the USSR. The script, with the help of which the search for Russian and Soviet Union spacecrafts in the knowledge base was made, is shown below:(listing 5). 3

1 2 3 4 5 6 7 8 9 10 11 #L i s t o f s p a c e c r a f t i n E n g l i s h SELECT ? s p a c e c r a f t WHERE { {? s p a c e c r a f t wdt : P31 wd : Q40218 . } UNION #s p a c e c r a f t {? s p a c e c r a f t wdt : P31 wd : Q18039177 . } UNION #f i c t i o n a l s p a c e c r a f t {? s p a c e c r a f t wdt : P31 wd : Q402330 . }#r o b o t i c s p a c e c r a f t {? s p a c e c r a f t wdt : P17 wd : Q15180 . } UNION #USSR {? s p a c e c r a f t wdt : P17 wd : Q159 . } #R u s s i a 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 ” en ” . } } Listing 5: Before filling of Wikidata SPARQL-request returns 3 results, 30.10.2017. It turned out that the objects of the spacecrafts do exist, but they have wrong value in the property “instance of”: for example, as a “manned flight.” 6 Filling in Wikidata on the objects of spacecrafts and stations. In order to get more records when executing the script to search for Russian and Soviet Union spacecrafts and stations, it was decided to fill in the property “instance of (P86)” for objects of the type human spaceflight (Q752783) ”. The results are presented below: (listing 6). 1 2 3 4 5 6 7 8 9 10 11 #L i s t o f s p a c e c r a f t i n E n g l i s h SELECT ? s p a c e c r a f t WHERE { {? s p a c e c r a f t wdt : P31 wd : Q40218 . } UNION #s p a c e c r a f t {? s p a c e c r a f t wdt : P31 wd : Q18039177 . } UNION #f i c t i o n a l s p a c e c r a f t {? s p a c e c r a f t wdt : P31 wd : Q402330 . }#r o b o t i c s p a c e c r a f t {? s p a c e c r a f t wdt : P17 wd : Q15180 . } UNION #USSR {? s p a c e c r a f t wdt : P17 wd : Q159 . } #R u s s i a 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 ” en ” . } } Listing 6: After filling of Wikidata SPARQL-request returns 103 results, 09.11.2017. Before we made the corrections in Wikidata, some of these objects had the property “instance of” with the wrong value “manned flight”. These errors were fixed. These Wikidata corrections allow us to construct more correct time schedules presented at bar graphs below. 4

Time schedules of space exploration in Russia and the USSR and in the world The following script constructs the bar graph with the schedule of launching spacecraft in Russia and the USSR from 1960 to 2017 (listing 7). 1 2 3 4 5 6 7 8 9 10 11 12 13 SELECT ( s t r ( ? d ec ad e ) AS ? de ca de ) (COUNT( ? i n c e p t i o n ) AS ? q u a n t i t y ) # number o f ” i n c e p t i o n s ” WHERE { {? item wdt : P31 wd : Q40218 . } UNION #s p a c e c r a f t {? item wdt : P31 wd : Q18039177 . } UNION #f i c t i o n s p a c e c r a f t {? item wdt : P31 wd : Q402330 . } #r o b o t i c s p a c e c r a f t {? item wdt : P17 wd : Q15180 . } UNION #R u s s i a n and S o v i e t Union {? item wdt : P17 wd : Q159 . } ? item wdt : P619 ? i n c e p t i o n . BIND( YEAR( ? i n c e p t i o n ) a s ? y e a r ) BIND( FLOOR( ? y e a r / 1 0 ) ∗10 a s ? d ec ad e ) # . . . p e r each 10 y e a r s } GROUP BY ? de ca de ORDER BY ? d ec ad e Listing 7: Schedule of launching spacecraft in Russia and the USSR from 1960 to 2017. SPARQL-request. Figure 1: Time schedule for launching spacecraft in Russia and the USSR It can be seen from the graph that the most active period of space exploration in Russia and the USSR was in the 1970-1999 years. The same graph with script for the whole world are shown below: The same graph with script for the whole world are shown below (listing 8): 1 2 3 4 5 SELECT ( s t r ( ? d ec ad e ) AS ? de ca de ) (COUNT( ? i n c e p t i o n ) AS ? q u a n t i t y ) # number o f ” i n c e p t i o n s ” WHERE { {? item wdt : P31 wd : Q40218 . } UNION #s p a c e c r a f t {? item wdt : P31 wd : Q18039177 . } UNION #f i c t i o n s p a c e c r a f t {? item wdt : P31 wd : Q402330 . } #r o b o t i c s p a c e c r a f t 5

6 7 8 9 10 11 ? item wdt : P619 ? i n c e p t i o n . BIND( YEAR( ? i n c e p t i o n ) a s ? y e a r ) BIND( FLOOR( ? y e a r / 1 0 ) ∗10 a s ? d ec ad e ) # . . . p e r each 10 y e a r s } GROUP BY ? de ca de ORDER BY ? d ec ad e Listing 8: Graph for the whole world from 1960 to 2017. SPARQL-request. Figure 2: Time schedule for launching spacecraft in the world The graph shows that at the current moment the data on Russian and Soviet Union spacecrafts prevail in the Wikidata, and spacecrafts from other countries are undistinguishable. 7 Acknowledgements The authors are grateful to Evgenia Ivanovna Sokolova, the Head of the Foreign Languages Department at PetrSU, for the help in translating the article into the English language. 6

References [1] All ships, 1998. 7

Рецензии:

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

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

Отзывы:

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