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

El ejercicio que se nos plantea es desarrollar una base de datos para la gestión integral del sistema sanitario. Además, también tendremos que crear un almacén de datos para facilitar el análisis de la situación del sistema.

Estudo avaliativo da consulta de enfermagem na Rede Básica de Curitiba - PR

A implantação do prontuário eletrônico na rede básica de Curitiba propiciou um avanço, com a implantação da consulta de enfermagem e da CIPESC®, que utilizou para sua modelagem a estrutura de eixos da CIPE® e a lista de ações CIPESC®. Este estudo tem como objetivo avaliar a consulta de enfermagem na ótica da produtividade e cobertura assistencial. A população foi constituída da base de dados secundária, de consultas de enfermagem realizadas de abril a julho de 2005. A análise foi realizada com Datawarehouse e a ferramenta OLAP. A produtividade por profissional é de 2,5 consultas/dia, utilizando 16% da jornada diária nesta atividade e 27% do potencial/mês. A CIPESC® foi utilizada em 21% das consultas. A cobertura de 0,08 consulta/habitante atinge 6% da população. A consulta de enfermagem possibilita a caracterização do papel do enfermeiro no cuidado à saúde, e um novo posicionamento profissional capaz de influenciar a construção de políticas públicas.

Synthesis of Best Practice for Increasing Protection and Visibility of Highway Maintenance Vehicles, CTRE Final Report Iowa DOT Project TR-475, August 2002

The purpose of this research project is to study current practices in enhancing visibility and protection of highway maintenance vehicles involved in moving operations such as snow removal and shoulder operations, crack sealing, and pothole patching. The results will enable the maintenance staff to adequately assess the applicability and impact of each strategy to their use and budget. The report’s literature review chapter examines the use of maintenance vehicle warning lights, retroreflective tapes, shadow vehicles and truck-mounted attenuators, and advanced vehicle control systems, as well as other practices to improve visibility for both snowplow operators and vehicles. The chapter concludes that the Manual on Uniform Traffic Control Devices does not specify what color or kind of warning lights to use. Thus, a wide variety of lights are being used on maintenance vehicles. The study of the relevant literatures also suggests that there are no clear guidelines for moving work zones at this time. Two types of surveys were conducted to determine current practices to improve visibility and safety in moving work zones across the country and in the state of Iowa. In the first survey of state departments of transportation, most indicated using amber warning lights on their maintenance vehicles. Almost all the responding states indicated using some form of reflective material on their vehicles to make them more visible. Most participating states indicated that the color of their vehicles is orange. Most states indicated using more warning lights on snow removal vehicles than their other maintenance vehicles. All responding state agencies indicated using shadow vehicles and/or truck-mounted attenuators during their moving operations. In the second survey of Iowa counties, most indicated using very similar traffic control and warning devices during their granular road maintenance and snow removal operations. Mounting warning signs and rotating or strobe lights on the rear of maintenance vehicles is common for Iowa counties. The most common warning devices used during the counties’ snow removal operations are reflective tapes, warning flags, strobe lights, and auxiliary headlamps.

Work and health conditions of sugar cane workers in Brazil

This is an exploratory research, with a quantitative approach, developed with the objective of analyzing the work and of life situations that can offer risks to the workers' health involved in the manual and automated cut of the sugar cane. The sample was composed by 39 sugar cane cutters and 16 operators of harvesters. The data collection occurred during the months of July and August of 2006, by the technique of direct observation of work situations and workers' homes and through interviews semi-structured. The interviews were recorded and later transcribed. Data were analyzed according to Social Ecological Theory. It was observed that the workers deal with multiple health risk situations, predominantly to the risks of occurrence of respiratory, musculoskeletal and psychological problems and work-related accidents due to the work activities. The interaction of individual, social and environmental factors can determine the workers' tendency to falling ill.

Quantifying urban attractiveness from the distribution and density of digital footprints

In the past, sensors networks in cities have been limited to fixed sensors, embedded in particular locations, under centralised control. Today, new applications can leverage wireless devices and use them as sensors to create aggregated information. In this paper, we show that the emerging patterns unveiled through the analysis of large sets of aggregated digital footprints can provide novel insights into how people experience the city and into some of the drivers behind these emerging patterns. We particularly explore the capacity to quantify the evolution of the attractiveness of urban space with a case study of in the area of the New York City Waterfalls, a public art project of four man-made waterfalls rising from the New York Harbor. Methods to study the impact of an event of this nature are traditionally based on the collection of static information such as surveys and ticket-based people counts, which allow to generate estimates about visitors’ presence in specific areas over time. In contrast, our contribution makes use of the dynamic data that visitors generate, such as the density and distribution of aggregate phone calls and photos taken in different areas of interest and over time. Our analysis provides novel ways to quantify the impact of a public event on the distribution of visitors and on the evolution of the attractiveness of the points of interest in proximity. This information has potential uses for local authorities, researchers, as well as service providers such as mobile network operators.

Feasibility of replacing multiple ADSL connections with Multi-Dwelling Access

This final project was made for the Broadband/Implementation department of TeliaSonera Finland. The question to be examined is if the operator should replace multiple ADSL connections implemented over a leased line with Multi-Dwelling access based on an Ethernet/Optical Fibre access network. The project starts with describing the technology related to these access network solu-tions and presents the technology that is used in TeliaSonera Finland's access network. It continues from the technology to describe the problem with some of the ADSL implemen-tations of TeliaSonera. The problem is the implementations done over a leased line that can cost TeliaSonera over years as much as a possible investment to extend network when there is several lines leased to the same building. The project proposes a Multi-Dwelling access as a solution to this problem and defines the circumstances when to use it. After a satisfactory solution has found the project takes a view how implementation of the solution might alter the network and a new problem is found. When used commonly to replace need of ADSL implementation Multi-Dwelling access would significantly increase optical cable congestion near operators POP. As a final deed this project also proposes a technical change to existing way to implement multi-dwelling access with EPON technology.

Towards Integrated Governance of Landscape Development : The Swiss Model of Regional Nature Parks

Coherent regulation of landscape as a resource is a major challenge. How can the development interests of some actors (eg cable car operators and property developers) be reconciled with those of others (agriculture, forestry) and with conservation of biodiversity and scenic value? To help understand how the newly introduced Regional Nature Parks (RNPs) can improve the coherence of the regulation regime in Switzerland, we highlight current direct mechanisms for regulation of landscape as a resource (bans, inventories, subsidies) as well as indirect mechanisms (taking place through the regulation of the physical basis of landscapes, eg forest, land, and water planning policies). We show that RNPs are fundamentally innovative because they make it possible to manage and coordinate indirect strategies for appropriate regulation of resources at a landscape scale. In other words, RNPs enable organization of governance of landscape as a resource in a perimeter that is not necessarily restricted to administrative boundaries.

Evaluation of Virtual Reality Snowplow Simulator Training: A Literature Review, September 2006

Each winter, the Iowa Department of Transportation (Iowa DOT) maintenance operators are primarily responsible for plowing snow off federal and state roads. Drivers typically work long shifts under treacherous conditions. In addition to properly navigating the vehicle, drivers are required to operate several plowing mechanisms simultaneously, such as plow controls and salt sprayers. However, operators have few opportunities during the year to practice and refine their skills. An ideal training program would provide operators with the opportunity to practice these skills under realistic yet safe conditions, as well as provide basic training to novice or less-experienced operators. Recent technological advancements have made driving simulators a desirable training and research tool. This literature review discusses much of the recent research establishing simulator fidelity and espousing its applicability. Additionally, this report provides a summary of behavioral and eye tracking research involving driving simulators. Other research topics include comparisons between novice and expert drivers’ behavioral patterns, methods for avoiding cybersickness in virtual environments, and a synopsis of current personality measures with respect to job performance and driving performance. This literature review coincides with a study designed to examine the effectiveness of virtual reality snowplow simulator training for current maintenance operators, using the TranSim VS III truck and snowplow simulator recently purchased by the Iowa DOT.

Sistema de Informação de Apoio à Detecção de Perdas de Energia Eléctrica – O Caso da Electra

A realidade mundial é preocupante no que diz respeito ao aumento de ocorrências de perdas e fraudes em redes de distribuição de energia eléctrica. Em Cabo Verde, mas precisamente na Cidade da Praia a realidade é ainda mais preocupante devido ao número de ocorrências e a gravidade dos mesmos. Propõe-se um trabalho de investigação sobre perdas e fraudes de energia eléctrica baseado na análise dos dados relativos aos registos dos clientes na Base de Dados da Electra (Cabo Verde), com o intuito de nortear as tomadas de decisões de gestão estratégica no que diz respeito às políticas de controlo e prevenção de perdas e fraudes de energia eléctrica. O trabalho baseia-se na recolha e selecção de dados a organizar numa Data Warehouse para depois aplicar as tecnologias OLAP para a identificação de perdas nos Postos de Transformação e zonas geográficas da Cidade da Praia em Cabo Verde e posteriormente identificar possíveis fraudes de energia eléctrica nos clientes finais utilizando Data Mining. Os resultados principais consistiram na identificação de situações de perdas de energia eléctrica nos Postos de Transformação, a identificação de áreas críticas seleccionadas para inspecção dos seus clientes finais e a detecção de padrões de anomalias associadas ao perfil dos clientes.

Difficulties of familes in caring for children and adolescents with mental disorders: an integrative review

Objective To identify the difficulties of families with children and/or adolescents with mental disorder. Method This is an integrative review. In December 2013, an electronic search was performed on Latin American Caribbean Literature on Health Sciences databases (LILACS) and on Electronic Medicus Index of the National Library of Medicine (MEDLINE) indexed in the Health Virtual Library (BVS) using a combination of descriptors and boolean operators as follows: mental disorders and child or adolescent and caregivers and/not health staff. Results 557 studies were identified, of which 15 were selected for this study. The findings indicated difficulties related to the care for or to interaction with children/adolescents with mental disorder. Conclusion The studies revealed difficulties related to everyday practices of care and feelings expressed during care practices, as well as in relationships with children or adolescents with mental disorder.



Evaluation of Virtual Reality Snowplow Simulator Training, January 2007

Each winter, Iowa Department of Transportation (Iowa DOT) maintenance operators are responsible for plowing snow off federal and state roads in Iowa. Drivers typically work long shifts under treacherous conditions. In addition to properly navigating the vehicle, drivers are required to operate several plowing mechanisms simultaneously, such as plow controls and salt spreaders. There is little opportunity for practicing these skills in real-world situations. A virtual reality training program would provide operators with the opportunity to practice these skills under realistic yet safe conditions, as well as provide basic training to novice or less-experienced operators. In order to provide such training to snowplow operators in Iowa, the Iowa DOT purchased a snowplow simulator. The Iowa DOT commissioned a study through Iowa State University designed to (1) assess the use of this simulator as a training tool and (2) examine personality and other characteristics associated with being an experienced snowplow operator. The results of this study suggest that Iowa DOT operators of all ages and levels of experience enjoyed and seemed to benefit from virtual reality snowplow simulator training. Simulator sickness ratings were relatively low, implying that the simulator is appropriate for training a wide range of Iowa DOT operators. Many reported that simulator training was the most useful aspect of training for them.

Bases de dades

Este proyecto final de carrera ha consistido principalmente en la planificación y ejecución del diseño e implementación de una base de datos (BD) relacional para la gestión sanitaria. El sistema resultante permite tanto la gestión de las consultas externas de los centros hospitalarios como la de los pacientes atendidos. Toda la gestión y acceso a los datos de las tablas se ha hecho mediante procedimientos almacenados creados en la propia base de datos. También se ha definido un almacén de datos que permite realizar un análisis de los datos almacenados en dicha BD.

Determinants of organizational form: Transaction costs and institutions in the European trucking industry

We explain why European trucking carriers are much smaller and rely more heavily on owner-operators(as opposed to employee drivers) than their US counterparts. Our analysis begins by ruling outdifferences in technology as the source of those disparities and confirms that standard hypothesesin organizational economics, which have been shown to explain the choice of organizational form inUS industry, also apply in Europe. We then argue that the preference for subcontracting oververtical integration in Europe is the result of European institutions particularly, labor regulationand tax laws that increase the costs of vertical integration.

Quasi-integration in less-than-truckload trucking

This work studies the organization of less-than-truckload trucking from a contractual point of view. We show that the huge number of owner-operators working in the industry hides a much less fragmented reality. Most of those owner-operators are quasi-integrated in higher organizational structures. This hybrid form is generally more efficient than vertical integration because, in the Spanish institutional environment, it lessens serious moral hazard problems, related mainly to the use of the vehicles, and makes it possible to reach economies of scale and density. Empirical evidence suggests that what leads organizations to vertically integrate is not the presence of such economies but hold-up problems, related to the existence of specific assets. Finally, an international comparison hints that institutional constraints are able to explain differences in the evolution of vertical integration across countries.

Driver scheduling problem modelling

The Drivers Scheduling Problem (DSP) consists of selecting a set of duties for vehicle drivers, for example buses, trains, plane or boat drivers or pilots, for the transportation of passengers or goods. This is a complex problem because it involves several constraints related to labour and company rules and can also present different evaluation criteria and objectives. Being able to develop an adequate model for this problem that can represent the real problem as close as possible is an important research area.The main objective of this research work is to present new mathematical models to the DSP problem that represent all the complexity of the drivers scheduling problem, and also demonstrate that the solutions of these models can be easily implemented in real situations. This issue has been recognized by several authors and as important problem in Public Transportation. The most well-known and general formulation for the DSP is a Set Partition/Set Covering Model (SPP/SCP). However, to a large extend these models simplify some of the specific business aspects and issues of real problems. This makes it difficult to use these models as automatic planning systems because the schedules obtained must be modified manually to be implemented in real situations. Based on extensive passenger transportation experience in bus companies in Portugal, we propose new alternative models to formulate the DSP problem. These models are also based on Set Partitioning/Covering Models; however, they take into account the bus operator issues and the perspective opinions and environment of the user.We follow the steps of the Operations Research Methodology which consist of: Identify the Problem; Understand the System; Formulate a Mathematical Model; Verify the Model; Select the Best Alternative; Present the Results of theAnalysis and Implement and Evaluate. All the processes are done with close participation and involvement of the final users from different transportation companies. The planner s opinion and main criticisms are used to improve the proposed model in a continuous enrichment process. The final objective is to have a model that can be incorporated into an information system to be used as an automatic tool to produce driver schedules. Therefore, the criteria for evaluating the models is the capacity to generate real and useful schedules that can be implemented without many manual adjustments or modifications. We have considered the following as measures of the quality of the model: simplicity, solution quality and applicability. We tested the alternative models with a set of real data obtained from several different transportation companies and analyzed the optimal schedules obtained with respect to the applicability of the solution to the real situation. To do this, the schedules were analyzed by the planners to determine their quality and applicability. The main result of this work is the proposition of new mathematical models for the DSP that better represent the realities of the passenger transportation operators and lead to better schedules that can be implemented directly in real situations.