An automatic correction tool for relational database schemas

A Web-based tool developed to automatically correct relational database schemas is presented. This tool has been integrated into a more general e-learning platform and is used to reinforce teaching and learning on database courses. This platform assigns to each student a set of database problems selected from a common repository. The student has to design a relational database schema and enter it into the system through a user friendly interface specifically designed for it. The correction tool corrects the design and shows detected errors. The student has the chance to correct them and send a new solution. These steps can be repeated as many times as required until a correct solution is obtained. Currently, this system is being used in different introductory database courses at the University of Girona with very promising results

Plan de marketing para el Dive Center Palamós específico para el mercado francés

Realització d’un pla de màrqueting i comercial de l’empresa Dive Center Palamós orientat específicament al mercat francès. L'autora tria aquest segment de clients per la seva proximitat a la Costa Brava i per la seva tradició de submarinisme

Database resources for the tuberculosis community.

Access to online repositories for genomic and associated "-omics" datasets is now an essential part of everyday research activity. It is important therefore that the Tuberculosis community is aware of the databases and tools available to them online, as well as for the database hosts to know what the needs of the research community are. One of the goals of the Tuberculosis Annotation Jamboree, held in Washington DC on March 7th-8th 2012, was therefore to provide an overview of the current status of three key Tuberculosis resources, TubercuList (tuberculist.epfl.ch), TB Database (www.tbdb.org), and Pathosystems Resource Integration Center (PATRIC, www.patricbrc.org). Here we summarize some key updates and upcoming features in TubercuList, and provide an overview of the PATRIC site and its online tools for pathogen RNA-Seq analysis.

Timetable database restructuring

Heriot-Watt University uses a software package called Syllabus Plus for its timetabling. This package can perform scheduling functions however it is currently employed only as a room booking system at present. In academic session 2008-2009 the university will be restructuring its academic year from 3 terms of 10 weeks to semesters of 14 weeks and therefore major changes will be required to the timetabling information. This project has two functions, both with practical and relevant applications to the timetabling of the university. The aims of the project are the ability to change population number of modules and activities, delete term 3 modules and activities, the ability to change module and activity name, and change the teaching week pattern from the semester

Signe et signification des discours de marketing : analyse critique des contributions sémiotiques en marketing

Alors que la sémiotique et ses propositions méthodologiques d'analyse des discours sont bien répandues dans les milieux scientifiques, son utilisation sur des signes issus du monde des entreprises reste pourtant très limitée par rapport à sa contribution potentielle à la description et à l'explication de problèmes de marketing. Il est dès lors intéressant de montrer - indépendamment des orientations prises par la sémiotique - quel est l'objet de sa recherche ? Quels sont les outils qu'elle a développés ? Et quels sont les discours de marketing sur lesquels ces outils ont été appliqués? Enfin, on se penchera sur les problèmes qui limitent un usage plus étendu des outils sémiotiques en marketing tout en précisant les perspectives de recherche.

Integrating forensic information in a crime intelligence database

Since 2008, Intelligence units of six states of the western part of Switzerland have been sharing a common database for the analysis of high volume crimes. On a daily basis, events reported to the police are analysed, filtered and classified to detect crime repetitions and interpret the crime environment. Several forensic outcomes are integrated in the system such as matches of traces with persons, and links between scenes detected by the comparison of forensic case data. Systematic procedures have been settled to integrate links assumed mainly through DNA profiles, shoemarks patterns and images. A statistical outlook on a retrospective dataset of series from 2009 to 2011 of the database informs for instance on the number of repetition detected or confirmed and increased by forensic case data. Time needed to obtain forensic intelligence in regard with the type of marks treated, is seen as a critical issue. Furthermore, the underlying integration process of forensic intelligence into the crime intelligence database raised several difficulties in regards of the acquisition of data and the models used in the forensic databases. Solutions found and adopted operational procedures are described and discussed. This process form the basis to many other researches aimed at developing forensic intelligence models.

Use of DNA profiles for investigation using a simulated national DNA database: Part II. Statistical and ethical considerations on familial searching.

Familial searching consists of searching for a full profile left at a crime scene in a National DNA Database (NDNAD). In this paper we are interested in the circumstance where no full match is returned, but a partial match is found between a database member's profile and the crime stain. Because close relatives share more of their DNA than unrelated persons, this partial match may indicate that the crime stain was left by a close relative of the person with whom the partial match was found. This approach has successfully solved important crimes in the UK and the USA. In a previous paper, a model, which takes into account substructure and siblings, was used to simulate a NDNAD. In this paper, we have used this model to test the usefulness of familial searching and offer guidelines for pre-assessment of the cases based on the likelihood ratio. Siblings of "persons" present in the simulated Swiss NDNAD were created. These profiles (N=10,000) were used as traces and were then compared to the whole database (N=100,000). The statistical results obtained show that the technique has great potential confirming the findings of previous studies. However, effectiveness of the technique is only one part of the story. Familial searching has juridical and ethical aspects that should not be ignored. In Switzerland for example, there are no specific guidelines to the legality or otherwise of familial searching. This article both presents statistical results, and addresses criminological and civil liberties aspects to take into account risks and benefits of familial searching.

Aménagement du lieu de vente : expertise des professionnels du marketing du sport et connaissance du comportement du consommateur

Cet article traite de la façon dont les professionnels du marketing des articles de sport procèdent pour optimiser l'influence du lieu de vente sur les comportements d'achat. Leurs expertises reposent sur une combinaison de données et d'expériences qui peut être rapprochée des démarches sociologiques. Leurs analyses des situations d'achat nous permettent de comprendre comment ils peuvent agir sur les comportements à travers les points de vente, en tentant de guider la perception des produits par le consommateur. Elles nous aident plus globalement à mieux appréhender les décisions des consommateurs. Abstract This paper focuses on how marketers of sporting goods proceed to optimize the influence of the store on purchasing behaviour. Their expertise is based on a combination of data and experiences that parallels the sociological methods. Their analysis of purchasing situations aloud to understand how they can influence behaviours through retailing places, while trying to guide consumers' perception of the products. More broadly, they contribute to a better understanding of consumer's decisions. Keywords: sports, retail, store, marketing, sociology.

The potential of the European network of congenital anomaly registers (EUROCAT) for drug safety surveillance: a descriptive study.

BACKGROUND: European Surveillance of Congenital Anomalies (EUROCAT) is a network of population-based congenital anomaly registries in Europe surveying more than 1 million births per year, or 25% of the births in the European Union. This paper describes the potential of the EUROCAT collaboration for pharmacoepidemiology and drug safety surveillance. METHODS: The 34 full members and 6 associate members of the EUROCAT network were sent a questionnaire about their data sources on drug exposure and on drug coding. Available data on drug exposure during the first trimester available in the central EUROCAT database for the years 1996-2000 was summarised for 15 out of 25 responding full members. RESULTS: Of the 40 registries, 29 returned questionnaires (25 full and 4 associate members). Four of these registries do not collect data on maternal drug use. Of the full members, 15 registries use the EUROCAT drug code, 4 use the international ATC drug code, 3 registries use another coding system and 7 use a combination of these coding systems. Obstetric records are the most frequently used sources of drug information for the registries, followed by interviews with the mother. Only one registry uses pharmacy data. Percentages of cases with drug exposure (excluding vitamins/minerals) varied from 4.4% to 26.0% among different registries. The categories of drugs recorded varied widely between registries. CONCLUSIONS: Practices vary widely between registries regarding recording drug exposure information. EUROCAT has the potential to be an effective collaborative framework to contribute to post-marketing drug surveillance in relation to teratogenic effects, but work is needed to implement ATC drug coding more widely, and to diversify the sources of information used to determine drug exposure in each registry.

Real-life versus package insert: a post-marketing study on adverse-event rates of the virosomal hepatitis A vaccine Epaxal® in healthy travellers.

There are various methods to collect adverse events (AEs) in clinical trials. The methods how AEs are collected in vaccine trials is of special interest: solicited reporting can lead to over-reporting events that have little or no biological relationship to the vaccine. We assessed the rate of AEs listed in the package insert for the virosomal hepatitis A vaccine Epaxal(®), comparing data collected by solicited or unsolicited self-reporting. In an open, multi-centre post-marketing study, 2675 healthy travellers received single doses of vaccine administered intramuscularly. AEs were recorded based on solicited and unsolicited questioning during a four-day period after vaccination. A total of 2541 questionnaires could be evaluated (95.0% return rate). Solicited self-reporting resulted in significantly higher (p<0.0001) rates of subjects with AEs than unsolicited reporting, both at baseline (18.9% solicited versus 2.1% unsolicited systemic AEs) and following immunization (29.6% versus 19.3% local AEs; 33.8% versus 18.2% systemic AEs). This could indicate that actual reporting rates of AEs with Epaxal(®) may be substantially lower than described in the package insert. The distribution of AEs differed significantly between the applied methods of collecting AEs. The most common AEs listed in the package insert were reported almost exclusively with solicited questioning. The reporting of local AEs was more likely than that of systemic AEs to be influenced by subjects' sex, age and study centre. Women reported higher rates of AEs than men. The results highlight the need for detailing the methods how vaccine tolerability was reported and assessed.

Marketing verde e práticas socioambientais nas indústrias do Paraná

A preocupação das empresas com o meio ambiente e com todas as questões sociais envolvidas em seu processo tem se tornado uma constante nos últimos tempos. Devido a isso, estão surgindo novas formas de administrar os recursos disponíveis. Nesse contexto, enquadra-se o marketing verde que deve estar pautado em práticas ambientalmente corretas, com o intuito de gerar produtos e serviços mais sustentáveis, fortalecendo a imagem das empresas e diferenciando suas marcas no mercado. O intuito neste trabalho foi verificar se as grandes indústrias do Paraná estão se utilizando das práticas de marketing verde e se mantêm projetos de gestão socioambiental. Para atender a tais objetivos, elaborou-se uma pesquisa descritiva e quantitativa com 48 grandes empresas cadastradas na Federação das Indústrias do Paraná. Os resultados obtidos indicam que a maior parte das empresas possui departamento de marketing formalizado, mantém sistemas de gestão ambiental e utiliza moderadamente práticas de marketing verde.

Marketing de lugar: estado da arte e perspectivas futuras

O objetivo neste trabalho é contribuir com o repensar da natureza e do significado do marketing de lugar presente na literatura, descrevendo as três principais perspectivas influentes em seu desenvolvimento – promoção, planejamento e branding – e apresentar uma análise crítica de seu processo de evolução. No intuito de orientar o entendimento, evitar interpretações individuais e propor uma linguagem comum, a análise compreende a convergência das perspectivas em um conceito caracterizado como uma importante ferramenta de gerenciamento das trocas que ocorrem em âmbito territorial visando ao desenvolvimento socioeconômico da localidade. Como contribuição, sugere-se uma estruturação para investigações futuras identificando lacunas entre a teoria do marketing de lugar e a forma como é compreendido, assim como as dificuldades significativas para sua implementação.

SwissBioisostere: a database of molecular replacements for ligand design.

The SwissBioisostere database (http://www.swissbioisostere.ch) contains information on molecular replacements and their performance in biochemical assays. It is meant to provide researchers in drug discovery projects with ideas for bioisosteric modifications of their current lead molecule, as well as to give interested scientists access to the details on particular molecular replacements. As of August 2012, the database contains 21 293 355 datapoints corresponding to 5 586 462 unique replacements that have been measured in 35 039 assays against 1948 molecular targets representing 30 target classes. The accessible data were created through detection of matched molecular pairs and mining bioactivity data in the ChEMBL database. The SwissBioisostere database is hosted by the Swiss Institute of Bioinformatics and available via a web-based interface.