Cleaning Denial Constraint Violations through Relaxation

Data cleaning is a time-consuming process that depends on the data analysis that users perform. Existing solutions treat data cleaning as a separate offline process that takes place before analysis begins. Applying data cleaning before analysis assumes a priori knowledge of the inconsistencies and the query workload, thereby requiring effort on understanding and cleaning the data that is unnecessary for the analysis. We propose an approach that performs probabilistic repair of denial constraint violations on-demand, driven by the exploratory analysis that users perform. We introduce Daisy, a system that seamlessly integrates data cleaning into the analysis by relaxing query results. Daisy executes analytical query-workloads over dirty data by weaving cleaning operators into the query plan. Our evaluation shows that Daisy adapts to the workload and outperforms traditional offline cleaning on both synthetic and real-world workloads.Comment: To appear in SIGMOD 2020 proceeding

Greater functional diversity and redundancy of coral endolithic microbiomes align with lower coral bleaching susceptibility.

The skeleton of reef-building coral harbors diverse microbial communities that could compensate for metabolic deficiencies caused by the loss of algal endosymbionts, i.e., coral bleaching. However, it is unknown to what extent endolith taxonomic diversity and functional potential might contribute to thermal resilience. Here we exposed Goniastrea edwardsi and Porites lutea, two common reef-building corals from the central Red Sea to a 17-day long heat stress. Using hyperspectral imaging, marker gene/metagenomic sequencing, and NanoSIMS, we characterized their endolithic microbiomes together with 15N and 13C assimilation of two skeletal compartments: the endolithic band directly below the coral tissue and the deep skeleton. The bleaching-resistant G. edwardsi was associated with endolithic microbiomes of greater functional diversity and redundancy that exhibited lower N and C assimilation than endoliths in the bleaching-sensitive P. lutea. We propose that the lower endolithic primary productivity in G. edwardsi can be attributed to the dominance of chemolithotrophs. Lower primary production within the skeleton may prevent unbalanced nutrient fluxes to coral tissues under heat stress, thereby preserving nutrient-limiting conditions characteristic of a stable coral-algal symbiosis. Our findings link coral endolithic microbiome structure and function to bleaching susceptibility, providing new avenues for understanding and eventually mitigating reef loss

The genetic structure of Aedes aegypti populations is driven by boat traffic in the Peruvian Amazon.

In the Americas, as in much of the rest of the world, the dengue virus vector Aedes aegypti is found in close association with human habitations, often leading to high population densities of mosquitoes in urban settings. In the Peruvian Amazon, this vector has been expanding to rural communities over the last 10-15 years, but to date, the population genetic structure of Ae. aegypti in this region has not been characterized. To investigate the relationship between Ae. aegypti gene flow and human transportation networks, we characterized mosquito population structure using a panel of 8 microsatellite markers and linked results to various potential mechanisms for long-distance dispersal. Adult and immature Ae. aegypti (>20 individuals per site) were collected from Iquitos city and from six neighboring riverine communities, i.e., Nauta, Indiana, Mazan, Barrio Florida, Tamshiaco, and Aucayo. FST statistics indicate significant, but low to moderate differentiation for the majority of study site pairs. Population structure of Ae. aegypti is not correlated with the geographic distance between towns, suggesting that human transportation networks provide a reasonable explanation for the high levels of population mixing. Our results indicate that Ae. aegypti gene flow among sub-populations is greatest between locations with heavy boat traffic, such as Iquitos-Tamshiaco and Iquitos-Indiana-Mazan, and lowest between locations with little or no boat/road traffic between them such as Barrio Florida-Iquitos. Bayesian clustering analysis showed ancestral admixture among three genetic clusters; no single cluster was exclusive to any site. Our results are consistent with the hypothesis that human transportation networks, particularly riverways, are responsible for the geographic spread of Ae. aegypti in the Peruvian Amazon. Our findings are applicable to other regions of the world characterized by networks of urban islands connected by fluvial transport routes

How far will we need to go to reach HIV-infected people in rural South Africa?

Background: The South African Government has outlined detailed plans for antiretroviral (ART) rollout in KwaZulu-Natal Province, but has not created a plan to address treatment accessibility in rural areas in KwaZulu-Natal. Here, we calculate the distance that People Living With HIV/AIDS (PLWHA) in rural areas in KwaZulu-Natal would have to travel to receive ART. Specifically, we address the health policy question 'How far will we need to go to reach PLWHA in rural KwaZulu-Natal?'. Methods: We developed a model to quantify treatment accessibility in rural areas; the model incorporates heterogeneity in spatial location of HCFs and patient population. We defined treatment accessibility in terms of the number of PLWHA that have access to an HCF. We modeled the treatment-accessibility region (i.e. catchment area) around an HCF by using a two-dimensional function, and assumed that treatment accessibility decreases as distance from an HCF increases. Specifically, we used a distance-discounting measure of ART accessibility based upon a modified form of a two-dimensional gravity-type model. We calculated the effect on treatment accessibility of: (1) distance from an HCF, and (2) the number of HCFs. Results: In rural areas in KwaZulu-Natal even substantially increasing the size of a small catchment area (e.g. from 1 km to 20 km) around an HCF would have a negligible impact (~2%) on increasing treatment accessibility. The percentage of PLWHA who can receive ART in rural areas in this province could be as low as ~16%. Even if individuals were willing (and able) to travel 50 km to receive ART, only ~50% of those in need would be able to access treatment. Surprisingly, we show that increasing the number of available HCFs for ART distribution ~ threefold does not lead to a threefold increase in treatment accessibility in rural KwaZulu-Natal. Conclusion: Our results show that many PLWHA in rural KwaZulu-Natal are unlikely to have access to ART, and that the impact of an additional 37 HCFs on treatment accessibility in rural areas would be less substantial than might be expected. There is a great length to go before we will be able to reach many PLWHA in rural areas in South Africa, and specifically in KwaZulu-Natal.David P Wilson and Sally Blowe

Nanocarrier lipid composition modulates the impact of pulmonary surfactant protein B (SP-B) on cellular delivery of siRNA

Two decades since the discovery of the RNA interference (RNAi) pathway, we are now witnessing the approval of the first RNAi-based treatments with small interfering RNA (siRNA) drugs. Nevertheless, the widespread use of siRNA is limited by various extra- and intracellular barriers, requiring its encapsulation in a suitable (nanosized) delivery system. On the intracellular level, the endosomal membrane is a major barrier following endocytosis of siRNA-loaded nanoparticles in target cells and innovative materials to promote cytosolic siRNA delivery are highly sought after. We previously identified the endogenous lung surfactant protein B (SP-B) as siRNA delivery enhancer when reconstituted in (proteo) lipid-coated nanogels. It is known that the surface-active function of SP-B in the lung is influenced by the lipid composition of the lung surfactant. Here, we investigated the role of the lipid component on the siRNA delivery-promoting activity of SP-B proteolipid-coated nanogels in more detail. Our results clearly indicate that SP-B prefers fluid membranes with cholesterol not exceeding physiological levels. In addition, SP-B retains its activity in the presence of different classes of anionic lipids. In contrast, comparable fractions of SP-B did not promote the siRNA delivery potential of DOTAP:DOPE cationic liposomes. Finally, we demonstrate that the beneficial effect of lung surfactant on siRNA delivery is not limited to lung-related cell types, providing broader therapeutic opportunities in other tissues as well

Clinical peripherality: development of a peripherality index for rural health services

BACKGROUND: The configuration of rural health services is influenced by geography. Rural health practitioners provide a broader range of services to smaller populations scattered over wider areas or more difficult terrain than their urban counterparts. This has implications for training and quality assurance of outcomes. This exploratory study describes the development of a "clinical peripherality" indicator that has potential application to remote and rural general practice communities for planning and research purposes. METHODS: Profiles of general practice communities in Scotland were created from a variety of public data sources. Four candidate variables were chosen that described demographic and geographic characteristics of each practice: population density, number of patients on the practice list, travel time to nearest specialist led hospital and travel time to Health Board administrative headquarters. A clinical peripherality index, based on these variables, was derived using factor analysis. Relationships between the clinical peripherality index and services offered by the practices and the staff profile of the practices were explored in a series of univariate analyses. RESULTS: Factor analysis on the four candidate variables yielded a robust one-factor solution explaining 75% variance with factor loadings ranging from 0.83 to 0.89. Rural and remote areas had higher median values and a greater scatter of clinical peripherality indices among their practices than an urban comparison area. The range of services offered and the profile of staffing of practices was associated with the peripherality index. CONCLUSION: Clinical peripherality is determined by the nature of the practice and its location relative to secondary care and administrative and educational facilities. It has features of both gravity model-based and travel time/accessibility indicators and has the potential to be applied to training of staff for rural and remote locations and to other aspects of health policy and planning. It may assist planners in conceptualising the effects on general practices of centralising specialist clinical services or administrative and educational facilities

Efficient handling of SPARQL OPTIONAL for OBDA

OPTIONAL is a key feature in SPARQL for dealing with missing information. While this operator is used extensively, it is also known for its complexity, which can make efficient evaluation of queries with OPTIONAL challenging. We tackle this problem in the Ontology-Based Data Access (OBDA) setting, where the data is stored in a SQL relational database and exposed as a virtual RDF graph by means of an R2RML mapping. We start with a succinct translation of a SPARQL fragment into SQL. It fully respects bag semantics and three-valued logic and relies on the extensive use of the LEFT JOIN operator and COALESCE function. We then propose optimisation techniques for reducing the size and improving the structure of generated SQL queries. Our optimisations capture interactions between JOIN, LEFT JOIN, COALESCE and integrity constraints such as attribute nullability, uniqueness and foreign key constraints. Finally, we empirically verify effectiveness of our techniques on the BSBM OBDA benchmark

Population Distribution, Settlement Patterns and Accessibility across Africa in 2010

The spatial distribution of populations and settlements across a country and their interconnectivity and accessibility from urban areas are important for delivering healthcare, distributing resources and economic development. However, existing spatially explicit population data across Africa are generally based on outdated, low resolution input demographic data, and provide insufficient detail to quantify rural settlement patterns and, thus, accurately measure population concentration and accessibility. Here we outline approaches to developing a new high resolution population distribution dataset for Africa and analyse rural accessibility to population centers. Contemporary population count data were combined with detailed satellite-derived settlement extents to map population distributions across Africa at a finer spatial resolution than ever before. Substantial heterogeneity in settlement patterns, population concentration and spatial accessibility to major population centres is exhibited across the continent. In Africa, 90% of the population is concentrated in less than 21% of the land surface and the average per-person travel time to settlements of more than 50,000 inhabitants is around 3.5 hours, with Central and East Africa displaying the longest average travel times. The analyses highlight large inequities in access, the isolation of many rural populations and the challenges that exist between countries and regions in providing access to services. The datasets presented are freely available as part of the AfriPop project, providing an evidence base for guiding strategic decisions

Do pediatric hospitalizations have a unique geography?

BACKGROUND: In the U.S. small-area health services research studies are often based on the hospital service areas (HSAs) defined by the Dartmouth Atlas of Healthcare project. These areas are based on the geographic origins of Medicare Part A hospital patients, the great majority of whom are seniors. It is reasonable to question whether the geographic system so defined is appropriate for health services research for all ages, particularly for children, who have a very different system of healthcare financing and provision in the U.S. METHODS: This article assesses the need for a unique system of HSAs to support pediatric small-area analyses. It is a cross-sectional analysis of California hospital discharges for two age groups – non-newborns 0–17 years old, and seniors. The measure of interest was index of localization, which is the percentage of HSA residents hospitalized in their home HSA. Indices were computed separately for each age group, and index agreement was assessed for 219 of the state's HSAs. We examined the effect of local pediatric inpatient volume and pediatric inpatient resources on the divergence of the age group indices. We also created a new system of HSAs based solely on pediatric patient origins, and visually compared maps of the traditional and the new system. RESULTS: The mean localization index for pediatric discharges was 20 percentage points lower than for Medicare cases, indicating a poorer fit of the traditional geographic system for children. The volume of pediatric cases did not appear to be associated with the magnitude of index divergence between the two age groups. Pediatric medical and surgical case subgroups gave very similar results, and both groups differed substantially from seniors. Location of children's hospitals and local pediatric bed supply were associated with Medicare-pediatric divergence. There was little visual correspondence between the maps of traditional and pediatric-specific HSAs. CONCLUSION: Children and seniors have significantly different geographic patterns of hospitalization in California. Medicare-based HSAs may not be appropriate for all age groups and service types throughout the U.S

A method to determine spatial access to specialized palliative care services using GIS

Background: Providing palliative care is a growing priority for health service administratorsworldwide as the populations of many nations continue to age rapidly. In many countries, palliativecare services are presently inadequate and this problem will be exacerbated in the coming years.The provision of palliative care, moreover, has been piecemeal in many jurisdictions and there islittle distinction made at present between levels of service provision. There is a pressing need todetermine which populations do not enjoy access to specialized palliative care services in particular.Methods: Catchments around existing specialized palliative care services in the Canadian provinceof British Columbia were calculated based on real road travel time. Census block face populationcounts were linked to postal codes associated with road segments in order to determine thepercentage of the total population more than one hour road travel time from specialized palliativecare.Results: Whilst 81% of the province\u27s population resides within one hour from at least onespecialized palliative care service, spatial access varies greatly by regional health authority. Based onthe definition of specialized palliative care adopted for the study, the Northern Health Authorityhas, for instance, just two such service locations, and well over half of its population do not havereasonable spatial access to such care.Conclusion: Strategic location analysis methods must be developed and used to accurately locatefuture palliative services in order to provide spatial access to the greatest number of people, andto ensure that limited health resources are allocated wisely. Improved spatial access has thepotential to reduce travel-times for patients, for palliative care workers making home visits, and fortravelling practitioners. These methods are particularly useful for health service planners – andprovide a means to rationalize their decision-making. Moreover, they are extendable to a numberof health service allocation problems