Disseny i implementació d'una base de dades relacional per a una empresa de selecció de personal

Base de dades realitzada en Oracle per controlar i ajustar les ofertes de de treball que es reben de les empreses i les demandes de feina i currículums que presenten els treballadors. Tot l'accés a les dades es realitza mitjançant procediments emmagatzemats.

Bases de datos : Empresa de selección de personal

Este documento refleja el trabajo realizado durante el diseño e implementación de una base de datos relacional y un almacén de datos para una empresa de gestión de personal.

Disseny i implementació d'una base de dades relacional per a una empresa de selecció de personal

Una empresa de selecció de personal vol incorporar un sistema per controlar i ajustar les ofertes de feina que rep de les empreses i les demandes de feina i currículums que presenten els treballadors.

An anonymous reputation mechanism for cloud computing networks using volunteer resources

One of the major problems when using non-dedicated volunteer resources in adistributed network is the high volatility of these hosts since they can go offlineor become unavailable at any time without control. Furthermore, the use ofvolunteer resources implies some security issues due to the fact that they aregenerally anonymous entities which we know nothing about. So, how to trustin someone we do not know?.Over the last years an important number of reputation-based trust solutionshave been designed to evaluate the participants' behavior in a system.However, most of these solutions are addressed to P2P and ad-hoc mobilenetworks that may not fit well with other kinds of distributed systems thatcould take advantage of volunteer resources as recent cloud computinginfrastructures.In this paper we propose a first approach to design an anonymous reputationmechanism for CoDeS [1], a middleware for building fogs where deployingservices using volunteer resources. The participants are reputation clients(RC), a reputation authority (RA) and a certification authority (CA). Users needa valid public key certificate from the CA to register to the RA and obtain thedata needed to participate into the system, as now an opaque identifier thatwe call here pseudonym and an initial reputation value that users provide toother users when interacting together. The mechanism prevents not only themanipulation of the provided reputation values but also any disclosure of theusers' identities to any other users or authorities so the anonymity isguaranteed.

Do labour mobility and networks foster geographical knowledge diffusion? The case of European regions

The goal of this paper is twofold: first, we aim to assess the role played by inventors’ cross-regional mobility and networks of collaboration in fostering knowledge diffusion across regions and subsequent innovation. Second, we intend to evaluate the feasibility of using mobility and networks information to build cross-regional interaction matrices to be used within the spatial econometrics toolbox. To do so, we depart from a knowledge production function where regional innovation intensity is a function not only of the own regional innovation inputs but also external accessible R&D gained through interregional interactions. Differently from much of the previous literature, cross-section gravity models of mobility and networks are estimated to use the fitted values to build our ‘spatial’ weights matrices, which characterize the intensity of knowledge interactions across a panel of 269 regions covering most European countries over 6 years.

Medium access control messaging scheme for cognitive radio networks

Los sistemas de radio cognitivos son una solución a la deficiente distribución del espectro inalámbrico de frecuencias. Usando acceso dinámico al medio, los usuarios secundarios pueden comunicarse en canales de frecuencia disponibles, mientras los usuarios asignados no están usando dichos canales. Un buen sistema de mensajería de control es necesario para que los usuarios secundarios no interfieran con los usuarios primarios en las redes de radio cognitivas. Para redes en donde los usuarios son heterogéneos en frecuencia, es decir, no poseen los mismos canales de frecuencia para comunicarse, el grupo de canales utilizado para transmitir información de control debe elegirse cuidadosamente. Por esta razón, en esta tesis se estudian las ideas básicas de los esquemas de mensajería de control usados en las redes de radio cognitivas y se presenta un esquema adecuado para un control adecuado para usuarios heterogéneos en canales de frecuencia. Para ello, primero se presenta una nueva taxonomía para clasificar las estrategias de mensajería de control, identificando las principales características que debe cumplir un esquema de control para sistemas heterogéneos en frecuencia. Luego, se revisan diversas técnicas matemáticas para escoger el mínimo número de canales por los cuales se transmite la información de control. Después, se introduce un modelo de un esquema de mensajería de control que use el mínimo número de canales y que utilice las características de los sistemas heterogéneos en frecuencia. Por último, se comparan diversos esquemas de mensajería de control en términos de la eficiencia de transmisión.

La valoració del coneixement de la llengua pròpia i del dret propi de Catalunya en la provisió de places del personal al servei de l’administració de justícia

La recerca proposa l’estudi del contingut i abast de les principals disposicions normatives que ordenen la valoració del coneixement de la llengua i el dret propis de Catalunya en la provisió de les places judicials. L’anàlisi de la tramitació parlamentària de les disposicions ha permès posar en context decisions del legislador, oferint instruments d’hermenèutica útils per resoldre debats interpretatius que avui es plantegen en seu doctrinal. La recerca inclou l’estudi dels efectes d’aquests textos normatius, en tant que permeten mesurar-ne la seva eficàcia i s’han de tenir en compte en el debat de les reformes que, eventualment, puguin desplegar-se. Des de la perspectiva d’anàlisi de les polítiques públiques, la recerca descriu les principals mesures formulades i implementades per les diferents Administracions Públiques, i molt especialment per la Generalitat de Catalunya, amb l’objectiu de corregir disfuncions que presenta aquest marc legal i reglamentari. La recerca ha posat en evidència que el règim jurídic que ordena l’aptitud lingüística i el coneixement del dret propi de Catalunya per part del personal judicial es caracteritza per la seva complexitat i falta de coherència. La valoració del coneixement de la llengua i el dret propis de la Comunitat Autònoma s’ha regulat molt tardament. Com a regla general, es valora com un mèrit en la provisió de la plaça, sotmès a més a intenses controvèrsies pel que fa a la determinació dels barems de puntuació concedits. En certs casos, com és el cos de Fiscals substituts, la valoració de la llengua i el dret propis de la Comunitat Autònoma ni tan sols es valora com un mèrit. Simplement no es té en compte. Pel que fa referència als secretaris judicials, la darrera reforma de la L.O. 6/1985 d’1 de juliol, del Poder Judicial, aprovada per L.O. 19/2003 de 23 de desembre, ha introduït el requisit de la capacitació lingüística per cobrir determinades places, per bé que el criteri general és el de la meritació puntuable. Altrament, en el cas del personal judicial depenent de la Generalitat s’ha garantit el requisit d’aptitud lingüística. D’aquesta manera, s’ha optat per assegurar un coneixement adequat i suficient de les dues llengües oficials, tant en l’expressió oral com en l’escrita, per a desenvolupar eficaçment les funcions pròpies del seu lloc de treball.

Object-oriented Bayesian networks for evaluating DIP-STR profiling results from unbalanced DNA mixtures.

The genetic characterization of unbalanced mixed stains remains an important area where improvement is imperative. In fact, with current methods for DNA analysis (Polymerase Chain Reaction with the SGM Plus™ multiplex kit), it is generally not possible to obtain a conventional autosomal DNA profile of the minor contributor if the ratio between the two contributors in a mixture is smaller than 1:10. This is a consequence of the fact that the major contributor's profile 'masks' that of the minor contributor. Besides known remedies to this problem, such as Y-STR analysis, a new compound genetic marker that consists of a Deletion/Insertion Polymorphism (DIP), linked to a Short Tandem Repeat (STR) polymorphism, has recently been developed and proposed elsewhere in literature [1]. The present paper reports on the derivation of an approach for the probabilistic evaluation of DIP-STR profiling results obtained from unbalanced DNA mixtures. The procedure is based on object-oriented Bayesian networks (OOBNs) and uses the likelihood ratio as an expression of the probative value. OOBNs are retained in this paper because they allow one to provide a clear description of the genotypic configuration observed for the mixed stain as well as for the various potential contributors (e.g., victim and suspect). These models also allow one to depict the assumed relevance relationships and perform the necessary probabilistic computations.

Integració i gestió dels marcatges laborals del personal d'empresa al sistema SAP R/3

L'objectiu d'aquest projecte és realitzar l'estudi i el disseny per a la corresponent implantació d'un sistema de control dels marcatges per fer el traspàs i poder-los gestionar amb SAP R/3 en un grup d'empreses.

Conocimiento de la ley y preparación del personal sanitario sobre el proceso asistencial de la muerte.

The aims of this study were to ascertain the perception that health professionals (doctors, nurses and nursing assistants) have about their preparation for the care of terminally ill patients and to determine their knowledge about palliative care legislation. This cross sectional study was performed at a hospital in Granada (Spain); we administered an ad hoc questionnaire. The results indicated that although most of the staff had worked with terminally ill patients, only half believed that they have been trained to care for them. A significant proportion stated that they did not know about the current palliative care legislation. Most professionals would question the withdrawal of therapies for the maintenance of life; most of them are also unaware of the mechanism for reporting on the completion of a Living Will, as well as a Plan for Palliative Care in Andalusia (Spain).

Adaptación y validación al español del cuestionario 4CornerSAT para la medida de la satisfacción profesional del personal médico de atención especializada.

BACKGROUND Satisfaction of physicians is a concern in the healthcare sector, and it requires a multi-dimensional questionnaire in Spanish which studies their high-order needs. The objectives of this study are to adapt the 4CornerSAT Questionnaire to measure career satisfaction of physicians and to evaluate its validity in our context. METHOD The 4CornerSAT Questionnaire was adapted into Spanish, validating it among physicians of hospitals in Andalusia, Spain. A confirmatory factor analysis (CFA) was performed to corroborate the a priori model, and it was evaluated the internal consistency and the construct validity through the Cronbach's alpha and the correlation between the scale and the global item, respectively. RESULTS The adapted questionnaire was administrated to 121 specialist physicians. The CFA corroborated the four dimensions of the questionnaire (χ2=114.64, df=94, p<0.07; χ2/df=1.22; RMSEA=0.04). The internal consistency obtained an α=0.92 and the correlation between the summed scale and the global item verified the construct validity (r=0.77; p<0.001). CONCLUSIONS The 4CornerSAT questionnaire was adapted to Spanish, identifying an adequate construct validity and internal consistency.

The combination of social and personal contexts affects dominance hierarchy development in shore crabs, Carcinus maenas

Many animals that live in groups maintain competitive relationships, yet avoid continual fighting, by forming dominance hierarchies. We compare predictions of stochastic, individual-based models with empirical experimental evidence using shore crabs to test competing hypotheses regarding hierarchy development. The models test (1) what information individuals use when deciding to fight or retreat, (2) how past experience affects current resource-holding potential, and (3) how individuals deal with changes to the social environment. First, we conclude that crabs assess only their own state and not their opponent's when deciding to fight or retreat. Second, willingness to enter, and performance in, aggressive contests are influenced by previous contest outcomes. Winning increases the likelihood of both fighting and winning future interactions, while losing has the opposite effect. Third, when groups with established dominance hierarchies dissolve and new groups form, individuals reassess their ranks, showing no memory of previous rank or group affiliation. With every change in group composition, individuals fight for their new ranks. This iterative process carries over as groups dissolve and form, which has important implications for the relationship between ability and hierarchy rank. We conclude that dominance hierarchies emerge through an interaction of individual and social factors, and discuss these findings in terms of an underlying mechanism. Overall, our results are consistent with crabs using a cumulative assessment strategy iterated across changes in group composition, in which aggression is constrained by an absolute threshold in energy spent and damage received while fighting.