Disseny i implementació d'una base de dades relacional per a la gestió d'apostes de futbol

Memòria del projecte final de carrera on es desenvolupen la planificació de les tasques, la definició i anàlisi dels requeriments, l'enumeració dels casos d'ús, el disseny de la base de dades operacional i de data warehouse, implementació dels esquemes, realització de proves unitàries i procedimentació i tasques d'extracció, transformació i càrrega. L'usuari s'haurà de validar usant la funció login i per poder accedir a la informació haurà d'usar els paquets de la base de dades sense poder accedir directament a les dades de les taules.

Identificación de criterios que permiten definir el tipo de las primeras claras en las masas de Pinus nigra subsp. laricio en el País Vasco (España)

Se pretende definir el tipo de clara mas conveniente en las masas de latizal de Pinus nigra Arn. subsp. laricio (Poir) del Pais Vasco, a partir de la caracterizacion obtenida a traves de ciertos atributos individuales de los arboles y de su estratificacion vertical. Se desprende que los individuos no ofrecen rasgos distintivos destacables y suficientes sobre los que sustentar los criterios de eleccion de los arboles a apear en las claras, asi como que tampoco muestran tendencia hacia la estratificacion vertical. Desde este analisis, se apunta como necesario primar aspectos de sencillez y operatividad practica en la fase de senalamiento de la intervencion selvicola, optandose, en consecuencia, por las claras por lo bajo y posponiendose para mas adelante las selectivas.

Preface: Extreme events induced by weather and climate change: evaluation, forecasting and proactive planning

This special issue of Natural Hazards and Earth System Sciences (NHESS) contains eight papers presented as oral or poster contributions in the Natural Hazards NH-1.2 session on"Extreme events induced by weather and climate change: evaluation, forecasting and proactive planning", held at the European Geosciences Union (EGU) General Assembly in Vienna, Austria, on 13-18 April 2008. The aim of the session was to provide an international forum for presenting new results and for discussing innovative ideas and concepts on extreme hydro-meteorological events, including: (i) the assessment of the risk posed by the extreme events, (ii) the expected changes in the frequency and intensity of the events driven by a changing climate and by multiple human- induced causes, (iii) new modelling approaches and original forecasting methods to predict extreme events and their consequences, and (iv) strategies for hazard mitigation and risk reduction, and for a improved adaptation to extreme hydro-meteorological events ...

Cultural Planning and community sustainability: The case of the Cultural Facilities Plan of Catalonia (PECCAT 2010-20)

The government of Catalonia has developed a planning framework that seeks to establish the provision of cultural facilities throughout the country. The Cultural Facilities Plan of Catalonia (PECCAT) is based on an analysis of historical gaps and establishes a minimum spatial scheme. The plan responds to problems associated with the absence of a former similar instrument, which has led to an inconsistent and inappropriate cultural infrastructure that fails to fulfill its fundamental mission of securing the cultural rights of the population. The paper sets forth the aims of this policy and describes the objectives and basic characteristics of the plan and the expected outcomes. With the plan, the government of Catalonia seeks to rebalance the infrastructure within the territory and to ensure universal access to basic cultural services, while avoiding a logic of standardization and taking local communities into account. With the development of local plans in the municipalities, local governments encourage community participation processes to adapt and decide on priorities for action based on needs assessments and cultural opportunities for local sustainable development. The local plans focus on local cultural strengths, take advantage of opportunities, and aim to realize the cultural dynamics of a place through establishing an infrastructure that can best respond to the needs and cultural demands of the local communities, taking into account economic, social, and environmental sustainability.

Aquaculture production in areas with high seasonal temperature variations: Development of planning tools

Postprint (published version)

A survey on coverage path planning for robotics

Coverage Path Planning (CPP) is the task of determining a path that passes over all points of an area or volume of interest while avoiding obstacles. This task is integral to many robotic applications, such as vacuum cleaning robots, painter robots, autonomous underwater vehicles creating image mosaics, demining robots, lawn mowers, automated harvesters, window cleaners and inspection of complex structures, just to name a few. A considerable body of research has addressed the CPP problem. However, no updated surveys on CPP reflecting recent advances in the field have been presented in the past ten years. In this paper, we present a review of the most successful CPP methods, focusing on the achievements made in the past decade. Furthermore, we discuss reported field applications of the described CPP methods. This work aims to become a starting point for researchers who are initiating their endeavors in CPP. Likewise, this work aims to present a comprehensive review of the recent breakthroughs in the field, providing links to the most interesting and successful works

ESTRO-HERO survey: Guidelines for equipment and staffing of radiotherapy facilities in the European countries: Final results of the ESTRO-HERO survey

Background and purpose: In planning to meet evidence based needs for radiotherapy, guidelines for the provision of capital and human resources are central if access, quality and safety are not to be compromised. A component of the ESTRO-HERO (Health Economics in Radiation Oncology) project is to document the current availability and content of guidelines for radiotherapy in Europe. Materials and methods: An 84 part questionnaire was distributed to the European countries through their national scientific and professional radiotherapy societies with 30 items relating to the availability of guidelines for equipment and staffing and selected operational issues. Twenty-nine countries provided full or partial evaluable responses. Results: The availability of guidelines across Europe is far from uniform. The metrics used for capital and human resources are variable. There seem to have been no major changes in the availability or specifics of guidelines over the ten-year period since the QUARTS study with the exception of the recent expansion of RTT staffing models. Where comparison is possible it appears that staffing for radiation oncologists, medical physicists and particularly RTTs tend to exceed guidelines suggesting developments in clinical radiotherapy are moving faster than guideline updating. Conclusion: The efficient provision of safe, high quality radiotherapy services would benefit from the availability of well-structured guidelines for capital and human resources, based on agreed upon metrics, which could be linked to detailed estimates of need

Operational Cost Reduction in WDM Networks using Lighttours

Wavelength division multiplexing (WDM) networks have been adopted as a near-future solution for the broadband Internet. In previous work we proposed a new architecture, named enhanced grooming (G+), that extends the capabilities of traditional optical routes (lightpaths). In this paper, we compare the operational expenditures incurred by routing a set of demands using lightpaths with that of lighttours. The comparison is done by solving an integer linear programming (ILP) problem based on a path formulation. Results show that, under the assumption of single-hop routing, almost 15% of the operational cost can be reduced with our architecture. In multi-hop routing the operation cost is reduced in 7.1% and at the same time the ratio of operational cost to number of optical-electro-optical conversions is reduced for our architecture. This means that ISPs could provide the same satisfaction in terms of delay to the end-user with a lower investment in the network architecture

Balancing effluent quality, economic cost and greenhouse gas emissions during the evaluation of (plant-wide) control/operational strategies in WWTPs

The objective of this paper was to show the potential additional insight that result from adding greenhouse gas (GHG) emissions to plant performance evaluation criteria, such as effluent quality (EQI) and operational cost (OCI) indices, when evaluating (plant-wide) control/operational strategies in wastewater treatment plants (WWTPs). The proposed GHG evaluation is based on a set of comprehensive dynamic models that estimate the most significant potential on-site and off-site sources of CO2, CH4 and N2O. The study calculates and discusses the changes in EQI, OCI and the emission of GHGs as a consequence of varying the following four process variables: (i) the set point of aeration control in the activated sludge section; (ii) the removal efficiency of total suspended solids (TSS) in the primary clarifier; (iii) the temperature in the anaerobic digester; and (iv) the control of the flow of anaerobic digester supernatants coming from sludge treatment. Based upon the assumptions built into the model structures, simulation results highlight the potential undesirable effects of increased GHG production when carrying out local energy optimization of the aeration system in the activated sludge section and energy recovery from the AD. Although off-site CO2 emissions may decrease, the effect is counterbalanced by increased N2O emissions, especially since N2O has a 300-fold stronger greenhouse effect than CO2. The reported results emphasize the importance and usefulness of using multiple evaluation criteria to compare and evaluate (plant-wide) control strategies in a WWTP for more informed operational decision making

Emergency Management in the United States of America

Core capabilities are under the above mission areas as outlined in the National Preparedness Goal. Planning, Public Information and Warning, and Operational Coordination cut across all five mission areas. Without these three cross-cutting capabilities, the other capabilities might not be achieved or could be weakened. Other core capabilities are aligned under a specific mission area, based on where it had the most relevance. Core capabilities alignment: Prevention capabilities focus on things related to preventing an imminent terrorist attack; by imminent, we mean an attack that is about to happen ; Protection capabilities focus on security— making sure things, systems, and people are protected ; Mitigation capabilities focus on risk, resilience and building a culture of preparedness; Response capabilities focus on meeting a community’s immediate needs when disaster strikes and finally, recovery capabilities focus on getting communities back on their feet.

Plan estratégico 2012-2105 para la empresa Automatizaciones Eléctricas, SL

La empresa moderna, se encuentra en una situación actual de incertidumbre en la que además está más expuesta a factores externos con el aumento de la competencia y el impacto de la globalización. Se enfrenta a un panorama que debe ser gestionado adecuadamente para asegurar su supervivencia y el éxito de su existencia. En este TFC, se presenta una de las herramientas ‘buque insignia’ del Management moderno, aquella que está destinada a ser la base de la Gestión de la empresa y que cada vez más se hace imprescindible para la construcción de un futuro cada vez más incierto, la Planificación Estratégica. El Plan Estratégico 2012-2015 de AESL se desarrolla en varios apartados que intentarán dar con las claves de la dirección que la empresa debe seguir y propone los objetivos que encontrará a través de la puesta en marcha de las acciones y estrategias determinadas. La primera etapa, y la más extensa, realiza un Análisis de la situación externa e interna de la empresa además de un Diagnóstico de la misma. Se analizan diversos factores que pueden contribuir o hacer peligrar el futuro de la empresa, y constituye el punto de partida de la planificación. En la segunda etapa, y con la información de la anterior fase, comienza la fijación de los Objetivos Corporativos y la definición de las Decisiones Estratégicas que han de transformar nuestro rumbo actual en el logro de esos objetivos. Las estrategias no sólo comportarán un ámbito corporativo, también se centrarán en estrategias funcionales con un carácter más definitorio en el interior de la empresa. Por último, la tercera y última etapa, aglutinará todas estas Decisiones estratégicas para transformarlas en las Decisiones Operativas, aquellas que se encargarán de gestionar el día a día de la empresa a través de los Planes de Acción, que suponen la etapa de mayor concreción del Plan. Este Plan a 3 años deberá erigirse como la herramienta de planificación más importante de la empresa, debiendo guiar las principales decisiones tomadas y convirtiéndose en un instrumento de consulta no sólo para decidir hoy lo que se hará en el futuro sino también para mantener unos niveles altos de competitividad en el tremendo esfuerzo que supone la gestión de una PYME.