On the Quality of Relational Database Schemas in Open-source Software

International audienceThe relational schemas of 512 open-source projects storing their data in MySQL or PostgreSQL databases are investigated by querying the standard information schema, looking for overall design issues. The set of SQL queries used in our research is released as the Salix free software. As it is fully relational and relies on standards, it may be installed in any compliant database to help improve schemas. Our research shows that the overall quality of the surveyed schemas is poor: a majority of projects have at least one table without any primary key or unique constraint to identify a tuple; data security features such as referential integrity or transactional back-ends are hardly used; projects that advertise supporting both databases often have missing tables or attributes. PostgreSQL projects appear to be of higher quality than MySQL projects, and have been updated more recently, suggesting a more active maintenance. This is even better for projects with PostgreSQL-only support. However, the quality difference between both databases management systems is mostly due to MySQL-specific issues. An overall predictor of bad database quality is that a project chooses MySQL or PHP, while good design is found with PostgreSQL and Java. The few declared constraints allow to detect latent bugs, that are worth fixing: more declarations would certainly help unveil more bugs. Our survey also suggests that some features of MySQL and PostgreSQL are particularly error-prone. This first survey on the quality of relational schemas in open-source software provides a unique insight in the data engineering practice of these projects

A Field Analysis of Relational Database Schemas in Open-source Software (Extended)

International audienceThe relational schemas of 512 open-source projects storing their data in MySQL or PostgreSQL databases are investigated by querying the standard information schema, looking for various issues. These SQL queries are released as the Salix free software. As it is fully relational and relies on standards, it may be installed in any compliant database to help improve schemas. The overall quality of the surveyed schemas is poor: a majority of projects have at least one table without any primary key or unique constraint to identify a tuple; data security features such as referential integrity or transactional back-ends are hardly used; projects that advertise supporting both databases often have missing tables or attributes. PostgreSQL projects have a better quality compared to MySQL projects, and it is even better for projects with PostgreSQL-only support. However, the difference between both databases is mostly due to MySQL-specific issues. An overall predictor of bad database quality is that a project chooses MySQL or PHP, while good design is found with PostgreSQL and Java. The few declared constraints allow to detect latent bugs, that are worth fixing: more declarations would certainly help unveil more bugs. Our survey also suggests some features of MySQL and PostgreSQL as particularly error-prone. This first survey on the quality of relational schemas in open-source software provides a unique insight in the data engineering practice of these project

Treatment of HCV with ABT-450/r-ombitasvir and dasabuvir with ribavirin

BACKGROUND The interferon-free combination of the protease inhibitor ABT-450 with ritonavir (ABT-450/r) and the NS5A inhibitor ombitasvir (also known as ABT-267) plus the nonnucleoside polymerase inhibitor dasabuvir (also known as ABT-333) and ribavirin has shown efficacy against the hepatitis C virus (HCV) in patients with HCV genotype 1 infection. In this phase 3 trial, we evaluated this regimen in previously untreated patients with HCV genotype 1 infection and no cirrhosis

Distinguishing the Impacts of Inadequate Prey and Vessel Traffic on an Endangered Killer Whale (Orcinus orca) Population

Managing endangered species often involves evaluating the relative impacts of multiple anthropogenic and ecological pressures. This challenge is particularly formidable for cetaceans, which spend the majority of their time underwater. Noninvasive physiological approaches can be especially informative in this regard. We used a combination of fecal thyroid (T3) and glucocorticoid (GC) hormone measures to assess two threats influencing the endangered southern resident killer whales (SRKW; Orcinus orca) that frequent the inland waters of British Columbia, Canada and Washington, U.S.A. Glucocorticoids increase in response to nutritional and psychological stress, whereas thyroid hormone declines in response to nutritional stress but is unaffected by psychological stress. The inadequate prey hypothesis argues that the killer whales have become prey limited due to reductions of their dominant prey, Chinook salmon (Oncorhynchus tshawytscha). The vessel impact hypothesis argues that high numbers of vessels in close proximity to the whales cause disturbance via psychological stress and/or impaired foraging ability. The GC and T3 measures supported the inadequate prey hypothesis. In particular, GC concentrations were negatively correlated with short-term changes in prey availability. Whereas, T3 concentrations varied by date and year in a manner that corresponded with more long-term prey availability. Physiological correlations with prey overshadowed any impacts of vessels since GCs were lowest during the peak in vessel abundance, which also coincided with the peak in salmon availability. Our results suggest that identification and recovery of strategic salmon populations in the SRKW diet are important to effectively promote SRKW recovery

Australia's National Bowel Cancer Screening Program: does it work for Indigenous Australians?

<p>Abstract</p> <p>Background</p> <p>Despite a lower incidence of bowel cancer overall, Indigenous Australians are more likely to be diagnosed at an advanced stage when prognosis is poor. Bowel cancer screening is an effective means of reducing incidence and mortality from bowel cancer through early identification and prompt treatment. In 2006, Australia began rolling out a population-based National Bowel Cancer Screening Program (NBCSP) using the Faecal Occult Blood Test. Initial evaluation of the program revealed substantial disparities in bowel cancer screening uptake with Indigenous Australians significantly less likely to participate in screening than the non-Indigenous population.</p> <p>This paper critically reviews characteristics of the program which may contribute to the discrepancy in screening uptake, and includes an analysis of organisational, structural, and socio-cultural barriers that play a part in the poorer participation of Indigenous and other disadvantaged and minority groups.</p> <p>Methods</p> <p>A search was undertaken of peer-reviewed journal articles, government reports, and other grey literature using electronic databases and citation snowballing. Articles were critically evaluated for relevance to themes that addressed the research questions.</p> <p>Results</p> <p>The NBCSP is not reaching many Indigenous Australians in the target group, with factors contributing to sub-optimal participation including how participants are selected, the way the screening kit is distributed, the nature of the test and comprehensiveness of its contents, cultural perceptions of cancer and prevailing low levels of knowledge and awareness of bowel cancer and the importance of screening.</p> <p>Conclusions</p> <p>Our findings suggest that the population-based approach to implementing bowel cancer screening to the Australian population unintentionally excludes vulnerable minorities, particularly Indigenous and other culturally and linguistically diverse groups. This potentially contributes to exacerbating the already widening disparities in cancer outcomes that exist among Indigenous Australians. Modifications to the program are recommended to facilitate access and participation by Indigenous and other minority populations. Further research is also needed to understand the needs and social and cultural sensitivities of these groups around cancer screening and inform alternative approaches to bowel cancer screening.</p

Optimasi Portofolio Resiko Menggunakan Model Markowitz MVO Dikaitkan dengan Keterbatasan Manusia dalam Memprediksi Masa Depan dalam Perspektif Al-Qur`an

Risk portfolio on modern finance has become increasingly technical, requiring the use of sophisticated mathematical tools in both research and practice. Since companies cannot insure themselves completely against risk, as human incompetence in predicting the future precisely that written in Al-Quran surah Luqman verse 34, they have to manage it to yield an optimal portfolio. The objective here is to minimize the variance among all portfolios, or alternatively, to maximize expected return among all portfolios that has at least a certain expected return. Furthermore, this study focuses on optimizing risk portfolio so called Markowitz MVO (Mean-Variance Optimization). Some theoretical frameworks for analysis are arithmetic mean, geometric mean, variance, covariance, linear programming, and quadratic programming. Moreover, finding a minimum variance portfolio produces a convex quadratic programming, that is minimizing the objective function ðð¥with constraintsð ð 𥠥 ðandð´ð¥ = ð. The outcome of this research is the solution of optimal risk portofolio in some investments that could be finished smoothly using MATLAB R2007b software together with its graphic analysis

Differential cross section measurements for the production of a W boson in association with jets in proton–proton collisions at √s = 7 TeV

Measurements are reported of differential cross sections for the production of a W boson, which decays into a muon and a neutrino, in association with jets, as a function of several variables, including the transverse momenta (pT) and pseudorapidities of the four leading jets, the scalar sum of jet transverse momenta (HT), and the difference in azimuthal angle between the directions of each jet and the muon. The data sample of pp collisions at a centre-of-mass energy of 7 TeV was collected with the CMS detector at the LHC and corresponds to an integrated luminosity of 5.0 fb[superscript −1]. The measured cross sections are compared to predictions from Monte Carlo generators, MadGraph + pythia and sherpa, and to next-to-leading-order calculations from BlackHat + sherpa. The differential cross sections are found to be in agreement with the predictions, apart from the pT distributions of the leading jets at high pT values, the distributions of the HT at high-HT and low jet multiplicity, and the distribution of the difference in azimuthal angle between the leading jet and the muon at low values.United States. Dept. of EnergyNational Science Foundation (U.S.)Alfred P. Sloan Foundatio

Juxtaposing BTE and ATE – on the role of the European insurance industry in funding civil litigation

One of the ways in which legal services are financed, and indeed shaped, is through private insurance arrangement. Two contrasting types of legal expenses insurance contracts (LEI) seem to dominate in Europe: before the event (BTE) and after the event (ATE) legal expenses insurance. Notwithstanding institutional differences between different legal systems, BTE and ATE insurance arrangements may be instrumental if government policy is geared towards strengthening a market-oriented system of financing access to justice for individuals and business. At the same time, emphasizing the role of a private industry as a keeper of the gates to justice raises issues of accountability and transparency, not readily reconcilable with demands of competition. Moreover, multiple actors (clients, lawyers, courts, insurers) are involved, causing behavioural dynamics which are not easily predicted or influenced. Against this background, this paper looks into BTE and ATE arrangements by analysing the particularities of BTE and ATE arrangements currently available in some European jurisdictions and by painting a picture of their respective markets and legal contexts. This allows for some reflection on the performance of BTE and ATE providers as both financiers and keepers. Two issues emerge from the analysis that are worthy of some further reflection. Firstly, there is the problematic long-term sustainability of some ATE products. Secondly, the challenges faced by policymakers that would like to nudge consumers into voluntarily taking out BTE LEI

Penilaian Kinerja Keuangan Koperasi di Kabupaten Pelalawan

This paper describe development and financial performance of cooperative in District Pelalawan among 2007 - 2008. Studies on primary and secondary cooperative in 12 sub-districts. Method in this stady use performance measuring of productivity, efficiency, growth, liquidity, and solvability of cooperative. Productivity of cooperative in Pelalawan was highly but efficiency still low. Profit and income were highly, even liquidity of cooperative very high, and solvability was good

Search for stop and higgsino production using diphoton Higgs boson decays

Results are presented of a search for a "natural" supersymmetry scenario with gauge mediated symmetry breaking. It is assumed that only the supersymmetric partners of the top-quark (stop) and the Higgs boson (higgsino) are accessible. Events are examined in which there are two photons forming a Higgs boson candidate, and at least two b-quark jets. In 19.7 inverse femtobarns of proton-proton collision data at sqrt(s) = 8 TeV, recorded in the CMS experiment, no evidence of a signal is found and lower limits at the 95% confidence level are set, excluding the stop mass below 360 to 410 GeV, depending on the higgsino mass