Creació de taules d'una base de dades relacional a partir del diagrama de classes d'anàlisi d'UML

És ben sabut que les úniques etapes del cicle de vida del programari que necessàriament s'han d'especificar són les de recollida de requisits i l'anàlisi o l'especificació del programari. La resta (disseny, implementació i prova) es pot generar d'una manera més o menys automàtica a partir de l'anàlisi. En aquest PFC hem volgut estudiar la viabilitat de la construcció automàtica de codi SQL a partir de diagrames de classes d'anàlisi UML. S'ha estès l'eina de modelatge UML Poseidon amb un connector, de manera que amb una interfície molt simple es pot obtenir molt ràpidament l'esquema bàsic d'una base de dades, incloent-hi les taules, les seves columnes, claus rimàries i foranes, i també els disparadors (i les claus úniques) necessaris per a garantir les restriccions de cardinalitat de les associacions.

Gestiona't : aplicació en J2EE per a la gestió personal del treball

Aquest treball final de carrera es basa en l'anàlisi, disseny i implementació d'una solució per a la autogestió dels recursos humans de l'empresa; és a dir, per tal que tots els treballadors de la mateixa puguin gestionar tot el relacionat amb el seu entorn de treball (les seves dades personals, el seu temps de treball, les tasques relacionades amb el seu càrrec, la sol·licitud de vacances...). Paral·lelament, aquest treball estudia la viabilitat d'emprar com a eina de treball professional diària l'IDE Eclipse amb la integració del plug-in d'Exadel Studio per a l'ús del framework Struts.

Cardiac rotation and relaxation after anterolateral myocardial infarction.

BACKGROUND: Both systolic and diastolic dysfunction have been observed in patients with anterolateral myocardial infarction. Diastolic dysfunction is related to disturbances in relaxation and diastolic filling. OBJECTIVE: To analyse cardiac rotation, regional shortening and diastolic relaxation in patients with anterolateral infarction. METHODS: Cardiac rotation and relaxation in controls and patients with chronic anterolateral infarction were assessed by myocardial tagging. Myocardial tagging is based on magnetic resonance imaging and allows us to label specific myocardial regions for imaging cardiac motion (rotation, translation and radial displacement). A rectangular grid was placed on the myocardium (basal, equatorial and apical short-axis plane) of each of 18 patients with chronic anterolateral infarction and 13 controls. Cardiac rotation, change in area and shortening of circumference were determined in each case. RESULTS: The left ventricle in controls performs a systolic wringing motion with a clockwise rotation at the base and a counterclockwise rotation at the apex when viewed from the apex. During relaxation a rotational motion in the opposite direction (namely untwisting) can be observed. In patients with anterolateral infarction, there is less systolic rotation at the apex and diastolic untwisting is delayed and prolonged in comparison with controls. In the presence of a left ventricular aneurysm (n = 4) apical rotation is completely lost. There is less shortening of circumference in infarcted and remote regions. CONCLUSIONS: The wringing motion of the myocardium might be an important mechanism involved in maintaining normal cardiac function with minimal expenditure of energy. This mechanism no longer operates in patients with left ventricular aneurysms and operates significantly less than normal in those with anterolateral hypokinaesia. Diastolic untwisting is significantly delayed and prolonged in patients with anterolateral infarction, which could explain the occurrence of diastolic dysfunction in these patients.

Implementación de un esquema criptográfico para gestionar deforma segura las historias médicas de los pacientes a través de una red de comunicaciones

En aquest projecte de final de carrera s'ha dissenyat, implementat i provat un sistema que utilitzant criptografia de clau pública, garanteix la correcta utilització de les dades en un procés de consulta i complimentació d'una història clínica informatitzada consultada a distància.

The Role of Information in Contemporary Migration. More Sources but Less Informed

La migració internacional contemporània és integrada en un procés d'interconnexió global definit per les revolucions del transport i de les tecnologies de la informació i la comunicació. Una de les conseqüències d'aquesta interconnexió global és que les persones migrants tenen més capacitat per a processar informació tant abans com després de marxar. Aquests canvis podrien tenir implicacions inesperades per a la migració contemporània pel que fa a la capacitat de les persones migrants per a prendre decisions més informades, la reducció de la incertesa en contextos migratoris, el desdibuixament del concepte de distància o la decisió d'emigrar cap a llocs més llunyans. Aquesta recerca és important, ja que la manca de coneixement sobre aquesta qüestió podria contribuir a fer augmentar la distància entre els objectius de les polítiques de migració i els seus resultats. El paper que tenen els agents de la informació en els contextos migratoris també podria canviar. En aquest escenari, perquè les polítiques de migració siguin més efectives, s'haurà de tenir en compte la major capacitat de la població migrant de processar la informació i les fonts d'informació en què es confia. Aquest article demostra que l'equació més informació equival a més ben informat no es compleix sempre. Fins i tot en l'era de la informació, les fonts no fiables, les expectatives falses, la sobreinformació i els rumors encara són presents en els contextos migratoris. Tanmateix, defensem l'argument que aquests efectes no volguts es podrien reduir complint quatre requisits de la informació fiable: que sigui exhaustiva, que sigui rellevant, que s'hi confiï i que sigui actualitzada.

Identification of factors associated with diagnostic error in primary care.

BACKGROUND Missed, delayed or incorrect diagnoses are considered to be diagnostic errors. The aim of this paper is to describe the methodology of a study to analyse cognitive aspects of the process by which primary care (PC) physicians diagnose dyspnoea. It examines the possible links between the use of heuristics, suboptimal cognitive acts and diagnostic errors, using Reason's taxonomy of human error (slips, lapses, mistakes and violations). The influence of situational factors (professional experience, perceived overwork and fatigue) is also analysed. METHODS Cohort study of new episodes of dyspnoea in patients receiving care from family physicians and residents at PC centres in Granada (Spain). With an initial expected diagnostic error rate of 20%, and a sampling error of 3%, 384 episodes of dyspnoea are calculated to be required. In addition to filling out the electronic medical record of the patients attended, each physician fills out 2 specially designed questionnaires about the diagnostic process performed in each case of dyspnoea. The first questionnaire includes questions on the physician's initial diagnostic impression, the 3 most likely diagnoses (in order of likelihood), and the diagnosis reached after the initial medical history and physical examination. It also includes items on the physicians' perceived overwork and fatigue during patient care. The second questionnaire records the confirmed diagnosis once it is reached. The complete diagnostic process is peer-reviewed to identify and classify the diagnostic errors. The possible use of heuristics of representativeness, availability, and anchoring and adjustment in each diagnostic process is also analysed. Each audit is reviewed with the physician responsible for the diagnostic process. Finally, logistic regression models are used to determine if there are differences in the diagnostic error variables based on the heuristics identified. DISCUSSION This work sets out a new approach to studying the diagnostic decision-making process in PC, taking advantage of new technologies which allow immediate recording of the decision-making process.

The pressure cooker technique for the treatment of brain AVMs.

Arteriovenous malformations (AVMs) may be cured by injecting liquid embolic agents such as Onyx. Reflux, however, can sometimes be difficult to control and may jeopardize a complete embolization. The pressure cooker technique (PCT) was designed to create an anti-reflux plug by trapping the detachable part of an Onyx-compatible microcatheter with coils and glue in order to obtain wedge-flow conditions, thereby enabling a better understanding of macrofistulous AVMs and a more comprehensive, forceful and controlled Onyx embolization. The PCT might enlarge the range of AVMs amenable to endovascular cure. Three illustrative cases are presented.

Synthesis of bone-like structured foams

Here we present a processing route to produce multi-structured ceramic foams based on the combination of particle-stabilized foams with polymeric sponges to produce positive and negative templating structures. Polyester sponges are infiltrated with freshly produced calcium aluminate alumina foams and upon sintering either positive templating structures are produced when wetting the sponges, or negative templating foams with a percolating pore network are obtained when completely filling the sponges. Additionally, by combining different layers of these particle-stabilized foam infiltrated sponges, various different structures can be produced, including sandwich structures, pore size gradients, and ceramic bone-like structures applying to different types of bone. The particle-stabilized foams used were in situ self-hardening calcium aluminate cement enriched alumina foams to obtain crack-free samples with pore interconnections and tailorable pore sizes.

Climate change, anthropogenic disturbance and the northward range expansion of Lactuca serriola (Asteraceae)

The distribution range of Lactuca serriola, a species native to the summer-dry mediterranean climate, has expanded northwards during the last 250 years. This paper assesses the influence of climate on the range expansion of this species and highlights the importance of anthropogenic disturbance to its spread. Location Central and Northern Europe. Methods Data on the geographic distribution of L. serriola were assembled through a literature search as well as through floristic and herbarium surveys. Maps of the spread of L. serriola in Central and Northern Europe were prepared based on herbarium data. The spread was assessed more precisely in Germany, Austria and Great Britain by pooling herbarium and literature data. We modelled the bioclimatic niche of the species using occurrence and climatic data covering the last century to generate projections of suitable habitats under the climatic conditions of five time periods. We tested whether the observed distribution of L. serriola could be explained for each time period, assuming that the climatic niche of the species was conserved across time. Results The species has spread northwards since the beginning of the 19th century. We show that climate warming in Europe increased the number of sites suitable for the species at northern latitudes. Until the late 1970s, the distribution of the species corresponded to the climatically suitable sites available. For the last two decades, however, we could not show any significant relationship between the increase in suitable sites and the distributional range change of L. serriola. However, we highlight potential areas the species could spread to in the future (Great Britain, southern Scandinavia and the Swedish coast). It is predominantly non-climatic influences of global change that have contributed to its rapid spread. Main conclusions The observation that colonizing species are not filling their climatically suitable range might imply that, potentially, other ruderal species could expand far beyond their current range. Our work highlights the importance of historical floristic and herbarium data for understanding the expansion of a species. Such historical distributional data can provide valuable information for those planning the management of contemporary environmental problems, such as species responses to environmental change.

A New Imaging Software To Evaluate The Centration Of Capsulorhexis And Intraocular Lens (IOL) After Cataract Surgery

Purpose: IOL centration and stability after cataract surgery is of high interest for cataract surgeons and IOL-producing companies. We present a new imaging software to evaluate the centration of the rhexis and the centration of the IOL after cataract surgery.Methods: We developed, in collaboration with the Biomedical Imaging Group (BIG), EPFL, Lausanne, a new working tool in order to assess precisely outcomes after IOL-implantation, such as ideal capsulorhexis and IOL-centration. The software is a plug-in of ImageJ, a general-purpose image processing and image-analysis package. The specifications of this software are: evaluation of the rhexis-centration and evaluation the position of the IOL in the posterior chamber. The end points are to analyze the quality of the centration of a rhexis after cataract surgery, the deformation of the rhexis with capsular bag retraction and the centration of the IOL after implantation.Results: This software delivers tools to interactively measure the distances between limbus, IOL and capsulorhexis and its changes over time. The user is invited to adjust nodes of three radial curves for the limbus, rhexis and the optic of the IOL. The radial distances of the curves are computed to evaluate the IOL implantation. The user is also able to define patterns for ideal capsulorhexis and optimal IOL-centration. We are going to present examples of calculations after cataract surgery.Conclusions: Evaluation of the centration of the rhexis and of the IOL after cataract surgery is an important end point for optimal IOL implantation after cataract surgery. Especially multifocal or accommodative lenses need a precise position in the bag with a good stability over time. This software is able to evaluate these parameters just after the surgery but also its changes over time. The results of these evaluations can lead to an optimizing of surgical procedures and materials.

Determine Initial Cause for Current Premature Portland Cement Concrete Pavement Deterioration Final Report, 2000

A detailed investigation has been conducted on core samples taken from 17 portland cement concrete pavements located in Iowa. The goal of the investigation was to help to clarify the root cause of the premature deterioration problem that has become evident since the early 1990s. Laboratory experiments were also conducted to evaluate how cement composition, mixing time, and admixtures could have influenced the occurrence of premature deterioration. The cements used in this study were selected in an attempt to cover the main compositional parameters pertinent to the construction industry in Iowa. The hardened air content determinations conducted during this study indicated that the pavements that exhibited premature deterioration often contained poor to marginal entrained-air void systems. In addition, petrographic studies indicated that sometimes the entrained-air void system had been marginal after mixing and placement of the pavement slab, while in other instances a marginal to adequate entrained-air void system had been filled with ettringite. The filling was most probably accelerated because of shrinkage cracking at the surface of the concrete pavements. The results of this study suggest that the durability—more sciecifically, the frost resistance—of the concrete pavements should be less than anticipated during the design stage of the pavements. Construction practices played a significant role in the premature deterioration problem. The pavements that exhibited premature distress also exhibited features that suggested poor mixing and poor control of aggregate grading. Segregation was very common in the cores extracted from the pavements that exhibited premature distress. This suggests that the vibrators on the paver were used to overcome a workability problem. Entrained-air voids formed in concrete mixtures experiencing these types of problems normally tend to be extremely coarse, and hence they can easily be lost during the paving process. This tends to leave the pavement with a low air content and a poor distribution of air voids. All of these features were consistent with a premature stiffening problem that drastically influenced the ability of the contractor to place the concrete mixture. Laboratory studies conducted during this project indicated that most premature stiffening problems can be directly attributed to the portland cement used on the project. The admixtures (class C fly ash and water reducer) tended to have only a minor influence on the premature stiffening problem when they were used at the dosage rates described in this study.

L-canavanine, an inhibitor of inducible nitric oxide synthase, improves venous return in endotoxemic rats.

OBJECTIVE: To investigate the hemodynamic effects of L-canavanine (an inhibitor of inducible, but not of constitutive, nitric oxide synthase) in endotoxic shock. DESIGN: Controlled, randomized, experimental study. SETTING: Animal laboratory. SUBJECTS: Wistar rats. INTERVENTIONS: Rats were anesthetized with pentobarbital, and hemodynamically monitored. One hour after an intravenous challenge with 5 mg/kg of Escherichia coli endotoxin, the rats were randomized to receive a continuous infusion of either L-canavanine (20 mg/kg/hr; n = 8) or vehicle only (isotonic saline, n = 11). In all animals, the infusion was given over 5 hrs at a rate of 2 mL/kg/hr. These experiments were repeated in additional rats challenged with isotonic saline instead of endotoxin (sham experiments). MEASUREMENTS AND MAIN RESULTS: Arterial blood pressure, heart rate, thermodilution cardiac output, central venous pressure, mean systemic filling pressure, urine output, arterial blood gases, blood lactate concentration, and hematocrit were measured. In sham experiments, hemodynamic stability was maintained throughout and L-canavanine had no detectable effect. Animals challenged with endotoxin and not treated with L-canavanine developed progressive hypotension and low cardiac output. After 6 hrs of endotoxemia, both central venous pressure and mean systemic filling pressure were significantly below their baseline values, indicating relative hypovolemia as the main determinant of reduced cardiac output. In endotoxemic animals treated with L-canavanine, hypotension was less marked, while cardiac output, central venous pressure, and mean systemic filling pressure were maintained throughout the experiment. L-canavanine had no effect on the time-course of hematocrit. L-canavanine significantly increased urine output and reduced the severity of lactic acidosis. CONCLUSIONS: Six hours after an endotoxin challenge in rats, low cardiac output develops, which appears to be primarily related to relative hypovolemia. L-canavanine, a selective inhibitor of the inducible nitric oxide synthase, increases the mean systemic filling pressure, thereby improving venous return, under these conditions.

Barriers to Employment, March 2001

During the last five years, Iowa has experienced a shortage of workers and will continue to feel the impact of a short labor supply. As the state prepares to reverse this trend of a declining population, attracting immigrants and refugees has great potential. In addition, released preliminary reports from the 2000 Census are reporting growth of the Latino population in several Iowa counties. This survey was conducted as a way to supplement the information collected about the Latino population by the State Public Policy Group in 1999, Snapshot in Time: A clear view of the importance, value and impacts of the Latino population in central Iowa. (Una Foto Actual de la Comunicad Latina: Un panoramaclaro de la importancia, del valor, y de los impactos de la población Latina en el área central de Iowa.) Although this survey was enlightening, it was broad in scope. It was the goal of the agency to collect more specific data regarding workforce needs and barriers that the Latino population encounter in the State of Iowa. Although it was the desire to broaden the scope of the previous survey, it should be noted that the survey samples were not identical. But it is recognized that because the Latino population within the state is small, some of the respondents could have participated in both surveys. We were also hoping to benefit from the extensive work conducted by SPPG within the community as a way to increase the response rate for this survey. This executive summary highlights some of the most significant findings from the survey of Latinos residing in Central Iowa. This analysis centers on the impact the Latino population can have in filling the labor shortages and how Iowa can best embrace the new Iowan. In addition, some of the key findings could offer insight into removing unnecessary barriers that prevent immigrants from utilizing valuable work skills as they integrate into the workforce. This information may be insightful to community leaders and employers who want to welcome new immigrants into their community. The following diagram collected from the 2000 Census illustrates the percentage of Latinos residing in the state.

Capital cities of federations. On the way to analysing the normative base of their asymmetrical status

Federal Capitals often have special statutes. Compared with member states, they often enjoy a lower degree of self-government and a lesser share in the governing of the federation. Why do actors choose such devices, and how can they be justified in a liberal democracy? Surprisingly, the burgeoning literature on asymmetric federalism (to which our research group has contributed significantly) has overlooked this important feature of a de iure asymmetry, perhaps because political theory up to now has concentrated on cases of multicultural and plurinational federations. However, comparative literature is also rare. This paper is the first step to filling in this gap by comparing some federal capitals. The Federal District model (Washington) is compared to capitals organized as member-states (Berlin and Brussels), and capitals that are cities belonging to a single member state (Ottawa in Ontario). The different features of de iure asymmetry will thereby be highlighted. Some light will be shed on the possible motives, reasons and justifications for the choice of each respective status. The paper opens the door to further research on such status questions by analysing public and parliamentary debates, for example. It paves the way for more thorough research. Sicne the author has been awarded a grant by the Institut d’Estudis Autonòmics, this research will be carried out soon.

Gift of Peace of Mind-The For yourself For your Family,

The purpose of this booklet is to educate the public about advance directives. By doing so, we hope to increase the use of advance directives, as well as the quality and accuracy of the documents themselves. The reader is led through a series of steps that ultimately lead to filling out the advance directive documents in an informed manner.