Bases de dades multimedia

La part del treball de recerca inclou un estudi que recull l'evolució de les bases de dades des del seu començament fins a l'actualitat, incloent-hi una previsió del futur de les bases de dades; finalment, com a aprofundiment, s'hi estudien les bases de dades multimèdia. D'altra banda, la part pràctica mira d'aplicar tots el coneixements adquirits durant l'estudi de recerca i durant les diferents assignatures de la carrera, i intenta obtenir una aplicació que es pugui fer servir en el món real.

Generació automàtica de l'esquema de bases de dades relacional d'una aplicació a partir del seu diagrama de classes representat en XML i creació automàtica d'interfícies de control d'intercanvi d'informació

En aquest projecte, amb la finalitat d'analitzar per mitjà d'un exemple (la base de dades d'una botiga que opera en línia) algunes de les possibilitats que dóna XML, s'ha construït un sistema que permet generar bases de dades relacionals (amb SQL) a partir de diagrames de classes definits en XML. D?aquesta manera es mostra la flexibilitat que aporta XML a la definició, el processament i la transformació dels documents.

RetroDisseny de Bases de Dades Relacionals

El plantejament inicial d'aquest projecte és el de aconseguir obtenir l'esquema conceptual originari de qualsevol base de dades relacional per a fer tasques de reenginyeria. Es pretén, a més, dotar al diagrama ER a obtenir d'extensions emprant llenguatge de definició de restriccions (OCL), per la qual cosa emprarem les llibreries de funcions Dresden OCL.

Uso de tecnologías abiertas (Processing) en el desarrollo de interfaces avanzadas de visualización y acceso de datos : Estudio del caso Organic.Edunet

El artículo muestra, a través del estudio del caso del buscador semántico del portal Organic.Edunet, cómo el uso de tecnologías cerradas en la creación de interfaces avanzadas de visualización de datos impide su desarrollo y evolución. En el artículo se mostrará también cómo, combinado con técnicas para la medición y valoración de la usabilidad de las aplicaciones, el uso de tecnologías abiertas permite detectar los problemas del interface, proponer soluciones o alternativas, e implementarlas rápidamente.

The profiling of MDMA tablets: a study of the combination of physical characteristics and organic impurities as sources of information

The profiling of MDMA tablets can be carried out using different sets of characteristics. The first type of measurements performed on MDMA tablets are physical characteristics (i.e. post-tabletting characteristics). They yield preliminary profiling data that may be valuable in a first stage for investigation purposes. However organic impurities (i.e. pre-tabletting characteristics) are generally considered to bring more reliable information, particularly for presentation of evidence in court. This work aimed therefore at evaluating the added value of combining pre-tabletting characteristics and post-tabletting characteristics of seized MDMA tablets. In approximately half of the investigated cases, the post-tabletting links were confirmed with organic impurities analyses. In the remaining cases, post-tabletting batches (post-TBs) were divided in several pre-tabletting batches (pre-TBs), thus supporting the hypothesis that several production batches of MDMA powder (pre-TBs) were used to produce one single post-TB (i.e. tablets having the same shape, diameter, thickness, weight and score; but different organic impurities composition). In view of the obtained results, the hypotheses were discussed through illustrating examples. In conclusion, both sets of characteristics were found relevant alone and combined together. They actually provide distinct information about MDMA illicit production and trafficking.

Parental occupational exposure to organic solvents and anencephaly in Mexico

Objective: To assess the relationship between parental occupational exposure to organic solvents, and the risk of anencephaly in Mexico. Methods: A case-control study was conducted based on the registers of the Epidemiological Surveillance System for Neural Tube Defects in Mexico; 151 cases of anencephaly of ≥20 weeks’ gestation were included. A control, born alive and without any apparent congenital malformations at birth, was selected for each case in the same maternity service in which the case was born. Information on occupational exposures, lifestyle habits, reproductive history, use of medicines, supplementation with multivitamins and folic acid, was obtained by a general questionnaire; a food frequency questionnaire was also applied to obtain information of daily intake of folate and other B vitamins. Occupational exposure to organic solvents was based on job title as a proxy for exposure and analysed considering two critical periods around conception. Results: In logistic regression analysis, the odds of having a child with anencephaly was higher if the mother or the father was occupationally exposed to organic solvents during the periconceptional period, or when both parents or at least one of them were occupationally exposed during this period with an adjusted odds ratio of 2.97 (95% CI 1.36 to 6.52). Conclusions: The results support the hypothesis that both maternal and paternal occupational exposure to organic solvents can increase the probability of having a child with anencephaly.

Endocannabinoid system and psychiatry: in search of a neurobiological basis for detrimental and potential therapeutic effects.

Public concern on mental health has noticeably increased given the high prevalence of neuropsychiatric disorders. Cognition and emotionality are the most affected functions in neuropsychiatric disorders, i.e., anxiety disorders, depression, and schizophrenia. In this review, most relevant literature on the role of the endocannabinoid (eCB) system in neuropsychiatric disorders will be presented. Evidence from clinical and animal studies is provided for the participation of CB1 and CB2 receptors (CB1R and CB2R) in the above mentioned neuropsychiatric disorders. CBRs are crucial in some of the emotional and cognitive impairments reported, although more research is required to understand the specific role of the eCB system in neuropsychiatric disorders. Cannabidiol (CBD), the main non-psychotropic component of the Cannabis sativa plant, has shown therapeutic potential in several neuropsychiatric disorders. Although further studies are needed, recent studies indicate that CBD therapeutic effects may partially depend on facilitation of eCB-mediated neurotransmission. Last but not least, this review includes recent findings on the role of the eCB system in eating disorders. A deregulation of the eCB system has been proposed to be in the bases of several neuropsychiatric disorders, including eating disorders. Cannabis consumption has been related to the appearance of psychotic symptoms and schizophrenia. In contrast, the pharmacological manipulation of this eCB system has been proposed as a potential strategy for the treatment of anxiety disorders, depression, and anorexia nervosa. In conclusion, the eCB system plays a critical role in psychiatry; however, detrimental consequences of manipulating this endogenous system cannot be underestimated over the potential and promising perspectives of its therapeutic manipulation.

Binding of ²³⁹Pu and ⁹⁰Sr to organic colloids in soil solutions: evidence from a field experiment.

Colloidal transport has been shown to enhance the migration of plutonium in groundwater downstream from contaminated sites, but little is known about the adsorption of ⁹⁰Sr and plutonium onto colloids in the soil solution of natural soils. We sampled soil solutions using suction cups, and separated colloids using ultrafiltration to determine the distribution of ²³⁹Pu and ⁹⁰Sr between the truly dissolved fraction and the colloidal fraction of the solutions of three Alpine soils contaminated only by global fallout from the nuclear weapon tests. Plutonium was essentially found in the colloidal fraction (>80%) and probably associated with organic matter. A significant amount of colloidal ⁹⁰Sr was detected in organic-rich soil solutions. Our results suggest that binding to organic colloids in the soil solutions plays a key role with respect to the mobility of plutonium in natural alpine soils and, to a lesser extent, to the mobility of ⁹⁰Sr.

Characterization of a protein of the plastid inner envelope having homology to animal inorganic phosphate, chloride and organic-anion transporters.

A protein from Arabidopsis thaliana (L.) Heynh. showing homology to animal proteins of the NaPi-1 family, involved in the transport of inorganic phosphate, chloride, glutamate and sialic acid, has been characterized. This protein, named ANTR2 (for anion transporters) was shown by chloroplast subfractionation to be localized to the plastid inner envelope in both A. thaliana and Spinacia oleracea (L.). Immunolocalization revealed that ANTR2 was expressed in the leaf mesophyll cells as well as in the developing embryo at the upturned-U stage. Five additional homologues of ANTR2 are found in the Arabidopsis genome, of which one was shown by green fluorescent protein (GFP) fusion to be also located in the chloroplast. All ANTR proteins share homology to the animal NaPi-1 family, as well as to other organic-anion transporters that are members of the Anion:Cation Symporter (ACS) family, and share the main features of transporters from this family, including the presence of 12 putative transmembrane domains and of a 7-amino acid motif in the fourth putative transmembrane domain. ANTR2 thus represent a novel protein of the plastid inner envelope that is likely to be involved in anion transport.

Evaluation of work-related volatile organic compounds (VOCs) exposition in automotive painting cabins industrial cleanings

Automotive painting cabins are cleaned with several solvents, being great part of them mixtures of volatile organic compounds (VOCs), where the three xylene isomers are the most important constituents. To evaluate the work-related exposition of the cleaners that use these mixtures of solvents, xylenes have been determined in the working ambient air as well as its metabolite, o-m-p-methyl hippuric acid, has been analysed in urine to establish the dermal and respiratory exposition. This evaluation has been done in order to assess the occupational exposure to VOCs and to know the working conditions of the cleaners, but also to evaluate the effectiveness of personal protective equipment (PPE), the engineering control and the work practices.The xylenes have been chosen as indicators of exposition because they are the main components in the cleaning solvents used, with a level of concentration between 50% and 85%.The Xylenes have an occupational exposure limit (8 h TWA) of 50 ppm (221 mg/m3) and a short-term exposure limit (STEL) of 100 ppm (442 mg/m3). On the other hand, the biological exposure index (BEI) for xylenes is the sum of the total methyl hippuric acids in urine at the end of the work-shift, being the value 1500 mg/g creatinine.

Bases de datos : Empresa de selección de personal

Este documento refleja el trabajo realizado durante el diseño e implementación de una base de datos relacional y un almacén de datos para una empresa de gestión de personal.

L’atribució legal de drets successoris al cònjuge i al convivent: bases per a una reforma

Se explora el fundamento y finalidad de las atribuciones legales mortis causa previstas para el cónyuge y el conviviente. Los beneficios viudales y sucesorios se analizan para aportar reflexiones que sirvan para afrontar una reforma de los mismos que sea capaz de ajustarles mejor técnica, familiar y socialmente.

XML y web semántica : Bases de datos en el contexto de la web semántica

Este trabajo define qué es una base de datos semántica, qué ventajas ofrece, cómo se utiliza y en qué tipo de proyectos o sistemas tiene sentido usarla. Además, en él se estudia en detalle una de ellas, OWLIM 1, de la empresa Ontotext, para evaluar la dificultad de usarla, su rendimiento y sus capacidades específicas.

Bases neuroestructurals i neurofuncionals de la discalcúlia del desenvolupament

La discalcúlia del desenvolupament (DD) és un trastorn de l'aprenentatge que afecta a la correcta adquisició i execució de les habilitats aritmètiques, i que comporta una discrepància entre la capacitat per al càlcul i el quocient d'intel•ligència. La prevalença és d'un 3 a un 6%, similar a la d'altres trastorns del desenvolupament. Existeix comorbilitat de la DD amb altres trastorns del desenvolupament: amb la dislèxia en un 17% i amb el trastorn per dèficit d'atenció/hiperactivitat en un 20%. Es creu que l'origen neural de la DD es localitzaria al lòbul parietal, i en concret, estudis actuals de neuroimatge recolzen el solc intraparietal (IPS) com la regió clau del processament aritmètic. Tot i així, també hi participarien altres regions cerebrals, com el lòbul prefrontal. L'objectiu del nostre projecte és aprofundir en els dèficits anatòmics i funcionals associats als dèficits numèrics en persones amb discalcúlia pura, amb DD associada a dislèxia i amb DD associada a TDA/H. La determinació de diferents patrons de dèficits neurals i de rendiment cognitiu, en aquests tres grups de pacients, ajudaria a l'elaboració de programes de reeducació més específics, i repercutiria positivament en el tractament de la DD. En el present estudi, s'evaluaren neuropsicològicament i mitjançant ressonància magnètica funcional 22 nens i nenes amb DD pura i cómorbida amb dislèxia i TDA/H. En el present moment, l'estudi es troba a la fase de recollida de dades.