Construcción y explotación de un almacén de datos de planificación hidrológica

Este documento es la memoria del trabajo de final de carrera (TFC) del área de almacenes de datos, dentro de los estudios de Ingeniería Técnica en Informática de Gestión de la Universitat Oberta de Catalunya (UOC).El proyecto a desarrollar en dicho TFC versa sobre el diseño, implementación y explotación de un almacén de datos para la Confederación Hidrográfica del Noreste (CHNE). Partiendo de sus fuentes de datos construiremos un almacén de datos del cual poder obtener un conjunto de informes predefinidos, según las especificaciones del CHNE.

Construcción y explotación de un almacén de datos de planificación hidrológica

Este documento describe el plan de trabajo, el análisis y la implementación del trabajo de fin de carrera de los estudios de Ingeniería Técnica de Informática de Gestión, en concreto del área de almacén de datos.El objetivo de este trabajo es familiarizarse con la arquitectura de un DW: el diseño de un DW, tratamiento de datos, así como conocer las herramientas de que dispone el mercado para trabajar con estos modelos y realizar los análisis dirigidos a usuarios finales.

Disseny i implementació d'una base de dades relacional per a la gestió d'incidències de productes

El projecte suposa el disseny i construcció de diferents parts: anàlisi dels requeriments de l'empresa, el disseny de les taules de la base de dades, definició dels índexs de les taules, disseny i implementació dels procediments emmagatzemats de la base de dades. Aquests procediments emmagatzemats seran l'única forma d'entrada o sortida de la base de dades ocultant així els detalls més pesats relatius a l'estructura interna de la base de dades creada, d'aquesta manera, les consultes de les dades podran ser realitzades per part d'usuaris que no tenen coneixements específics sobre bases de dades.

Gestión postventa

Proyecto final de carrera en el que una empresa, especializada en el segmento de los electrodomésticos, se ve en la necesidad de cambiar el sistema que tiene para gestionar la postventa de sus productos. Se han analizado los requerimientos del nuevo sistema, así como implementado la base de datos que satisface estos requerimientos junto con los procedimientos necesarios para la gestión que proporcionaran el único método de acceso. A parte de la gestión diaria de las incidencias, se han consolidado datos para generar estadísticas que permitan mejorar la eficiencia de la empresa.

Disseny i implementació d'un sistema de gestió d'amonestacions i sancions en centres educatius

El treball se centra en desenvolupar un sistema informàtic que serveixi com a magatzem d'informació per a una futura aplicació de gestió d'amonestacions i sancions en centres educatius d'ensenyament secundari dependents de la Generalitat de Catalunya i implica tant el disseny com la implementació de la base de dades. L'aplicació concreta de gestió, però, resta fora de l'àmbit d'aquest treball. El projecte permet, mitjançant procediments emmagatzemats, efectuar les funcionalitats principals del sistema: inserir, esborrar i/o modificar dades; a més, proporciona diversa informació estadística.

Disseny i implementació d'un sistema de gestió d'amonestacions i sancions en centres educatius

Es un proyecto sobre todos los pasos a seguir para un proyecto informático. Este proyecto está realizado sobre una gestión de amonestaciones y sanciones en un centro educativo. Tenemos el diseño de la base de datos, su implementación y todas las diferentes pruebas para su testeo.

Enhancing fault management performance of two-step QoS routing algorithms in GMPLS networks

In this paper a novel methodology aimed at minimizing the probability of network failure and the failure impact (in terms of QoS degradation) while optimizing the resource consumption is introduced. A detailed study of MPLS recovery techniques and their GMPLS extensions are also presented. In this scenario, some features for reducing the failure impact and offering minimum failure probabilities at the same time are also analyzed. Novel two-step routing algorithms using this methodology are proposed. Results show that these methods offer high protection levels with optimal resource consumption

An ATM distributed simulator for network management research

Due to the high cost of a large ATM network working up to full strength to apply our ideas about network management, i.e., dynamic virtual path (VP) management and fault restoration, we developed a distributed simulation platform for performing our experiments. This platform also had to be capable of other sorts of tests, such as connection admission control (CAC) algorithms, routing algorithms, and accounting and charging methods. The platform was posed as a very simple, event-oriented and scalable simulation. The main goal was the simulation of a working ATM backbone network with a potentially large number of nodes (hundreds). As research into control algorithms and low-level, or rather cell-level methods, was beyond the scope of this study, the simulation took place at a connection level, i.e., there was no real traffic of cells. The simulated network behaved like a real network accepting and rejecting SNMP ones, or experimental tools using the API node

Dynamic bandwidth management as part of an integrated network management system based on distributed agents

We present a system for dynamic network resource configuration in environments with bandwidth reservation and path restoration mechanisms. Our focus is on the dynamic bandwidth management results, although the main goal of the system is the integration of the different mechanisms that manage the reserved paths (bandwidth, restoration, and spare capacity planning). The objective is to avoid conflicts between these mechanisms. The system is able to dynamically manage a logical network such as a virtual path network in ATM or a label switch path network in MPLS. This system has been designed to be modular in the sense that in can be activated or deactivated, and it can be applied only in a sub-network. The system design and implementation is based on a multi-agent system (MAS). We also included details of its architecture and implementation

An automatic correction tool for relational database schemas

A Web-based tool developed to automatically correct relational database schemas is presented. This tool has been integrated into a more general e-learning platform and is used to reinforce teaching and learning on database courses. This platform assigns to each student a set of database problems selected from a common repository. The student has to design a relational database schema and enter it into the system through a user friendly interface specifically designed for it. The correction tool corrects the design and shows detected errors. The student has the chance to correct them and send a new solution. These steps can be repeated as many times as required until a correct solution is obtained. Currently, this system is being used in different introductory database courses at the University of Girona with very promising results

Exploring Cross-layer power management for PGAS applications on the SCC platform

Technological limitations and power constraints are resulting in high-performance parallel computing architectures that are based on large numbers of high-core-count processors. Commercially available processors are now at 8 and 16 cores and experimental platforms, such as the many-core Intel Single-chip Cloud Computer (SCC) platform, provide much higher core counts. These trends are presenting new sets of challenges to HPC applications including programming complexity and the need for extreme energy efficiency.In this work, we first investigate the power behavior of scientific PGAS application kernels on the SCC platform, and explore opportunities and challenges for power management within the PGAS framework. Results obtained via empirical evaluation of Unified Parallel C (UPC) applications on the SCC platform under different constraints, show that, for specific operations, the potential for energy savings in PGAS is large; and power/performance trade-offs can be effectively managed using a cross-layerapproach. We investigate cross-layer power management using PGAS language extensions and runtime mechanisms that manipulate power/performance tradeoffs. Specifically, we present the design, implementation and evaluation of such a middleware for application-aware cross-layer power management of UPC applications on the SCC platform. Finally, based on our observations, we provide a set of recommendations and insights that can be used to support similar power management for PGAS applications on other many-core platforms.

Visual management of sags and incidents gathered in distribution substations for power quality management

Monitor a distribution network implies working with a huge amount of data coining from the different elements that interact in the network. This paper presents a visualization tool that simplifies the task of searching the database for useful information applicable to fault management or preventive maintenance of the network

M.A.M. (Mobile Applications Management)

L'objectiu fonamental d'aquest treball és implementar un sistema de base de dades per donar resposta a la necessitat dels desenvolupadors d'aplicacions mòbils a nivell mundial per unificar i millorar l'experiència dels seus usuaris a l'hora de descarregar les seves aplicacions.

The region makes the difference: disparities in management of acute myocardial infarction within Switzerland.

BACKGROUND: In Switzerland, health policies are decided at the local level, but little is known regarding their impact on the management of acute myocardial infarction (AMI). In this study, we assessed geographical differences within Switzerland regarding management of AMI. DESIGN: Cross-sectional study. METHODS: Swiss hospital discharge database for period 2007-2008 (26,204 discharges from AMI). Seven Swiss regions (Leman, Mittelland, Northwest, Zurich, Central, Eastern, and Ticino) were analysed. RESULTS: Almost 53.7% of discharges from AMI were managed in a single hospital, ranging from 62.1% (Leman) to 31.6% (Ticino). The highest intensive care unit admission rate was in Leman (69.4%), the lowest (16.9%) in Ticino (Swiss average: 36.0%). Intracoronary revascularization rates were highest in Leman (51.1%) and lowest (30.9%) in Central Switzerland (average: 41.0%). Bare (non-drug-eluting) stent use was highest in Leman (61.4%) and lowest (16.9%) in Ticino (average: 42.1%), while drug-eluting stent use was highest (83.2%) in Ticino and lowest (38.6%) in Leman (average: 57.9%). Coronary artery bypass graft rates were highest (4.8%) in Ticino and lowest (0.5%) in Eastern Switzerland (average: 2.8%). Mechanical circulatory assistance rates were highest (4.2%) in Zurich and lowest (0.5%) in Ticino (average: 1.8%). The differences remained after adjusting for age, single or multiple hospital management, and gender. CONCLUSIONS: In Switzerland, significant geographical differences in management and revascularization procedures for AMI were found.

Trends in hospital discharges, management and in-hospital mortality from acute myocardial infarction in Switzerland between 1998 and 2008.

BACKGROUND: Since the late nineties, no study has assessed the trends in management and in-hospital outcome of acute myocardial infarction (AMI) in Switzerland. Our objective was to fill this gap. METHODS: Swiss hospital discharge database for years 1998 to 2008. AMI was defined as a primary discharge diagnosis code I21 according to the ICD10 classification. Invasive treatments and overall in-hospital mortality were assessed. RESULTS: Overall, 102,729 hospital discharges with a diagnosis of AMI were analyzed. The percentage of hospitalizations with a stay in an Intensive Care Unit decreased from 38.0% in 1998 to 36.2% in 2008 (p for trend < 0.001). Percutaneous revascularizations increased from 6.0% to 39.9% (p for trend < 0.001). Bare stents rose from 1.3% to 16.6% (p for trend < 0.001). Drug eluting stents appeared in 2004 and increased to 23.5% in 2008 (p for trend < 0.001). Coronary artery bypass graft increased from 1.0% to 3.0% (p for trend < 0.001). Circulatory assistance increased from 0.2% to 1.7% (p for trend < 0.001). Among patients managed in a single hospital (not transferred), seven-day and total in-hospital mortality decreased from 8.0% to 7.0% (p for trend < 0.01) and from 11.2% to 10.1%, respectively. These changes were no longer significant after multivariate adjustment for age, gender, region, revascularization procedures and transfer type. After multivariate adjustment, differing trends in revascularization procedures and in in-hospital mortality were found according to the geographical region considered. CONCLUSION: In Switzerland, a steep rise in hospital discharges and in revascularization procedures for AMI occurred between 1998 and 2008. The increase in revascularization procedures could explain the decrease in in-hospital mortality rates.