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.

Deletion of mu- and kappa-opioid receptors in mice changes epidermal hypertrophy, density of peripheral nerve endings, and itch behavior.

The mu- (MOR) and kappa- (KOR) opioid receptors have been implicated in the regulation of homeostasis of non-neuronal cells, such as keratinocytes, and sensations like pain and chronic pruritus. Therefore, we have studied the phenotype of skin after deletion of MOR and KOR. In addition, we applied a dry skin model in these knockout mice and compared the different mice before and after induction of the dermatitis in terms of epidermal thickness, epidermal peripheral nerve ending distribution, dermal inflammatory infiltrate (mast cells, CD4 positive lymphocytes), and scratching behavior. MOR knockout mice reveal as phenotype a significantly thinner epidermis and a higher density of epidermal fiber staining by protein gene product 9.5 than the wild-type counterparts. Epidermal hypertrophy, induced by the dry skin dermatitis, was significantly less developed in MOR knockout than in wild-type mice. Neither mast cells nor CD4 T(h)-lymphocytes are involved in the changes of epidermal nerve endings and epidermal homeostasis. Finally, behavior experiments revealed that MOR and KOR knockout mice scratch less after induction of dry skin dermatitis than wild-type mice. These results indicate that MOR and KOR are important in skin homeostasis, epidermal nerve fiber regulation, and pathophysiology of itching.

Aplicació per a la gestió d'una empresa de transport

La finalitat d'aquest projecte és la creació d'una aplicació web per gestionar una empresa d'autobusos. El resultat que s'obtingui anirà dirigit a Agobe Tours SL. Permetrà reservar places als usuaris i l'administrador podrà gestionar tots els esdeveniments relacionats amb el negoci. Es desenvoluparà de zero per crear una aplicació a mida amb el propòsit de complir els objectius de l'empresa.

Simulation of stromatolite growth using diffusion-limited aggregation and a discrete model of biogeochemical exchanges in microbial mat

Resume : Mieux comprendre les stromatolithes et les tapis microbiens est un sujet important en biogéosciences puisque cela aide à l'étude des premières formes de vie sur Terre, a mieux cerner l'écologie des communautés microbiennes et la contribution des microorganismes a la biominéralisation, et même à poser certains fondements dans les recherches en exobiologie. D'autre part, la modélisation est un outil puissant utilisé dans les sciences naturelles pour appréhender différents phénomènes de façon théorique. Les modèles sont généralement construits sur un système d'équations différentielles et les résultats sont obtenus en résolvant ce système. Les logiciels disponibles pour implémenter les modèles incluent les logiciels mathématiques et les logiciels généraux de simulation. L'objectif principal de cette thèse est de développer des modèles et des logiciels pour aider a comprendre, via la simulation, le fonctionnement des stromatolithes et des tapis microbiens. Ces logiciels ont été développés en C++ en ne partant d'aucun pré-requis de façon a privilégier performance et flexibilité maximales. Cette démarche permet de construire des modèles bien plus spécifiques et plus appropriés aux phénomènes a modéliser. Premièrement, nous avons étudié la croissance et la morphologie des stromatolithes. Nous avons construit un modèle tridimensionnel fondé sur l'agrégation par diffusion limitée. Le modèle a été implémenté en deux applications C++: un moteur de simulation capable d'exécuter un batch de simulations et de produire des fichiers de résultats, et un outil de visualisation qui permet d'analyser les résultats en trois dimensions. Après avoir vérifié que ce modèle peut en effet reproduire la croissance et la morphologie de plusieurs types de stromatolithes, nous avons introduit un processus de sédimentation comme facteur externe. Ceci nous a mené a des résultats intéressants, et permis de soutenir l'hypothèse que la morphologie des stromatolithes pourrait être le résultat de facteurs externes autant que de facteurs internes. Ceci est important car la classification des stromatolithes est généralement fondée sur leur morphologie, imposant que la forme d'un stromatolithe est dépendante de facteurs internes uniquement (c'est-à-dire les tapis microbiens). Les résultats avancés dans ce mémoire contredisent donc ces assertions communément admises. Ensuite, nous avons décidé de mener des recherches plus en profondeur sur les aspects fonctionnels des tapis microbiens. Nous avons construit un modèle bidimensionnel de réaction-diffusion fondé sur la simulation discrète. Ce modèle a été implémenté dans une application C++ qui permet de paramétrer et exécuter des simulations. Nous avons ensuite pu comparer les résultats de simulation avec des données du monde réel et vérifier que le modèle peut en effet imiter le comportement de certains tapis microbiens. Ainsi, nous avons pu émettre et vérifier des hypothèses sur le fonctionnement de certains tapis microbiens pour nous aider à mieux en comprendre certains aspects, comme la dynamique des éléments, en particulier le soufre et l'oxygène. En conclusion, ce travail a abouti à l'écriture de logiciels dédiés à la simulation de tapis microbiens d'un point de vue tant morphologique que fonctionnel, suivant deux approches différentes, l'une holistique, l'autre plus analytique. Ces logiciels sont gratuits et diffusés sous licence GPL (General Public License). Abstract : Better understanding of stromatolites and microbial mats is an important topic in biogeosciences as it helps studying the early forms of life on Earth, provides clues re- garding the ecology of microbial ecosystems and their contribution to biomineralization, and gives basis to a new science, exobiology. On the other hand, modelling is a powerful tool used in natural sciences for the theoretical approach of various phenomena. Models are usually built on a system of differential equations and results are obtained by solving that system. Available software to implement models includes mathematical solvers and general simulation software. The main objective of this thesis is to develop models and software able to help to understand the functioning of stromatolites and microbial mats. Software was developed in C++ from scratch for maximum performance and flexibility. This allows to build models much more specific to a phenomenon rather than general software. First, we studied stromatolite growth and morphology. We built a three-dimensional model based on diffusion-limited aggregation. The model was implemented in two C++ applications: a simulator engine, which can run a batch of simulations and produce result files, and a Visualization tool, which allows results to be analysed in three dimensions. After verifying that our model can indeed reproduce the growth and morphology of several types of stromatolites, we introduced a sedimentation process as an external factor. This lead to interesting results, and allowed to emit the hypothesis that stromatolite morphology may be the result of external factors as much as internal factors. This is important as stromatolite classification is usually based on their morphology, imposing that a stromatolite shape is dependant on internal factors only (i.e. the microbial mat). This statement is contradicted by our findings, Second, we decided to investigate deeper the functioning of microbial mats, We built a two-dimensional reaction-diffusion model based on discrete simulation, The model was implemented in a C++ application that allows setting and running simulations. We could then compare simulation results with real world data and verify that our model can indeed mimic the behaviour of some microbial mats. Thus, we have proposed and verified hypotheses regarding microbial mats functioning in order to help to better understand them, e.g. the cycle of some elements such as oxygen or sulfur. ln conclusion, this PhD provides a simulation software, dealing with two different approaches. This software is free and available under a GPL licence.

Amoebal pathogens as emerging causal agents of pneumonia.

Despite using modern microbiological diagnostic approaches, the aetiological agents of pneumonia remain unidentified in about 50% of cases. Some bacteria that grow poorly or not at all in axenic media used in routine clinical bacteriology laboratory but which can develop inside amoebae may be the agents of these lower respiratory tract infections (RTIs) of unexplained aetiology. Such amoebae-resisting bacteria, which coevolved with amoebae to resist their microbicidal machinery, may have developed virulence traits that help them survive within human macrophages, i.e. the first line of innate immune defence in the lung. We review here the current evidence for the emerging pathogenic role of various amoebae-resisting microorganisms as agents of RTIs in humans. Specifically, we discuss the emerging pathogenic roles of Legionella-like amoebal pathogens, novel Chlamydiae (Parachlamydia acanthamoebae, Simkania negevensis), waterborne mycobacteria and Bradyrhizobiaceae (Bosea and Afipia spp.).

Juego 2D para Android

El proyecto consistirá en diseñar desde cero un juego para smartphones que utilicen el sistema operativo Android. El objetivo del juego será sobrevivir a las oleadas de enemigos, que aparecerán en el extremo derecho de la pantalla y se dirigirán al lado opuesto, durante el tiempo suficiente para superar el nivel actual. Al mismo tiempo tendremos que tratar de esquivar los obstáculos y recoger los objetos que nos proporcionarán un bonus de puntos. En el juego habrá un número finito de niveles, cada uno más difícil que el anterior.

Immune Antibodies and Helminth Products Drive CXCR2-Dependent Macrophage-Myofibroblast Crosstalk to Promote Intestinal Repair.

Helminth parasites can cause considerable damage when migrating through host tissues, thus making rapid tissue repair imperative to prevent bleeding and bacterial dissemination particularly during enteric infection. However, how protective type 2 responses targeted against these tissue-disruptive multicellular parasites might contribute to homeostatic wound healing in the intestine has remained unclear. Here, we observed that mice lacking antibodies (Aid-/-) or activating Fc receptors (Fcrg-/-) displayed impaired intestinal repair following infection with the murine helminth Heligmosomoides polygyrus bakeri (Hpb), whilst transfer of immune serum could partially restore chemokine production and rescue wound healing in Aid-/- mice. Impaired healing was associated with a reduced expression of CXCR2 ligands (CXCL2/3) by macrophages (MΦ) and myofibroblasts (MF) within intestinal lesions. Whilst antibodies and helminths together triggered CXCL2 production by MΦ in vitro via surface FcR engagement, chemokine secretion by intestinal MF was elicited by helminths directly via Fcrg-chain/dectin2 signaling. Blockade of CXCR2 during Hpb challenge infection reproduced the delayed wound repair observed in helminth infected Aid-/- and Fcrg-/- mice. Finally, conditioned media from human MΦ stimulated with infective larvae of the helminth Ascaris suum together with immune serum, promoted CXCR2-dependent scratch wound closure by human MF in vitro. Collectively our findings suggest that helminths and antibodies instruct a chemokine driven MΦ-MF crosstalk to promote intestinal repair, a capacity that may be harnessed in clinical settings of impaired wound healing.

Desenvolupament des de zero d'un sistema Linux per ser instal·lat als ordinadors de les aules ordinàries d'un institut de secundària

Exposició dels passos que cal seguir per construir un sistema GNU/Linux adreçat a les aules dels instituts de secundària prenent com a base Linux From Scratch versió 7.5.

Diet-related buccal dental microwear patterns in central african pygmy foragers and bantu-speaking farmer and pastoralist populations.

Pygmy hunter-gatherers from Central Africa have shared a network of socioeconomic interactions with non-Pygmy Bantu speakers since agropastoral lifestyle spread across sub-Saharan Africa. Ethnographic studies have reported that their diets differ in consumption of both animal proteins and starch grains. Hunted meat and gathered plant foods, especially underground storage organs (USOs), are dietary staples for pygmies. However, scarce information exists about forager-farmer interaction and the agricultural products used by pygmies. Since the effects of dietary preferences on teeth in modern and past pygmies remain unknown, we explored dietary history through quantitative analysis of buccal microwear on cheek teeth in well-documented Baka pygmies. We then determined if microwear patterns differ among other Pygmy groups (Aka, Mbuti, and Babongo) and between Bantu-speaking farmer and pastoralist populations from past centuries. The buccal dental microwear patterns of Pygmy hunter-gatherers and non-Pygmy Bantu pastoralists show lower scratch densities, indicative of diets more intensively based on nonabrasive foodstuffs, compared with Bantu farmers, who consume larger amounts of grit from stoneground foods. The Baka pygmies showed microwear patterns similar to those of ancient Aka and Mbuti, suggesting that the mechanical properties of their preferred diets have not significantly changed through time. In contrast, Babongo pygmies showed scratch densities and lengths similar to those of the farmers, consistent with sociocultural contacts and genetic factors. Our findings support that buccal microwear patterns predict dietary habits independent of ecological conditions and reflect the abrasive properties of preferred or fallback foods such as USOs, which may have contributed to the dietary specializations of ancient human populations.

Elinkaarikustannusanalyysi teknologiayrityksessä

Työn tavoitteena oli suunnitella ja toteuttaa elinkaarikustannusten laskentasovellus teknologiaympäristössä. Ensin luotiin elinkaarikustannuslaskennalle viitekehys ja työlle teoreettinen pohja kirjallisuuslähteiden perusteella. Varsinainen tutkimus aloitettiin strategisille asiakkaille suunnatulla tutkimuksella heidän käyttämistään sovelluksista elinkaarikustannusten laskentaan, laskennan menetelmistä sekä yhteistyön kannalta oleellisista kustannusparametreista. Lisäksi selvitettiin yrityksen omat tarpeet laskennalle.Seuraavaksi kartoitettiin markkinoilta löytyviä sovelluksia elinkaarikustannusten hallintaan, joista valittiin neljä tarkempaan vertailuun aiemmin selvitettyjen vaatimusten perusteella. Vaihtoehtona harkittiin myös oman laskentasovelluksen kehittämistä, mutta todettiin vertailussa löytyneen valmiin ohjelmiston täyttävän sovellukselle asetetut vaatimukset niin hyvin, ettei oman sovelluksen suunnittelun katsottu olevan tarpeellista.Lopuksi muokattiin valittu sovellus toimimaan tulevassa käyttöympäristössä ja luotiin käytön kannalta oleelliset tietokannat elinkaarikustannusten laskennassa tarvittaville lähtötiedoille. Samalla luotiin myös toimintarutiinit ja jaettiin vastuut sovelluksen tulevaa käyttöä ja tietokantojen päivitystä varten. Tutkimuksen tuloksena saatiin yrityksen käyttöön luotua sekä yrityksen että asiakkaiden vaatimukset täyttävä sovellus elinkaarikustannusten laskentaan.

The life history of retrocopies illuminates the evolution of new mammalian genes.

New genes contribute substantially to adaptive evolutionary innovation, but the functional evolution of new mammalian genes has been little explored at a broad scale. Previous work established mRNA-derived gene duplicates, known as retrocopies, as models for the study of new gene origination. Here we combine mammalian transcriptomic and epigenomic data to unveil the processes underlying the evolution of stripped-down retrocopies into complex new genes. We show that although some robustly expressed retrocopies are transcribed from preexisting promoters, most evolved new promoters from scratch or recruited proto-promoters in their genomic vicinity. In particular, many retrocopy promoters emerged from ancestral enhancers (or bivalent regulatory elements) or are located in CpG islands not associated with other genes. We detected 88-280 selectively preserved retrocopies per mammalian species, illustrating that these mechanisms facilitated the birth of many functional retrogenes during mammalian evolution. The regulatory evolution of originally monoexonic retrocopies was frequently accompanied by exon gain, which facilitated co-option of distant promoters and allowed expression of alternative isoforms. While young retrogenes are often initially expressed in the testis, increased regulatory and structural complexities allowed retrogenes to functionally diversify and evolve somatic organ functions, sometimes as complex as those of their parents. Thus, some retrogenes evolved the capacity to temporarily substitute for their parents during the process of male meiotic X inactivation, while others rendered parental functions superfluous, allowing for parental gene loss. Overall, our reconstruction of the "life history" of mammalian retrogenes highlights retroposition as a general model for understanding new gene birth and functional evolution.

Lautanauhaohjeen muodostus tavoitekuviosta geneettisellä algoritmilla

Lautanauhatekniikka on monipuolinen menetelmä esimerkiksi kuvioitujen nauhojen kutomiseen, mutta uusien kuvioaiheiden suunnittelu, tai aloittelijalle jo valmiiden ohjeettomien kuviomallien jäljittely, voi helposti käydä työlääksi menetelmän ominaispiirteiden johdosta. Tämän työn tavoitteena oli kehittää ohjelmallinen työkalu auttamaan näissä ongelmissa automatisoimalla kudontaohjeen etsintä käyttäjän laatimalle tavoitekuviolle. Ratkaisumenetelmän perustaksi valittiin geneettinen algoritmi, minkä johdosta työn keskeisintutkimusongelma oli kartoittaa algoritmin perusoperaatioiden parametrien ja tavoitekuvion kompleksisuuden keskinäisiä riippuvuuksia riittävästi toimivien arvosuositusten antamiseen ohjelman tulevassa käytännön käytössä. Työssä ei kehitetty sovellusalueeseen mukautettuja evoluutiooperaatioita, vaan keskityttiin luomaan hyvin tunnetuista elementeistä perusta, jota voi myöhemmin kehittää eteenpäin.

Adhesivos tipo poliuretano obtenidos a partir de aceite de ricino y almidón químicamente modificados

This study reports the preparation of polyurethane adhesives using polyols obtained from castor oil modified by a transesterification reaction with pentaerythritol and starch modified by glycosylation. The physical properties of the polyols such as hydroxyl value were determined and the infrared spectroscopic analysis of the polyols reported. The effect of varying the hydroxyl value in the polyols on physical properties of polyurethane coatings on wood and steel panels was determined. The characterization of polyurethane coatings carried out by IR spectroscopic analysis, scratch hardness resistance, impact resistance, lap shear strength, T-peel strength measurements, solvent resistance and chemical resistant determination were reported.

Consumer Attitudes on Aroma Printing

Olfactory packaging is an emerging technology which uses the aromatic capsules to release various scents. Normally, manufacturers add these aromatic capsules in the printing ink, the label or packaging material itself. When the aromatic capsules meet suitable release triggers, the scents will be released. The common release triggers are external forces, temperature changes, humidity changes and so on. The aim for this Masters of Science Thesis is to understand the aroma printing technology from literature and make market research for this kind of technology. The main target is to collect the current technology principle of aroma packaging and figure out how they are implemented on products with those. In addition, an investigation is made about consumers' attitudes from Chinese and Finnish market through the questionnaire, and the market potential is analyzed as well. The key points researched in this work are: the general attitudes on aroma printing technology, market potential and economic possibilities. This thesis specifies the main technologies used in aroma printing, the solutions of products with aroma packaging and the original results of the questionnaires. It also includes analysis of the acceptance of Chinese and Finnish consumers, what are their opinions of the aroma printing technology and the products packed by aroma printing technology. In addition, various factors which impact the market is discussed in the thesis. At last, some comparisons are made from the point of views of similarities and differences between Chinese and Finnish market.

Project Management Tools in Agile Embedded Systems Development

Agile methods have become increasingly popular in the field of software engineering. While agile methods are now generally considered applicable to software projects of many different kinds, they have not been widely adopted in embedded systems development. This is partly due to the natural constraints that are present in embedded systems development (e.g. hardware–software interdependencies) that challenge the utilization of agile values, principles and practices. The research in agile embedded systems development has been very limited, and this thesis tackles an even less researched theme related to it: the suitability of different project management tools in agile embedded systems development. The thesis covers the basic aspects of many different agile tool types from physical tools, such as task boards and cards, to web-based agile tools that offer all-round solutions for application lifecycle management. In addition to these two extremities, there is also a wide range of lighter agile tools that focus on the core agile practices, such as backlog management. Also other non-agile tools, such as bug trackers, can be used to support agile development, for instance, with plug-ins. To investigate the special tool requirements in agile embedded development, the author observed tool related issues and solutions in a case study involving three different companies operating in the field of embedded systems development. All three companies had a distinct situation in the beginning of the case and thus the tool solutions varied from a backlog spreadsheet built from scratch to plug-in development for an already existing agile software tool. Detailed reports are presented of all three tool cases. Based on the knowledge gathered from agile tools and the case study experiences, it is concluded that there are tool related issues in the pilot phase, such as backlog management and user motivation. These can be overcome in various ways epending on the type of a team in question. Finally, five principles are formed to give guidelines for tool selection and usage in agile embedded systems development.