Data Warehouses in Public Schools: Lessons Learned in an On-Going Implementation

Over the last several years data warehouses and data marts have been increasingly used in commercial business enterprises to support decision making. However, this technology has not been as widely adopted in not-forprofit enterprises and public education in particular. Public education is coming under increased scrutiny as grass-roots support for spending is on the wane and accountability expectations for resource utilization are increasing. Data warehousing can effectively support data-driven decision making and represents a logical area for investment. This paper describes a partnership between a major metropolitan university and a large urban school district to deploy a comprehensive studentcentered data warehouse to support educators and administrators in their day-to-day operations. It addresses managerial, technical, and political issues faced in the implementation

Avaliação das condições de saúde no Rio Grande do Sul

Por meio de um conjunto de indicadores de saúde, pretendeu-se hierarquizar as delegacias regionais de saúde do Estado do Rio Grande do Sul (Brasil), no período de 1979 a 1982. Selecionaram-se cinco indicadores clássicos: mortalidade proporcional em menores de cinco anos, coeficiente de Swaroop-Uemura, coeficiente de mortalidade infantil, mortalidade proporcional por doenças infecciosas e percentual de óbitos mal definidos que apresentaram maior peso relativo usando metodologia de análise fatorial. Estes indicadores foram padronizados, utilizando a variável Z, ponderados, utilizando coeficiente de escore fatorial, e as regiões administrativas foram classificadas em sete grupos. Todos os grupos apresentaram melhora no nível de saúde, no período observado. Através do conceito de risco foram sugeridos alguns indicadores para integrarem a vigilância epidemiológica de saúde que permitiram hierarquizar as delegacias regionais de saúde, com vistas a estabelecer prioridades em termos de ações de saúde e aplicação de recursos.By the use of a group of health statistics, this study classifies the health status of the administrative regions in Rio Grande do Sul (Brazil) for the period form 1979 to 1982. Five classic health parameters were chosen according to the following criteria: accessibility to a hisitorical series of three years; necessarily part of an information system currently in use and having a high rate of factorial score. Each parameter was weighed (CEF) for "Health Level", "Immunization Level" and "Medical Care Level". They were: proportional mortality under five years, Swaroop-Uemura, infant mortality rate, proportional mortality for infectious diseases and percentage of undefined deaths. The parameters were standardized by a Z-variable and weighed by factorial score rate. In this way the final score was obtained for each administrative region. Such a score is a fusion of five parameters in one, making the data comparison easier. The administrative regions were classified in seven groups. It was possible to identify regions where investment is needed, i.e., where health levels are low. Apart from this study's principal purpose, it was found that the regions with the lowest health levels are characteristically agricultural, with large rural properties and marked distinctions in social class. It is suggested that the parameters should be used as instruments in a model for epidemiological surveillance which would show the present situation of the health/disease ratio in a population

Field-deployable, quantitative, rapid identification of active Ebola virus infection in unprocessed blood

The West African Ebola virus outbreak underlined the importance of delivering mass diagnostic capability outside the clinical or primary care setting in effectively containing public health emergencies caused by infectious disease. Yet, to date, there is no solution for reliably deploying at the point of need the gold standard diagnostic method, real time quantitative reverse transcription polymerase chain reaction (RT- qPCR), in a laboratory infrastructure-free manner. In this proof of principle work, we demonstrate direct performance of RT-qPCR on fresh blood using far-red fluorophores to resolve fluorogenic signal inhibition and controlled, rapid freeze/thawing to achieve viral genome extraction in a single reaction chamber assay. The resulting process is entirely free of manual or automated sample pre-processing, requires no microfluidics or magnetic/mechanical sample handling and thus utilizes low cost consumables. This enables a fast, laboratory infrastructure-free, minimal risk and simple standard operating procedure suited to frontline, field use. Developing this novel approach on recombinant bacteriophage and recombinant human immunodeficiency virus (HIV; Lentivirus), we demonstrate clinical utility in symptomatic EBOV patient screening using live, infectious Filoviruses and surrogate patient samples. Moreover, we evidence assay co-linearity independent of viral particle structure that may enable viral load quantification through pre-calibration, with no loss of specificity across an 8 log- linear maximum dynamic range. The resulting quantitative rapid identification (QuRapID) molecular diagnostic platform, openly accessible for assay development, meets the requirements of resource- limited countries and provides a fast response solution for mass public health screening against emerging biosecurity threats

Perception and valuations of community-based education and service by alumni at Makerere University College of Health Sciences

<p>Abstract</p> <p>Background</p> <p>Training of health professionals can be deliberately structured to enhance rural recruitment by exposing the trainees to the realities of rural life and practice through Community-Based Education and Service (COBE) programs. Few studies have surveyed the alumni of these programs to establish their post-university views and whether the positive impact of COBE programs endures into the post-university life. This study surveyed the alumni of COBE at Makerere to obtain their perceptions of the management and administration of COBE and whether COBE had helped develop their confidence as health workers, competence in primary health care and willingness and ability to work in rural communities.</p> <p>Objectives</p> <p>• To assess the efficiency of the management and administration of COBES.</p> <p>• To obtain the views of the impact of COBES on its alumni.</p> <p>Methods</p> <p>A mixed qualitative and quantitative study was conducted using focus group discussions (FGD) and a telephone administered questionnaire. From a total of 300 COBES alumni 150 were contacted. Twenty four Alumni (13 females and 11 males) were purposefully selected by discipline, gender and place of work, and invited for the focus group discussion. The discussions were transcribed and analyzed using a manifest content analysis table. The thematic issues from the FGDs were used to develop a structured questionnaire which was administered by telephone by the authors. The data were entered into Microsoft excel template and exported to Stata for analysis. The findings of the telephone survey were used to cross-match the views expressed during the focus group discussions.</p> <p>Results</p> <p>The alumni almost unanimously agree that the initial three years of COBES were very successful in terms of administration and coordination. COBES was credited for contributing to development of confidence as health workers, team work, communication skills, competence in primary health care and willingness to work in rural areas. The COBES alumni also identified various challenges associated with administration and coordination of COBES at Makerere.</p> <p>Conclusions</p> <p>This study has established that the positive impact of COBES endures with the alumni of the program. Health planners should take advantage of the impact of COBES and provide it with more support.</p

Structural Basis of Enzymatic Activity for the Ferulic Acid Decarboxylase (FADase) from Enterobacter sp. Px6-4

Microbial ferulic acid decarboxylase (FADase) catalyzes the transformation of ferulic acid to 4-hydroxy-3-methoxystyrene (4-vinylguaiacol) via non-oxidative decarboxylation. Here we report the crystal structures of the Enterobacter sp. Px6-4 FADase and the enzyme in complex with substrate analogues. Our analyses revealed that FADase possessed a half-opened bottom β-barrel with the catalytic pocket located between the middle of the core β-barrel and the helical bottom. Its structure shared a high degree of similarity with members of the phenolic acid decarboxylase (PAD) superfamily. Structural analysis revealed that FADase catalyzed reactions by an “open-closed” mechanism involving a pocket of 8×8×15 Å dimension on the surface of the enzyme. The active pocket could directly contact the solvent and allow the substrate to enter when induced by substrate analogues. Site-directed mutagenesis showed that the E134A mutation decreased the enzyme activity by more than 60%, and Y21A and Y27A mutations abolished the enzyme activity completely. The combined structural and mutagenesis results suggest that during decarboxylation of ferulic acid by FADase, Trp25 and Tyr27 are required for the entering and proper orientation of the substrate while Glu134 and Asn23 participate in proton transfer

Comparative and demographic analysis of orang-utan genomes

Orang-utan- is derived from a Malay term meaning man of the forest- and aptly describes the southeast Asian great apes native to Sumatra and Borneo. The orang-utan species, Pongo abelii (Sumatran) and Pongo pygmaeus (Bornean), are the most phylogenetically distant great apes from humans, thereby providing an informative perspective on hominid evolution. Here we present a Sumatran orang-utan draft genome assembly and short read sequence data from five Sumatran and five Bornean orang-utan genomes. Our analyses reveal that, compared to other primates, the orang-utan genome has many unique features. Structural evolution of the orang-utan genome has proceeded much more slowly than other great apes, evidenced by fewer rearrangements, less segmental duplication, a lower rate of gene family turnover and surprisingly quiescent Alu repeats, which have played a major role in restructuring other primate genomes. We also describe a primate polymorphic neocentromere, found in both Pongo species, emphasizing the gradual evolution of orang-utan genome structure. Orang-utans have extremely low energy usage for a eutherian mammal, far lower than their hominid relatives. Adding their genome to the repertoire of sequenced primates illuminates new signals of positive selection in several pathways including glycolipid metabolism. From the population perspective, both Pongo species are deeply diverse; however, Sumatran individuals possess greater diversity than their Bornean counterparts, and more species-specific variation. Our estimate of Bornean/Sumatran speciation time, 400,000years ago, is more recent than most previous studies and underscores the complexity of the orang-utan speciation process. Despite a smaller modern census population size, the Sumatran effective population size (N e) expanded exponentially relative to the ancestral N e after the split, while Bornean N e declined over the same period. Overall, the resources and analyses presented here offer new opportunities in evolutionary genomics, insights into hominid biology, and an extensive database of variation for conservation efforts. © 2011 Macmillan Publishers Limited. All rights reserved

Improving community health networks for people with severe mental illness : a case study investigation

Introduction Policy drivers in mental health to address personal recovery, stigma and poor physical health indicate that new service solutions are required. This study aimed to understand how connections to people, places and activities were utilised by individuals with severe mental illness (SMI) to benefit health and wellbeing. Methods A five-module mixed-methods design was undertaken in two study sites. Data were collected from 150 network-mapping interviews and 41 in-depth follow-up interviews with people with SMI; in-depth interviews with 30 organisation stakeholders and 12 organisation leaders; and 44 telephone interviews with practitioners. We undertook a three-stage synthesis process including independent lived experience feedback, and a patient and public involvement team participated in tool design, data collection, analysis and write-up. Results Three personal network types were found in our study using the community health network approach: diverse and active; family and stable; formal and sparse. Controlled for other factors we found only four variables significantly associated with which network type a participant had: living alone or not; housing status; formal education; long-term sickness or disability. Diagnosis was not a factor. These variables are challenging to address but they do point to potential for network change. The qualitative interviews with people with SMI provided further understanding of connection-building and resource utilisation. We explored individual agency across each network type, and identified recognition of the importance and value of social support and active connection management alongside the risks of isolation, even for those most affected by mental illness. We identified tensions in personal networks, be that relationships with practitioners or families, dealing with the impact of stigma, or frustrations of not being in employment, which all impact on network resources and well-being. The value of connectedness within personal networks of people, place and activity for supporting recovery was evident in shaping identity, providing meaning to life and sense of belonging, gaining access to new resources, structuring routines and helping individuals ‘move on’ in their recovery journey. Health-care practitioners recognised that social factors were important in recovery but reported system-level barriers (workload, administrative bureaucracy, limited contact time with clients) in addressing these issues fully. Even practitioners working in third-sector services whose remit involved increasing clients’ social connection faced restrictions due to being evaluated by outcome criteria that limited holistic recovery-focused practices. Service providers were keen to promote recovery-focused approaches. We found contrasts between recovery ideology within mental health policy and recovery practice on the ground. In particular, the social aspects of supporting people with SMI are often underprioritised in the health-care system. In a demanding and changing context, strategic multiagency working was seen as crucial but we found few examples of embedded multisector organisation partnerships. Conclusion While our exploratory study has limitations, findings suggest potential for people with SMI to be supported to become more active managers of their personal networks to support well-being regardless of current network type. The health and social care system does not currently deliver multiagency integrated solutions to support SMI and social recovery

Professional Service Utilisation among Patients with Severe Mental Disorders

<p>Abstract</p> <p>Background</p> <p>Generally, patients with serious mental disorders (SMD) are frequent users of services who generate high care-related costs. Current reforms aim to increase service integration and primary care for improved patient care and health-care efficiency. This article identifies and compares variables associated with the use by patients with SMD of services offered by psychiatrists, case managers, and general practitioners (GPs). It also compares frequent and infrequent service use.</p> <p>Method</p> <p>One hundred forty patients with SMD from five regions in Quebec, Canada, were interviewed on their use of services in the previous year. Patients were also required to complete a questionnaire on needs-assessment. In addition, data were collected from clinical records. Descriptive, bivariate, and multivariate analyses were conducted.</p> <p>Results</p> <p>Most patients used services from psychiatrists and case managers, but no more than half consulted GPs. Most patients were followed at least by two professionals, chiefly psychiatrists and case managers. Care access, continuity of care, and total help received were the most important variables associated with the different types of professional consultation. These variables were also associated with frequent use of professional service, as compared with infrequent service use. In all, enabling factors rather than need factors were the core predictors of frequency of service utilisation by patients with SMD.</p> <p>Conclusion</p> <p>This study reveals that health care system organisation and professional practice - rather than patient need profiles - are the core predictors of professional consultation by patients with SMD. The homogeneity of our study population, i.e. mainly users with schizophrenia, recently discharged from hospital, may partly account for these results. Our findings also underscored the limited involvement of GPs in this patient population's care. As comorbidity is often associated with serious mental disorders, closer follow-up by GPs is needed. Globally, more effort should be directed at increasing shared-care initiatives, which would enhance coordination among psychiatrists, GPs, and psychosocial teams (including case managers). Finally, there is a need to increase awareness among health care providers, especially GPs, of the level of care required by patients with disabling and serious mental disorders.</p

LNCaP Atlas: Gene expression associated with in vivo progression to castration-recurrent prostate cancer

<p>Abstract</p> <p>Background</p> <p>There is no cure for castration-recurrent prostate cancer (CRPC) and the mechanisms underlying this stage of the disease are unknown.</p> <p>Methods</p> <p>We analyzed the transcriptome of human LNCaP prostate cancer cells as they progress to CRPC <it>in vivo </it>using replicate LongSAGE libraries. We refer to these libraries as the LNCaP atlas and compared these gene expression profiles with current suggested models of CRPC.</p> <p>Results</p> <p>Three million tags were sequenced using <it>in vivo </it>samples at various stages of hormonal progression to reveal 96 novel genes differentially expressed in CRPC. Thirty-one genes encode proteins that are either secreted or are located at the plasma membrane, 21 genes changed levels of expression in response to androgen, and 8 genes have enriched expression in the prostate. Expression of 26, 6, 12, and 15 genes have previously been linked to prostate cancer, Gleason grade, progression, and metastasis, respectively. Expression profiles of genes in CRPC support a role for the transcriptional activity of the androgen receptor (<it>CCNH, CUEDC2, FLNA, PSMA7</it>), steroid synthesis and metabolism (<it>DHCR24, DHRS7</it>, <it>ELOVL5, HSD17B4</it>, <it>OPRK1</it>), neuroendocrine (<it>ENO2, MAOA, OPRK1, S100A10, TRPM8</it>), and proliferation (<it>GAS5</it>, <it>GNB2L1</it>, <it>MT-ND3</it>, <it>NKX3-1</it>, <it>PCGEM1</it>, <it>PTGFR</it>, <it>STEAP1</it>, <it>TMEM30A</it>), but neither supported nor discounted a role for cell survival genes.</p> <p>Conclusions</p> <p>The <it>in vivo </it>gene expression atlas for LNCaP was sequenced and support a role for the androgen receptor in CRPC.</p