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

Five ways to enhance the impact of climate science

Policy-making is rarely driven by evidence alone. Thus, climate scientists who adopt an ‘evidence-based’ mindset, expecting more science to lead automatically to better policy, are likely to be disappointed. Instead, embracing an ‘evidence-informed’ attitude to policy-making will be more productive, recognising that evidence must be deployed in such a way as to interact persuasively with other factors. Using the 5th Assessment Report of the IPCC as inspiration, this commentary argues that climate scientists would do well to consider five ideas and ultimately embrace an evidence-informed approach to presenting evidence.This work is taken from a larger PhD project currently being undertaken in the Department of Geography at the University of Cambridge. This work is very kindly funded by the Economic and Social Research Council (grant number ES/I901957/1) and by the Homerton College Charter Scholarship scheme. I would like to thank S. E. Owens, A. Donovan and W. M. Adams for comments, and D. Watson for help with the figures.This is the accepted manuscript. The final version is available in Nature Climate Change 4, 522–524 (2014) doi:10.1038/nclimate2270 . http://www.nature.com/nclimate/journal/v4/n7/full/nclimate2270.htm

Assessing Communities of Practice in health policy : A conceptual framework as a first step towards empirical research

Peer reviewe

Guidance for Evidence-Informed Policies about Health Systems: Linking Guidance Development to Policy Development

In the second paper in a three-part series on health systems guidance, John Lavis and colleagues explore the challenge of linking guidance development and policy development at global and national levels

Computational and mathematical approaches to societal transitions

After an introduction of the theoretical framework and concepts of transition studies, this article gives an overview of how structural change in social systems has been studied from various disciplinary perspectives. This overview first leads to the conclusion that computational and mathematical approaches and their practical form, modeling, up till now, have been almost absent in the research and theorizing of structural change or transitions in social systems. Second, this review of the social science literature suggests numerous theoretical constructs relevant for transition modeling. Relevant concepts include the conceptualization of the micro-to-macro link, the importance of explaining both stability and change, quantitative and qualitative definitions of structural change, the use of dichotomies, synchronic and diachronic reasoning in explaining structural change, definitions of basic patterns of social change, the conceptualization of resistance to change and intentional and normative aspects of social change. This article employs these theoretical concepts to describe and discuss the models presented in this special issue in order to develop an understanding of what exactly entails a computational or mathematical approach to societal transitions

Large herbivores may alter vegetation structure of semi-arid savannas through soil nutrient mediation

In savannas, the tree–grass balance is governed by water, nutrients, fire and herbivory, and their interactions. We studied the hypothesis that herbivores indirectly affect vegetation structure by changing the availability of soil nutrients, which, in turn, alters the competition between trees and grasses. Nine abandoned livestock holding-pen areas (kraals), enriched by dung and urine, were contrasted with nearby control sites in a semi-arid savanna. About 40 years after abandonment, kraal sites still showed high soil concentrations of inorganic N, extractable P, K, Ca and Mg compared to controls. Kraals also had a high plant production potential and offered high quality forage. The intense grazing and high herbivore dung and urine deposition rates in kraals fit the accelerated nutrient cycling model described for fertile systems elsewhere. Data of a concurrent experiment also showed that bush-cleared patches resulted in an increase in impala dung deposition, probably because impala preferred open sites to avoid predation. Kraal sites had very low tree densities compared to control sites, thus the high impala dung deposition rates here may be in part driven by the open structure of kraal sites, which may explain the persistence of nutrients in kraals. Experiments indicated that tree seedlings were increasingly constrained when competing with grasses under fertile conditions, which might explain the low tree recruitment observed in kraals. In conclusion, large herbivores may indirectly keep existing nutrient hotspots such as abandoned kraals structurally open by maintaining a high local soil fertility, which, in turn, constrains woody recruitment in a negative feedback loop. The maintenance of nutrient hotspots such as abandoned kraals by herbivores contributes to the structural heterogeneity of nutrient-poor savanna vegetation

Terrestrialization, Miniaturization and Rates of Diversification in African Puddle Frogs (Anura: Phrynobatrachidae)

Terrestrialization, the evolution of non-aquatic oviposition, and miniaturization, the evolution of tiny adult body size, are recurring trends in amphibian evolution, but the relationships among the traits that characterize these phenomena are not well understood. Furthermore, these traits have been identified as possible “key innovations” that are predicted to increase rates of speciation in those lineages in which they evolve. We examine terrestrialization and miniaturization in sub-Saharan puddle frogs (Phrynobatrachidae) in a phylogenetic context to investigate the relationship between adaptation and diversification through time. We use relative dating techniques to ascertain if character trait shifts are associated with increased diversification rates, and we evaluate the likelihood that a single temporal event can explain the evolution of those traits. Results indicate alternate reproductive modes evolved independently in Phrynobatrachus at least seven times, including terrestrial deposition of eggs and terrestrial, non-feeding larvae. These shifts towards alternate reproductive modes are not linked to a common temporal event. Contrary to the “key innovations” hypothesis, clades that exhibit alternate reproductive modes have lower diversification rates than those that deposit eggs aquatically. Adult habitat, pedal webbing and body size have no effect on diversification rates. Though these traits putatively identified as key innovations for Phrynobatrachus do not seem to be associated with increased speciation rates, they may still provide opportunities to extend into new niches, thus increasing overall diversity

Australia's insurance crisis and the inequitable treatment of self-employed midwives

Based upon a review of articles published in Australia's major newspapers over the period January 2001 to December 2005, a case study approach has been used to investigate why, when compared with other small business operators, including medical specialists, Australian governments have appeared reluctant to protect the economic viability of the businesses of self-employed midwives. Theories of agenda setting and structuralism have been used to explore that inequity. What has emerged is a picture of the complex of factors that may have operated, and may be continuing to operate, to shape the policy agenda and thus prevent solutions to the insurance problems of self-employed midwives being found

“Working the System”—British American Tobacco's Influence on the European Union Treaty and Its Implications for Policy: An Analysis of Internal Tobacco Industry Documents

Katherine Smith and colleagues investigate the ways in which British American Tobacco influenced the European Union Treaty so that new EU policies advance the interests of major corporations, including those that produce products damaging to health

Cheetah mothers' vigilance: looking out for prey or for predators?

Free-living cheetah ( Acinonyx jubatus ) cubs are killed by a number of predators, thus vigilance in cheetah mothers may be a form of anti-predator behaviour as well as a means of locating prey. Mothers' vigilance during the day was closely associated with measures of hunting but not with measures of anti-predator behaviour. In contrast, mothers' vigilance at kills was not related to hunting but was related to anti-predator behaviour. Both forms of vigilance decreased as cubs grew older. Vigilance during the day increased with litter size which supports a model of ‘shared’ parental investment (Lazarus and Inglis 1986) because after prey had been located and caught by mothers, cubs shared the prey between them. Vigilance at kills did not increase with litter size when cubs were young; in these situations predators stole cheetahs' prey and rarely chased cubs so, at most, only a single cub would be taken. Mothers' anti-predator behaviour away from kills did increase with litter size at young cub ages however; more cubs are killed in these circumstances the greater is the size of the litter. When cubs were older and could outrun predators, neither vigilance at kills nor anti-predator behaviour increased with litter size. These results strongly support two models of ‘unshared’ investment (Lazarus and Inglis 1986) and demonstrate, not only that superficially similar behaviour has different functions in different contexts, but that parental investment is shaped by the type of benefits accrued from it.Peer Reviewedhttp://deepblue.lib.umich.edu/bitstream/2027.42/46879/1/265_2004_Article_BF00300681.pd