Join Execution Using Fragmented Columnar Indices on GPU and MIC

The paper describes an approach to the parallel natural join execution on computing clusters with GPU and MIC Coprocessors. This approach is based on a decomposition of natural join relational operator using the column indices and domain-interval fragmentation. This decomposition admits parallel executing the resource-intensive relational operators without data transfers. All column index fragments are stored in main memory. To process the join of two relations, each pair of index fragments corresponding to particular domain interval is joined on a separate processor core. Described approach allows efficient parallel query processing for very large databases on modern computing cluster systems with many-core accelerators. A prototype of the DBMS coprocessor system was implemented using this technique. The results of computational experiments for GPU and Xeon Phi are presented. These results confirm the efficiency of proposed approach

Document management as part of social communication

In this article the authors introduce a special type of communications - documen

ISOLATED INFLUENZA VIRUSES FROM CLINICALLY HEALTHY CHILDREN AT THE BEGINNING OF THE INFLUENZA WAVE IN 1983

No abstrac

Convergence modelling in international integration associations

The article considers mathematical tools for modelling economic policy as a whole, as well as convergence in the field of labor, foreign economic activity, monetary and debt policy. Convergence was estimated using the convergence model, which characterizes the decrease in time spread in the levels of development of countries and regions, reflecting the negative relationship between economic growth rates and the initial level of development of countries and regions. The convergence was estimated by the coefficient of variation and by the dispersion-based model. To assess convergence, we used the Barro and Salai- Martin models, as well as the Baumol, Solow-Svan, and Quadrado-Rour models. The use of this mathematical toolkit allows to explore the presence and speed of convergence before and after joining international integration associations. The proposed mathematical modelling tools are recommended to be used in order to analyze convergence processes, study the dynamics of convergence or divergence, and also to adjust the directions and methods of state and regional economic policies of countries included in the integration association. © 2020 South Ural State University. All rights reserved

Interaction of the Church and Society in Commemoration Campaigns Activated By Museum of Sanctity and Asceticism in the Urals in 20

The article analyzes attempts of the Orthodox Church and secular society to form some integrated space of historical memory about repressions in the Urals in the 2

Formation of Millisecond Pulsars in Globular Clusters

In this contribution we discuss how neutron stars are produced and retained in globular clusters, outlining the most important dynamical channels and evolutionary events that affect thepopulation of mass-transferring binaries with neutron stars and result in the formation of recycled pulsars. We confirm the importance of electron-capture supernovae in globular clusters as the major supplier of retained neutron stars.By comparing the observed millisecond pulsar population and the results obtained from simulations, we discuss several constraints on the evolution of mass-transferring systems.In particular, we find that in our cluster model the following mass-gaining events create populations of MSPs that do not match the observations (with respect to binary periods and companion masses or the number of produced systems) and therefore likely do not lead to NSs spun up to millisecond periods: (i) accretion during a common envelope event with a NS formed through accretion-induced collapse, and (ii) mass transfer from a WD donor. By restricting ourselves to the evolutionary and dynamical paths that most likely lead to neutron star recycling, we obtain good agreement between our models and the numbers and characteristics of observed millisecond pulsars in the clusters Terzan 5 and 47 Tuc.Comment: 6 pages, 3 figures, to appear in the proceedings of the 40 Years of Pulsars conference held at McGill University in August 200

An advancement of treatment of nasopharyngeal signs of gastroesophageal reflux disease in children against the background of vitamin D deficiency

The work aims at substantiating the prescription of vitamin D3 for treatment and prevention of nasopharyngeal signs of GERD in children through determining the main risk factors of the development of the disease.Materials and methods. Eighty-eight children aged about 4.6 ± 0.14 years were enrolled in the study. The patients were divided into four groups: group 1 consisted of 22 children with nasopharyngeal signs of gastroesophageal reflux disease (GERD); group 2 comprised 22 children with chronic ENT pathology and without GERD; group 3 was formed of 22 children with GERD and without any ENT pathology; group 4 (control group) included 22 children without an ENT or gastrointestinal pathology. No substantial gender differences were observed in each of the groups. GERD was diagnosed on the basis of symptoms and 24-hour pH monitoring; the test for Vitamin D provision was performed; mucosal immunity characteristics were identified and the contamination of the upper airways mucous membranes was studied. The results are statistically processed using Microsoft Office Excel and Statistica 13 software.Results. Children with GERD with nasopharyngeal signs have been proved to have acute respiratory viral infections (ARVI) more frequently than children with GERD and without ENT pathologies (the number of aggravations is 8.5 (8.0;10.0) and 3.0 (2.0;3.0) respectively (р<0.00001)).The contamination of mucus membranes of oropharynx and nose of the children with nasopharyngeal signs of GERD is represented by opportunistic microflora (in 95.5%) with prevailing Haemophilus influenzae. More than two kinds of microorganism have been inoculated in 63.6% of children (р=0.002), which indicates considerable impairment of colonization resistance in palatal tonsils. Moreover, the majority of the prolonged acid refluxes has been registered in children with the presence of Haemophilus influenza (7,5±1,62 against 3,67±1,2, р=0,04). These data confirm that the acid content of the refluxate not only irritates the mucous membrane of the oral cavity but also leads to the impairment of local immunity mechanisms and creates favourable conditions for the colonization and growth of bacteria which results in the development of lesions in the pharyngeal mucous membrane.Children with GERD accompanied with nasopharyngeal signs are characteristic of vitamin D deficiency which is confirmed by lower levels of 25(ОН)D3. This, in its turn, influences the production of antimicrobial peptides (α-defensins 1-3 and cathelicidins LL 37). Group 1 children present with significantly low levels of antimicrobial peptides (α-defensins 1-3 2474.08±180.4 pg/ml and cathelicidins LL 37 18.89±2,84 pg/ml, р˂0.05) against the background of lower 25(OH)D3 (13.05±0.55 ng/ml, р=0.00001). The determined peculiarities substantiated the introduction of vitamin D3 into therapy for GERD.Children of the treatment group were prescribed vitamin D3 in the dosage of 2000 MU per day for a monthly period, and monotherapy with vitamin D3 in the dosage of 1000 MU per day for a year, daily from September to April, including the break between May and September. Before the treatment, the yearly incidence of the acute respiratory viral disease (ARVD) in the treatment group children was 9.0 [8.0;10.0], and in the control group children, it was 8.0 [7.0; 10.0]. After a year since the beginning of the treatment, the incidence of ARVI in the treatment group children was 4,0 [3.0;4.0], which is significantly lower than in the control group children (5.0 [4.0;6.0], р=0.008). During the year, aggravation of chronic tonsillitis was registered only in 45.5% of the control group children (р=0.03), and GERD symptoms were registered only in 18.2 % of the treatment group patients (р=0.03).Obtained results prove the advisability of including vitamin D3 in the therapeutic regimen of gastroesophageal reflux disease, and its nasopharyngeal signs in particular, in preschoolers.  Conclusions. It is typical of children with GERD accompanied by nasopharyngeal signs to demonstrate significantly low levels of antimicrobial peptides against the background of even lower 25(OH)D3 (13.05±0.55 ng/ml, р=0.00001). Children with GERD and nasopharyngeal signs tend to have ARVI more frequently than those with GERD but without ENT pathologies (number of aggravations is 8.5 (8.0;10.0) and 3.0 (2.0;3.0) respectively (р<0.00001)). The prescription of vitamin D3 in the complex therapy for GERD with nasopharyngeal signs allows to decrease the incidence of the acute respiratory viral infection (ARVI) over a year (р=0.008) and to gain stable regression of the clinical symptomatology (р=0.03)