Estudi i avaluació de les funcionalitats de PostgreSQL

L'objectiu del projecte és fer un resum de les funcionalitats i la idoneïtat del sistema de gestió de base de dades PostgreSQL, per a facilitar la posible implantació en l'àmbit docent universitari.

Construcció d'un SIG municipal aplicat a les necessitats d'una població qualsevol

Aquest TFC pretén endinsar-se i aprofundir en el coneixement i comprensió del món dels SIG. En concret, el present TFC es centra en la implantació d'un SIG per a la gestió municipal d'una zona en concret del municipi de Tremp.

Implantación de un sistema ERP SAP

Aquest treball té com a objectiu plantejar i desenvolupar les activitats que s'han de dur a terme en un projecte d'implantació del sistema d'informació integrat ERP (Enterprise Resource Planning) SAP R/3 en una empresa espanyola del sector farmacèutic.

Management of a post-operative multi-resistant infectious spondylitis associated with a kyphotic deformity.

Anterior spinal infection (prevertebral abscess and/or discitis) after posterior instrumentation for vertebral fractures is a challenging complication, since a new implant may become necessary anteriorly, in a septic environment. Generally accepted management guidelines are yet to be established. The authors present a case of posterior instrumentation for fractures of T12 and L1, complicated after 9 months with an anterior infection (prevertebral abscess and discitis) with extended-spectrum beta-lactamase (ESBL) producing Escherichia coli (E. coli). This case is unique in that the multi-resistant organism was isolated only after the second stage of infection treatment, which consisted of anterior débridement and anterior implantation of titanium cages and rods. In this particular case, infection was controlled despite implantation of multiple cages, screws and rods, and fusion was achieved, by means of intravenous antibiotic treatment for 12 months. At the latest follow-up, 24 months post surgery, there was no evidence of infection. This problem case may be helpful for surgeons confronted with spinal deformities secondary to infections with multi-resistant organisms.

Interstitial cells of Cajal are normally distributed in both ganglionated and aganglionic bowel in Hirschsprung's disease

Résumé Introduction : La chirurgie de la maladie de Hirschsprung est fréquemment compliquée d'une atteinte post-opératoire de la motilité intestinale. Des anomalies du système nerveux entérique (SNE) telles que la dysplasie neuronale intestinale de type B, l'hypoganglionose ou l'aganglionose, présents dans le segment abaissé, peuvent être la cause de certaines de ces complications mais aucune information n'est disponible quant au rôle des cellules interstitielles de Cajal (CIC) sur la motilité intestinale dans la phase post-opératoire. Ces cellules sont considérées avoir un rôle de pacemaker dans le tractus gastro-intestinal. L'objectif de cette étude était de décrire la distribution des CIC dans le segment proximal du côlon réséqué lors de cures chirurgicales de maladie de Hirschsprung et de confronter ces observations à l'évolution clinique post-opératoire. Matériel et Méthodes : L'incidence des complications post-opératoires a été déterminée par une revue rétrospective des dossiers de 48 patients opérés pour maladie de Hirschspung entre 1977 et 1999 et par l'étude histologique et immuno-histochimique des pièces réséquées chez ces patients. Nous avons comparé la distribution des CIC dans le segment proximal du côlon avec celle du côlon sain de 16 enfants contrôles par microscopie optique. L'immunohistochimie au c-Kit a été utilisée pour marquer spécifiquement les CIC sur échantillons paraffinés. Ces résultats ont ensuite été corrélés avec l'étude du SNE de ces mêmes segments, déterminée par immunohistochimie au CD56 et au protein gene product 9.5. Résultats Les complications post-opératoires suivantes furent identifiées : constipation 46%, constipation avec incontinence 15%, entérocolite 8%, décès 4% (probablement sur entérocolite). La distribution des CIC dans les segments proximaux réséqués chez les enfants avec maladie de Hirschsprung était identique à celle observée dans les segments de côlon sain, et ce indépendamment de la distribution normale ou anormale du SNE. Chez les enfants opérés pour maladie de Hirschsprung les segments réséqués présentaient les anomalies d'innervation suivantes : aganglionose 10.4%, hypoganglionose 12.5%, dysplasie neuronale intestinale de type B 6.3%, autres dysganglionoses 14.6%. Aucune relation entre ces anomalies d'innervation et les complications post-opératoires n'a été mise en évidence. Conclusion : La distribution des CIC est normale chez les patient opérés pour maladie de Hirschsprung, et ne contribue donc pas aux atteintes post-opératoires de la motilité intestinale. Cela signifie aussi que le réseau de CIC se développe noinialement dans le côlon humain, même en présence d'une innervation colique anormale ou absente. Abstract: Surgery for Hirschsprung's disease is often complicated by post-operative bowel motility disorders. The impact of intestinal neural histology on the surgical outcome has been previously studied, but no information is available concerning the influence of the distribution of interstitial cells of Cajal (ICC) on these complications. These cells are considered to be pacemakers in the gastrointestinal tract. The aim of this study was to assess the distribution of ICC in the proximal segment of resected bowel in Hirschsprung's disease and confront these results with the clinical outcome. Using immunohistochemistry for light microscopy, we compared the pattern of distribution of ICC in the proximal segment of resected bowel in Hirschsprung's disease with that in normal colon. We correlated these results with the corresponding neural intestinal histology determined by CD56 and the protein gene product 9.5 immunohistochemistry. The distribution of ICC in the proximal segment of resected bowel is identical to that of normal colon, regardless of normal or abnormal colon innervation. ICC distribution does not seem to contribute to post-operative bowel motility disorders in patients operated for Hirschsprung's disease.

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.

Adaptació de Xarxipèlag 2.0 a l'IER Juníper Serra

El treball mostra el procés d'implantació del projecte Xarxipèlag 2.0 a l'IES Juníper Serra de Palma de Mallorca.

Development and experimental validation of a finite element model of total ankle replacement.

Total ankle replacement remains a less satisfactory solution compared to other joint replacements. The goal of this study was to develop and validate a finite element model of total ankle replacement, for future testing of hypotheses related to clinical issues. To validate the finite element model, an experimental setup was specifically developed and applied on 8 cadaveric tibias. A non-cemented press fit tibial component of a mobile bearing prosthesis was inserted into the tibias. Two extreme anterior and posterior positions of the mobile bearing insert were considered, as well as a centered one. An axial force of 2kN was applied for each insert position. Strains were measured on the bone surface using digital image correlation. Tibias were CT scanned before implantation, after implantation, and after mechanical tests and removal of the prosthesis. The finite element model replicated the experimental setup. The first CT was used to build the geometry and evaluate the mechanical properties of the tibias. The second CT was used to set the implant position. The third CT was used to assess the bone-implant interface conditions. The coefficient of determination (R-squared) between the measured and predicted strains was 0.91. Predicted bone strains were maximal around the implant keel, especially at the anterior and posterior ends. The finite element model presented here is validated for future tests using more physiological loading conditions.

Morphological scoring of human pronuclear zygotes for prediction of pregnancy outcome.

BACKGROUND: As embryo selection is not allowed by law in Switzerland, we need a single early scoring system to identify zygotes with high implantation potential and to select zygotes for fresh transfer or cryopreservation. The underlying aim is to maximize the cumulated pregnancy rate while limiting the number of multiple pregnancies. METHODS: In all, 613 fresh and 617 frozen-thawed zygotes were scored for proximity, orientation and centring of the pronuclei, cytoplasmic halo, and number and polarization of the nucleolar precursor bodies. From these individual scores, a cumulated pronuclear score (CPNS) was calculated. Correlation between CPNS and implantation was examined and compared between fresh and frozen-thawed zygotes. The effect of freezing on CPNS was also investigated. RESULTS: CPNS was positively associated with embryo implantation in both fresh and frozen zygotes. With similar CPNS, frozen zygotes presented implantation rates as high as those of fresh zygotes. Nucleolar precursor bodies pattern and cytoplasmic halo appeared as the most important factors predictive of implantation for both types of zygotes, while pronuclei position was specifically relevant for frozen-thawed zygotes. Freezing induced an alteration of most zygote parameters, resulting in a significantly lower CPNS and a lower pregnancy rate. CONCLUSIONS: CPNS may be used as a single prognostic tool for implantation of both fresh and frozen-thawed zygotes. Lower CPNS values of frozen-thawed zygotes may also be indicative of freezing damage to zygotes. Successful implantation of frozen zygotes despite lower CPNS suggests that they may recover after thawing and in vitro culture.

Variability of indication criteria in knee and hip replacement: an observational study

BACKGROUND. Total knee (TKR) and hip (THR) replacement (arthroplasty) are effective surgical procedures that relieve pain, improve patients' quality of life and increase functional capacity. Studies on variations in medical practice usually place the indications for performing these procedures to be highly variable, because surgeons appear to follow different criteria when recommending surgery in patients with different severity levels. We therefore proposed a study to evaluate inter-hospital variability in arthroplasty indication. METHODS. The pre-surgical condition of 1603 patients included was compared by their personal characteristics, clinical situation and self-perceived health status. Patients were asked to complete two health-related quality of life questionnaires: the generic SF-12 (Short Form) and the specific WOMAC (Western Ontario and Mcmaster Universities) scale. The type of patient undergoing primary arthroplasty was similar in the 15 different hospitals evaluated.The variability in baseline WOMAC score between hospitals in THR and TKR indication was described by range, mean and standard deviation (SD), mean and standard deviation weighted by the number of procedures at each hospital, high/low ratio or extremal quotient (EQ5-95), variation coefficient (CV5-95) and weighted variation coefficient (WCV5-95) for 5-95 percentile range. The variability in subjective and objective signs was evaluated using median, range and WCV5-95. The appropriateness of the procedures performed was calculated using a specific threshold proposed by Quintana et al for assessing pain and functional capacity. RESULTS. The variability expressed as WCV5-95 was very low, between 0.05 and 0.11 for all three dimensions on WOMAC scale for both types of procedure in all participating hospitals. The variability in the physical and mental SF-12 components was very low for both types of procedure (0.08 and 0.07 for hip and 0.03 and 0.07 for knee surgery patients). However, a moderate-high variability was detected in subjective-objective signs. Among all the surgeries performed, approximately a quarter of them could be considered to be inappropriate. CONCLUSIONS. A greater inter-hospital variability was observed for objective than for subjective signs for both procedures, suggesting that the differences in clinical criteria followed by surgeons when indicating arthroplasty are the main responsible factors for the variation in surgery rates.

Randomized controlled trial comparing highly purified (HP-hCG) and recombinant hCG (r-hCG) for triggering ovulation in ART.

BACKGROUND: A randomized controlled trial (RCT) comparing highly purified human Choriogonadotrophin (HP-hCG) and recombinant hCG (r-hCG) both administered subcutaneously for triggering ovulation in controlled ovarian stimulation (COS) for Assisted Reproductive Technology (ART). METHODS: Multi-centre (n = 4), prospective, controlled, randomized, non-inferiority, parallel group, investigator blind design, including 147 patients. The trial was registered with www.clinicaltrials.gov, using the identifier: NCT00335569. The primary endpoint is the number of oocytes retrieved, while the secondary endpoints include embryo implantation, pregnancy and delivery rates as well as safety parameters. RESULTS: The number of retrieved oocytes was not inferior when HP-hCG was used as compared to r-hCG: the mean number was 13.3 (6.8) in HP-hCG and 12.5 (5.8) in the r-hCG group (p = 0.49) with a 95% CI (-1.34, 2.77). Regarding the secondary outcomes, there were also no differences in fertilization rate at 57.3% (467/815) vs. 61.3% (482/787) (p = 0.11), the number of embryos available for transfer and cryopreservation (2PN stage) and implantation, pregnancy and delivery rates. Furthermore, there were no differences in the number and type of adverse events reported. HP-hCG was therefore not inferior to r-hCG. CONCLUSIONS: HP-hCG and r-hCG are equally efficient and safe for triggering ovulation in ART and, both being administered subcutaneously, equally practical and well tolerated by patients.

Postmortem circulation: a new model for testing endovascular devices and training clinicians in their use.

The development of new medical devices, such as aortic valves, requires numerous preliminary studies on animals and training of personnel on cadavers before the devices can be used in patients. Postmortem circulation, a technique used for postmortem angiography, allows the vascular system to be reperfused in a way similar to that in living persons. This technique is used for postmortem investigations to visualize the human vascular system and to make vascular diagnoses. Specific material for reperfusing a human body was developed recently. Our aim was to investigate whether postmortem circulation that imitates in vivo conditions allows for the testing of medical materials on cadavers. We did this by delivering an aortic valve using minimally invasive methods. Postmortem circulation was established in eight corpses to recreate an environment as close as possible to in vivo conditions. Mobile fluoroscopy and a percutaneous catheterization technique were used to deliver the material to the correct place. Once the valve was implanted, the heart and primary vessels were extracted to confirm its position. Postmortem circulation proved to be essential in several of the cadavers because it helped the clinicians to deliver the material and improve their implantation techniques. Due to the intravascular circulation, sites with substantial arteriosclerotic stenosis could be bypassed, which would have been impossible without perfusion. Although originally developed for postmortem investigations, this reperfusion technique could be useful for testing new medical devices intended for living patients.

Urological complications in renal transplantation from cadaveric donor grafts : a retrospective analysis of 20 years

Résumé : Introduction Cette étude est une analyse rétrospective des complications urétérales et de leurs prises en charge à partir d'une série monocentrique de 277 transplantations rénales consécutives. Matériel et méthode De septembre 1979 à juin 1999, 277 transplantations rénales (origine cadavérique) ont été pratiquées chez 241 patients. L'uretère provenant de la greffe rénale a été inséré dans la vessie selon la technique d'implantation extravésicale décrite par Lich-Gregoir et Campos-Freire. L'étude a analysé la date de survenue et le genre de complications observés. Les différentes procédures pour restaurer le tractus urinaire transplanté sont présentées dans cette étude. Résultats Des complications sont survenues chez 43/277 transplantations rénales (15,5%). Les fuites urinaires sur l'anastomose ou les sténoses urétérales étaient les plus fréquentes. La date de survenue de ces complications étaient soit précoce (< 1 mois) soit tardive (> 1 mois) dans un nombre similaire de cas. La plupart des cas ont été pris en charge chirurgicalement 33/43 cas (76,7%). La réparation chirurgicale la plus fréquente a été la réimplantation urétérovésicale (n-13), suivie par : l'anastomose urétérourétérale termino-terminale (uretère natif-uretère greffé, n-5) ; l'anastomose pyélourétérale (uretère natif-bassinet rénal greffé, n=5) ; la simple révision de l'implantation urétérovésicale (n=4) ; la résection et l'anastomose termino-terminale de l'uretère greffé (n=2) ; la calico-vésicostomie (vessie greffée, n=1) ; l'implantation selon Boari (n=1) ; la pyélovésicostomie avec bipartition de la vessie (n-1), et la pyéloiléocystoplastie avec greffe iléale détubularisée (n=1). Aucun décès en relation avec les complications urologiques n'a été rapporté. Cependant, 2 reflux vésico-rénaux consécutifs ont conduit à distance à la perte du greffon. Conclusion Le taux de complications constaté dans cette analyse rétrospective est similaire à celui observé dans d'autres études. Il se situe entre 2 et 20%. Si l'implantation urétérovésicale extravésicale classique reste une technique attractive en raison de sa simplicité, l'équipe chirurgicale dans un centre de formation doit rester attentive à toute mesure de prévention des complications urétérales, comme le choix d'une autre technique d'implantation de l'uretère et/ou de l'insertion transitoire d'un stent urétéral. Abstract Introduction: This study is a retrospective analysis of ureteral complications and their management from a monocenter series of 277 consecutive renal transplantations. Materials and Methods: From September 1979 to June 1999, 277 renal transplantations (cadaveric origin) were performed in 241 patients. The ureter from the kidney graft was inserted into the bladder according to the technique of extravesical implantation described by Lich-Gregoir and Campos-Freire. The study analyzed the time of occurrence and the type of complications observed. The different procedures to restore the transplanted urinary tract are presented. Results: Complications occurred in 431277 renal transplantations (15.5%). Anastomotic urine leakage or ureteral stricture were the most frequent. The time to appearance of these complications was either short (<1 month) or late (>1 month) in a similar number of cases. Most cases were managed surgically: 33/43 cases (76.7%). The most frequent surgi cal repair was ureterovesical reimplantation n =13), Followed by: ureteroureteral end, to end anastomosis (native ureter-ureter transplant, n =, 5); pyeloureteral anastomosis (native ureter-renal pelvis transplant n = 5): simple revision of ureterovesical implantation (n=4): resection and end-to end anastomosis of the transplant ureter (n=2); calico-vesicostomy graft-bladder, n = 1); implantation according to Boari (n= 1); pyelovesicostomy with bipartition of bladder (n = 1), and pyeloileocystoplasty with detubularized ileal graft (n=1). No deaths related to any of the urological complications were reported However, 2 consecutive vesico-renal refluxes led to the loss of the kidney graft in the long-term. Conclusion: The rate of complications observed in this retrospective analysis is similar to the experience of other studies, ranging from 2 to 20% If the classical extravesical ureteral bladder implantation is to remain an attractive technique due to its simplicity, the surgical team at the training center should be aware of all the means to prevent any ureteral complications, such as the choice of another implantation technique and/or insertion of a transient ureteral stent.

Transcatheter aortic valve replacement for degenerative bioprosthetic surgical valves: Results from the global valve-in-valve registry.

BACKGROUND Transcatheter aortic valve-in-valve implantation is an emerging therapeutic alternative for patients with a failed surgical bioprosthesis and may obviate the need for reoperation. We evaluated the clinical results of this technique using a large, worldwide registry. METHODS AND RESULTS The Global Valve-in-Valve Registry included 202 patients with degenerated bioprosthetic valves (aged 77.7±10.4 years; 52.5% men) from 38 cardiac centers. Bioprosthesis mode of failure was stenosis (n=85; 42%), regurgitation (n=68; 34%), or combined stenosis and regurgitation (n=49; 24%). Implanted devices included CoreValve (n=124) and Edwards SAPIEN (n=78). Procedural success was achieved in 93.1% of cases. Adverse procedural outcomes included initial device malposition in 15.3% of cases and ostial coronary obstruction in 3.5%. After the procedure, valve maximum/mean gradients were 28.4±14.1/15.9±8.6 mm Hg, and 95% of patients had ≤+1 degree of aortic regurgitation. At 30-day follow-up, all-cause mortality was 8.4%, and 84.1% of patients were at New York Heart Association functional class I/II. One-year follow-up was obtained in 87 patients, with 85.8% survival of treated patients. CONCLUSIONS The valve-in-valve procedure is clinically effective in the vast majority of patients with degenerated bioprosthetic valves. Safety and efficacy concerns include device malposition, ostial coronary obstruction, and high gradients after the procedure.