Methods and Techniques for the Generation and Eficient Exploitation of RDB2RDF Mappings

RDB to RDF Mapping Language (R2RML) es una recomendación del W3C que permite especificar reglas para transformar bases de datos relacionales a RDF. Estos datos en RDF se pueden materializar y almacenar en un sistema gestor de tripletas RDF (normalmente conocidos con el nombre triple store), en el cual se pueden evaluar consultas SPARQL. Sin embargo, hay casos en los cuales la materialización no es adecuada o posible, por ejemplo, cuando la base de datos se actualiza frecuentemente. En estos casos, lo mejor es considerar los datos en RDF como datos virtuales, de tal manera que las consultas SPARQL anteriormente mencionadas se traduzcan a consultas SQL que se pueden evaluar sobre los sistemas gestores de bases de datos relacionales (SGBD) originales. Para esta traducción se tienen en cuenta los mapeos R2RML. La primera parte de esta tesis se centra en la traducción de consultas. Se propone una formalización de la traducción de SPARQL a SQL utilizando mapeos R2RML. Además se proponen varias técnicas de optimización para generar consultas SQL que son más eficientes cuando son evaluadas en sistemas gestores de bases de datos relacionales. Este enfoque se evalúa mediante un benchmark sintético y varios casos reales. Otra recomendación relacionada con R2RML es la conocida como Direct Mapping (DM), que establece reglas fijas para la transformación de datos relacionales a RDF. A pesar de que ambas recomendaciones se publicaron al mismo tiempo, en septiembre de 2012, todavía no se ha realizado un estudio formal sobre la relación entre ellas. Por tanto, la segunda parte de esta tesis se centra en el estudio de la relación entre R2RML y DM. Se divide este estudio en dos partes: de R2RML a DM, y de DM a R2RML. En el primer caso, se estudia un fragmento de R2RML que tiene la misma expresividad que DM. En el segundo caso, se representan las reglas de DM como mapeos R2RML, y también se añade la semántica implícita (relaciones de subclase, 1-N y M-N) que se puede encontrar codificada en la base de datos. Esta tesis muestra que es posible usar R2RML en casos reales, sin necesidad de realizar materializaciones de los datos, puesto que las consultas SQL generadas son suficientemente eficientes cuando son evaluadas en el sistema gestor de base de datos relacional. Asimismo, esta tesis profundiza en el entendimiento de la relación existente entre las dos recomendaciones del W3C, algo que no había sido estudiado con anterioridad. ABSTRACT. RDB to RDF Mapping Language (R2RML) is a W3C recommendation that allows specifying rules for transforming relational databases into RDF. This RDF data can be materialized and stored in a triple store, so that SPARQL queries can be evaluated by the triple store. However, there are several cases where materialization is not adequate or possible, for example, if the underlying relational database is updated frequently. In those cases, RDF data is better kept virtual, and hence SPARQL queries over it have to be translated into SQL queries to the underlying relational database system considering that the translation process has to take into account the specified R2RML mappings. The first part of this thesis focuses on query translation. We discuss the formalization of the translation from SPARQL to SQL queries that takes into account R2RML mappings. Furthermore, we propose several optimization techniques so that the translation procedure generates SQL queries that can be evaluated more efficiently over the underlying databases. We evaluate our approach using a synthetic benchmark and several real cases, and show positive results that we obtained. Direct Mapping (DM) is another W3C recommendation for the generation of RDF data from relational databases. While R2RML allows users to specify their own transformation rules, DM establishes fixed transformation rules. Although both recommendations were published at the same time, September 2012, there has not been any study regarding the relationship between them. The second part of this thesis focuses on the study of the relationship between R2RML and DM. We divide this study into two directions: from R2RML to DM, and from DM to R2RML. From R2RML to DM, we study a fragment of R2RML having the same expressive power than DM. From DM to R2RML, we represent DM transformation rules as R2RML mappings, and also add the implicit semantics encoded in databases, such as subclass, 1-N and N-N relationships. This thesis shows that by formalizing and optimizing R2RML-based SPARQL to SQL query translation, it is possible to use R2RML engines in real cases as the resulting SQL is efficient enough to be evaluated by the underlying relational databases. In addition to that, this thesis facilitates the understanding of bidirectional relationship between the two W3C recommendations, something that had not been studied before.

Methods and Techniques for Segmentation of Consumers in Social Media

Los medios sociales han revolucionado la manera en la que los consumidores se relacionan entre sí y con las marcas. Las opiniones publicadas en dichos medios tienen un poder de influencia en las decisiones de compra tan importante como las campañas de publicidad. En consecuencia, los profesionales del marketing cada vez dedican mayores esfuerzos e inversión a la obtención de indicadores que permitan medir el estado de salud de las marcas a partir de los contenidos digitales generados por sus consumidores. Dada la naturaleza no estructurada de los contenidos publicados en los medios sociales, la tecnología usada para procesar dichos contenidos ha menudo implementa técnicas de Inteligencia Artificial, tales como algoritmos de procesamiento de lenguaje natural, aprendizaje automático y análisis semántico. Esta tesis, contribuye al estado de la cuestión, con un modelo que permite estructurar e integrar la información publicada en medios sociales, y una serie de técnicas cuyos objetivos son la identificación de consumidores, así como la segmentación psicográfica y sociodemográfica de los mismos. La técnica de identificación de consumidores se basa en la huella digital de los dispositivos que utilizan para navegar por la Web y es tolerante a los cambios que se producen con frecuencia en dicha huella digital. Las técnicas de segmentación psicográfica descritas obtienen la posición en el embudo de compra de los consumidores y permiten clasificar las opiniones en función de una serie de atributos de marketing. Finalmente, las técnicas de segmentación sociodemográfica permiten obtener el lugar de residencia y el género de los consumidores. ABSTRACT Social media has revolutionised the way in which consumers relate to each other and with brands. The opinions published in social media have a power of influencing purchase decisions as important as advertising campaigns. Consequently, marketers are increasing efforts and investments for obtaining indicators to measure brand health from the digital content generated by consumers. Given the unstructured nature of social media contents, the technology used for processing such contents often implements Artificial Intelligence techniques, such as natural language processing, machine learning and semantic analysis algorithms. This thesis contributes to the State of the Art, with a model for structuring and integrating the information posted on social media, and a number of techniques whose objectives are the identification of consumers, as well as their socio-demographic and psychographic segmentation. The consumer identification technique is based on the fingerprint of the devices they use to surf the Web and is tolerant to the changes that occur frequently in such fingerprint. The psychographic profiling techniques described infer the position of consumer in the purchase funnel, and allow to classify the opinions based on a series of marketing attributes. Finally, the socio-demographic profiling techniques allow to obtain the residence and gender of consumers.

Alphavirus-based expression vectors: strategies and applications.

Alphaviruses are positive-strand RNA viruses that can mediate efficient cytoplasmic gene expression in insect and vertebrate cells. Through recombinant DNA technology, the alphavirus RNA replication machinery has been engineered for high-level expression of heterologous RNAs and proteins. Amplification of replication-competent alpha-virus RNAs (replicons) can be initiated by RNA or DNA transfection and a variety of packaging systems have been developed for producing high titers of infectious viral particles. Although normally cytocidal for vertebrate cells, variants with adaptive mutations allowing noncytopathic replication have been isolated from persistently infected cultures or selected using a dominant selectable marker. Such mutations have been mapped and used to create new alphavirus vectors for noncytopathic gene expression in mammalian cells. These vectors allow long-term expression at moderate levels and complement previous vectors designed for short-term high-level expression. Besides their use for a growing number of basic research applications, recombinant alphavirus RNA replicons may also facilitate genetic vaccination and transient gene therapy.

The virion glycoproteins of Ebola viruses are encoded in two reading frames and are expressed through transcriptional editing.

In late 1994 and early 1995, Ebola (EBO) virus dramatically reemerged in Africa, causing human disease in the Ivory Coast and Zaire. Analysis of the entire glycoprotein genes of these viruses and those of other EBO virus subtypes has shown that the virion glycoprotein (130 kDa) is encoded in two reading frames, which are linked by transcriptional editing. This editing results in the addition of an extra nontemplated adenosine within a run of seven adenosines near the middle of the coding region. The primary gene product is a smaller (50-70 kDa), nonstructural, secreted glycoprotein, which is produced in large amounts and has an unknown function. Phylogenetic analysis indicates that EBO virus subtypes are genetically diverse and that the recent Ivory Coast isolate represents a new (fourth) subtype of EBO virus. In contrast, the EBO virus isolate from the 1995 outbreak in Kikwit, Zaire, is virtually identical to the virus that caused a similar epidemic in Yambuku, Zaire, almost 20 years earlier. This genetic stability may indicate that EBO viruses have coevolved with their natural reservoirs and do not change appreciably in the wild.

Stress management in mothers of children with Autism Spectrum Disorder : psychological characteristics, coping strategies and biological correlates

Un figlio con un Disturbo dello Spettro Autistico, caratterizzato da gravi difficoltà nelle relazioni, nei comportamenti e nella comunicazione, costringe tutto il sistema familiare a gestire un notevole stress dovuto alla gestione quotidiana di una patologia così complessa. Per questi motivi, i genitori necessitano di un sostegno il più possibile personalizzato rispetto alle caratteristiche del loro contesto familiare. Per fare questo sarebbe importante individuare quali siano i parametri correlati ai livelli di stress nei familiari di pazienti con autismo e che potrebbero avere un’influenza sul benessere familiare. Lo scopo di questo studio è quello di valutare quali caratteristiche di personalità, stili di coping e capacità di gestire le emozioni possano essere in relazione con la reattività individuale alle situazioni di stress, valutata attraverso alcuni correlati biologici, quali il livello di cortisolo (l’ormone dello stress) e la variabilità della frequenza cardiaca. L’ottica di ricerca applicata fa sì che gli obiettivi ultimi di questo lavoro siano anche quelli di diminuire l’accesso ai servizi per questi soggetti, considerando il fatto che progetti individualizzati di sostegno genitoriale costituiscono un fattore protettivo rispetto a conseguenze fisiche e psicologiche di disagio se implementati tenendo conto della variabilità individuale rispetto alle caratteristiche sopra citate.

Molecular Genetic Basis of Opposite Gene by Environment Interactions in Reading Disability and Attention Deficit/Hyperactivity Disorder

The goal of this study is to better understand the genetic basis of Reading Disability (RD) and Attention Deficit Hyperactivity Disorder (ADHD) by examining molecular G x E interactions with parental education for each disorder. Research indicates that despite sharing genetic risk factors, RD and ADHD are influenced by different types of G x E interactions with parental education - a diathesis stress interaction in the case of ADHD and a bioecological interaction in RD. In order to resolve this apparent paradox, we conducted a preliminary study using behavioral genetic methods to test for G x E interactions in RD and the inattentive subtype of ADHD (ADHD-I) in the same sample of monozygotic and dizygotic Colorado Learning Disabilities Research Center same-sex twin pairs (DeFries et al., 1997), and our findings were consistent with the literature. We posited a genetic hypothesis for this opposite pattern of interactions, which suggests that only genes specific to each disorder enter into these opposite interactions, not the shared genes underlying their comorbidity. This study sought to further investigate this paradox using molecular genetics methods. We examined multiple candidate genes identified for RD or related language phenotypes and those identified for ADHD for G x E interactions with parental education. The specific aims of this study were as follows: 1) partition known risk alleles for RD and/or related language phenotypes and ADHD-I into those which are pleiotropic and non-pleiotropic by testing each risk allele for association with both RD and ADHD-I, 2) explore the main effects of parental education on both RD and ADHD-I, 3) address G-E correlations, and 4) conduct exploratory G x E interaction analyses in order to test the genetic hypothesis. Analyses suggested a number of pleiotropic genes that influence both RD and ADHD; however, results did not remain after correcting for multiple comparisons. Although exploratory G x E interaction findings were not significant after multiple comparison correction, results suggested a G x E interaction in the bioecological direction with KIAA0319, parental education, and ADHD-I. Given the limited power in the current study, replication of these findings with larger samples is necessary.

The Tube on YouTube: TV Series, Media Strategies, and User Tactics in a Transmedia Environment

This study analyzes the traffic generated on YouTube around television series. We selected a sample of 314 short YouTube videos about 21 Spanish TV series that premiered in 2013 by Spain’s three most popular mainstream television networks (Telecinco, Antena 3, and La1). These videos, which together received more than 24 million views, were classified according to two key variables: the nature (official or nonofficial) of the YouTube channel on which they were located and the exclusivity of their content (already broadcast on TV or Web exclusive). The analysis allows us to characterize the strategies used by TV networks on YouTube and the activity of fans as well as their efforts in the construction of a transmedia narrative universe around TV series.

Reading Processes and Parenting Styles

Home literacy environment explains between 12 and 18.5% of the variance of children’s language skills. Although most authors agree that children whose parents encourage them to read tend to develop better and earlier reading skills, some authors consider that the impact of family environment in reading skills is overvalued. Probably, other variables of parent–child relationship, like parenting styles, might be relevant for this field. Nevertheless, no previous studies on the effect of parenting styles in literacy have been found. To analyze the role of parenting styles in the reading processes of children. Children’s perceptions of parenting styles contribute significantly to the explanation of statistical variance of children’s reading processes. 110 children (67 boys and 43 girls), aged between 7 and 11 years (M=9.22 and SD = 1.14) from Portuguese schools answered to a socio-demographic questionnaire. To assess reading processes it was administered the Portuguese adaptation (Figueira et al. in press) of Bateria de Avaliação dos Processos Leitores-Revista (PROLEC-R). To assess the parenting styles Egna Minnen av Barndoms Uppfostran-parents (EMBU-P) and EMBU-C (children version) were administered. According to multiple hierarchical linear regressions, individual factors contribute to explain all reading tests of PROLEC-R, while family factors contribute to explain most of these tests. Regarding parenting styles, results evidence the explanatory power about grammatical structures, sentence comprehension and listening. Parenting styles have an important role in the explanation of higher reading processes (syntactic and semantic) but not in lexical processes, focused by main theories concerning dyslexia.

Shaping sustainable economies-holistic strategies and principles. Policy Brief #2012/03

A society acts sustainably if it ensures the long-term stability and productivity of ecological, sociopolitical and economic systems. In the past, issues of sustainability were typically handled separately, neglecting individual measures’ effects on other elements implied by a comprehensive conception of sustainability. The challenge ahead is to develop a holistic strategy for sustainable economic activity that takes into ac-count interdependencies between the various aspects of sustainability, and does not seek to solve problems of sustainability at other aspects’ expense.

Responsive multimodal transportation management strategies and IVHS. Final report.

Federal Highway Administration, Office of Safety and Traffic Operations Research and Development, McLean, Va.