Gestió d'incidències post venda de productes electrodomèstics

Base de dades per gestionar incidències post venda de productes electrodomèstics. Inclou anàlisi, disseny i creació de la base de dades i del magatzem de Dades.

TFC almacén de datos : creación y explotación de un almacén de datos de festivales cinematográficos

Memoria de TFC de creación y explotación de un almacén de datos de festivales cinematográficos.

Web per a psicologia i teràpia online Espai Nirvana

Aquest Treball de Final de Carrera engloba l'anàlisi, el disseny i la implementació d'una aplicació web per a psicologia i teràpia online. L'enginyeria d'aquest programari està basada en la tècnica d'orientació a objectes, dins l'estàndard UML. Els aspectes generals de l'anàlisi i disseny s'han desenvolupat amb un cicle de vida en cascada, per tenir una bona base de partida i poder confeccionar una planificació en el temps. La fase de implementació, està basada en un cicle de vida iteratiu e incremental, implementant a cada iteració una petita part amb autonomia que correspon a un cas d'ús. Com a llenguatge de desenvolupament he escollit Java , i com a arquitectura de l'aplicació J2EE, degut a la seva robustesa i a que en l'actualitat, té un fort posicionament en aplicacions web i en xarxa, arribant a ser un estàndard en l'entorn distribuït d'aplicacions empresarials a Internet. En l'estratègia en el disseny i per donar solucions efectives a problemes tipificats, he fet servir el patró MVC, que a més, ha incrementat considerablement la reusabilitat i efectivitat del codi i estructura de la programació. Per a la implementació he incorporat el framework Struts2, que basa la seva arquitectura en el patró MVC, i que ha facilitat molt el treball ja que ha donat solucions a problemes generals estàndard i altres de baix nivell, i ha permès focalitzar els esforços en donar solució a qüestions més particulars i específiques del projecte. En l'accés transparent a les dades he optat per Hibernate3, una poderosa eina que enllaça el món relacional de les BBDD amb el mon de l'orientació a objectes de les classes de les aplicacions. I com a SGBD per a la persistència de dades, he fet servir Oracle 10g XE, també tot un referent en la indústria, i un dels més complets.

Construcció i explotació d'un magatzem de dades d'informació cinematogràfica

El present document és la memòria del Treball de Final de Carrera de la Enginyeria Tècnica de Gestió de l'àrea de Magatzem de Dades.Hi trobarem el resum del procés de creació complerta d'un magatzem de dades amb einesOracle, des de l'anàlisi preliminar del problema plantejat fins a la creació dels informes per a la explotació de les dades.La base de dades que s'ha utilitzat correspon a informació cinematogràfica referent a premis aconseguits.

What does determine gonad weight in the wild kissing bug Mepraia spinolai

Female fecundity increases with body size in a variety of insects, but it is unknown if this generalization applies for kissing bugs. In this study, we evaluate whether gonad weight in the bloodsucking insect Mepraia spinolai correlates with body size, or determined by nutrition or developmental time. We found that the investment on reproductive tissue correlates positively and significantly with body size and with the amount of ingested blood by female insects along their lifespan. Total molting time did not significantly affect gonad weight. We suggest that under optimal feeding conditions M. spinolai females could express their maximum reproductive potential.

Analyse UBM du site de filtration après sclérectomie profonde postérieure modifiée utillisant un tube Ex-PRESS? X-50

Purpose: To study the filtering site using ultrasound biomicroscopy. (UBM) after posterior deep sclerectomy with Ex-PRESS? X-50 implant in patients undergoing filtering surgery.¦Methods: Twenty-six patients that participated in this prospective, non comparative study underwent a posterior deep sclerectomy and an Ex- PRESS? X-50 tube implantation. Clinical outcome factors recorded include: intraocular pressure, number of antiglaucoma medications, best corrected visual acuity (BCVA), frequency and types of complications. Six months postoperatively, an ultrasound biomicroscopy examination was performed.¦Results: Mean follow up was 12.0±3.4 months. Mean IOP decreased from 21 ±5.7 mmHg to 12.4±3 mmHg. At last follow-up examination, 65% of eyes had a complete success and 30% a qualified success. The mean number of antiglaucoma medications decreased from 2.5±1.2 preoperatively to 0.7±1 at the last follow-up postoperatively. BCVA was not changed. 27 complications were observed. On the UBM images, the mean intrascleral space volume was 0.25±0.27 mm3 and no relationship was found between volume and intraocular pressure reduction. We noted in 5/26 (19%) eyes a suprachoroïdal hypoechoic. Low-reflective blebs (L-type) were the most common: 15/26 (58%). No correlation between UBM findings and surgical success was evident.¦Conclusions: Deep sclerectomy with Ex-PRESS? X-50 tube implantation seems an efficient glaucoma surgery. It allows satisfactory IOP reduction with a low number of post operative complications. The advantages of deep sclerectomy with collagen implant are maintained with this modified technique. In both, the same reflective types of filtering blebs are present (high, low, encapsulated and flat). The UBM underlines the three mechanisms of aqueous humor resorption previously identified but no correlation with surgical success can be proved.¦-¦Ce travail de thèse est une analyse par ultrasonographic biomicroscopique (UBM) du site de filtration après sclérectomie profonde postérieure modifiée avec implantation d'un tube Ex- PRESS? X-50.¦Vingt six patients atteints d'un glaucome à angle ouvert, ont participé à cette étude prospective et non-comparative. Le critère d'inclusion est un glaucome à angle ouvert non contrôlé malgré un traitement topique maximal.¦Différents types de chirurgie filtrante sont effectués dans la chirurgie du glaucome dont la trabéculectomie et la sclérectomie profonde.¦L'intervention chirurgicale pratiquée dans cette étude consiste en l'implantation d'un tube Ex-PRESS? X-50 de format défini (3 mm de longueur et 50 μπι de diamètre interne) dans la chambre antérieure,au niveau du trabeculum, sous un volet scléral, ce qui permet le drainage de l'humeur aqueuse vers les espaces sous-conjonctivaux, avec diminution de la pression intraoculaire.¦Cette technique implique uniquement une dissection d'un volet scléral superficiel , sans volet scléral profond comme d'une sclérectomie profonde classique.¦Les modes de fonctionnement de cette sclérectomie profonde modifiée sont explorés par UBM, qui donne des images à haute résolution, semblables à des coupes anatomiques. Le volume de l'espace intrascléral créé artificiellement peut en effet être mesuré et mis en corrélation avec la pression intraoculaire et donc avec le taux de succès. Les différents types d'échogénécité de la bulle de filtration sous-conjonctivale provoquée par la dérivation de l'humeur aqueuse sont également observés. La présence éventuelle d'une filtration supplémentaire au niveau choroïdien est aussi détectée.¦De février 2007 à juin 2008, nous avons suivi chez les vingt six yeux des vingt six patients le volume intrascléral, la filtration sous-conjonctivale et la filtration choroïdienne le cas échéant, de même que l'acuité visuelle, la pression intraoculaire, le nombre de traitement antihypertenseur topique et les complications.¦Les résultats démontrent une réduction de 41 % par rapport à la pression intraoculaire préopératoire, ce qui est statistiquement significatif (p<0.0005). En ce qui concerne l'acuité visuelle, les valeurs demeurent stables. Par ailleurs, le nombre de médicaments antiglaucomateux diminue de façon significative de 2.5 ± 1.2 en préopératoire à 0.7 ± 1.0 au dernier examen (p<0.0005). Le volume de l'espace intrascléral, apparaissant toujours en échographie d'aspect fusiforme, n'est pas corrélé de façon significative avec un meilleur succès chirurgical bien que l'on aperçoive une tendance à une corrélation entre un plus grand volume et une pression intraoculaire plus basse.¦La classification la bulle de filtration se fait selon les 4 catégories de bulle de filtration décrites dans la littérature. La répartition révèle une majorité de type L soit hypoéchogène: 15/26 (58%) et une proportion identique, soit, 4/26 (16%), de bulles hyperéchogènes (type H) et encapsulées (type E); les bulles de filtration plates et hyperéchogènes (type F) sont les moins nombreuses 3/26 (11 %).¦La ligne hyporéflective visible dans 19 % des cas entre la sclère et la choroïde représentant potentiellement un drainage suprachoroïdien, n'est pas associée statistiquement à une meilleure filtration et une pression intraoculaire plus basse mais demeure une troisième voie de filtration, en plus de la filtration sous-conjonctivale et intrasclérale.¦En conclusion, cette technique différente, offrant une plus grande sécurité et des résultats satisfaisants sur l'abaissement de la pression intraoculaire, peut être, dans certains cas, une alternative à la sclérectomie profonde classique ,dont elle partage les mécanismes de filtration objectivés par ultrasonographic biomicrioscopique.

Sistema de gestió d'amonestacions i sancions en centres educatius

L'objectiu d'aquest treball és l'elaboració del disseny i la implementació d'una base de dades relacional per a la gestió d'amonestacions i sancions en centres educatius d'ensenyament secundari de Catalunya.

Projecte "Aca" : TFC Treball Fi de Carrera (Magatzem de dades)

Construcció i explotació d'un magatzem de dades d'informació cinematogràfica.

Sistema d'amonestacions i sancions per al Departament d'Ensenyament

Disseny d'una base de dades per a gestionar les amonestacions i sancions imposades als alumnes de tots els centres d'ensenyament del Departament d'Ensenyament.

Disseny i implementació d¿un sistema de gestió d¿amonestacions i sancions en centres educatius

Aquest projecte és una proposta de disseny i implementació d¿una base de dades relacionalper la Generalitat de Catalunya. Sintetitza cadascuna de les fases que tot projecte d'elaboració de programari ha de tenir. La implementació de la BD ha estat realitzada amb el SGBD Oracle.

Use of the chicken lysozyme 5' matrix attachment region to generate high producer CHO cell lines.

Scaffold or matrix attachment region (S/MAR) genetic elements have previously been proposed to insulate transgenes from repressive effects linked to their site of integration within the host cell genome. We have evaluated their use in various stable transfection settings to increase the production of recombinant proteins such as monoclonal antibodies from Chinese hamster ovary (CHO) cell lines. Using the green fluorescent protein coding sequence, we show that S/MAR elements mediate a dual effect on the population of transfected cells. First, S/MAR elements almost fully abolish the occurrence of cell clones that express little transgene that may result from transgene integration in an unfavorable chromosomal environment. Second, they increase the overall expression of the transgene over the whole range of expression levels, allowing the detection of cells with significantly higher levels of transgene expression. An optimal setting was identified as the addition of a S/MAR element both in cis (on the transgene expression vector) and in trans (co-transfected on a separate plasmid). When used to express immunoglobulins, the S/MAR element enabled cell clones with high and stable levels of expression to be isolated following the analysis of a few cell lines generated without transgene amplification procedures.

IL-4 rapidly produced by V beta 4 V alpha 8 CD4+ T cells instructs Th2 development and susceptibility to Leishmania major in BALB/c mice.

BALB/c mice develop aberrant T helper 2 (Th2) responses and suffer progressive disease after infection with Leishmania major. These outcomes depend on the production of interleukin-4 (IL-4) early after infection. Here we demonstrate that the burst of IL-4 mRNA, peaking in draining lymph nodes of BALB/c mice 16 hr after infection, occurs within CD4+ T cells that express V beta 4 V alpha 8 T cell receptors. In contrast to control and V beta 6-deficient BALB/c mice, V beta 4-deficient BALB/c mice were resistant to infection, demonstrating the role of these cells in Th2 development. The early IL-4 response was absent in these mice, and T helper 1 responses occurred following infection. Recombinant LACK antigen from L. major induced comparable IL-4 production in V beta 4 V alpha 8 CD4+ cells. Thus, the IL-4 required for Th2 development and susceptibility to L. major is produced by a restricted population of V beta 4 V alpha 8 CD4+ T cells after cognate interaction with a single antigen from this complex organism.

SNARE protein expression in synaptic terminals and astrocytes in the adult hippocampus: a comparative analysis.

Several evidences suggest that astrocytes release small transmitter molecules, peptides, and protein factors via regulated exocytosis, implying that they function as specialized neurosecretory cells. However, very little is known about the molecular and functional properties of regulated secretion in astrocytes in the adult brain. Establishing these properties is central to the understanding of the communication mode(s) of these cells and their role(s) in the control of synaptic functions and of cerebral blood flow. In this study, we have set-up a high-resolution confocal microscopy approach to distinguish protein expression in astrocytic structures and neighboring synaptic terminals in adult brain tissue. This approach was applied to investigate the expression pattern of core SNARE proteins for vesicle fusion in the dentate gyrus and CA1 regions of the mouse hippocampus. Our comparative analysis shows that astrocytes abundantly express, in their cell body and main processes, all three protein partners necessary to form an operational SNARE complex but not in the same isoforms expressed in neighbouring synaptic terminals. Thus, SNAP25 and VAMP2 are absent from astrocytic processes and typically concentrated in terminals, while SNAP23 and VAMP3 have the opposite expression pattern. Syntaxin 1 is present in both synaptic terminals and astrocytes. These data support the view that astrocytes in the adult hippocampus can communicate via regulated exocytosis and also indicates that astrocytic exocytosis may differ in its properties from action potential-dependent exocytosis at neuronal synapses, as it relies on a distinctive set of SNARE proteins.

Expression pattern of sirtuins in innate immune cells and influence of Sirtuin 1/2 inhibition on innate immune responses to Toll-like receptor ligands and to infection

Purpose/Objective: The family of histone deacetylases comprises 18 members in mammals, among which seven sirtuins (SIRT1-7). Sirtuins are NADP-dependent enzymes that have been involved in the control of cell metabolism, proliferation and survival. The expression pattern of sirtuins and their influence on host response to microbial infection remain largely unknown. The aim of the study was to analyze the expression of SIRT1-7 and to address the effects of SIRT1/2 inhibition on innate immune responses in vitro and in vivo.. Materials and methods: in vitro: Bone marrow (BM), BM-derived macrophages (BMDMs) and dendritic cells (BMDCs) and RAW 264.7 and J774.1 macrophage cell lines were stimulated for 0, 2, 6 and 18 h with LPS, Pam3CSK4 and CpG ODN. SIRT1-7 mRNA was quantified by real time-PCR. TNF was measured by ELISA. In vivo: BALB/c mice were challenged with LPS (350 lg i.p.) with or without a SIRT1/2 inhibitor. Blood and organs were collected after 0, 1, 4, 8 and 24 h to quantify SIRT1-7 and TNF. Mortality was assessed daily. Results: Bone marrow, macrophages and DCs express, in order of abundance, SIRT2 > > SIRT1, SIRT3 and SIRT6 > SIRT4, SIRT5 and SIRT7. Microbial products decrease the expression of all sirtuins except SIRT6 in a time dependent manner in BMDMs (0_24 h). SIRT2 is the most expressed sirtuin also in the liver, kidney (together with SIRT3) and spleen. Upon LPS challenge, SIRT1, SIRT3, SIRT4 and SIRT7 mRNA levels decrease in the liver (from 4 h to 24 h), whereas SIRT1-7 mRNA levels decrease within 1 h in both kidney and spleen. Pharmacological inhibition of SIRT1/2 decreases TNF production by macrophages stimulated with LPS, Pam3CSK4 and CpG ODN (n = 6; P < 0.001). In agreement, prophylactic treatment with a SIRT1/2 inhibitor decreases TNF production (n = 8; P = 0.04) and increases survival (n = 13, P = 0.03) of mice challenged with LPS. Conclusions: Sirtuins are expressed in innate immune cells. Inhibition of SIRT1/2 activity decreases cytokine production by macrophages and protects from endotoxemia, suggesting that sirtuin inhibitors may represent novel adjunctive therapy for treating inflammatory disorders such as sepsis.

Mice Transgenic For Human Dominant Mutations Of The GUCY2D Gene

Purpose: Animal models are essential to study pathological mechanisms and to test new therapeutic strategies. Many mouse models mimic human rod loss but only a limited number simulate cone dystrophies. The importance of cone function for human vision highlights the need to engineer a model for cone degeneration. An approach of lentiviral-directed transgenesis was tested in mice to express a dominant mutant gene described in a human cone dystrophy.Methods: Lentiviral vectors (LV) encoding either hrGFPII or the human double mutant GUCY2DE837D/R838S cDNA under the control of a region of the pig arrestin-3 promoter (Arr3) were produced and used for lentiviral-derived transgenesis. PCR-genotyping determined the transgenic mouse ratio. The expression of GFP was then analyzed both in vivo and by immunohistochemistry in Arr3-GFPII mice. Functional analysis was performed by ERG at 5, 9, 16 and 24 weeks for Arr3-GUCY2DE837D/R838S mice. Mice were sacrificed at 10 months of age for both histological analysis and RNA extraction.Results: While all the newborns from the transgenesis using the LV-Arr3-GFPII were transgenic, one third of the newborns from the LV-Arr3-GUCY2DE837D/R838S transgenesis were positive. Expression of GFPII was demonstrated by in vivo imaging, while expression of the mutant GUCY2D transcript was detetected using RT-PCR. No severe alteration of the functional response was observed up to 24 weeks of age in the transgenic mice. No obvious modification of the retinal morphology was identified either.Conclusions: Lentiviral-directed transgenesis is a rapid and straightforward method to engineer transgenic mice. Protein expression can be specifically targeted to the retina and thus could help to study the effect of expression of dominant mutant proteins. In our case, Arr3-GUCY2DE837D/R838S mice have a less severe phenotype than that described for human patients. Further analyses are required to understand this difference but several modifications of the expression cassette might also help to increase the expression of the mutant protein and reinforce the phenotype. Interestingly, the same construct is less effective in mouse versus pig retina (see Arsenijevic et al. ARVO 2011 abstract).