Extraction of fact tables from a relational database: an effort to establish rules in denormalization

Relational databases are supported by very well established models. However, some neglected problems can occur with the join operator: semantic mistakes caused by the multiple access path problem and faults when connection traps arise. In this paper we intend to identify and overcome those problems and to establish rules for relational data denormalization. Two denormalization forms are proposed and a case study is presented.info:eu-repo/semantics/publishedVersio

Phenotypic variability among pumpkin accessions in the Brazilian semiarid

The aim of this study was to estimate the phenotypic divergence among fourteen pumpkins accessions of the cucurbits Germplasm Active Bank of Embrapa Semiárido, in order to support breeding program to these species. Nine morphoagronomic descriptors were analyzed by the principal components and by UPGMA techniques. In the analysis of principal components, the formation of three contrasting clusters was observed, each one composed of two accessions. There occurred also the formation of one core group composed of five accessions, being the accessions called 683 and 684 collected in Bahia and the other in Maranhão. The most divergent accessions were 620, 624 and 748. The variables of the greatest contribution to the genetic divergence were diameter, weight and average length of the fruit. In the UPGMA analysis, obtained from the symmetric matrices generated by the Mahalanobis distance for the nine descriptors, there was the formation of one core group, composed of ten accessions, whose similarity was 45.71%, with geographically divergent accessions presenting the greatest similarity. Three accessions were not clustered with others. The study identified phenotypic variability for the analyzed characters and the absence of relationship between place of collection and phenotypic diversity

Site Fidelity in Space Use by Spider Monkeys (Ateles geoffroyi) in the Yucatan Peninsula, Mexico

Animal home ranges may vary little in their size and location in the short term but nevertheless show more variability in the long term. We evaluated the degree of site fidelity of two groups of spider monkeys (Ateles geoffroyi) over a 10- and 13-year period, respectively, in the northeastern Yucatan peninsula, Mexico. We used the Local Convex Hull method to estimate yearly home ranges and core areas (defined as the 60% probability contour) for the two groups. Home ranges varied from 7.7 to 49.6 ha and core areas varied from 3.1 to 9.2 ha. We evaluated the degree of site fidelity by quantifying the number of years in which different areas were used as either home ranges or core areas. Large tracts were used only as home ranges and only for a few years, whereas small areas were used as either core area or home range for the duration of the study. The sum of the yearly core areas coincided partially with the yearly home ranges, indicating that home ranges contain areas used intermittently. Home ranges, and especially core areas, contained a higher proportion of mature forest than the larger study site as a whole. Across years and only in one group, the size of core areas was positively correlated with the proportion of adult males in the group, while the size of home ranges was positively correlated with both the proportion of males and the number of tree species included in the diet. Our findings suggest that spider monkey home ranges are the result of a combination of long-term site fidelity and year-to-year use variation to enable exploration of new resources

Coping religioso/espiritual em pessoas com doença renal crônica em tratamento hemodialítico

O estudo tem como objetivo investigar o uso do coping religioso/espiritual em pacientes com doença renal crônica em hemodiálise. A investigação ocorreu em uma clínica de hemodiálise, por meio de entrevista utilizando um questionário sociodemográfico e a escala de coping religioso/espiritual. Para análise dos dados, foram empregados a estatística descritiva e o teste coeficiente de correlação de Sperman, a análise de variância e o modelo de regressão linear múltipla. Foram entrevistados 123 indivíduos, dos quais 79,6% apresentaram escore alto para o coping religioso/espiritual e nenhum deles apresentou os escores baixos e irrisórios. As variáveis que influenciaram no comportamento do coping religioso/espiritual foram: sexo, faixa etária, tempo de tratamento, renda familiar e prática religiosa. Conclui-se que os pacientes em estudo utilizam de modo positivo o coping religioso/espiritual como estratégia de enfrentamento da doença, destacando-se as mulheres, com renda familiar maior e que frequentam semanalmente a igreja

Search for new phenomena in final states with an energetic jet and large missing transverse momentum in pp collisions at √ s = 8 TeV with the ATLAS detector

Results of a search for new phenomena in final states with an energetic jet and large missing transverse momentum are reported. The search uses 20.3 fb−1 of √ s = 8 TeV data collected in 2012 with the ATLAS detector at the LHC. Events are required to have at least one jet with pT > 120 GeV and no leptons. Nine signal regions are considered with increasing missing transverse momentum requirements between Emiss T > 150 GeV and Emiss T > 700 GeV. Good agreement is observed between the number of events in data and Standard Model expectations. The results are translated into exclusion limits on models with either large extra spatial dimensions, pair production of weakly interacting dark matter candidates, or production of very light gravitinos in a gauge-mediated supersymmetric model. In addition, limits on the production of an invisibly decaying Higgs-like boson leading to similar topologies in the final state are presente