Disseny i implementació de la base de dades d'un sistema de control energètic

Aquest projecte ha estat creat per a la presentació a un concurs públic de licitació de disseny i implementació d'una base de dades per al control de la generació, transport i consum de l'energia elèctrica dins el marc de la Unió Europea.

Disseny i implementació de la base de dades d'un sistema de control energètic

Treball de final de carrera que consisteix en el disseny i implementació d'una base de dades que ha de donar suport a una aplicació per a la generació d'estadístiques de contol energètic en l'àmbit europeu.

Disseny i implementació d'una base de dades relacional d'un sistema de control energètic

El propòsit d'aquest treball és el disseny i la implementació d'una base de dades relacional d'un sistema de control energètic a nivell europeu. Aquesta base de dades emmagatzema tota la informació referent a: línies de comunicació, centrals de producció, centraletes de distribució, comptadors, clients, connexions i contractes, a més dels consums diaris, consums històrics i produccions d'energia històriques. Conseqüentment, pel manteniment de tota aquesta informació s'han creat els diferents procediments d'alta, baixa i modificacions de registres per a cada entitat.

Disseny i implementació de la base de dades d'un sistema de control energètic

Aquest projecte consisteix en la creació d'una base de dades per a un sistema de control energètic que vol impulsar la Comunitat Europea. La base de dades haurà d'agrupar tota la informació referent als clients, comptadors, centraletes de distribució, línies de comunicació, centrals de producció, etc.

Surgery for Hirschsprung's disease: comparison between the Duhamel method and the transanal endorectal pull-through based on 59 patients and a review of the literature

Background:¦Hirschsprung's disease (HSCR) is a congenital malformation of the enteric nervous system due to the¦arrest of migration of neural crest cells to form the myenteric and submucosal plexuses. It leads to an anganglionic intestinal segment, which is permanently contracted causing intestinal obstruction. Its incidence is approximately 1/5000 birth, and males are more frequently affected with a male/female ratio of 4/1. The diagnosis is in most cases made within the first year of life. The rectal biopsy of the mucosa and sub-mucosa is the diagnostic gold standard.¦Purpose:¦The aim of this study was to compare two surgical approaches for HSCR, the Duhamel technique and the transanal endorectal pull-through (TEPT) in term of indications, duration of surgery, duration of hospital stay, postoperative treatment, complications, frequency of enterocolitis and functional outcomes.¦Methods:¦Fifty-nine patients were treated for HSCR by one of the two methods in our department of pediatric¦surgery between 1994 and 2010. These patients were separated into two groups (I: Duhamel, II: TEPT), which were compared on the basis of medical records. Statistics were made to compare the two groups (ANOVA test). The first group includes 43 patients and the second 16 patients. It is noteworthy that twenty-four patients (about 41% of all¦patients) were referred from abroad (Western Africa). Continence was evaluated with the Krickenbeck's score.¦Results:¦Statistically, this study showed that operation duration, hospital stay, postoperative fasting and duration of postoperative antibiotics were significantly shorter (p value < 0.05) in group II (TEPT). But age at operation and length of aganglionic segment showed no significant difference between the two groups. The continence follow-up showed generally good results (Krickenbeck's scores 1; 2.1; 3.1) in both groups with a slight tendency to constipation in group I and soiling in group II.¦Conclusion:¦We found two indications for the Duhamel method that are being referred from a country without¦careful postoperative surveillance and/or having a previous colostomy. Even if the Duhamel technique tends to be replaced by the TEPT, it remains the best operative approach for some selected patients. TEPT has also proved some advantages but must be followed carefully because, among other points, of the postoperative dilatations. Our postoperative standards, like digital rectal examination and anal dilatations seem to reduce the occurrence of complications like rectal spur and anal/anastomosis stenosis, respectively in the Duhamel method and the TEPT technique.

Diseño e implementación de una base de datos relacional

Con el fin de gestionar el consumo energético en el ámbito de la Comunidad Europea se ha diseñado e implementado una base de datos que dará persistencia a los valores que serán tratados por las futuras aplicaciones de gestión.

Disseny i implementació d'una base de dades relacional per a una empresa de selecció de personal

Base de dades realitzada en Oracle per controlar i ajustar les ofertes de de treball que es reben de les empreses i les demandes de feina i currículums que presenten els treballadors. Tot l'accés a les dades es realitza mitjançant procediments emmagatzemats.

Base de datos histórica dentro del ámbito de la gestión de proyectos

Trabajo de fin de carrera sobre una base de datos histórica de proyectos informáticos para la gestión de proyectos.

Disseny i implementació d'una base de dades relacional per a una empresa de selecció de personal

Una empresa de selecció de personal vol incorporar un sistema per controlar i ajustar les ofertes de feina que rep de les empreses i les demandes de feina i currículums que presenten els treballadors.

Consultes a base de dades en llenguatge natural

El treball presenta un prototip que ofereix la possibilitat d’obtenir informació d’una base de dades usant consultes en Llenguatge Natural a través d’un entorn web distribuït.

Disseny i implementació de la base de dades d'un sistema de control energètic

Implementació d'un sistema de base de dades per donar resposta a la necessitat de control energètic plantejada a nivell europeu. La base de dades ha de guardar informació relacionada amb el consum energètic i permetre la generació de dades estadístiques sobre l'ús de l'energia.

Role of surgery in the management of brain arteriovenous malformations: prospective cohort study.

BACKGROUND AND PURPOSE: Management of brain arteriovenous malformation (bAVM) is controversial. We have analyzed the largest surgical bAVM cohort for outcome. METHODS: Both operated and nonoperated cases were included for analysis. A total of 779 patients with bAVMs were consecutively enrolled between 1989 and 2014. Initial management recommendations were recorded before commencement of treatment. Surgical outcome was prospectively recorded and outcomes assigned at the last follow-up visit using modified Rankin Scale. First, a sensitivity analyses was performed to select a subset of the entire cohort for which the results of surgery could be generalized. Second, from this subset, variables were analyzed for risk of deficit or near miss (intraoperative hemorrhage requiring blood transfusion of ≥2.5 L, hemorrhage in resection bed requiring reoperation, and hemorrhage associated with either digital subtraction angiography or embolization). RESULTS: A total of 7.7% of patients with Spetzler-Ponce classes A and B bAVM had an adverse outcome from surgery leading to a modified Rankin Scale >1. Sensitivity analyses that demonstrated outcome results were not subject to selection bias for Spetzler-Ponce classes A and B bAVMs. Risk factors for adverse outcomes from surgery for these bAVMs include size, presence of deep venous drainage, and eloquent location. Preoperative embolization did not affect the risk of perioperative hemorrhage. CONCLUSIONS: Most of the ruptured and unruptured low and middle-grade bAVMs (Spetzler-Ponce A and B) can be surgically treated with a low risk of permanent morbidity and a high likelihood of preventing future hemorrhage. Our results do not apply to Spetzler-Ponce C bAVMs.

Reoperative Roux-En-Y Gastric Bypass Provides Similar Long-Term Results as Primary Surgery

Background: The increasing prevalence of obesity worldwide is associated with a massive increase in the number of yearly performed bariatric procedures, many of them purely restrictive. Consequently, a growing number of surgical revisions are necessary, and conversion to Roux-en-Y gastric bypass (RYGBP) is a common option. So far, few series including mostly patients reoperated using open surgery,and limited follow-up, have been reported.Patients and methods: Retrospective analysis of prospectively collected data of all patients undergoing revisional RYGBP in our two departments.Results: Between June 1999 and February 2011, 186 patients were submitted to revisional RYGBP, 161 women and 25 men with a mean age of 43 years. Their mean initial BMI was 45,3 kg/m2, their mean nadir BMI between the index operation and revision was 34, and their mean pre-revision BMI was 38,5. The initial procedure was gastric banding in 134 (72 %) patients, VBG in 48 (25,8 %), RYGBP in 5 (2,7 %), and others in 3. The main indications for revision were complications from the primary procedure with or without weight regain. A laparoscopic approach was usedin 137 (73,7 %) cases. Overall early morbidity was 18,8 %, and major morbidity was 3,2 %. Comparing patients in the first, second and last third of our experience, the percentage of patients operated using a laparoscopic approach increased from 53,2 % to 71 % and finally 96,7 %, and overall morbidity decreased from 27,4 % to 24,2 % and then 4,8 %. There were more wound infections after laparotomy (22,4 versus 2,9 %, p<0,001). There was no mortality. The mean BMI remained between 30 and 32 up to nine years after revision. Up to this limit, a BMI of <35 was maintained in between 75 and 83 % of the patients.Conclusions: Revisional RYGBP proves to be an effective and safe procedure. It can be performed by laparoscopy in most cases, especially as experience increases., It is associated with an acceptable morbidity, though higher than with primary RYGBP. Long-term results are equivalent to those of primary RYGBP, and can be considered as very satisfactory considering the fact that, on average, patients requiring redo surgery represent a sub-selection of difficult bariatric patients.

Influence of deep sternal wound infection on long-term survival after cardiac surgery.

BACKGROUND: This study aimed to investigate the influence of deep sternal wound infection on long-term survival following cardiac surgery. MATERIAL AND METHODS: In our institutional database we retrospectively evaluated medical records of 4732 adult patients who received open-heart surgery from January 1995 through December 2005. The predictive factors for DSWI were determined using logistic regression analysis. Then, each patient with deep sternal wound infection (DSWI) was matched with 2 controls without DSWI, according to the risk factors identified previously. After checking balance resulting from matching, short-term mortality was compared between groups using a paired test, and long-term survival was compared using Kaplan-Meier analysis and a Cox proportional hazard model. RESULTS: Overall, 4732 records were analyzed. The mean age of the investigated population was 69.3±12.8 years. DSWI occurred in 74 (1.56%) patients. Significant independent predictive factors for deep sternal infections were active smoking (OR 2.19, CI95 1.35-3.53, p=0.001), obesity (OR 1.96, CI95 1.20-3.21, p=0.007), and insulin-dependent diabetes mellitus (OR 2.09, CI95 1.05-10.06, p=0.016). Mean follow-up in the matched set was 125 months, IQR 99-162. After matching, in-hospital mortality was higher in the DSWI group (8.1% vs. 2.7% p=0.03), but DSWI was not an independent predictor of long-term survival (adjusted HR 1.5, CI95 0.7-3.2, p=0.33). CONCLUSIONS: The results presented in this report clearly show that post-sternotomy deep wound infection does not influence long-term survival in an adult general cardio-surgical patient population.