Construcció i explotació d'un magatzem de dades per a l'anàlisi d'informació sobre allotjaments turístics

Aquest document il·lustra el procés dut a terme a l'hora de realitzar el treball de fi de carrera en els estudis del grau en enginyeria informàtica a l'àrea de magatzem de dades. Inclou les diferents fases del projecte, des d'una introducció inicial on s'explica que és el data warehouse, la justificació i objectius del projecte, els requeriments del client, fins al seu anàlisi, disseny i posterior implementació.

Construcción y explotación de un almacén de datos para el análisis de información sobre alojamientos turísticos en Catalunya

El proyecto sigue el formato de un encargo de una solución de almacén de datos por parte de un cliente hipotético llamado ONdO que necesita poder analizar datos de establecimientos turísticos, población y equipamientos del territorio catalán.

Characterizing the connectome in schizophrenia with diffusion spectrum imaging.

Schizophrenia is a complex psychiatric disorder characterized by disabling symptoms and cognitive deficit. Recent neuroimaging findings suggest that large parts of the brain are affected by the disease, and that the capacity of functional integration between brain areas is decreased. In this study we questioned (i) which brain areas underlie the loss of network integration properties observed in the pathology, (ii) what is the topological role of the affected regions within the overall brain network and how this topological status might be altered in patients, and (iii) how white matter properties of tracts connecting affected regions may be disrupted. We acquired diffusion spectrum imaging (a technique sensitive to fiber crossing and slow diffusion compartment) data from 16 schizophrenia patients and 15 healthy controls, and investigated their weighted brain networks. The global connectivity analysis confirmed that patients present disrupted integration and segregation properties. The nodal analysis allowed identifying a distributed set of brain nodes affected in the pathology, including hubs and peripheral areas. To characterize the topological role of this affected core, we investigated the brain network shortest paths layout, and quantified the network damage after targeted attack toward the affected core. The centrality of the affected core was compromised in patients. Moreover the connectivity strength within the affected core, quantified with generalized fractional anisotropy and apparent diffusion coefficient, was altered in patients. Taken together, these findings suggest that the structural alterations and topological decentralization of the affected core might be major mechanisms underlying the schizophrenia dysconnectivity disorder. Hum Brain Mapp, 36:354-366, 2015. © 2014 Wiley Periodicals, Inc.

Increasing stair climbing in a train station: effects of contextual variables and visibility

Accumulation of physical activity during daily living is a current public health target that is influenced by the layout of the built environment. This study reports how the layout of the environment may influence responsiveness to an intervention. Pedestrian choices (n = 41 717) between stairs and the adjacent escalators were monitored for seven weeks in a train station (Birmingham, UK). After a 3.5 week baseline period, a stair riser banner intervention to increase stair climbing was installed on two staircases adjacent to escalators and monitoring continued for a further 3.5 weeks. Logistic regression analyses revealed that the visibility of the intervention, defined as the area of visibility in the horizontal plane opposite to the direction of travel (termed the isovist) had a major effect on success of the intervention. Only the largest isovist produced an increase in stair climbing (isovist=77.6 m2, OR = 1.10, CIs 1.02-1.19; isovist=40.7 m2, OR = 0.98, CIs 0.91-1.06; isovist=53.2 m2, OR = 1.00, CIs 0.95-1.06). Additionally, stair climbing was more common during the morning rush hour (OR = 1.56, CIs 1.80-2.59) and at higher levels of pedestrian traffic volume (OR = 1.92, CIs 1.68-2.21). The layout of the intervention site can influence responsiveness to point-of-choice interventions. Changes to the design of train stations may maximize the choice of the stairs at the expense of the escalator by pedestrians leaving the station.

Implantació d'un sistema SCADA en una cèl·lula flexible de fabricació

La Universitat de Vic disposa, entre altres equips, d’una cèl·lula flexible de fabricació, del fabricant Festo, que simula un procés de formació de palets amb els productes que es disposen en un magatzem intermedi. Aquesta cèl·lula està composta de quatre estacions de muntatge diferenciades (càrrega de palets, càrrega de plaques, magatzem intermedi i transport). Cada una disposa d'un PLC SIEMENS S7-300 per la seva automatització, i tots aquests es troben interconnectats amb una xarxa industrial Profibus. L'objectiu d'aquest projecte és implantar el sistema SCADA Vijeo Citect pel control i supervisió de l'estació magatzem d'aquesta cèl·lula flexible de fabricació, establint també un intercanvi de dades entre l'SCADA i el Microsoft Access, per poder ser utilitzat per la docència. Aquest projecte s'ha desenvolupat en cinc fases diferents: 1. La primera fase s'ha dedicat a l'automatització pròpiament de l'estació magatzem a partir de l'autòmat programable Siemens S7-300 i complint amb les necessitats plantejades. 2. En la segona fase s'ha programat i establert la comunicació per l'intercanvi de dades (lectura i escriptura) entre el sistema SCADA Vijeo Citect i la base de dades de Microsoft Access. 3. En la tercera fase s'ha elaborat i programat l'entorn gràfic de supervisió i control del procés a partir del sistema SCADA Vijeo Citect. 4. En la quarta fase s'ha instal·lat un OPC Server en el PC i s'ha establert la comunicació entre el PLC i el sistema SCADA. 5. Finalment s'ha anat revisant i depurant les diferents programacions i comunicacions per tal de que el sistema funcioni com a un conjunt.

Diseño e implementación de una base de datos relacional para la gestión de un videojuego

Diseño e implementación de una base de datos relacional para la gestión de un videojuego. Diseño de un almacén de datos a partir de dicha base de datos.

Diseño e implementación de una base de datos relacional para la gestión de un videojuego

El proyecto consiste en la creación de una base de datos que administra la información y actividad de un videojuego on-line. Adicionalmente se crea un DWH con Pentaho.

Investigação qualitativa e abordagem psico-cultural do desvio [Qualitative research and psycho-cultural approaches of deviance]

Qualitative research and psycho-cultural approaches to deviant behaviour¦In this paper, the authors discuss the relevance of some historical, theoretical and¦methodological features of qualitative research for a psycho-cultural approach to¦deviance. Specifically, three methods are presented: ethnography, life stories and¦grounded theory. Some common features of these methods are: their potentialities of¦articulation with other methods, their plasticity and their procedures grounded in¦research contexts, experiences and meanings lived by participants. The role of the¦researcher, as well as the constructed and dialogical characteristics of both process¦and products of research, are also emphasised in these approaches. In this way,¦qualitative methods seem particularly adequate to a psycho-cultural approach to¦deviance, allowing the research of "hidden" phenomena and an understanding of¦deviance that takes into account its cultural norms. Thus, qualitative research is as a¦methodological device which allows to get beyond the traditional ethnocentrism of psychology.

Formica paralugubris (Hymenoptera, Formicidae) in the Italian Alps from new data and old data revisited.

We provide evidence that Formica paralugubris Seifert, 1996, a species of wood and recently described from Switzerland, is present in the Italian Alps. Until 1996, this species was confounded with F.lugubris Zetterstedt, 1838. We examine the wood and collection deposited at the University of Pavia (Italy) and collect new samples within the Italian Alps. Formica paralugubris seems to be more abundant than F.lugubris. Moreover, both species are found in sympatry in some localities

The Implied Book and the Narrative Text. On a Blind Spot in Narratological Theory - from a Media Studies Perspective

The article is concerned with the formal definition of a largely unnoticed factor in narrative structure. Based on the assumptions that (1) the semantics of a written text depend, among other factors, directly on its visual alignment in space, that (2) the formal structure of a text has to meet that of its spatial presentation and that (3) these assumptions hold true also for narrative texts (which, however, in modern times typically conceal their spatial dimensions by a low-key linear layout), it is argued that, how ever low-key, the expected material shape of a given narrative determines the configuration of its plot by its author. The ,implied book' thus denotes an author's historically assumable, not necessarily conscious idea of how his text, which is still in the process of creation, will be dimensionally presented and under these circumstances visually absorbed. Assuming that an author's knowledge of this later (potentially) substantiated material form influences the composition, the implied book is to be understood as a text-genetically determined, structuring moment of the text. Historically reconstructed, it thus serves the methodical analysis of structural characteristics of a completed text.

1208-005 North Raccoon Watershed Final Report

The Buena Vista SWCD is submitting this WIRB request on behalf of both Buena Vista and Pocahontas SWCDs. The two SWCDs are working jointly on a project that includes three existing Mississippi River Basin Imitative (MRBI) project areas in the North Raccoon River Watershed. The total project area is 280,654 crop acres. The MRBI project involves installing conservation practices through the EQIP program. Funding from MRBI will support costs of practice design, layout and checkout, however, there is no funding to market and sell the program and practices to landowners and producers in the project area. Both soil and water districts are financially supporting work currently being done to encourage signup for the approved practices. To effectively implement the MRBI project it is imperative that marketing and promotion through group meetings and one-on­ one contacts is completed. Funding from WIRB will allow the existing employee to spend the needed time on these promotional activities in both Buena Vista and Pocahontas County. Through this WIRB request these two SWCDs districts plan to apply over $800,000 worth of conservation practices that is funded through the MRBI program. The return from this investment of WIRB dollars is large. This is an opportunity to support a large amount of conservation work in the North Raccoon River Watershed, which, is also an important water source for the city Des Moines and provides recreational activities from Des Moines up to BY and Pocahontas Counties.

Développement de l'interprétation quantitative de la sismique réflexion lacustre : application de l'AVO aux sédiments quaternaires dans le lac Léman

Résumé Des développements antérieurs, au sein de l'Institut de Géophysique de Lausanne, ont permis de développer des techniques d'acquisition sismique et de réaliser l'interprétation des données sismique 2D et 3D pour étudier la géologie de la région et notamment les différentes séquences sédimentaires du Lac Léman. Pour permettre un interprétation quantitative de la sismique en déterminant des paramètres physiques des sédiments la méthode AVO (Amplitude Versus Offset) a été appliquée. Deux campagnes sismiques lacustres, 2D et 3D, ont été acquises afin de tester la méthode AVO dans le Grand Lac sur les deltas des rivières. La géométrie d'acquisition a été repensée afin de pouvoir enregistrer les données à grands déports. Les flûtes sismiques, mises bout à bout, ont permis d'atteindre des angles d'incidence d'environ 40˚ . Des récepteurs GPS spécialement développés à cet effet, et disposés le long de la flûte, ont permis, après post-traitement des données, de déterminer la position de la flûte avec précision (± 0.5 m). L'étalonnage de nos hydrophones, réalisé dans une chambre anéchoïque, a permis de connaître leur réponse en amplitude en fonction de la fréquence. Une variation maximale de 10 dB a été mis en évidence entre les capteurs des flûtes et le signal de référence. Un traitement sismique dont l'amplitude a été conservée a été appliqué sur les données du lac. L'utilisation de l'algorithme en surface en consistante a permis de corriger les variations d'amplitude des tirs du canon à air. Les sections interceptes et gradients obtenues sur les deltas de l'Aubonne et de la Dranse ont permis de produire des cross-plots. Cette représentation permet de classer les anomalies d'amplitude en fonction du type de sédiments et de leur contenu potentiel en gaz. L'un des attributs qui peut être extrait des données 3D, est l'amplitude de la réflectivité d'une interface sismique. Ceci ajoute une composante quantitative à l'interprétation géologique d'une interface. Le fond d'eau sur le delta de l'Aubonne présente des anomalies en amplitude qui caractérisent les chenaux. L'inversion de l'équation de Zoeppritz par l'algorithme de Levenberg-Marquardt a été programmée afin d'extraire les paramètres physiques des sédiments sur ce delta. Une étude statistique des résultats de l'inversion permet de simuler la variation de l'amplitude en fonction du déport. On a obtenu un modèle dont la première couche est l'eau et dont la seconde est une couche pour laquelle V P = 1461 m∕s, ρ = 1182 kg∕m3 et V S = 383 m∕s. Abstract A system to record very high resolution (VHR) seismic data on lakes in 2D and 3D was developed at the Institute of Geophysics, University of Lausanne. Several seismic surveys carried out on Lake Geneva helped us to better understand the geology of the area and to identify sedimentary sequences. However, more sophisticated analysis of the data such as the AVO (Amplitude Versus Offset) method provides means of deciphering the detailed structure of the complex Quaternary sedimentary fill of the Lake Geneva trough. To study the physical parameters we applied the AVO method at some selected places of sediments. These areas are the Aubonne and Dranse River deltas where the configurations of the strata are relatively smooth and the discontinuities between them easy to pick. A specific layout was developed to acquire large incidence angle. 2D and 3D seismic data were acquired with streamers, deployed end to end, providing incidence angle up to 40˚ . One or more GPS antennas attached to the streamer enabled us to calculate individual hydrophone positions with an accuracy of 50 cm after post-processing of the navigation data. To ensure that our system provides correct amplitude information, our streamer sensors were calibrated in an anechoic chamber using a loudspeaker as a source. Amplitude variations between the each hydrophone were of the order of 10 dB. An amplitude correction for each hydrophone was computed and applied before processing. Amplitude preserving processing was then carried out. Intercept vs. gradient cross-plots enable us to determine that both geological discontinuities (lacustrine sediments/moraine and moraine/molasse) have well defined trends. A 3D volume collected on the Aubonne river delta was processed in order ro obtain AVO attributes. Quantitative interpretation using amplitude maps were produced and amplitude maps revealed high reflectivity in channels. Inversion of the water bottom of the Zoeppritz equation using the Levenberg-Marquadt algorithm was carried out to estimate V P , V S and ρ of sediments immediately under the lake bottom. Real-data inversion gave, under the water layer, a mud layer with V P = 1461 m∕s, ρ = 1182 kg∕m3 et V S = 383 m∕s.

Ein unbekanntes Fragment der "Alexandreis" Walters von Châtillon

Das im letzten Viertel des 12. Jahrhunderts entstandene Alexander-Epos Walters von Châtillon, schon im 13. Jahrhundert in den ,,status of a classic" (Colker) und überdies zum Schultext avanciert, gehört zu den am reichhaltigsten überlieferten Erzähltexten der lateinischen Literatur des Mittelalters. Der Beitrag kann ausser den in der Ausgabe Colkers (1987) nachgewiesenen 209 Textzeugen 15 weitere Handschriften und Fragmente belegen und zudem einen Neufund vorstellen: Im Archiv der Bürgergemeinde Frauenfeld, Schweiz, erhielt sich als einzelnes Doppelblatt ein glossiertes Fragment des Textes aus dem späten 13. oder frühen 14. Jahrhundert. Sein Layout verrät, dass es für die begleitende Kommentierung von vornherein angelegt war und vermutlich einem Schulbuch entstammt. Die erhaltenen Scholien scheinen dem ,,Standardkommentar" (Killermann) zur ,Alexandreis' nahezustehen, könnten aber auch Bezüge zum Kommentar des Geoffrey de Vitry aufweisen, der in einer mit seinem Namen auktorial verbundenen, aus Rheinau stammenden Handschrift erhalten ist. In vergleichsweise dichter räumlicher und zeitlicher Nähe zu diesem Textzeugen entstand die Handschrift, aus der das neue Frauenfelder Fragment stammt: Die Untersuchung der Akte, als deren Schutzumschlag das Doppelblatt aus der ,Alexandreis' diente, zeigt, dass sie sich seit dem frühen 15. Jahrhundert im jetzigen Kontext, den Beständen des heutigen Archivs der Frauenfelder Bürgergemeinde, befunden hat, das auf eine seit dem 13. Jahrhundert geführte Sammlung zurückgeht. Da zudem in Frauenfeld eine Lateinschule seit dem 14. Jahrhundert nachweisbar und schon im 13. Jahrhundert zu vermuten ist, liegt es nahe, dass der Fundort des neuen Textzeugen auch der seiner Entstehung oder doch zumindest seiner Benutzung im Unterricht war. Das Fragment bietet einen trotz schlechter Abschrift (mit häufigen Korrekturen durch den Glossator) unverkennbar guten Text, in kritischer Hinsicht dabei nur geringen Gewinn. Seine textgeschichtliche Verortung kann angesichts der nach wie vor weitgehend unaufgearbeiteten Überlieferung der ,Alexandreis' nur in groben Zügen vorgenommen werden. - Mit einem durch einen kritischen Apparat erschlossenen diplomatischen Abdruck und zwei Abbildungen des neuen Fragments.

Construcción y explotación de un almacén de datos para el análisis de información sobre el tránsito rodado de vehículos

El objetivo principal del TFC es la construcción y explotación de un almacén de datos. El proceso de trabajo se basa en la ejecución de un caso práctico, en el cual se presenta un escenario en el que se necesita desarrollar un almacén de datos para la Fundació d'Estudis per a la Conducció Responsable, la cual desea estudiar la evolución del número de desplazamientos en vehículo de motor en Cataluña así como analizar las posibles correlaciones entre medios de locomoción, perfiles de conductores y algunas variables de seguridad vial.

Construcció i explotació d'un magatzem de dades per a l'anàlisi d'informació sobre trànsit rodat de vehicles

Aquest document defineix la construcció i explotació d'un magatzem de dades per a la Fundació d'Estudis per a la Conducció Responsable. L'objectiu del projecte és homogeneïtzar la informació que rep la fundació, des de diverses fonts i en diferents formats, consolidar-la en un únic magatzem de dades i habilitar eines que facilitin la seva explotació i anàlisi. La consecució d'aquestes fites és determinant perquè la direcció conegui l'evolució del trànsit rodat de vehicles a Catalunya i minimitzi el riscos en cas de qualsevol presa de decisions.