Creació d'un Sistema d'Informació Geogrà fic per a la consulta i gestió de la base de vèrtexs geodèsics de Catalunya amb Geomedia PRO 6.0©

L'objectiu és realitzar una explicació dels passos i les tasques realitzades per a la construcció d'un Sistema d'Informació Geogràfica (SIG) que permeti la gestió de vèrtex geodèsics de Catalunya i la implementació de l'algorisme de Delaunay sobre un conjunt de vèrtex seleccionats.

Construcció d'un SIG i sincronització de les etiquetes amb els objectes representats a GEOMEDIA PROFESSIONAL 5.2

En aquest treball de fi de carrera s'estudia en què consisteix en SIG i les seves característiques, en concret es realitza l'estudi d'un SIG comercial, GEOMEDIA PROFESSIONAL 5.2 D'aquest producte es presenta el problema de sincronització de les etiquetes amb les entitats que etiqueten, i es planteja una solució a aquest problema, mitjançant el desenvolupament d'una aplicació implementada amb MICROSOFT VISUAL BASIC 6.0

Restaural, sistema de gestió de comandes per restaurants

El projecte consisteix en un sistema informatitzat per restaurantscentralitzat en un servidor que permet recollir comandes als clients a través dePDA’s i de pantalles tàctils situades a la barra per enviar-les als corresponentsllocs d’ elaboració: -Terminal de la cuina on s’elaboraran tots els menjars.-Terminal de la bodega on es serviran els vins i caves.-Terminal barra on es serviran els licors, refrescos (entre d’altresproductes totalment configurables).-Terminal de postres on es reben les línies de comanda relacionadesamb els postres.L’objectiu acadèmic del projecte serà adquirir coneixement a nivell dedisseny i gestió de dades, així com la comunicació de diversos dispositius entemps real. S’utilitzarà la tecnologia .net, concretament el llenguatge deprogramació visual c# .net. i com a gestor de bases de dades el mysql 5.0.19.A més, es treballa amb la metodologia UML, utilitzant també diversos patrons. Per fer del sistema un sistema centralitzat en un servidor s’utilitzarà lacomunicació per terminal service de windows el qual ens brinda la possibilitat d’establir diverses sessions d’usuaris concurrents. Cada sessió estarà destinadaa un cambrer, per tant, hi haurà una sessió per PDA

Mòdul de gestió de magatzems segons el model d'organització física de "magatzem caòtic"

Creació d'una 'aplicació de gestió comercial i comptable partint de la ja existent en l’empresa Ph Systems S.L., seguint per tant la tecnologia utilitzada en aquesta aplicació, desenvolupada en Visual Basic 6 i utilitzant uns objectes i llibreries propis per facilitat l’enllaç dels formularis amb les taules de la base de dades utilitzant tant connexions ODBC com connexions OLE DB. El gestor de base de dades seleccionat per realitzar el projecte serà Oracle, que és el que actualment s’utilitza per les dades de l’aplicació de gestió d’estocs. Tasques a realitzar:Anàlisi dels requeriments del sistema.Disseny dels diferents mòduls de la futura aplicació.Obtenir una base de dades ben definida partint de la ja existent.Implementació dels mòduls de la futura aplicació.Els objectius d’aprenentatge d’aquest projecte són els següents:Millora del coneixement de la gestió d’una base de dades OracleMillora en l’aprenentatge del llenguatge de programació Visual Basic 6

Pà gina Web gestió protectora d'animals

Aplicació Web amb ASP visual studio 2010 i Visual C# , Microsoft SQL Server i AJAX.

La Cooperació territorial de les regions. L’experiència de Catalunya

L’EPM s’inscriu en el context de les estratègies de la cooperació interterritorial impulsades a Catalunya des de l’adhesió d’Espanya a la UE. L’activisme europeu de les institucions catalanes va començar a manifestar-se cap a finals dels anys vuitanta, arran de la posada en marxa del Mercat Únic de 1993, amb un conjunt d’iniciatives tendents a fomentar fórmules innovadores de cooperació transregional - és a dir, desproveïdes de continuïtat territorial – i transfronterera amb altres comunitats regionals i locals. Els Quatre Motors per a Europa i Eurociutats corresponen al primer model, mentre que l’antiga Euroregió Mediterrània formada per Catalunya, Llenguadoc-Rosselló i Migdia-Pirineus, i la Comunitat de Treball dels Pirineus encarnen el segon. La xarxa C-6 i les dues experiències més actuals, l’Arc Llatí i l’Euroregió Pirineus-Mediterrània, combinen elements d’ambdós models.

Effectiveness of a drug dosing service provided by community pharmacists in polymedicated elderly patients with renal impairment a comparative study

Background: Drug dosing errors are common in renal-impaired patients. Appropriate dosing adjustment and drug selection is important to ensure patients" safety and to avoid adverse drug effects and poor outcomes. There are few studies on this issue in community pharmacies. The aims of this study were, firstly, to determine the prevalence of dosing inadequacy as a consequence of renal impairment in patients over 65 taking 3 or more drug products who were being attended in community pharmacies and, secondly, to evaluate the effectiveness of the community pharmacist"s intervention in improving dosing inadequacy in these patients when compared with usual care. Methods: The study was carried out in 40 Spanish community pharmacies. The study had two phases: the first, with an observational, multicentre, cross sectional design, served to determine the dosing inadequacy, the drug-related problems per patient and to obtain the control group. The second phase, with a controlled study with historical control group, was the intervention phase. When dosing adjustments were needed, the pharmacists made recommendations to the physicians. A comparison was made between the control and the intervention group regarding the prevalence of drug dosing inadequacy and the mean number of drug-related problems per patient. Results: The mean of the prevalence of drug dosing inadequacy was 17.5% [95% CI 14.6-21.5] in phase 1 and 15.5% [95% CI 14.5-16.6] in phase 2. The mean number of drug-related problems per patient was 0.7 [95% CI 0.5-0.8] in phase 1 and 0.50 [95% CI 0.4-0.6] in phase 2. The difference in the prevalence of dosing inadequacy between the control and intervention group before the pharmacists" intervention was 0.73% [95% CI (−6.0) - 7.5] and after the pharmacists" intervention it was 13.5% [95% CI 8.0 - 19.5] (p < 0.001) while the difference in the mean of drug-related problems per patient before the pharmacists" intervention was 0.05 [95% CI( -0.2) - 0.3] and following the intervention it was 0.5 [95% CI 0.3 - 0.7] (p < 0.001). Conclusion: A drug dosing adjustment service for elderly patients with renal impairment in community pharmacies can increase the proportion of adequate drug dosing, and improve the drug-related problems per patient. Collaborative practice with physicians can improve these results.

Optical response of Cu3Ge thin films

We report an investigation on the optical properties of Cu3Ge thin films displaying very high conductivity, with thickness ranging from 200 to 2000 Ã…, deposited on Ge substrates. Reflectance, transmittance, and ellipsometric spectroscopy measurements were performed at room temperature in the 0.01-6.0, 0.01-0.6, and 1.4-5.0 eV energy range, respectively. The complex dielectric function, the optical conductivity, the energy-loss function, and the effective charge density were obtained over the whole spectral range. The low-energy free-carrier response was well fitted by using the classical Drude-Lorentz dielectric function. A simple two-band model allowed the resulting optical parameters to be interpreted coherently with those previously obtained from transport measurements, hence yielding the densities and the effective masses of electrons and holes.

Electronic structure and properties of Cu2O

The structural and electronic properties of Cu2O have been investigated using the periodic Hartree-Fock method and a posteriori density-functional corrections. The lattice parameter, bulk modulus, and elastic constants have been calculated. The electronic structure of and bonding in Cu2O are analyzed and compared with x-ray photoelectron spectroscopy spectra, showing a good agreement for the valence-band states. To check the quality of the calculated electron density, static structure factors and Compton profiles have been calculated, showing a good agreement with the available experimental data. The effective electron and hole masses have been evaluated for Cu2O at the center of the Brillouin zone. The calculated interaction energy between the two interpenetrated frameworks in the cuprite structure is estimated to be around -6.0 kcal/mol per Cu2O formula. The bonding between the two independent frameworks has been analyzed using a bimolecular model and the results indicate an important role of d10-d10 type interactions between copper atoms.

Magnetic properties and giant magnetoresistance in melt-spun CoCu alloys

Magnetic, structural, and transport properties of as quenched and annealed Co10Cu90 samples have been investigated using x¿ray diffraction and a SQUID magnetometer. The largest value of MR change was observed for the as¿quenched sample annealed at 450°C for 30 min. The magnetic and transport properties closely correlate with the microstructure, mainly with Co magnetic particle size and its distribution. For thermal annealing the as quenched samples below 600°C, the Co particle diameters increase from 4.0 to 6.0 nm with a magnetoresistance (MR) drop from 33.0% to 5.0% at 10 K. Comparison with the theory indicates that the interfacial electron spin¿dependent scattering mechanism correlates with GMR for Co particle diameters up to about 6.0 nm.

Electronic structure and properties of Cu2O

The structural and electronic properties of Cu2O have been investigated using the periodic Hartree-Fock method and a posteriori density-functional corrections. The lattice parameter, bulk modulus, and elastic constants have been calculated. The electronic structure of and bonding in Cu2O are analyzed and compared with x-ray photoelectron spectroscopy spectra, showing a good agreement for the valence-band states. To check the quality of the calculated electron density, static structure factors and Compton profiles have been calculated, showing a good agreement with the available experimental data. The effective electron and hole masses have been evaluated for Cu2O at the center of the Brillouin zone. The calculated interaction energy between the two interpenetrated frameworks in the cuprite structure is estimated to be around -6.0 kcal/mol per Cu2O formula. The bonding between the two independent frameworks has been analyzed using a bimolecular model and the results indicate an important role of d10-d10 type interactions between copper atoms.

Is the 23-valent pneumococcal polysaccharide vaccine useful in preventing community-acquired pneumonia?

Although bacteremic pneumococcal pneumonia is the most severe form of pneumonia, non-bacteremic forms are much more frequent. Laboratory methods for the diagnosis of nonbacteremic pneumococcal pneumonia have a low sensitivity and specificity, and therefore all-cause pneumonia has been proposed as a suitable outcome to evaluate vaccination effectiveness. This work reviews the epidemiology of community-acquired pneumonia (CAP) and evaluates the effectiveness of the 3-valent pneumococcal polysaccharide vaccine (PPV-23) in preventing CAP requiring hospitalization in people aged ≥65 years. We performed a case-control study in patients aged ≥65 years admitted through the emergency department who presented with clinical signs and symptoms compatible with pneumonia. Weincluded 489 cases and 1,467 controls and it was obtained a vaccine efectiveness of 23.6 (0.9-41.0). Our results suggest that PPV-23 vaccination is effective and reduces hospital admissions due to pneumonia in the elderly, strengthening the rationale for vaccination programmes in this age group.

Effectiveness of a drug dosing service provided by community pharmacists in polymedicated elderly patients with renal impairment a comparative study

Background: Drug dosing errors are common in renal-impaired patients. Appropriate dosing adjustment and drug selection is important to ensure patients" safety and to avoid adverse drug effects and poor outcomes. There are few studies on this issue in community pharmacies. The aims of this study were, firstly, to determine the prevalence of dosing inadequacy as a consequence of renal impairment in patients over 65 taking 3 or more drug products who were being attended in community pharmacies and, secondly, to evaluate the effectiveness of the community pharmacist"s intervention in improving dosing inadequacy in these patients when compared with usual care. Methods: The study was carried out in 40 Spanish community pharmacies. The study had two phases: the first, with an observational, multicentre, cross sectional design, served to determine the dosing inadequacy, the drug-related problems per patient and to obtain the control group. The second phase, with a controlled study with historical control group, was the intervention phase. When dosing adjustments were needed, the pharmacists made recommendations to the physicians. A comparison was made between the control and the intervention group regarding the prevalence of drug dosing inadequacy and the mean number of drug-related problems per patient. Results: The mean of the prevalence of drug dosing inadequacy was 17.5% [95% CI 14.6-21.5] in phase 1 and 15.5% [95% CI 14.5-16.6] in phase 2. The mean number of drug-related problems per patient was 0.7 [95% CI 0.5-0.8] in phase 1 and 0.50 [95% CI 0.4-0.6] in phase 2. The difference in the prevalence of dosing inadequacy between the control and intervention group before the pharmacists" intervention was 0.73% [95% CI (−6.0) - 7.5] and after the pharmacists" intervention it was 13.5% [95% CI 8.0 - 19.5] (p < 0.001) while the difference in the mean of drug-related problems per patient before the pharmacists" intervention was 0.05 [95% CI( -0.2) - 0.3] and following the intervention it was 0.5 [95% CI 0.3 - 0.7] (p < 0.001). Conclusion: A drug dosing adjustment service for elderly patients with renal impairment in community pharmacies can increase the proportion of adequate drug dosing, and improve the drug-related problems per patient. Collaborative practice with physicians can improve these results.

Effectiveness of a drug dosing service provided by community pharmacists in polymedicated elderly patients with renal impairment a comparative study

Background: Drug dosing errors are common in renal-impaired patients. Appropriate dosing adjustment and drug selection is important to ensure patients" safety and to avoid adverse drug effects and poor outcomes. There are few studies on this issue in community pharmacies. The aims of this study were, firstly, to determine the prevalence of dosing inadequacy as a consequence of renal impairment in patients over 65 taking 3 or more drug products who were being attended in community pharmacies and, secondly, to evaluate the effectiveness of the community pharmacist"s intervention in improving dosing inadequacy in these patients when compared with usual care. Methods: The study was carried out in 40 Spanish community pharmacies. The study had two phases: the first, with an observational, multicentre, cross sectional design, served to determine the dosing inadequacy, the drug-related problems per patient and to obtain the control group. The second phase, with a controlled study with historical control group, was the intervention phase. When dosing adjustments were needed, the pharmacists made recommendations to the physicians. A comparison was made between the control and the intervention group regarding the prevalence of drug dosing inadequacy and the mean number of drug-related problems per patient. Results: The mean of the prevalence of drug dosing inadequacy was 17.5% [95% CI 14.6-21.5] in phase 1 and 15.5% [95% CI 14.5-16.6] in phase 2. The mean number of drug-related problems per patient was 0.7 [95% CI 0.5-0.8] in phase 1 and 0.50 [95% CI 0.4-0.6] in phase 2. The difference in the prevalence of dosing inadequacy between the control and intervention group before the pharmacists" intervention was 0.73% [95% CI (−6.0) - 7.5] and after the pharmacists" intervention it was 13.5% [95% CI 8.0 - 19.5] (p < 0.001) while the difference in the mean of drug-related problems per patient before the pharmacists" intervention was 0.05 [95% CI( -0.2) - 0.3] and following the intervention it was 0.5 [95% CI 0.3 - 0.7] (p < 0.001). Conclusion: A drug dosing adjustment service for elderly patients with renal impairment in community pharmacies can increase the proportion of adequate drug dosing, and improve the drug-related problems per patient. Collaborative practice with physicians can improve these results.

Molecular dating of caprines using ancient DNA sequences of Myotragus balearicus, an extinct endemic Balearic mammal

Background: Myotragus balearicus was an endemic bovid from the Balearic Islands (Western Mediterranean) that became extinct around 6,000-4,000 years ago. The Myotragus evolutionary lineage became isolated in the islands most probably at the end of the Messinian crisis, when the desiccation of the Mediterranean ended, in a geological date established at 5.35 Mya. Thus, the sequences of Myotragus could be very valuable for calibrating the mammalian mitochondrial DNA clock and, in particular, the tree of the Caprinae subfamily, to which Myotragus belongs. Results: We have retrieved the complete mitochondrial cytochrome b gene (1,143 base pairs), plus fragments of the mitochondrial 12S gene and the nuclear 28S rDNA multi-copy gene from a well preserved Myotragus subfossil bone. The best resolved phylogenetic trees, obtained with the cytochrome b gene, placed Myotragus in a position basal to the Ovis group. Using the calibration provided by the isolation of Balearic Islands, we calculated that the initial radiation of caprines can be dated at 6.2 ± 0.4 Mya. In addition, alpine and southern chamois, considered until recently the same species, split around 1.6 ± 0.3 Mya, indicating that the two chamois species have been separated much longer than previously thought. Conclusion: Since there are almost no extant endemic mammals in Mediterranean islands, the sequence of the extinct Balearic endemic Myotragus has been crucial for allowing us to use the Messinian crisis calibration point for dating the caprines phylogenetic tree.