Disseny i implementació d'una base de dades relacional per a la gestió d'un videojoc

Projecte de final de carrera d'enginyeria en informàtica. Consisteix en la creació d'una base de dades relacional per donar suport a un videojoc. La base de dades inclou la implementació de tots els procediments emmagatzemats per accedir i gestionar la informació. El projecte també inclou el disseny d'un magatzem de dades per explotar estadísticament la informació continguda.

Mastectomy, Body De-Construction and Impact on Identity: A qualitative study

Objectives: This qualitative study aims at understanding the consequences of body deconstruction through mastectomy on corporality and identity in women with breast cancer. Design: Nineteen women were contacted through the hospital. All had to undergo mastectomy. Some were offered immediate breast reconstruction, others, because of cancer treatments, had no planned reconstruction. A qualitative reflexive methodological background was chosen. Method: Women were invited to participate in three semi-structured interviews, one shortly before or after mastectomy, and the other interviews later in their illness courses, after surgery. All interviews were transcribed verbatim. Thematic analysis was performed. The analysis of the first interview of each woman is presented in this article. Results: Mastectomy provokes a painful experience of body deconstruction. Even when immediate reconstruction is proposed, contrasted feelings and dissonance are expressed when comparing the former healthy body to the present challenged body entity. Body transformations are accompanied with experiences of mutilation, strangeness, and modify the physical, emotional social, symbolic and relational dimensions of the woman's gendered identity. Although the opportunity of breast reconstruction is seen as a possible recovery of a lost physical symmetry and body integrity, grieving the past body and integrating a new corporality leads to a painful identity crisis. Conclusion: With mastectomy, the roots of the woman's identity are challenged, leading to a re-evaluation of her existential values. The consequences of mastectomy transform the woman's corporality and embodiment, and question her identity. Psychological support is discussed in the perspective of our results.

Disseny i implementació de la base de dades d'un sistema centralitzat de control de despesa pública dels parlaments europeus

La Comunitat Europea ha decidit realitzar una base de dades per controlar la despesa pública parlamentària, tant dels parlaments com dels seus parlamentaris, i que les dades puguin ser consultades on line. L'objectiu del present treball és realitzar la base de dades on es guardarà la informació indicada pel client, així com un seguit de consultes i dades estadístiques que es podran consultar a través d'una plana web.

Development of LRFD Procedures for Bridge Pile Foundations in Iowa, Volume I: An Electronic Database for PIle LOad Tests (PILOT), TR-573, 2011

For well over 100 years, the Working Stress Design (WSD) approach has been the traditional basis for geotechnical design with regard to settlements or failure conditions. However, considerable effort has been put forth over the past couple of decades in relation to the adoption of the Load and Resistance Factor Design (LRFD) approach into geotechnical design. With the goal of producing engineered designs with consistent levels of reliability, the Federal Highway Administration (FHWA) issued a policy memorandum on June 28, 2000, requiring all new bridges initiated after October 1, 2007, to be designed according to the LRFD approach. Likewise, regionally calibrated LRFD resistance factors were permitted by the American Association of State Highway and Transportation Officials (AASHTO) to improve the economy of bridge foundation elements. Thus, projects TR-573, TR-583 and TR-584 were undertaken by a research team at Iowa State University’s Bridge Engineering Center with the goal of developing resistance factors for pile design using available pile static load test data. To accomplish this goal, the available data were first analyzed for reliability and then placed in a newly designed relational database management system termed PIle LOad Tests (PILOT), to which this first volume of the final report for project TR-573 is dedicated. PILOT is an amalgamated, electronic source of information consisting of both static and dynamic data for pile load tests conducted in the State of Iowa. The database, which includes historical data on pile load tests dating back to 1966, is intended for use in the establishment of LRFD resistance factors for design and construction control of driven pile foundations in Iowa. Although a considerable amount of geotechnical and pile load test data is available in literature as well as in various State Department of Transportation files, PILOT is one of the first regional databases to be exclusively used in the development of LRFD resistance factors for the design and construction control of driven pile foundations. Currently providing an electronically organized assimilation of geotechnical and pile load test data for 274 piles of various types (e.g., steel H-shaped, timber, pipe, Monotube, and concrete), PILOT (http://srg.cce.iastate.edu/lrfd/) is on par with such familiar national databases used in the calibration of LRFD resistance factors for pile foundations as the FHWA’s Deep Foundation Load Test Database. By narrowing geographical boundaries while maintaining a high number of pile load tests, PILOT exemplifies a model for effective regional LRFD calibration procedures.

Sexualité des adolescents: epidémiologie, approche clinique et stratégies préventives [Adolescent sexuality: epidemiology, clinical approach and preventive measures].

The interest in sexuality of adolescents in medical practice is often mainly focussed on the onset of sexual intercourse and on the emergence of contraceptive needs, though the beginning of adolescence takes place much earlier with the first signs of puberty followed by the menarche. At the issue of this profound metamorphosis the adolescent needs to adapt herself to a modified, sexual body. Adolescence is also a time of identity development and of changes in relationships, which are influenced by gender role in family and perception related to gender during childhood. This article shows epidemiological data to consider and the main issues of gynaecologic consultation with the adolescent. The different stages of development depend on biological and environmental factors which either favour resilience or weaken the individual due to a lack of affection or to abusive relationships. Medical consultation for a gynaecological problem, questions on puberty and development or on contraception give medical professionals and especially gynaecologists a chance to address sexual issues naturally, to anticipate questions as well as contraceptive needs. The consultation with the adolescent includes also the screening for behaviour related to a lack of information or a personal or relational difficulty.

La Formación de la imagen turística inducida: un modelo conceptual

Teniendo en cuenta que la imagen turística ha sido reconocida como uno de los elementos más influyentes para la competitividad de los destinos turísticos, el principal objetivo de este artículo es construir un marco conceptual que muestre la influencia de la red relacional del destino en su imagen emitida. En este contexto, se asume que la imagen tu rística es una construcción social resultante de lainteracción de los distintos agentes que intervienen en el destino turístico (administraciones públicas, instituciones locales, empresas turísticas, etc.); y se propone un modelo teórico para mostrar los efectos de la red relacional del destino turístico en la calidad de la imagen turística creada en términos de conocimiento generado y, por tanto, en su competitividad

La perception subjective de l'effet des neuroleptiques chez des patients schizophrènes ambulatoires: une étude transversale [Subjective perception of the effect of neuroleptics by outpatient schizophrenic patients: a cross-sectional study].

Subjective response to neuroleptics is essential to long term observance of treatment and quality of life of patients. Numerous factors (pharmacological, relational and psychopathological) are responsible of this subjective response. Objectives of this study are: (a) to examine psychometric features of the french version of the Drug Attitude Inventory (DAI-30) [13] and (b) to explore pharmacological, relational and psychopathological factors related to this subjective response. Subjects and methods: 78 subjects were rated (self rated response rate 61% (n = 48)) for (a) subjective response to neuroleptics, (b) compliance, (c) therapeutic alliance, (d) symptoms (e) severity of disorder. RESULTS: Factor analysis yielded 2 main clinically relevant factors, similar to the original version: (I) global subjective response and (II) specific subjective response. Internal consistency is high. Correspondance analysis showed two important dimensions in the treatment of schizophrenic patients: (I) Recovery--aggravation, (II) Therapeutic ambition--positive or negative symptoms. CONCLUSION: French version of DAI-30 seems to have a similar structure and psychometric features as the original version. It shows concordance with the degree of compliance. Pharmacological factors are not the only factors implicated in subjective response, but are still to be identified. Limitations of our study are: (a) nonhomogenous indication for treatment, (b) small rate and degree of non compliance in our sample. Relationships between therapeutic ambition, type of symptoms and treatment outcome should be further studied.

Studien zu einer Poetik des Engels

In dieser Thèse "Studien zu einer Poetik des Engels" wird anhand verschiedener Texte aus verschiedenen Epochen, jedoch mit Akzent auf der zweiten Hàlfte des 20. Jahrhunderts, dem Erscheinen von Engeln in literarischen Texten nachgegangen, mit besonderem Augenmerk auf der poetologischen Dimension, die mit der Darstellung von Engelfiguren zusammenhàngt, und mit besonderer Beriicksichtigung der Konsequenzen fur die Texte, in denen sie erscheinen.¦Literarische Texte bieten nàmlich einen geeigneten Immanenzort fur diese Art Epi-phanie an, eine Erscheinungsmoglichkeit fur Engel. Die Art und Weise, wie Dichterinnen und Dichter sie in ihren Texten erscheinen lassen, steht im Zentrum des Interesses dieser Studien. Wie verkorpern sich Engel in diesen Texten? Wie sprechen sie und wie kann mit ihnen und von ihnen gesprochen werden? Welche poetischen Funktionen ubernehmen diese Figuren, von denen die Dichter sprechen und die sie sprechen lassen? Welche poetischen Dynamiken entstehen in diesen Texten durch die Engelserscheinungen?¦Der Engel, der traditionell als Bote (gr. angelos), als Vermittler oder Obermittler gilt, hat im Medium Literatur (oder Text) selbst auch eine mediale Funktion inne, sodass Engel und Literatur einander widerspiegeln und Engeltexte zu Orten werden, an denen eine sprachliche und poetologische Auseinandersetzung stattfinden kann, die sowohl der Lite¬ratur (und auch etwa dem Erzàhler) als auch dem Engel inhàrent ist und es mit dem Ver- mittlungs(un)vermogen zu tun hat.¦In diesen Studien geht es darum, die produktive und dynamische Leistung des Engels (oder der Engel) im Schreib- und im Leseprozess zu erfahren und nachzuzeichnen. Durch ihre Pràsenz im Text bringen Engel einen Perspektivenwechsel ins Spiel, der die Auseinandersetzung mit dem Text pràgt und den Text selbst beeinflusst, sodass die Engel diese Texte zur Schreib- und Leseerfahrung werden lassen.¦Engelsdichtungen erweisen sich als durch und durch relational, sie involvieren den Dichter sowie auch den Leser, der ihnen - lesend - begegnet, und beeinflussen den ganzen Text und seine Dynamik, da diese Figuren unmoglich von ihm abstrahiert werden konnen. Engel erweisen sich auch als àusserst subversiv, wenn sie dem nicht entsprechen, was man von ihnen erwartet, wenn sie sich den geltenden (sozialen, politischen, aber auch - im Medium Literatur - sprachlichen oder dichterischen) Regeln widersetzen.¦In einem einleitenden Kapitel wird die Fragestellung skizziert und anhand vieler Textbeispiele verfeinert, sowie auch die Methode veranschaulicht. Darin werden Texte von Wallace Stevens (The Necessary Angel), Jean Paul (Der Tod eines Engels), Wim Wenders und Peter Handke (Himmel über Berlin) betrachtet, sowie auch etwa von Goethe, Morike, Andersen, Tolstoi (Der Engel Gottes oder Wovon die Menschen leben), Pseudo- Strieker (Der König im Bade), Baudelaire.¦Die weiteren Kapitel sind als Fallstudien zu verstehen und setzen sich mit einzelnen Texten auseinander, die von verschiedenen Autoren und zu verschiedenen Zeiten geschrieben wurden und sich von der Gattung und der Lange her stark unterscheiden:¦- "Zwischen Lichterscheinung und Holzfigur": Zu einem Tagebucheintrag von Franz Kafka (25. Juni 1914).¦- "Schweigende Boten": Zu Heinrich Bolls Roman Der Engel schwieg [1949-1951 niedergeschrieben, erst 1992 posthum erschienen).¦- "Ein subversiver Engel - wider Willen": Zu Fridrich Dürrenmatts Komödie Ein Engel kommt nach Babylon (1. Fassung 1954, 2. Fassung 1957, Neufassung 1980).¦- Zu drei Engel-Texten von Ilse Aichinger:¦- "Ein errungenes Weihnachten - im Spiel": Zum Romankapitel Das grosse Spiel (6. Kapitel aus dem Roman Die grössere Hoffnung, 1948),¦- "»Habt ihr den Engel gesehen?« - Wenn sich mit den Engeln auf einmal jeder Sinn entzieht": Zur Erzählung Engel in der Nacht (1949; aus dem Band Der Gefesselte),¦- "Ober Verwirrung hinweg - Zur subversiven Poetik eines Engels": Zur Erzâhlung Der Engel (1963; aus dem Band Eliza Eliza).¦Im Schlusskapitel, in dem vergleichende Beobachtungen zu diesen Texten und ihren Analysen, Hervorhebungen der Gemeinsamkeiten und entscheidende poetische Merkmale dieser Texte erwähnt werden, wird nicht das Ziel angestrebt, eine Synthese aus dieser Vielfältigkeit zu machen, die in den verschiedenen Kapiteln zum Vorschein kommt. Vielmehr wird gezeigt, wie fruchtbar die Auseinandersetzung mit Engeln in diesen Texten ist und wie diese Texte sich von ihrem 'Gegenstand' berühren lassen, je auf unterschiedliche Weise.

Family interactions in IVF families: change over the transition to parenthood

Objective: This article presents a study of the change over time in the family interactions of couples who conceived through in-vitro fertilisation (IVF). Background: Observational methods are rarely used to study family interactions in families who used assisted reproductive techniques, but these methods are crucial for taking account of the communication that occurs in interactions with infants. Methods: Thirty-one couples expecting their first child were seen during the fifth month of pregnancy and when the child was nine months old. Family interactions were recorded in pre- and postnatal versions of the Lausanne Trilogue Play situation. Measures of marital satisfaction and parent-to-foetus/baby attachment or 'bonding' were also used to assess family relational dynamics. Results: Results showed that family alliance, marital satisfaction and parental attachment scores in the IVF sample were all similar to or higher than those in the reference sample during pregnancy. However, at nine months postnatally, the family alliance scores were lower. While marital satisfaction decreased over the period and parent-baby attachment increased, the family alliance scores were unstable, as no association was observed between the pre- and postnatal scores. In addition, neither prenatal marital satisfaction nor parent-foetus attachment predicted the postnatal family alliance. Conclusion: The change in the family alliance over the transition to parenthood appears to be specific to our IVF sample. Given that postnatal family functioning could not be predicted by prenatal family functioning, our observational data underline the importance of offering postnatal support to these families.

Instances d'aliénation: portrait du patient tiraillé. 2. Dispositif médical et discours dominants [Instances of alienation: portrait of the torn patient. 2. Medical apparatus and dominant discourses].

The first part of the article focused on the individual mechanisms--body, psyche and relational context--alienating the patient. The second part addresses alienating mechanisms related to the medical apparatus and the dominant discourses produced within and by society. The aim is not to comprehensively list possible mechanisms, but to discuss some of them using illustrative examples.

Unexplored aspects of bureaucratic autonomy: a state of the field and ways forward

This article first provides a selective overview of the literature on bureaucratic autonomy and identifies different approaches to this topic. The second section discusses three major sets of open questions, which will be tackled in the contributions to this special issue: the subjective, dynamic and relational nature of autonomy; the complex linkages between tasks, organizational forms, and national path dependencies on the one hand and autonomy and performance on the other hand; and the interplay between autonomy, accountability and democratic legitimacy.

Ohjelmistotuotteen hallintatietokannan suunnittelu ja toteutus

Ohjelmistotuotteen hallinta (SCM)on tärkeä osa ohjelmistoprojekteja. Se koostuu ohjelmistotuotteen hallinnan suunnittelusta, muutoksen hallinnasta, version hallinnasta, kääntämisestä, paketoinnista, kokoonpanon tilanteen seurannasta ja sen tarkistuksesta. Ohjelmistotuotteen hallintatietokanta (SCM DB) on tarkoitettu SCM:n liittyvändatan tallettamiseen yhteen paikkaan, jossa data on kaikkien löydettävissä. SCMDB on relaatiotietokanta ja WWW-käyttöliittymä sille. Tietokantaan talletetaan SCM - infrastruktuuri, SCM -resurssit, SCM -työskentelypaikat, integrointisuunnitteludata, paketoinnin raportit ja ohjeistukset, muutoksenhallintadata ja työkalujen hallintadata. Tietokannalla on monta käyttäjää. SCM managerit tallettavat tietokantaa yleiset tiedot, Integrointimanagerit tallettavat kantaan integrointisuunnitelmaa varten julkaisua koskevat tiedot. Paketointivastuulliset tallettavat kantaan paketointiraportit. Ohj elmistosuunnittelijat tekevät muutosvaatimuksia tietokantaan, jotka muutoksenhallintaelin käsittelee. He näkevät kannan kautta myös virheraportit. Työkalujen koordinointi tapahtuu myös kantaan talletettujen tietojen avulla. Lukemiseen tietokantaa voivat käyttää kaikki testauksesta suunnittelijoihin aikataulujen osalta. Tietokannasta voidaan lukea myös paketointityökalujen tallettamia tietoja ohjelmalohkoista eri pakettiversioissa. Paketointityökalut tai paketointivastuulliset saavat kannasta myös suoraan lähdetiedon paketointityökaluille.

Resource-based approach to new product development at the intersection of industries. Two case studies in telecommunications

Työn tavoitteena on selvittää mitkä ovat tärkeimmät aineettomat resurssit, joita tarvitaan teollisuuksien risteyskohdassa tapahtuvassa tuotekehityksessä. Teollisuuksien risteyskohdissa syntyvät tuotteet ovat usein radikaaleja, mikä tekee tuotteista mielenkiintoisia, paljon liiketoimintapotentiaalia tarjoavia. Tämä tutkimus lähestyy tuotekehitystä resurssipohjaisesta näkökulmasta. Myös tietämyspohjaista ja suhdepohjaista näkemystä hyödynnetään korostamaan keskittymistä aineettomiin resursseihin. Tutkimuksessa rakennetaan viitekehys, jossa tutkitaan eri resurssikategorioita. Valitut kategoriat ovat teknologiset, markkinointi-, johtamiseen ja hallinnointiin liittyvät ja suhdepohjaiset resurssit. Empiirisessä osassa tutkitaan kahta uutta tuotekonseptia, jotka ovat syntyneet teollisuuksien risteyskohdissa. Empiirisen osan tavoitteena on määritellä tutkimuksen kohteena olevia alustavia tuotekonsepteja tarkemmin ja selvittää millaisia resursseja näiden toteuttamiseen tarvitaan. Myös tarvittavien resurssien nykytila selvitetään ja pohditaan tulisiko puuttuvia resursseja kehittää yrityksen sisällä vai hankkia ne ulkopuolelta. Tutkimus toteutettiin asiantuntijahaastatteluin. Kahden tapaustutkimuksen perusteella näyttäisi siltä, että suhdepohjaiset resurssit ovat erittäin tärkeitä teollisuuksien risteyskohdissa tapahtuvassa tuotekehityksessä. Myös teknologiset resurssit ovat tärkeitä. Markkinointiresurssien tärkeys riippuu lopullisesta tuotekonseptista, kun taas johtamiseen ja kehittämiseen liittyvät resurssit ovat tärkeitänäiden konseptien luomisessa.

XML-verkkotietokantojen suorituskykyvertailu

XML:n kasvava suosio dokumenttiformaattina sekä sen alati monipuolistuva käyttö ovat lisänneet XML-tiedonhallintajärjestelmien tarvetta. Yksi tapa XML-dokumenttien hallintaan on edelleen tiedostopohjainen järjestelmä. Erilaisiin tietokantoihin perustuvat XML-tiedonhallintajärjestelmät ovat kuitenkin viime vuosina kasvattaneetsuosiotaan monipuolisempien ominaisuuksien ja paremman suorituskyvyn takia. Lisäksi XML-dokumenttien hallinta tiedostopohjaisessa järjestelmässä käy lähes mahdottomaksi suurilla datamäärillä. Suhteellisen uutena tulokkaana XML-dokumenttienhallintaan ovat tulleet natiivit XML -tietokannat, jotka ovat suunniteltu juuriXML:ää silmälläpitäen. Tässä diplomityössä esitellään erilaisia XML-tiedonhallintajärjestelmiä. Erityisesti relaatiotietokantoihin ja natiiveihin XML -tietokantoihin perustuvien ratkaisujen taustoihin ja teknisiin yksityiskohtiin yritetään luoda syvällinen katsaus. Neljälle XML-tiedonhallintaratkaisulle - Binary Approachille, Edge Approachille, eXistille ja Xindicelle - suoritetaan XMach-1 suorituskykytesti. Lisäksi testattavien ratkaisujen teknistä toimivuutta arvioidaan sekä analyyttisen että käytännön tarkastelun kautta. Suorituskykytestien ja teknisen toimivuuden arvioiden perusteella on tarkoitus valita XML-tiedonhallintaratkaisu Javalla toteutetulle Web-sovellukselle, joka käyttää XML:ää tietojen tallennusformaattina.

A mathematical study of fuzzy logic; an algebraic approach

Fuzzy set theory and Fuzzy logic is studied from a mathematical point of view. The main goal is to investigatecommon mathematical structures in various fuzzy logical inference systems and to establish a general mathematical basis for fuzzy logic when considered as multi-valued logic. The study is composed of six distinct publications. The first paper deals with Mattila'sLPC+Ch Calculus. THis fuzzy inference system is an attempt to introduce linguistic objects to mathematical logic without defining these objects mathematically.LPC+Ch Calculus is analyzed from algebraic point of view and it is demonstratedthat suitable factorization of the set of well formed formulae (in fact, Lindenbaum algebra) leads to a structure called ET-algebra and introduced in the beginning of the paper. On its basis, all the theorems presented by Mattila and many others can be proved in a simple way which is demonstrated in the Lemmas 1 and 2and Propositions 1-3. The conclusion critically discusses some other issues of LPC+Ch Calculus, specially that no formal semantics for it is given.In the second paper the characterization of solvability of the relational equation RoX=T, where R, X, T are fuzzy relations, X the unknown one, and o the minimum-induced composition by Sanchez, is extended to compositions induced by more general products in the general value lattice. Moreover, the procedure also applies to systemsof equations. In the third publication common features in various fuzzy logicalsystems are investigated. It turns out that adjoint couples and residuated lattices are very often present, though not always explicitly expressed. Some minor new results are also proved.The fourth study concerns Novak's paper, in which Novak introduced first-order fuzzy logic and proved, among other things, the semantico-syntactical completeness of this logic. He also demonstrated that the algebra of his logic is a generalized residuated lattice. In proving that the examination of Novak's logic can be reduced to the examination of locally finite MV-algebras.In the fifth paper a multi-valued sentential logic with values of truth in an injective MV-algebra is introduced and the axiomatizability of this logic is proved. The paper developes some ideas of Goguen and generalizes the results of Pavelka on the unit interval. Our proof for the completeness is purely algebraic. A corollary of the Completeness Theorem is that fuzzy logic on the unit interval is semantically complete if, and only if the algebra of the valuesof truth is a complete MV-algebra. The Compactness Theorem holds in our well-defined fuzzy sentential logic, while the Deduction Theorem and the Finiteness Theorem do not. Because of its generality and good-behaviour, MV-valued logic can be regarded as a mathematical basis of fuzzy reasoning. The last paper is a continuation of the fifth study. The semantics and syntax of fuzzy predicate logic with values of truth in ana injective MV-algerba are introduced, and a list of universally valid sentences is established. The system is proved to be semanticallycomplete. This proof is based on an idea utilizing some elementary properties of injective MV-algebras and MV-homomorphisms, and is purely algebraic.