35 resultados para SQL Server 2014
Resumo:
Signal search analysis is a general method to discover and characterize sequence motifs that are positionally correlated with a functional site (e.g. a transcription or translation start site). The method has played an instrumental role in the analysis of eukaryotic promoter elements. The signal search analysis server provides access to four different computer programs as well as to a large number of precompiled functional site collections. The programs offered allow: (i) the identification of non-random sequence regions under evolutionary constraint; (ii) the detection of consensus sequence-based motifs that are over- or under-represented at a particular distance from a functional site; (iii) the analysis of the positional distribution of a consensus sequence- or weight matrix-based sequence motif around a functional site; and (iv) the optimization of a weight matrix description of a locally over-represented sequence motif. These programs can be accessed at: http://www.isrec.isb-sib.ch/ssa/.
Resumo:
On 19 January 2014 Rolf ('Roffe') Bernander passed away unexpectedly. Rolf was a dedicated scientist; his research aimed at unravelling the cell biology of the archaeal domain of life, especially cell cycle-related questions, but he also made important contributions in other areas of microbiology. Rolf had a professor position in the Molecular Evolution programme at Uppsala University, Sweden for about 8 years, and in January 2013 he became chair professor at the Department of Molecular Biosciences, The Wenner-Gren Institute at Stockholm University in Sweden. Rolf was an exceptional colleague and will be deeply missed by his family and friends, and the colleagues and co-workers that he leaves behind in the scientific community. He will be remembered for his endless enthusiasm for science, his analytical mind, and his quirky sense of humour.
Resumo:
Le Cipret-Valais, la Société Médicale du Valais (SMV), Pharmavalais et Promotion Santé Valais, ont lancé en 2013 une campagne de sensibilisation sur l'impact du tabac sur les maladies cardiovasculaires (MCV). Cette campagne, qui sera déclinée sur trois ans (2013-2016), informe et sensibilise la population sur les liens existant entre le tabagisme et les MCV. La campagne suit différents axes : sensibiliser les fumeurs de plus de 40 ans aux conséquences du tabagisme sur leur risque de MCV, les encourager à contrôler leur pression artérielle (en pharmacie) et les inciter à prendre les mesures nécessaires à la réduction de leur risque de MCV. Dans une seconde phase, les fumeurs seront guidés dans leur démarche d'arrêt, avec des offres de désaccoutumance. Cette évaluation, qui concerne la première partie de la campagne (novembre 2013 et mars 2014), a pour but d'apporter un complément qualitatif aux données quantitatives récoltées au cours de la campagne (valeurs de tension artérielle (TA)). Des entretiens ont ainsi été menés avec le responsable du Cipret-Valais (A. Dubuis) et le président du Cipret-Valais, également responsable de la SMV pour cette campagne (Dr. D. Evéquoz). Un focus-group avec un échantillon de pharmacien était également prévu. N'ayant pu avoir lieu du fait d'une participation trop faible, il a été remplacé par des entretiens téléphoniques. Pour la partie quantitative de l'évaluation, les données sur les prises de TA en pharmacie ont été fournies par le Cipret-Valais et Pharmavalais, et celles sur la fréquentation du site internet par Cipret-Valais.
Resumo:
Microscopic colitis, which includes lymphocytic colitis and collagenous colitis, represents a frequent cause of chronic watery diarrhea especially in the elderly population. Several medications, such as nonsteroidal antiinflammatory drugs, proton pump inhibitors or antidepressants, as well as cigarette smoking have been recognized as risk factors for microscopic colitis. The diagnosis of microscopic colitis is based on a macroscopically normal ileo-colonoscopy and several biopsies from the entire colon, which demonstrate the pathognomonic histopathologic findings. Therapy is mainly based on the use of budesonide. Other medications, such as mesalazine, cholestyramine and bismuth, have been evaluated as well but the evidence is less solid.
Resumo:
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.