On Multiple Semantics for Declarative Database Repairs

We study the problem of database repairs through a rule-based framework that we refer to as Delta Rules. Delta Rules are highly expressive and allow specifying complex, cross-relations repair logic associated with Denial Constraints, Causal Rules, and allowing to capture Database Triggers of interest. We show that there are no one-size-fits-all semantics for repairs in this inclusive setting, and we consequently introduce multiple alternative semantics, presenting the case for using each of them. We then study the relationships between the semantics in terms of their output and the complexity of computation. Our results formally establish the tradeoff between the permissiveness of the semantics and its computational complexity. We demonstrate the usefulness of the framework in capturing multiple data repair scenarios for an Academic Search database and the TPC-H databases, showing how using different semantics affects the repair in terms of size and runtime, and examining the relationships between the repairs. We also compare our approach with SQL triggers and a state-of-the-art data repair system

PRImary care Streptococcal Management (PRISM) study:In vitro study, diagnostic cohorts and a pragmatic adaptive randomised controlled trial with nested qualitative study and cost-effectiveness study

Background: Antibiotics are still prescribed to most patients attending primary care with acute sore throat, despite evidence that there is modest benefit overall from antibiotics. Targeting antibiotics using either clinical scoring methods or rapid antigen detection tests (RADTs) could help. However, there is debate about which groups of streptococci are important (particularly Lancefield groups C and G), and uncertainty about the variables that most clearly predict the presence of streptococci. Objective: This study aimed to compare clinical scores or RADTs with delayed antibiotic prescribing. Design: The study comprised a RADT in vitro study; two diagnostic cohorts to develop streptococcal scores (score 1; score 2); and, finally, an open pragmatic randomised controlled trial with nested qualitative and cost-effectiveness studies. Setting: The setting was UK primary care general practices. Participants: Participants were patients aged ≥ 3 years with acute sore throat. Interventions: An internet program randomised patients to targeted antibiotic use according to (1) delayed antibiotics (control group), (2) clinical score or (3) RADT used according to clinical score. Main outcome measures: The main outcome measures were self-reported antibiotic use and symptom duration and severity on seven-point Likert scales (primary outcome: mean sore throat/difficulty swallowing score in the first 2-4 days). Results: The IMI TestPack Plus Strep A (Inverness Medical, Bedford, UK) was sensitive, specific and easy to use. Lancefield group A/C/G streptococci were found in 40% of cohort 2 and 34% of cohort 1. A five-point score predicting the presence of A/C/G streptococci [FeverPAIN: Fever; Purulence; Attend rapidly (≤ 3 days); severe Inflammation; and No cough or coryza] had moderate predictive value (bootstrapped estimates of area under receiver operating characteristic curve: 0.73 cohort 1, 0.71 cohort 2) and identified a substantial number of participants at low risk of streptococcal infection. In total, 38% of cohort 1 and 36% of cohort 2 scored ≤ 1 for FeverPAIN, associated with streptococcal percentages of 13% and 18%, respectively. In an adaptive trial design, the preliminary score (score 1; n = 1129) was replaced by FeverPAIN (n = 631). For score 1, there were no significant differences between groups. For FeverPAIN, symptom severity was documented in 80% of patients, and was lower in the clinical score group than in the delayed prescribing group (-0.33; 95% confidence interval -0.64 to -0.02; p = 0.039; equivalent to one in three rating sore throat a slight rather than moderately bad problem), and a similar reduction was observed for the RADT group (-0.30; -0.61 to 0.00; p = 0.053). Moderately bad or worse symptoms resolved significantly faster (30%) in the clinical score group (hazard ratio 1.30; 1.03 to 1.63) but not the RADT group (1.11; 0.88 to 1.40). In the delayed group, 75/164 (46%) used antibiotics, and 29% fewer used antibiotics in the clinical score group (risk ratio 0.71; 0.50 to 0.95; p = 0.018) and 27% fewer in the RADT group (0.73; 0.52 to 0.98; p = 0.033). No significant differences in complications or reconsultations were found. The clinical score group dominated both other groups for both the cost/quality-adjusted life-years and cost/change in symptom severity analyses, being both less costly and more effective, and cost-effectiveness acceptability curves indicated the clinical score to be the most likely to be cost-effective from an NHS perspective. Patients were positive about RADTs. Health professionals' concerns about test validity, the time the test took and medicalising self-limiting illness lessened after using the tests. For both RADTs and clinical scores, there were tensions with established clinical experience. Conclusions: Targeting antibiotics using a clinical score (FeverPAIN) efficiently improves symptoms and reduces antibiotic use. RADTs used in combination with FeverPAIN provide no clear advantages over FeverPAIN alone, and RADTs are unlikely to be incorporated into practice until health professionals' concerns are met and they have experience of using them. Clinical scores also face barriers related to clinicians' perceptions of their utility in the face of experience. This study has demonstrated the limitation of using one data set to develop a clinical score. FeverPAIN, derived from two data sets, appears to be valid and its use improves outcomes, but diagnostic studies to confirm the validity of FeverPAIN in other data sets and settings are needed. Experienced clinicians need to identify barriers to the use of clinical scoring methods. Implementation studies that address perceived barriers in the use of FeverPAIN are needed

Comment letters to the National Commission on Commission on Fraudulent Financial Reporting, 1987 (Treadway Commission) Vol. 2

https://egrove.olemiss.edu/aicpa_sop/1662/thumbnail.jp

Nearfield Summary and Statistical Analysis of the Second AIAA Sonic Boom Prediction Workshop

A summary is provided for the Second AIAA Sonic Boom Workshop held 8-9 January 2017 in conjunction with AIAA SciTech 2017. The workshop used three required models of increasing complexity: an axisymmetric body, a wing body, and a complete configuration with flow-through nacelle. An optional complete configuration with propulsion boundary conditions is also provided. These models are designed with similar nearfield signatures to isolate geometry and shock/expansion interaction effects. Eleven international participant groups submitted nearfield signatures with forces, pitching moment, and iterative convergence norms. Statistics and grid convergence of these nearfield signatures are presented. These submissions are propagated to the ground, and noise levels are computed. This allows the grid convergence and the statistical distribution of a noise level to be computed. While progress is documented since the first workshop, improvement to the analysis methods for a possible subsequent workshop are provided. The complete configuration with flow-through nacelle showed the most dramatic improvement between the two workshops. The current workshop cases are more relevant to vehicles with lower loudness and have the potential for lower annoyance than the first workshop cases. The models for this workshop with quieter ground noise levels than the first workshop exposed weaknesses in analysis, particularly in convective discretization

The burden and treatment of HIV in tuberculosis patients in Papua Province, Indonesia: a prospective observational study

<p>Abstract</p> <p>Background</p> <p>New diagnoses of tuberculosis (TB) present important opportunities to detect and treat HIV. Rates of HIV and TB in Indonesia's easternmost Papua Province exceed national figures, but data on co-infection rates and outcomes are lacking. We aimed to measure TB-HIV co-infection rates, examine longitudinal trends, compare management with World Health Organisation (WHO) recommendations, and document progress and outcome.</p> <p>Methods</p> <p>Adults with newly-diagnosed smear-positive pulmonary TB managed at the Timika TB clinic, Papua Province, were offered voluntary counselling and testing for HIV in accordance with Indonesian National Guidelines, using a point-of-care antibody test. Positive tests were confirmed with 2 further rapid tests. Study participants were assessed using clinical, bacteriological, functional and radiological measures and followed up for 6 months.</p> <p>Results</p> <p>Of 162 participants, HIV status was determined in 138 (85.2%), of whom 18 (13.0%) were HIV+. Indigenous Papuans were significantly more likely to be HIV+ than Non-Papuans (Odds Ratio [OR] 4.42, 95% confidence interval [CI] 1.38-14.23). HIV prevalence among people with TB was significantly higher than during a 2003-4 survey at the same TB clinic, and substantially higher than the Indonesian national estimate of 3%. Compared with HIV- study participants, those with TB-HIV co-infection had significantly lower exercise tolerance (median difference in 6-minute walk test: 25 m, p = 0.04), haemoglobin (mean difference: 1.3 g/dL, p = 0.002), and likelihood of cavitary disease (OR 0.35, 95% CI 0.12-1.01), and increased occurrence of pleural effusion (OR 3.60, 95% CI 1.70-7.58), higher rates of hospitalisation or death (OR 11.80, 95% CI 1.82-76.43), but no difference in the likelihood of successful 6-month treatment outcome. Adherence to WHO guidelines was limited by the absence of integration of TB and HIV services, specifically, with no on-site ART prescriber available. Only six people had CD4+ T-cell counts recorded, 11 were prescribed co-trimoxazole and 4 received ART before, during or after TB treatment, despite ART being indicated in 14 according to 2006 WHO guidelines.</p> <p>Conclusions</p> <p>TB-HIV co-infection in southern Papua, Indonesia, is a serious emerging problem especially among the Indigenous population, and has risen rapidly in the last 5 years. Major efforts are required to incorporate new WHO recommendations on TB-HIV management into national guidelines, and support their implementation in community settings.</p

Mechanical Properties of High and Very-High Strength Steel at Elevated Temperatures and After Cooling Down

High-strength steels (HSS) are produced using special chemical composition or/and manufacturing processes. Both aspects affect their mechanical properties at elevated temperatures and after cooling down, and particularly the residual strength and the ductility of the structural members. As HSS equates the design of lighter structural elements, higher temperatures are developed internally compared to the elements designed with conventional carbon steel. Therefore, the low thickness members, along with the severe effect of high temperature on the mechanical properties of the HSS, constitute to the increased vulnerability of such structures in fire. Moreover, the re-use and reinstatement of these structures are more challenging due to the lower residual mechanical properties of HSS after the cooling down period. This paper presents a review of the available experimental studies of the mechanical properties of HSS at elevated temperatures and after cooling down. The experimental results are collected and compared with the proposed material model (reduction factors) of EN1993–1-2. Based on these comparisons, modified equations describing the effect of elevated temperatures on the mechanical properties of HSS are proposed. Also, the post-fire mechanical properties of HSS are examined. A comprehensive discussion on the effect of influencing parameters, such as manufacturing process, microstructure, loading conditions, maximum temperature, and others is further explored