Using Business Intelligence to Improve DBA Productivity

The amount of data collected and used by companies has grown rapidly in size over the last decade. Business leaders are now using Business Intelligence (BI) systems to make effective business decisions against large amounts of data. The growth in the size of data has been a major challenge for Database Administrators (DBAs). The increase in the number and size of databases at the speed they have grown has made it difficult for DBA teams to provide the same level of service that the business requires they provide. The methods that DBAs have used in the last several decades can no longer be performed with the efficiency needed over all of the databases they administer. This paper presents the first BI system to improve DBA productivity and providing important data metrics for Information Technology (IT) managers. The BI system has been well received by Sherwin Williams Database Administrators. It has i) enabled the DBA team to quickly determine which databases needed work by a DBA without manually logging into the system; ii) helped the DBA team and its management to easily answer other business users' questions without using DBAs' time to research the issue; and iii) helped the DBA team to provide the business data for unanticipated audit request

Frequency Of Development Of Connective Tissue Disease In Statin-Users Versus Nonusers

Statins have pleiotropic properties that may affect the development of connective tissue diseases (CTD). The objective of this study was to compare the risk of CTD diagnoses in statin users and nonusers. This study was a propensity score-matched analysis of adult patients (30 to 85 years old) in the San Antonio military medical community. The study was divided into baseline (October 1, 2003 to September 30, 2005), and follow-up (October 1, 2005 to March 5, 2010) periods. Statin users received a statin prescription during fiscal year 2005. Nonusers did not receive a statin at any time during the study. The outcome measure was the occurrence of 3 diagnosis codes of the International Classification of Diseases, 9th Revision, Clinical Modification consistent with CTD. We described co-morbidities during the baseline period using the Charlson Comorbidity Index. We created a propensity score based on 41 variables. We then matched statin users and nonusers 1:1, using a caliper of 0.001. Of 46,488 patients who met study criteria (13,640 statin users and 32,848 nonusers), we matched 6,956 pairs of statin users and nonusers. Matched groups were similar in terms of patient age, gender, incidence of co-morbidities, total Charlson Comorbidity Index, health care use, and medication use. The odds ratio for CTD was lower in statin users than nonusers (odds ratio: 0.80; 95% confidence interval: 0.64 to 0.99; p = 0.05). Secondary analysis and sensitivity analysis confirmed these results. In conclusion, statin use was associated with a lower risk of CTD. Published by Elsevier Inc.Pharmac

Racial variations in processes of care for patients with community-acquired pneumonia

BACKGROUND: Patients hospitalized with community acquired pneumonia (CAP) have a substantial risk of death, but there is evidence that adherence to certain processes of care, including antibiotic administration within 8 hours, can decrease this risk. Although national mortality data shows blacks have a substantially increased odds of death due to pneumonia as compared to whites previous studies of short-term mortality have found decreased mortality for blacks. Therefore we examined pneumonia-related processes of care and short-term mortality in a population of patients hospitalized with CAP. METHODS: We reviewed the records of all identified Medicare beneficiaries hospitalized for pneumonia between 10/1/1998 and 9/30/1999 at one of 101 Pennsylvania hospitals, and randomly selected 60 patients at each hospital for inclusion. We reviewed the medical records to gather process measures of quality, pneumonia severity and demographics. We used Medicare administrative data to identify 30-day mortality. Because only a small proportion of the study population was black, we included all 240 black patients and randomly selected 720 white patients matched on age and gender. We performed a resampling of the white patients 10 times. RESULTS: Males were 43% of the cohort, and the median age was 76 years. After controlling for potential confounders, blacks were less likely to receive antibiotics within 8 hours (odds ratio with 95% confidence interval 0.6, 0.4–0.97), but were as likely as whites to have blood cultures obtained prior to receiving antibiotics (0.7, 0.3–1.5), to have oxygenation assessed within 24 hours of presentation (1.6, 0.9–3.0), and to receive guideline concordant antibiotics (OR 0.9, 0.6–1.7). Black patients had a trend towards decreased 30-day mortality (0.4, 0.2 to 1.0). CONCLUSION: Although blacks were less likely to receive optimal care, our findings are consistent with other studies that suggest better risk-adjusted survival among blacks than among whites. Further study is needed to determine why this is the case

The impact of empiric antimicrobial therapy with a β-lactam and fluoroquinolone on mortality for patients hospitalized with severe pneumonia

INTRODUCTION: National clinical practice guidelines have recommended specific empiric antimicrobial regimes for patients with severe community-acquired pneumonia. However, evidence confirming improved mortality with many of these regimes is lacking. Our aim was to determine the association between the empiric use of a β-lactam with fluoroquinolone, compared with other recommended antimicrobial therapies, and mortality in patients hospitalized with severe community-acquired pneumonia. METHODS: A retrospective observational study was conducted at two tertiary teaching hospitals. Eligible subjects were admitted with a diagnosis of community-acquired pneumonia and had a chest X-ray and a discharge ICD-9 diagnosis consistent with this. Subjects were excluded if they received 'comfort measures only' during the admission, had been transferred from another acute care hospital, did not meet criteria for severe pneumonia, or were treated with non-guideline-concordant antibiotics. A multivariable logistic regression model was used to assess the association between 30-day mortality and the use of a β-lactam antibiotic with a fluoroquinolone compared with other guideline-concordant therapies, after adjustment for potential confounders including a propensity score. RESULTS: Data were abstracted on 172 subjects at the two hospitals. The mean age was 63.5 years (SD 15.0). The population was 88% male; 91% were admitted through the emergency department and 62% were admitted to the intensive care unit within the first 24 hours after admission. Mortality was 19.8% at 30 days. After adjustment for potential confounders the use of a β-lactam with a fluoroquinolone (odds ratio 2.71, 95% confidence interval 1.2 to 6.1) was associated with increased mortality. CONCLUSION: The use of initial empiric antimicrobial therapy with a β-lactam and a fluoroquinolone was associated with increased short-term mortality for patients with severe pneumonia in comparison with other guideline-concordant antimicrobial regimes. Further research is needed to determine the range of appropriate empiric antimicrobial therapies for patients with severe community-acquired pneumonia

Mitigating crime and violence in coca-growing areas

Puzzled about why and how coca-growing areas in Bolivia do not have the same levels of violence and criminality experienced in their communities, eight peasant leaders from various coca-growing areas of Colombia joined a study tour to investigate. Notwithstanding differences in histories of conflict, political economy, infrastructure, and state-society relations, two explanations stood out. First, the usually overlooked intermediation role of strong local, self-help, and typically non-state institutions in peasant communities that enables marginalised households to assert their interests in interactions with both state and market structures appear as a key factor in mitigating violence and criminal activity. Second, land tenure security, access to public services, and diversifying local economies that draw land and labour away from illicit coca production could address the factors that draw in poor subsistence farmers, including unemployed and under-employed rural workers, to the illicit trade. This paper presents a documentation of the study tour, elaborates on the thinking behind the two explanations, and flags signposts for possible use in improving public policy on drugs and development

Transcriptomic responses in the blood and sputum of cigarette smokers compared to e-cigarette vapers.

RATIONALE: Electronic (e)-cigarettes are popular among youth and cigarette smokers attempting to quit. Studies to date have focused on the utility of e-cigarettes as a smoking cessation tool, but the biological effects are largely unknown. OBJECTIVES: To identify transcriptomic differences in the blood and sputum of e-cigarette users compared to conventional cigarettes smokers and healthy controls and describe biological pathways affected by these tobacco products. METHODS: Cross-sectional analysis of whole blood and sputum RNA-sequencing data from 8 smokers, 9 e-cigarette users (e-cigs) and 4 controls. Weighted gene co-network analysis (WGCNA) identified gene module associations. Ingenuity Pathway Analysis (IPA) identified canonical pathways associated with tobacco products. MAIN RESULTS: In blood, a three-group comparison showed 16 differentially expressed genes (DEGs); pair-wise comparison showed 7 DEGs between e-cigs and controls, 35 DEGs between smokers and controls, and 13 DEGs between smokers and e-cigs. In sputum, 438 DEGs were in the three-group comparison. In pair-wise comparisons, there were 2 DEGs between e-cigs and controls, 270 DEGs between smokers and controls, and 468 DEGs between smokers and e-cigs. Only 2 genes in the smokers vs. control comparison overlapped between blood and sputum. Most gene modules identified through WGCNA associated with tobacco product exposures also were associated with cotinine and exhaled CO levels. IPA showed more canonical pathways altered by conventional cigarette smoking than by e-cigarette use. CONCLUSION: Cigarette smoking and e-cigarette use led to transcriptomic changes in both blood and sputum. However, conventional cigarettes induced much stronger transcriptomic responses in both compartments