OpenFluDB, a database for human and animal influenza virus.

Although research on influenza lasted for more than 100 years, it is still one of the most prominent diseases causing half a million human deaths every year. With the recent observation of new highly pathogenic H5N1 and H7N7 strains, and the appearance of the influenza pandemic caused by the H1N1 swine-like lineage, a collaborative effort to share observations on the evolution of this virus in both animals and humans has been established. The OpenFlu database (OpenFluDB) is a part of this collaborative effort. It contains genomic and protein sequences, as well as epidemiological data from more than 27,000 isolates. The isolate annotations include virus type, host, geographical location and experimentally tested antiviral resistance. Putative enhanced pathogenicity as well as human adaptation propensity are computed from protein sequences. Each virus isolate can be associated with the laboratories that collected, sequenced and submitted it. Several analysis tools including multiple sequence alignment, phylogenetic analysis and sequence similarity maps enable rapid and efficient mining. The contents of OpenFluDB are supplied by direct user submission, as well as by a daily automatic procedure importing data from public repositories. Additionally, a simple mechanism facilitates the export of OpenFluDB records to GenBank. This resource has been successfully used to rapidly and widely distribute the sequences collected during the recent human swine flu outbreak and also as an exchange platform during the vaccine selection procedure. Database URL: http://openflu.vital-it.ch.

Cheminformatic studies of molecular properties and their influence on bioactivity in the context of drug discovery

Molecular shape has long been known to be an important property for the process of molecular recognition. Previous studies postulated the existence of a drug-like shape space that could be used to artificially bias the composition of screening libraries, with the aim to increase the chance of success in Hit Identification. In this work, it was analysed to which extend this assumption holds true. Normalized Principal Moments of Inertia Ratios (NPRs) have been used to describe the molecular shape of small molecules. It was investigated, whether active molecules of diverse targets are located in preferred subspaces of the NPR shape space. Results illustrated a significantly stronger clustering than could be expected by chance, with parts of the space unlikely to be occupied by active compounds. Furthermore, a strong enrichment of elongated, rather flat shapes could be observed, while globular compounds were highly underrepresented. This was confirmed for a wide range of small molecule datasets from different origins. Active compounds exhibited a high overlap in their shape distributions across different targets, making a purely shape­ based discrimination very difficult. An additional perspective was provided by comparing the shapes of protein binding pockets with those of their respective ligands. Although more globular than their ligands, it was observed that binding sites shapes exhibited a similarly skewed distribution in shape space: spherical shapes were highly underrepresented. This was different for unoccupied binding pockets of smaller size. These were on the contrary identified to possess a more globular shape. The relation between shape complementarity and exhibited bioactivity was analysed; a moderate correlation between bioactivity and parameters including pocket coverage, distance in shape space, and others could be identified, which reflects the importance of shape complementarity. However, this also suggests that other aspects are of relevance for molecular recognition. A subsequent analysis assessed if and how shape and volume information retrieved from pocket or respective reference ligands could be used as a pre-filter in a virtual screening approach. ln Lead Optimization compounds need to get optimized with respect to a variety of pararneters. Here, the availability of past success stories is very valuable, as they can guide medicinal chemists during their analogue synthesis plans. However, although of tremendous interest for the public domain, so far only large corporations had the ability to mine historical knowledge in their proprietary databases. With the aim to provide such information, the SwissBioisostere database was developed and released during this thesis. This database contains information on 21,293,355 performed substructural exchanges, corresponding to 5,586,462 unique replacements that have been measured in 35,039 assays against 1,948 molecular targets representing 30 target classes, and on their impact on bioactivity . A user-friendly interface was developed that provides facile access to these data and is accessible at http//www.swissbioisostere.ch. The ChEMBL database was used as primary data source of bioactivity information. Matched molecular pairs have been identified in the extracted and cleaned data. Success-based scores were developed and integrated into the database to allow re-ranking of proposed replacements by their past outcomes. It was analysed to which degree these scores correlate with chemical similarity of the underlying fragments. An unexpectedly weak relationship was detected and further investigated. Use cases of this database were envisioned, and functionalities implemented accordingly: replacement outcomes are aggregatable at the assay level, and it was shawn that an aggregation at the target or target class level could also be performed, but should be accompanied by a careful case-by-case assessment. It was furthermore observed that replacement success depends on the activity of the starting compound A within a matched molecular pair A-B. With increasing potency the probability to lose bioactivity through any substructural exchange was significantly higher than in low affine binders. A potential existence of a publication bias could be refuted. Furthermore, often performed medicinal chemistry strategies for structure-activity-relationship exploration were analysed using the acquired data. Finally, data originating from pharmaceutical companies were compared with those reported in the literature. It could be seen that industrial medicinal chemistry can access replacement information not available in the public domain. In contrast, a large amount of often-performed replacements within companies could also be identified in literature data. Preferences for particular replacements differed between these two sources. The value of combining different endpoints in an evaluation of molecular replacements was investigated. The performed studies highlighted furthermore that there seem to exist no universal substructural replacement that always retains bioactivity irrespective of the biological environment. A generalization of bioisosteric replacements seems therefore not possible. - La forme tridimensionnelle des molécules a depuis longtemps été reconnue comme une propriété importante pour le processus de reconnaissance moléculaire. Des études antérieures ont postulé que les médicaments occupent préférentiellement un sous-ensemble de l'espace des formes des molécules. Ce sous-ensemble pourrait être utilisé pour biaiser la composition de chimiothèques à cribler, dans le but d'augmenter les chances d'identifier des Hits. L'analyse et la validation de cette assertion fait l'objet de cette première partie. Les Ratios de Moments Principaux d'Inertie Normalisés (RPN) ont été utilisés pour décrire la forme tridimensionnelle de petites molécules de type médicament. Il a été étudié si les molécules actives sur des cibles différentes se co-localisaient dans des sous-espaces privilégiés de l'espace des formes. Les résultats montrent des regroupements de molécules incompatibles avec une répartition aléatoire, avec certaines parties de l'espace peu susceptibles d'être occupées par des composés actifs. Par ailleurs, un fort enrichissement en formes allongées et plutôt plates a pu être observé, tandis que les composés globulaires étaient fortement sous-représentés. Cela a été confirmé pour un large ensemble de compilations de molécules d'origines différentes. Les distributions de forme des molécules actives sur des cibles différentes se recoupent largement, rendant une discrimination fondée uniquement sur la forme très difficile. Une perspective supplémentaire a été ajoutée par la comparaison des formes des ligands avec celles de leurs sites de liaison (poches) dans leurs protéines respectives. Bien que plus globulaires que leurs ligands, il a été observé que les formes des poches présentent une distribution dans l'espace des formes avec le même type d'asymétrie que celle observée pour les ligands: les formes sphériques sont fortement sous­ représentées. Un résultat différent a été obtenu pour les poches de plus petite taille et cristallisées sans ligand: elles possédaient une forme plus globulaire. La relation entre complémentarité de forme et bioactivité a été également analysée; une corrélation modérée entre bioactivité et des paramètres tels que remplissage de poche, distance dans l'espace des formes, ainsi que d'autres, a pu être identifiée. Ceci reflète l'importance de la complémentarité des formes, mais aussi l'implication d'autres facteurs. Une analyse ultérieure a évalué si et comment la forme et le volume d'une poche ou de ses ligands de référence pouvaient être utilisés comme un pré-filtre dans une approche de criblage virtuel. Durant l'optimisation d'un Lead, de nombreux paramètres doivent être optimisés simultanément. Dans ce contexte, la disponibilité d'exemples d'optimisations réussies est précieuse, car ils peuvent orienter les chimistes médicinaux dans leurs plans de synthèse par analogie. Cependant, bien que d'un extrême intérêt pour les chercheurs dans le domaine public, seules les grandes sociétés pharmaceutiques avaient jusqu'à présent la capacité d'exploiter de telles connaissances au sein de leurs bases de données internes. Dans le but de remédier à cette limitation, la base de données SwissBioisostere a été élaborée et publiée dans le domaine public au cours de cette thèse. Cette base de données contient des informations sur 21 293 355 échanges sous-structuraux observés, correspondant à 5 586 462 remplacements uniques mesurés dans 35 039 tests contre 1948 cibles représentant 30 familles, ainsi que sur leur impact sur la bioactivité. Une interface a été développée pour permettre un accès facile à ces données, accessible à http:/ /www.swissbioisostere.ch. La base de données ChEMBL a été utilisée comme source de données de bioactivité. Une version modifiée de l'algorithme de Hussain et Rea a été implémentée pour identifier les Matched Molecular Pairs (MMP) dans les données préparées au préalable. Des scores de succès ont été développés et intégrés dans la base de données pour permettre un reclassement des remplacements proposés selon leurs résultats précédemment observés. La corrélation entre ces scores et la similarité chimique des fragments correspondants a été étudiée. Une corrélation plus faible qu'attendue a été détectée et analysée. Différents cas d'utilisation de cette base de données ont été envisagés, et les fonctionnalités correspondantes implémentées: l'agrégation des résultats de remplacement est effectuée au niveau de chaque test, et il a été montré qu'elle pourrait également être effectuée au niveau de la cible ou de la classe de cible, sous réserve d'une analyse au cas par cas. Il a en outre été constaté que le succès d'un remplacement dépend de l'activité du composé A au sein d'une paire A-B. Il a été montré que la probabilité de perdre la bioactivité à la suite d'un remplacement moléculaire quelconque est plus importante au sein des molécules les plus actives que chez les molécules de plus faible activité. L'existence potentielle d'un biais lié au processus de publication par articles a pu être réfutée. En outre, les stratégies fréquentes de chimie médicinale pour l'exploration des relations structure-activité ont été analysées à l'aide des données acquises. Enfin, les données provenant des compagnies pharmaceutiques ont été comparées à celles reportées dans la littérature. Il a pu être constaté que les chimistes médicinaux dans l'industrie peuvent accéder à des remplacements qui ne sont pas disponibles dans le domaine public. Par contre, un grand nombre de remplacements fréquemment observés dans les données de l'industrie ont également pu être identifiés dans les données de la littérature. Les préférences pour certains remplacements particuliers diffèrent entre ces deux sources. L'intérêt d'évaluer les remplacements moléculaires simultanément selon plusieurs paramètres (bioactivité et stabilité métabolique par ex.) a aussi été étudié. Les études réalisées ont souligné qu'il semble n'exister aucun remplacement sous-structural universel qui conserve toujours la bioactivité quel que soit le contexte biologique. Une généralisation des remplacements bioisostériques ne semble donc pas possible.

The effect of cognitive behavioral treatment on the positive symptoms of schizophrenia spectrum disorders: a meta-analysis

(from the journal abstract) Background: Despite the effectiveness of anti-psychotic pharmacotherapy, residual hallucinations and delusions do not completely resolve in some medicated patients. Additional cognitive behavioral therapy (CBT) seems to improve the management of positive symptoms. Despite promising results, the efficacy of CBT is still unclear. The present study addresses this issue taking into account a number of newly published controlled studies. Method: Fourteen studies including 1484 patients, published between 1990 and 2004 were identified and a meta-analysis of their results performed. Results: Compared to other adjunctive measures, CBT showed significant reduction in positive symptoms and there was a higher benefit of CBT for patients suffering an acute psychotic episode versus the chronic condition (effect size of 0.57 vs. 0.27). Discussion: CBT is a promising adjunctive treatment for positive symptoms in schizophrenia spectrum disorders. However, a number of potentially modifying variables have not yet been examined, such as therapeutic alliance and neuropsychological deficits. (PsycINFO Database Record (c) 2005 APA, all rights reserved)

Computer-generated reminders delivered on paper to healthcare professionals; effects on professional practice and health care outcomes.

BACKGROUND: Clinical practice does not always reflect best practice and evidence, partly because of unconscious acts of omission, information overload, or inaccessible information. Reminders may help clinicians overcome these problems by prompting the doctor to recall information that they already know or would be expected to know and by providing information or guidance in a more accessible and relevant format, at a particularly appropriate time. OBJECTIVES: To evaluate the effects of reminders automatically generated through a computerized system and delivered on paper to healthcare professionals on processes of care (related to healthcare professionals' practice) and outcomes of care (related to patients' health condition). SEARCH METHODS: For this update the EPOC Trials Search Co-ordinator searched the following databases between June 11-19, 2012: The Cochrane Central Register of Controlled Trials (CENTRAL) and Cochrane Library (Economics, Methods, and Health Technology Assessment sections), Issue 6, 2012; MEDLINE, OVID (1946- ), Daily Update, and In-process; EMBASE, Ovid (1947- ); CINAHL, EbscoHost (1980- ); EPOC Specialised Register, Reference Manager, and INSPEC, Engineering Village. The authors reviewed reference lists of related reviews and studies.  SELECTION CRITERIA: We included individual or cluster-randomized controlled trials (RCTs) and non-randomized controlled trials (NRCTs) that evaluated the impact of computer-generated reminders delivered on paper to healthcare professionals on processes and/or outcomes of care. DATA COLLECTION AND ANALYSIS: Review authors working in pairs independently screened studies for eligibility and abstracted data. We contacted authors to obtain important missing information for studies that were published within the last 10 years. For each study, we extracted the primary outcome when it was defined or calculated the median effect size across all reported outcomes. We then calculated the median absolute improvement and interquartile range (IQR) in process adherence across included studies using the primary outcome or median outcome as representative outcome. MAIN RESULTS: In the 32 included studies, computer-generated reminders delivered on paper to healthcare professionals achieved moderate improvement in professional practices, with a median improvement of processes of care of 7.0% (IQR: 3.9% to 16.4%). Implementing reminders alone improved care by 11.2% (IQR 6.5% to 19.6%) compared with usual care, while implementing reminders in addition to another intervention improved care by 4.0% only (IQR 3.0% to 6.0%) compared with the other intervention. The quality of evidence for these comparisons was rated as moderate according to the GRADE approach. Two reminder features were associated with larger effect sizes: providing space on the reminder for provider to enter a response (median 13.7% versus 4.3% for no response, P value = 0.01) and providing an explanation of the content or advice on the reminder (median 12.0% versus 4.2% for no explanation, P value = 0.02). Median improvement in processes of care also differed according to the behaviour the reminder targeted: for instance, reminders to vaccinate improved processes of care by 13.1% (IQR 12.2% to 20.7%) compared with other targeted behaviours. In the only study that had sufficient power to detect a clinically significant effect on outcomes of care, reminders were not associated with significant improvements. AUTHORS' CONCLUSIONS: There is moderate quality evidence that computer-generated reminders delivered on paper to healthcare professionals achieve moderate improvement in process of care. Two characteristics emerged as significant predictors of improvement: providing space on the reminder for a response from the clinician and providing an explanation of the reminder's content or advice. The heterogeneity of the reminder interventions included in this review also suggests that reminders can improve care in various settings under various conditions.

Effect of computerisation on the quality and safety of chemotherapy prescription.

BACKGROUND: Chemotherapy is prescribed according to protocols of several cycles. These protocols include not only therapeutic agents but also adjuvant solvents and inherent supportive care measures. Multiple errors can occur during the prescription, the transmission of documents and the drug delivery processes, and lead to potentially serious consequences. OBJECTIVE: To assess the effect of a computerised physician order entry (CPOE) system on the number of errors in prescription recorded by the centralised chemotherapy unit of a pharmacy service in a university hospital. PATIENTS AND METHODS: Existing chemotherapy protocols were standardised by a multidisciplinary team (composed of a doctor, a pharmacist and a nurse) and a CPOE system was developed from a File Maker Pro database. Chemotherapy protocols were progressively introduced into the CPOE system. The effect of the system on prescribing errors was measured over 15 months before and 21 months after starting computerised protocol prescription. Errors were classified as major (dosage and drug name) and minor (volume or type of infusion solution). RESULTS: Before computerisation, 141 errors were recorded for 940 prescribed chemotherapy regimens (15%). After introduction of the CPOE system, 75 errors were recorded for 1505 prescribed chemotherapy regimens (5%). Of these errors, 69 (92%) were recorded in prescriptions that did not use a computerised protocol. A dramatic decrease in the number of errors was noticeable when 50% of the chemotherapy protocols were prescribed through the CPOE system. CONCLUSION: Errors in chemotherapy prescription nearly disappeared after implementation of CPOE. The safety of chemotherapy prescription was markedly improved.

Impact of preoperative embolization of the left gastric artery on the rate of anastomotic leakage after esophageal resection

Objective: Impaired blood flow of the gastric tube represents a major cause of anastomotic leakage after esophageal resection. In order to improve local vascularisation, preoperative embolization (PE) of the left gastric artery has recently been proposed. The aimof this study was to assess our initial experience of this novel approach with a particular focus on anastomotic leakage.Methods: A consecutive series of 102 patients (81 male, 21 female, median age 64 years) underwent resection (82 Ivor-Lewis procedures, 9 transhiatal resections, 11 triple incisions) for esophageal malignancies at our institution from 2000 to 2009. Since 2004, PE was used selectively in 19 patients 21 days prior to elective esophagectomy. Selection criteria were normal gastric vascular anatomy, no pre-existing vascular disease, i.e. atheromatosis of the celiac trunk or superior mesenteric artery, and resectability of the tumor. PE was performed under local anesthesia on a dedicated system in a standard fashion. Following percutaneous transfemoral visceral angiography to identify gastric vascular anatomy, embolization was performed either with 5-F or with coaxial 3-F catheters and fibered metal coils. We analyzed retrospectively patient's data, operative data, and outcome from a prospective database.Results: The overall anastomotic leakage rate was 18・6% (19/102 patients); cervical anastomosis had a leak rate of 25% compared to intrathoracic anastomosis leak rate of 18・2%. While 17 of 83 patients without PE developed anastomotic leakage (20・5%), there were only 2 of 19 patients after PE revealing an anastomotic leakage (10・5%). Otherwise, patients with PE had no more other complications. There was only one PE-related complication (i.e. partial splenic necrosis).Mean hospital stay was 25 days versus 27 days for patients with PE and without PE, respectively. The mortality rate was 7・8% (8/102 patients), whereby four deaths were related to anastomotic leakage (1 and 3 patients with PE and without PE, respectively).Conclusion: PE is an interesting novel approach to improve gastric blood flow in order to minimize anastomotic leakage. Its application is safe and technically easy. Our preliminary experience revealed a decrease of the anastomotic leakage rate of almost 50%.

Potential influence of the chemical composition of water on the stable oxygen isotope composition of continental ostracods

Many studies in continental areas have successfully used the oxygen isotope composition of fossil ostracod valves to reconstruct past hydrological conditions associated with large changes in climate. Yet, ostracods are known to crystallise their valves out of isotopic equilibrium for oxygen and they generally have higher 18O contents compared to inorganic calcite grown at equilibrium under the same condi- tions. A review of vital offsets determined for continental ostracods indicates that vital offsets might change from site to site, questioning a potential influence of environmental conditions on oxygen isotope fractionation in ostracods. Results from the literature suggest that pH has no influence on ostracod vital offset. A re-evaluation of results from Li and Liu (J Paleolimnol 43:111-120, 2010) suggests that salin- ity may influence oxygen isotope fractionation in ostracods, with lower vital offsets for higher salinities. Such a relationship was also observed for the vital offsets determined by Chivas et al. (The ostracoda- applications in quaternary research. American Geo- physical Union, Washington, DC, 2002). Yet, when results of all studies are compiled, the correlation between vital offsets and salinity is low while the correlation between vital offsets and host water Mg/Ca is higher, suggesting that ionic composition of water and/or relative abundance of major ions may also control oxygen isotope fractionation in ostracods. Lack of data on host water ionic composition for the different studies precludes more detailed examination at this stage. Further studies such as natural or laboratory cultures done under strictly controlled conditions are needed to better understand the potential influence of varying environmental condi- tions on oxygen isotope compositions of ostracod valves.

Introducing a nationwide registry: the Swiss study on aneurysmal subarachnoid haemorrhage (Swiss SOS).

BACKGROUND: Aneurysmal subarachnoid haemorrhage (aSAH) is a haemorrhagic form of stroke and occurs in a younger population compared with ischaemic stroke or intracerebral haemorrhage. It accounts for a large proportion of productive life-years lost to stroke. Its surgical and medical treatment represents a multidisciplinary effort. Due to the complexity of the disease, the management remains difficult to standardise and quality of care is accordingly difficult to assess. OBJECTIVE: To create a registry to assess management parameters of patients treated for aSAH in Switzerland. METHODS: A cohort study was initiated with the aim to record characteristics of patients admitted with aSAH, starting January 1st 2009. Ethical committee approval was obtained or is pending from the institutional review boards of all centres. In the study period, seven Swiss hospitals (five university [U], two non-university medical centres) harbouring a neurosurgery department, an intensive care unit and an interventional neuroradiology team so far agreed to participate in the registry (Aarau, Basel [U], Bern [U], Geneva [U], Lausanne [U], St. Gallen, Zürich [U]). Demographic and clinical parameters are entered into a common database. DISCUSSION: This database will soon provide (1) a nationwide assessment of the current standard of care and (2) the outcomes for patients suffering from aSAH in Switzerland. Based on data from this registry, we can conduct cohort comparisons or design diagnostic or therapeutic studies on a national level. Moreover, a standardised registration system will allow healthcare providers to assess the quality of care.

Permanent.Plot.ch - a database for Swiss permanent vegetation plots

The aim of the Permanent.Plot.ch project is the conservation of historical data about permanent plots in Switzerland and the monitoring of vegetation in a context of environmental changes (mainly climate and land use). Permanent plots are currently being recognized as valuable tools to monitor long-term effects of environmental changes on vegetation. Often used in short studies (3 to 5 years), they are generally abandoned at the end of projects. However, their full potential might only be revealed after 10 or more years, once the location is lost. For instance, some of the oldest permanent plots in Switzerland (first half of the 20th century) were nearly lost, although they are now very valuable data. The Permanent.Plot.ch national database (GIVD ID EU-CH-001), by storing historical and recent data, will allow to ensuring future access to data from permanent vegetation plots. As the database contains some private data, it is not directly available on internet but an overview of the data can be downloaded from internet (http://www.unil.ch/ppch) and precise data are available on request.

Recent misconceptions about the "database search problem": a probabilistic analysis using Bayesian networks

This paper analyses and discusses arguments that emerge from a recent discussion about the proper assessment of the evidential value of correspondences observed between the characteristics of a crime stain and those of a sample from a suspect when (i) this latter individual is found as a result of a database search and (ii) remaining database members are excluded as potential sources (because of different analytical characteristics). Using a graphical probability approach (i.e., Bayesian networks), the paper here intends to clarify that there is no need to (i) introduce a correction factor equal to the size of the searched database (i.e., to reduce a likelihood ratio), nor to (ii) adopt a propositional level not directly related to the suspect matching the crime stain (i.e., a proposition of the kind 'some person in (outside) the database is the source of the crime stain' rather than 'the suspect (some other person) is the source of the crime stain'). The present research thus confirms existing literature on the topic that has repeatedly demonstrated that the latter two requirements (i) and (ii) should not be a cause of concern.

Hematopoietic stem cell transplantation in Switzerland: a comprehensive quality control report on centre effect.

Interest groups advocate centre-specific outcome data as a useful tool for patients in choosing a hospital for their treatment and for decision-making by politicians and the insurance industry. Haematopoietic stem cell transplantation (HSCT) requires significant infrastructure and represents a cost-intensive procedure. It therefore qualifies as a prime target for such a policy. We made use of the comprehensive database of the Swiss Blood Stem Cells Transplant Group (SBST) to evaluate potential use of mortality rates. Nine institutions reported a total of 4717 HSCT - 1427 allogeneic (30.3%), 3290 autologous (69.7%) - in 3808 patients between the years 1997 and 2008. Data were analysed for survival- and transplantation-related mortality (TRM) at day 100 and at 5 years. The data showed marked and significant differences between centres in unadjusted analyses. These differences were absent or marginal when the results were adjusted for disease, year of transplant and the EBMT risk score (a score incorporating patient age, disease stage, time interval between diagnosis and transplantation, and, for allogeneic transplants, donor type and donor-recipient gender combination) in a multivariable analysis. These data indicate comparable quality among centres in Switzerland. They show that comparison of crude centre-specific outcome data without adjustment for the patient mix may be misleading. Mandatory data collection and systematic review of all cases within a comprehensive quality management system might, in contrast, serve as a model to ascertain the quality of other cost-intensive therapies in Switzerland.

Mynodbcsv: Lightweight Zero-Config Database Solution for Handling Very Large CSV Files.

Volumes of data used in science and industry are growing rapidly. When researchers face the challenge of analyzing them, their format is often the first obstacle. Lack of standardized ways of exploring different data layouts requires an effort each time to solve the problem from scratch. Possibility to access data in a rich, uniform manner, e.g. using Structured Query Language (SQL) would offer expressiveness and user-friendliness. Comma-separated values (CSV) are one of the most common data storage formats. Despite its simplicity, with growing file size handling it becomes non-trivial. Importing CSVs into existing databases is time-consuming and troublesome, or even impossible if its horizontal dimension reaches thousands of columns. Most databases are optimized for handling large number of rows rather than columns, therefore, performance for datasets with non-typical layouts is often unacceptable. Other challenges include schema creation, updates and repeated data imports. To address the above-mentioned problems, I present a system for accessing very large CSV-based datasets by means of SQL. It's characterized by: "no copy" approach - data stay mostly in the CSV files; "zero configuration" - no need to specify database schema; written in C++, with boost [1], SQLite [2] and Qt [3], doesn't require installation and has very small size; query rewriting, dynamic creation of indices for appropriate columns and static data retrieval directly from CSV files ensure efficient plan execution; effortless support for millions of columns; due to per-value typing, using mixed text/numbers data is easy; very simple network protocol provides efficient interface for MATLAB and reduces implementation time for other languages. The software is available as freeware along with educational videos on its website [4]. It doesn't need any prerequisites to run, as all of the libraries are included in the distribution package. I test it against existing database solutions using a battery of benchmarks and discuss the results.

Selectome update: quality control and computational improvements to a database of positive selection.

Selectome (http://selectome.unil.ch/) is a database of positive selection, based on a branch-site likelihood test. This model estimates the number of nonsynonymous substitutions (dN) and synonymous substitutions (dS) to evaluate the variation in selective pressure (dN/dS ratio) over branches and over sites. Since the original release of Selectome, we have benchmarked and implemented a thorough quality control procedure on multiple sequence alignments, aiming to provide minimum false-positive results. We have also improved the computational efficiency of the branch-site test implementation, allowing larger data sets and more frequent updates. Release 6 of Selectome includes all gene trees from Ensembl for Primates and Glires, as well as a large set of vertebrate gene trees. A total of 6810 gene trees have some evidence of positive selection. Finally, the web interface has been improved to be more responsive and to facilitate searches and browsing.

Effects of antiresorptive agents on bone micro-architecture assessed by Trabecular Bone Score in women age 50 and older. The Manitoba Prospective Study

Antiresorptive agents such as bisphosphonates induce a rapid increase of BMD during the 1st year of treatment and a partial maintenance of bone architecture. Trabecular Bone Score (TBS), a new grey-level texture measurement that can be extracted from the DXA image, correlates with 3D parameters of bone micro-architecture. Aim: To evaluate the longitudinal effect of antiresorptive agents on spine BMD and on site-matched spine microarchitecture as assessed by TBS. Methods: From the BMD database for Province of Manitoba, Canada, we selected women age >50 with paired baseline and follow up spine DXA examinations who had not received any prior HRT or other antiresorptive drug.Women were divided in two subgroups: (1) those not receiving any HRT or antiresorptive drug during follow up (=non-users) and (2) those receiving non-HRT antiresorptive drug during follow up (=users) with high adherence (medication possession ratio >75%) from a provincial pharmacy database system. Lumbar spine TBS was derived by the Bone Disease Unit, University of Lausanne, for each spine DXA examination using anonymized files (blinded from clinical parameters and outcomes). Effects of antiresorptive treatment for users and non-users on TBS and BMD at baseline and during mean 3.7 years follow-up were compared. Results were expressed % change per year. Results: 1150 non-users and 534 users met the inclusion criteria. At baseline, users and non-users had a mean age and BMI of [62.2±7.9 vs 66.1±8.0 years] and [26.3±4.7 vs 24.7±4.0 kg/m²] respectively. Antiresorptive drugs received by users were bisphosphonates (86%), raloxifene (10%) and calcitonin (4%). Significant differences in BMD change and TBS change were seen between users and nonusers during follow-up (p<0.0001). Significant decreases in mean BMD and TBS (−0.36± 0.05% per year; −0.31±0.06% per year) were seen for non-users compared with baseline (p<0.001). A significant increase in mean BMD was seen for users compared with baseline (+1.86±0.0% per year, p<0.0018). TBS of users also increased compared with baseline (+0.20±0.08% per year, p<0.001), but more slowly than BMD. Conclusion: We observed a significant increase in spine BMD and a positive maintenance of bone micro-architecture from TBS with antiresorptive treatment, whereas the treatment naïve group lost both density and micro-architecture. TBS seems to be responsive to treatment and could be suitable for monitoring micro-architecture. This article is part of a Special Issue entitled ECTS 2011. Disclosure of interest: M.-A. Krieg: None declared, A. Goertzen: None declared, W. Leslie: None declared, D. Hans Consulting fees from Medimaps.