721 research outputs found
Database desing tool
La aplicación DataBase Design Tool es una herramienta para el diseño gráfico de bases de
datos relacionales.
El objetivo de la misma es facilitar el diseño de bases de datos relacionales de una forma
visual y simple para completar el aprendizaje en asignaturas que lo requieran o realizarlo de
forma particular.
Dado que la herramienta está orientada a entornos académicos, tiene una implementación
multiplataforma que permite ejecutarla tanto en sistemas Windows como en distribuciones
GNU/Linux (Debian y Ubuntu).
Al poseer un interfaz gráfico, similar al expuesto en la mayor parte de la bibliografía de uso
común, evita la complejidad del desarrollo sobre papel de diagramas que pueden llevar a
equívocos o errores, y permite la corrección de dichos esquemas. De la misma forma, el
profesor puede desempeñar su función de una forma más cómoda proponiendo soluciones o
corrigiendo ejercicios de una manera clara y eficaz.
La aplicación, además de permitir diseñar y comprobar un esquema, realiza la tarea de
generar del script en lenguaje SQL para la creación de la base de datos física diseñada. Dicho
proceso es automático y simplifica tanto el tiempo como la complejidad de un diseño teórico
llevado a la práctica.
El objetivo principal de la herramienta es su uso y desempeño con fines docentes,
proporcionando una gran ayuda tanto para enseñar como para aprender la teoría de las bases
de datos.
[ABSTRACT]
The application DataBase Design Tool is a tool for graphic design of relational databases.
Its purpose is to facilitate the design of relational databases in a simple and visual form to
complete the learning in subjects that require it or to do it on your own.
Having in mind that the tool is aimed to an academic environment, it has a multi-platform
implementation, that make possible to use it whether in Windows systems or in GNU/Linux
distributions (Debian and Ubuntu)
By having a graphical interface, similar to the one described in the most commonly used
literature, it avoids the complexity of development on paper charts that can lead to
misunderstandings or mistakes, and allows the verification of the correctness of such
schemes. In the same way, the teacher can perform his function in a more comfortable way
proposing solutions or correcting exercises in a clear and effective way.
The application, in addition to make possible to design and test a scheme, performs the task of
generating a SQL language script for the creation of the physical database designed. This
process is automatic and simplifies both time and complexity of a theoretical design
implemented in practice.
The main purpose of the tool is its use and performance for teaching purposes, in order to help
either the teaching or the learning of databases theory
A nationwide study of chronic pain prevalence in the general Spanish population, identifying clinical subgroups through cluster analysis.
Objective. This study aims to assess the prevalence
of chronic pain, its characteristics, and its
impact on the general Spanish population. Also,
to establish chronic pain patient subgroups according
to the characteristics of pain and to identify
variables specifically associated with each subgroup.
Design. Telephone-based, cross-sectional nationwide
study.
Subjects. A sample of 1,957 individuals representative
of the Spanish population.
Methods. Data were collected through telephone
interviews. A subject was considered to have
chronic pain if they had suffered pain (at least 4 days
a week) during the last 3 months. The subjects were
divided into two subgroups through a cluster analysis,
and a regression model was established to
determine the variables most specifically associated
with these subgroups.
Results. The prevalence of chronic pain was 16.6%
(95% confidence interval: 14.9–18.3) and among
these subjects, more than 50% referred to limitations
in their daily activities, 30% felt sad and/or
anxious, and 47.2% indicated that their pain was
affecting their family life. Two subgroups of subjects
with pain were identified: 1) characterized by generalized
pain in more than one location and of a long
evolution (150 months); and 2) characterized by pain
localized to only one site with a shorter duration
(100 months). Individuals who felt anxious because
of their pain and those who considered that their
pain was affecting their family were more likely to
belong to group 1.
Conclusions. Pain affects an important proportion
of the Spanish adult population and that it has a
strong personal impact. Two pain groups were
clearly distinguished by their clinical characteristics
Tecnología de las comunicaciones móviles
Las comunicaciones móviles es, claramente, uno de los campos de las telecomunicaciones donde estamos viviendo, día a día, un mayor desarrollo y cambio. El Área de Teoría de la Señal y Comunicaciones de la Universidad Miguel Hernández no se puede mostrar insensible a tales acontecimientos, y prueba de ello es la presente publicación. Con ella se pretende ofrecer al lector una completa visión de diferentes aspectos, como puede comprobar consultando el índice de la misma. Pretende ser un buen complemento a las explicaciones de clase de la asignatura “Tecnología de las comunicaciones móviles”, para la que está especialmente ideado. Se ha tratado de completar el libro “Introducción a las comunicaciones móviles” con las tecnologías de las comunicaciones móviles optimizadas para datos, y por tanto, orientadas a conmutación de paquetes. En el primer capítulo se da una breve introducción a WAP, pasando, después, en el capítulo 2 a describir más en profundidad GPRS o generación 2,5 de la telefonía móvil en Europa. El capítulo 3, nos introduce en la técnica de acceso múltiple por división de código, CDMA, para facilitarnos la mejor comprensión de los capítulos siguientes. En UMTS o tercera generación, (capítulo 4) nos paramos con más detalle, por ser la tecnología que se pretende revolucione el futuro. Por último, los capítulos 5 y 6 dan una iniciación a otras tecnologías, que aunque con cierta incertidumbre, interactuarán con las redes móviles en el entorno privado, como son las redes inalámbricas, WLAN, y Bluetooth
Introducción a las comunicaciones móviles
Las comunicaciones móviles es claramente uno de los campos de las telecomunicaciones donde estamos viviendo día a día un mayor desarrollo y cambio. El Área de Teoría de la Señal y Comunicaciones de la Universidad Miguel Hernández no se puede mostrar insensible a tales acontecimientos, y prueba de ello es la presente publicación. Con ella se pretende ofrecer al lector una completa visión de diferentes aspectos, como puede comprobar consultando el índice de la misma. Pretende ser un buen complemento a las explicaciones de clase de la asignatura “Introducción a las comunicaciones móviles”, para la que está especialmente ideado. Se ha tratado de dar un repaso a la evolución de las comunicaciones móviles, centrándonos especialmente en la comunicación de voz. En el primer capítulo se repasan temas básicos y comunes a este tipo de comunicaciones, pasando después en el capítulo 2 a describir brevemente las tecnologías analógicas. En GSM (capítulo 3) nos paramos con más detalle, por ser la tecnología predominante actualmente. Los capítulos 4 y 5 pretenden dar una iniciación a otras tecnologías presentes en el panorama actual como son las comunicaciones móviles por satélite y las comunicaciones inalámbricas. Por último, hemos considerado importante no finalizar la publicación sin dar un repaso en el capítulo 6 a la normativa española y europea en estos temas. Dejamos para una segunda publicación las tecnologías centradas en la transmisión de datos que utilizan conmutación de paquetes (GPRS y UMTS)
Prototipo brazo robótico.
La Inteligencia Artificial (IA) es la rama de las ciencias de la computación que se ocupa de
construir sistemas que permitan exhibir un comportamiento cada vez más inteligente. Un brazo robótico es un tipo de brazo mecánico, normalmente programable, con funciones
parecidas a las de un brazo humano; este puede ser la suma total del mecanismo o puede ser parte de un robot más complejo. Las partes de estos manipuladores o brazos son interconectadas a través de articulaciones que permiten, tanto un movimiento rotacional, como un movimiento transnacional o desplazamiento lineal.
El efector final, o mano robótica, se puede diseñar para realizar cualquier tarea que se desee como puede ser soldar, sujetar, girar, etc., dependiendo de la aplicación. En algunas circunstancias, lo que se busca es una simulación de la mano humana, como en los robots usados en tareas de desactivación de explosivo
La comunidad SIG- MERCATOR de la Consejería de Salud
La Web 2.0 ha supuesto un cambio importante en Internet al pasar el usuario de mero consumidor de contenidos
a generarlos en un espacio de colaboración e intercambio. En el seno de una organización, el conocimiento
corporativo producido debe estar disponible en cualquier momento, por cualquier empleado y desde cualquier parte.
El Entorno Colaborativo de Trabajo (ECT) de la Consejería de Salud proporciona herramientas de trabajo diario e
incorpora elementos de la Web 2.0.
El ECT está basado en el sistema de gestión de portales Liferay, con arquitectura web J2EE multiplataforma, y
portlets JSR 168.
Ofrece servicios de acceso a información (noticias, anuncios, documentación, directorios etc), comunicación,
colaboración y participación activa (foros, chat, wikis, blogs, encuestas, etc) y herramientas operativas (gestión de
reuniones, agendas, acceso a sistemas de información, etc.)
La base organizativa son las comunidades. Una de ellas es la comunidad SIG-Mercator compuesta actualmente
por 23 usuarios de la propia Consejería y de otros organismos, con un interés común sobre Sistemas de Información
Geográfica (SIG) y que comparten un espacio con información y herramientas de colaboración propias.
Los objetivos de esta comunidad son gestionar el conocimiento y fomentar debates con herramientas como el
blog y los foros, compartir documentación y elaborar de forma colaborativa mediante wikis documentos de
referencia, y difundir las actividades del Plan Cartográfico así como las novedades sobre aspectos tecnológicos de
los SIG.
Un factor clave en la comunidad son las sesiones presenciales, con periodicidad mensual, además de las propias
actividades virtuales.ABSTRACT
The Website 2.0 represents a dramatic change in internet. The user has became a content provider and not just a
consumer. Within an organisation, the corporate knowledge produced should be available at any time, for any
employee and from any part. The Collaborative Work Environment (CWE) of the Regional Ministry of Health provides
with tools for the daily work and adds some elements of the Website 2.0.
CWE is based on Liferay, with multi-platform J2EE website architecture and portlets JSR 168.
It offers services of access to information (news, announcements, documentation, directories, etc.), active
communication, cooperation and involvement (forums, chat, wikis, blogs, surveys …) and operational tools (meetings
management, agendas, access to information systems, etc.)
Communities are the organizational base. One of them is the community GIS-Mercator, composed currently by 23
users from the Regional Ministry of Health and other organisations, with a shared interest on GIS and sharing
information and collaboration tools.
The aims of this community are to manage the knowledge and to promote discussions with tools as forums and
blogs, to share documentation and to elaborate reference documents in a collaborative way via wikis, and to
disseminate the activities of the Mapping Plan so as the news on technological aspects of the GIS.
In addition to the own virtual activities, the monthly face-to-face meetings are a key factor in the community
Hydrogen-powered refrigeration system for environmentally friendly transport and delivery in the food supply chain
Urban population and the trend towards online commerce leads to an increase in delivery solution in cities. The
growth of the transport sector is very harmful to the environment, being responsible for approximately 40% of
greenhouse gas emissions in the European Union. The problem is aggravated when transporting perishable
foodstuffs, as the vehicle propulsion engine (VPE) must power not only the vehicle but also the refrigeration unit.
This means that the VPE must be running continuously, both on the road and stationary (during delivery), as the
cold chain must be preserved. The result is costly (high fuel consumption) and harmful to the environment. At
present, refrigerated transport does not support full-electric solutions, due to the high energy consumption
required, which motivates the work presented in this article. It presents a turnkey solution of a hydrogenpowered
refrigeration system (HPRS) to be integrated into standard light trucks and vans for short-distance
food transport and delivery. The proposed solution combines an air-cooled polymer electrolyte membrane fuel
cell (PEMFC), a lithium-ion battery and low-weight pressurised hydrogen cylinders to minimise cost and increase
autonomy and energy density. In addition, for its implementation and integration, all the acquisition, power and
control electronics necessary for its correct management have been developed. Similarly, an energy management
system (EMS) has been developed to ensure continuity and safety in the operation of the electrical system during
the working day, while maximizing both the available output power and lifetime of the PEMFC. Experimental
results on a real refrigerated light truck provide more than 4 h of autonomy in intensive intercity driving profiles,
which can be increased, if necessary, by simply increasing the pressure of the stored hydrogen from the current
200 bar to whatever is required. The correct operation of the entire HPRS has been experimentally validated in
terms of functionality, autonomy and safety; with fuel savings of more than 10% and more than 3650 kg of CO2/
year avoided.This work is a contribution of the two following Projects: “H2Integration& Control. Integration and Control of a hydrogen-based pilot plant in residential applications for energy supply”, Ref. PID2020-116616RB-C31 supported by the Spanish State Program of R + D + I Oriented to the Challenges of Society; and “SALTES: Smartgrid with reconfigurable Architecture for testing controL Techniques and Energy Storage priority contaminant waste”, Ref. P20-00730 supported by
Andalusian Regional Program of R + D + I. Funding for open access charge: Universidad de Huelva/CBUA
Urinary bladder sigma-1 receptors: A new target for cystitis treatment
Supplementary material related to this article can be found, in the
online version, at doi:https://doi.org/10.1016/j.phrs.2020.104724.No adequate treatment is available for painful urinary bladder disorders such as interstitial cystitis/bladder pain
syndrome, and the identification of new urological therapeutic targets is an unmet need. The sigma-1 receptor
(σ1-R) modulates somatic pain, but its role in painful urological disorders is unexplored. The urothelium expresses many receptors typical of primary sensory neurons (e.g. TRPV1, TRPA1 and P2X3) and high levels of σ1-
R have been found in these neurons; we therefore hypothesized that σ1-R may also be expressed in the urothelium and may have functional relevance in this tissue. With western blotting and immunohistochemical
methods, we detected σ1-R in the urinary bladder in wild-type (WT) but not in σ1-R-knockout (σ1-KO) mice.
Interestingly, σ1-R was located in the bladder urothelium not only in mouse, but also in human bladder sections.
The severity of histopathological (edema, hemorrhage and urothelial desquamation) and biochemical alterations
(enhanced myeloperoxidase activity and phosphorylation of extracellular regulated kinases 1/2 [pERK1/2]) that
characterize cyclophosphamide-induced cystitis was lower in σ1-KO than in WT mice. Moreover, cyclophosphamide-induced pain behaviors and referred mechanical hyperalgesia were dose-dependently reduced by σ1-R
antagonists (BD-1063, NE-100 and S1RA) in WT but not in σ1-KO mice. In contrast, the analgesic effect of
morphine was greater in σ1-KO than in WT mice. Together these findings suggest that σ1-R plays a functional role
in the mechanisms underlying cyclophosphamide-induced cystitis, and modulates morphine analgesia against
urological pain. Therefore, σ1-R may represent a new drug target for urinary bladder disorders.Spanish Ministry of Economy and Competitiveness (MINECO)
SAF2016-80540-REuropean Regional Development Funds (ERDF), Junta de Andalucia grant
CTS 109Esteve PharmaceuticalsInnovative Medicines Initiative 2 Joint Undertaking
777500European Union's Horizon 2020 research and innovation programmeEFPI
Development of an ultrasonic dry-coupling inspection wheel for Online NDI composite application
8 páginas, 5 figuras. 6th International Symposium on NDT in Aerospace, 12-14th November 2014, Madrid, SpainT he application of ultrasonic waves to the inspection of aeronautic compone
nts is based on the use of couplants
(water, gel, etc...) to facilitate the propagation of the sensi
ng wave through the material. Although several
solutions have been designed to integrate the use of these couplants and the
NDT operations in different stages
of component life (from production to in-service operation) its use incre
ases the complexity of the process and
the cost of the inspection because in some cases special infrastr
uctures may become necessary.
Some of the research effort developed in the last decades has been a
ddressed to reduce the necessity of couplant
gel or fluids. In this sense, the development of ultrasonic inspection w
heels based on special rubbers with a high
degree of humidity has been proposed and is being commercialized nowadays. How
ever, its use is not allowed in
applications where the condition of completely dry coupling is imperative.
Other tools based on air-coupling
have been also developed but they mainly operate in through transmission arrange
ments and its use is limited to
low frequencies.
T his work examines a new wheel-based tool which can operate in dry condit
ion . It has been developed in the
context of the ICARO Project (Innovación en Composites Avanzados y Rear-
End Optimizado) to provide a
nondestructive inspection solution to be integrated into an Out of Autoclave (
OoA) composite manufacturing
process based on electron beam curing technology layer by layer. T he solution
requires be able to inspect very
thin composite specimens (from 0.5mm) in clean and dry conditions compatibl
e with the manufacturing process.
T o overcome these conditions, a special inspection wheel prototype has bee
n developed that integrates a 5MHz
ultrasonic array transducer composed by 128 elements mounted in a particula
r wedge. T his aperture operates in
pulse-echo and generates an ultrasonic image based on linear scanning beam
forming process and a synthetic
aperture acquisition procedure known as 2R-SAFT .
Inspection results obtained from reference standard of different thic
kness are presented. T hese results are
compared with conventional immersion UT inspections and show the high potentia
l of this inspection wheel for
this special applications.Peer reviewe
- …