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

The interactional space in CLIL (Content and Language Integrated Learning) and EFL (English as a Foreign Language) classrooms

Aquest estudi pretén investigar els intercanvis verbals mestre/a – aprenent(s) en dos contextos d'instrucció diferents: classes amb un enfocament AICLE (Aprenentatge Integrat de Continguts Curriculars i Llengua Estrangera) on s’aprenen continguts no lingüístics a través de l’anglès, per una banda, i classes 'tradicionals' d'anglès com a llengua estrangera, on l’anglès és alhora objecte d’estudi i vehicle de comunicació, per una altra banda. Més concretament, les preguntes que formula el/la mestre/a, la producció oral dels aprenents i el 'feedback' del/de la mestre/a en els episodis d’atenció a la forma s’han estudiat a la llum de les principals teories provinents del camp de l’Adquisició de Segones Llengües (SLA) per tal de demostrar el seu paper en l’aprenentatge de l’anglès. El corpus de dades prové de l’enregistrament de 7 sessions AICLE i d'11 sessions EFL enregistrades en format àudio i vídeo en dos centres públics d’Educació Primària (EP) de Catalunya. A cadascuna de les escoles, el/la mateix/a mestre/a és l’encarregat/da dels dos tipus d’instrucció amb el mateix grup d’aprenents (10-11 anys d’edat), fet que permet eliminar variables individuals com l'aptitud dels aprenents o l'estil del/de la mestre/a.Els resultats mostren un cert nombre de similituds discursives entre AICLE i EFL donat que ambdós enfocaments tenen lloc en el context-classe amb unes característiques ben definides. Tal com apunta la recerca realitzada en aquest camp, la instrucció AICLE reuneix un seguit de condicions idònies per un major desenvolupament dels nivells de llengua anglesa més enllà de les classes ‘tradicionals’ d’anglès. Malgrat això, aquest estudi sembla indicar que el potencial d'AICLE pel que fa a facilitar una exposició rica a l’anglès i una producció oral significativa no s’explota degudament. En aquest sentit, els resultats d’aquest estudi poden contribuir a la formació dels futurs professors d'AICLE si es busca l’assoliment d’una complementarietat d’ambdós contextos amb l’objectiu últim de millorar els nivells de domini de la llengua anglesa.

Classical horizontal inequity and reranking: an integrated approach

The last 20 years have seen a significant evolution in the literature on horizontal inequity (HI) and have generated two major and "rival" methodological strands, namely, classical HI and reranking. We propose in this paper a class of ethically flexible tools that integrate these two strands. This is achieved using a measure of inequality that merges the well-known Gini coefficient and Atkinson indices, and that allows a decomposition of the total redistributive effect of taxes and transfers in a vertical equity effect and a loss of redistribution due to either classical HI or reranking. An inequality-change approach and a money-metric cost-of-inequality approach are developed. The latter approach makes aggregate classical HI decomposable across groups. As in recent work, equals are identified through a nonparametric estimation of the joint density of gross and net incomes. An illustration using Canadian data from 1981 to 1994 shows a substantial, and increasing, robust erosion of redistribution attributable both to classical HI and to reranking, but does not reveal which of reranking or classical HI is more important since this requires a judgement that is fundamentally normative in nature.

Demand and revenue implications of an integrated public transport policy: the case of Madrid

One of the most popular options for promoting public transport use is the provision of an integrated and high quality public transport system. This was the strategy adopted by the regional government in Madrid in 1986 and since then public transport patronage has increased by more than 50%. This paper has two objectives. The first is to identify the factors underlying the significant increase in the demand for public transport in Madrid. To do this we estimate an aggregate demand function for bus and underground trips, which allows us to obtain the demand elasticities with respect to the main attributes of public transport services and also to calculate the long-term impact of changes in those explanatory variables on patronage. The second objective is to evaluate the impact on revenue derived from the introduction of the travel card scheme, and to discuss the consequences on revenue of changes in the relative fare levels of different types of ticket without substantially affecting patronage. This latter issue is addressed by estimating a matrix of own and cross-price elasticities for different ticket types.

Equity and CO2 emissions distribution in climate change integrated assessment

Emissions distribution is a focus variable for the design of future international agreements to tackle global warming. This paper specifically analyses the future path of emissions distribution and its determinants in different scenarios. Whereas our analysis is driven by tools which are typically applied in the income distribution literature and which have recently been applied to the analysis of CO2 emissions distribution, a new methodological approach is that our study is driven by simulations run with a popular regionalised optimal growth climate change model over the 1995-2105 period. We find that the architecture of environmental policies, the implementation of flexible mechanisms and income concentration are key determinants of emissions distribution over time. In particular we find a robust positive relationship between measures of inequalities.

Creating the Gorizia-Goriska euroregion: an European cross-border administrative model for integrated socio-economic development in the upper adriatic. Crossborder co-operation as a tool for trans-national integration and conflict resolution

Contribució al Seminari: "Les Euroregions: Experiències i aprenatges per a l’Euroregió Pirineus-Mediterrània", 15-16 de desembre de 2005

Multi-Scale Integrated Analysis of Societal and Ecosystem Metabolism (MUSIASEM): an outline of rationale and theory

This paper presents an outline of rationale and theory of the MuSIASEM scheme (Multi-Scale Integrated Analysis of Societal and Ecosystem Metabolism). First, three points of the rationale behind our MuSIASEM scheme are discussed: (i) endosomatic and exosomatic metabolism in relation to Georgescu-Roegen’s flow-fund scheme; (2) the bioeconomic analogy of hypercycle and dissipative parts in ecosystems; (3) the dramatic reallocation of human time and land use patterns in various sectors of modern economy. Next, a flow-fund representation of the MUSIASEM scheme on three levels (the whole national level, the paid work sectors level, and the agricultural sector level) is illustrated to look at the structure of the human economy in relation to two primary factors: (i) human time - a fund; and (ii) exosomatic energy - a flow. The three levels representation uses extensive and intensive variables simultaneously. Key conceptual tools of the MuSIASEM scheme - mosaic effects and impredicative loop analysis - are explained using the three level flow-fund representation. Finally, we claim that the MuSIASEM scheme can be seen as a multi-purpose grammar useful to deal with sustainability issues.

Estudi pilot del progrés de la restauració a les activitats extractives de Catalunya

L’objecte d’aquest estudi és determinar el ritme restaurador i caracteritzar la tipologia de les restauracions d’algunes activitats extractives de Catalunya. S’ha analitzat l’evolució dels treballs de restauració en una selecció d’activitats extractives de Catalunya i s’ha estimat la qualitat de les restauracions efectuades en base a la observació de la vegetació desenvolupada, el control de l’erosió i la integració paisatgística. Per dur a terme aquest estudi s’ha creat una base de dades en format de qüestionari, combinada amb un sistema d’informació geogràfica, que s’ha assajat en un treball de camp amb una mostra limitada d’activitats extractives. A partir de la interpretació dels resultats, es determina que actualment la gestió incorpora la necessitat de restaurar, però com a element subordinat a la producció. Això produeix una manca de planificació que incideix directament en la qualitat de les restauracions dutes a terme. La gestió de les pedreres encara ha de situar el concepte de restauració integrada com a eix central del desenvolupament i planificació de l’activitat extractiva.

Sistemes integrats de gestió (Integrated Management Systems - IMS): Anàlisi empíric a les empreses de Catalunya

Projecte de recerca elaborat a partir d’una estada al Auditing and Integration of Management Systems Research Laboratory de la Universitat d’Alberta, Canadà, des de maig fins a setembre del 2007. Aquest centre porta a terme recerca de caire teòrica i bàsica aplicada a l’assegurament de la qualitat, i més concretament a l’estandardització i integració de sistemes de gestió. En primer lloc, s’han analitzat les dades obtingudes en l’estudi empíric descriptiu realitzat a Catalunya durant l’any 2005, focalitzat en els estàndards de gestió més utilitzats per les empreses catalanes, en que s’hi incloïen les normes ISO 9001, ISO 14001, OSHAS 18001 així com els nous estàndards de suport de la sèrie ISO 10000. En segon terme, i a partir d’aquest anàlisis previ, s’ha iniciat el disseny d’una metodologia flexible per a la integració dels sistemes de gestió basats en estàndards internacionals.

Establiment de bases científiques per al desenvolupament d'una estratègia integrada per avaluar toxicitat en reproducció

Report for the scientific sojourn at the National Institute for Public Health and the Environment (RIVM), Netherlands, from 2006 to 2008. This project aimed at creating scientific elements that could help deriving an integrated testing strategy for reproductive toxicity. Part of the project focused on the use of alternative tests for regulatory purposes. An in vitro-in vivo extrapolation method for embryotoxicity was proposed and evaluated. In vitro and in vivo dose descriptors were correlated; however, the scatter in the correlation was too large to allow an accurate estimation of an in vivo dose from an in vitro dose. The in vitro-in vivo extrapolation method together with toxicokinetic data was also applied to a category of substances (phthalates). Although based on a limited number of substances, the results suggested that in vitro-in vivo extrapolation for embryotoxicity is possible within a category of compounds if adequate toxicokinetic data is available. Because of the limitations that still remain in the use of alternative tests for reproductive toxicicity, other approaches to reduce animal testing were explored. Thus, a database of reproductive toxicity studies was created to retrospectively evaluate the comparative value of some studies or elements in a particular study. When compared to the subchronic toxicity study, the rat two-generation reproductive toxicity study had a considerable impact on the identification of hazard for reproductive toxicity, but not on the overall NOAEL. Among the two-generation studies included in our database, the second generation affected neither the overall NOAEL nor the critical effect. The rat and the rabbit developmental toxicity studies were, on average, similarly sensitive. However, for certain substances the developmental study in either one of the two species appeared to be more sensitive than in the other species.

Marine biotoxins in the Catalan littoral: could biosensors be integrated into monitoring programmes?

Aquest article descriu els sensors enzimàtics i immunosensors electroquímics que s’han desenvolupat als nostres grups per a la detecció de la biotoxina marina àcid okadaic (OA), i discuteix la possibilitat d’integrar-los en programes de seguiment. Els sensors enzimàtics per a OA que es presenten es basen en la inhibició de la proteïna fosfatasa (PP2A) per aquesta toxina i la mesura electroquímica de l’activitat enzimàtica mitjançant l’ús de substrats enzimàtics apropiats, electroquímicament actius després de la seva desfosforació per l’enzim. Els immunosensors electroquímics descrits en aquest article es basen en un enzimoimmunoassaig sobre fase sòlida competitiu indirecte (ciELISA), amb fosfatasa alcalina (ALP) o peroxidasa (HRP) com a marcatges, i un sistema de reciclatge enzimàtic amb diaforasa (DI). Els biosensors presentats aquí s’han aplicat a l’anàlisi de dinoflagel·lats, musclos i ostres. Les validacions preliminars amb assaigs colorimètrics i LC-MS/MS han demostrat la possibilitat d’utilitzar les bioeines desenvolupades per al cribratge preliminar de biotoxines marines en mostres de camp o de cultiu, que ofereixen informació complementària a la cromatografia. En conclusió, tot i que encara cal optimitzar alguns paràmetres experimentals, la integració dels biosensors a programes de seguiment és viable i podria proporcionar avantatges respecte a altres tècniques analítiques pel que fa al temps d’anàlisi, la simplicitat, la selectivitat, la sensibilitat, el fet de poder ser d’un sol ús i l’efectivitat de cost. This article describes the electrochemical enzyme sensors and immunosensors that have been developed by our groups for the detection of marine biotoxin okadaic acid (OA), and discusses the possibility of integrating them into monitoring programmes. The enzyme sensors for OA reported herein are based on the inhibition of immobilised protein phosphatase 2A (PP2A) by this toxin and the electrochemical measurement of the enzyme activity through the use of appropriate enzyme substrates, which are electrochemically active after dephosphorylation by the enzyme. The electrochemical immunosensors described in this article are based on a competitive indirect Enzyme- Linked ImmunoSorbent Assay (ciELISA), using alkaline phosphatase (ALP) or horseradish peroxidase (HRP) as labels, and an enzymatic recycling system with diaphorase (DI). The biosensors presented herein have been applied to the analysis of dinoflagellates, mussels and oysters. Preliminary validations with colorimetric assays and LC-MS/MS have demonstrated the possibility of using the developed biotools for the preliminary screening of marine biotoxins in field or cultured samples, offering complementary information to chromatography. In conclusion, although optimisation of some experimental parameters is still required, the integration of biosensors into monitoring programmes is viable and may provide advantages over other analytical techniques in terms of analysis time, simplicity, selectivity, sensitivity, disposability of electrodes and cost effectiveness.

A multi-purpose grammar generating a multi-scale integrated analysis of Laos

In this study we propose an application of the MuSIASEM approach which is used to provide an integrated analysis of Laos across different scales. With the term “integrated analysis across scales” we mean the generation of a series of packages of quantitative indicators, characterizing the performance of the socioeconomic activities performed in Laos when considering: (i) different hierarchical levels of organization (farming systems described at the level of household, rural villages, regions of Laos, the whole country level); and (ii) different dimensions of analysis (economic dimension, social dimension, ecological dimension, technical dimension). What is relevant in this application is that the information carried out by these different packages of indicators is integrated in a system of accounting which establishes interlinkages across these indicators. This is a essential feature to study sustainability trade-offs and to build more robust scenarios of possible changes. The multi-scale integrated representation presented in this study is based on secondary data (gathered in a three year EU project – SEAtrans and integrated by other available statistical sources) and it is integrated in GIS, when dealing with the spatial representation of Laos. However, even if we use data referring to Laos, the goal of this study is not that of providing useful information about a practical policy issue of Laos, but rather, to illustrate the possibility of using a multipurpose grammar to produce an integrated set of sustainability indicators at three different levels: (i) local; (ii) meso; (iii) macro level. The technical issue addressed is the simultaneous adoption of two multi-level matrices – one referring to a characterization of human activity over a set of different categories, and another referring to a characterization of land uses over the same set of categories. In this way, it becomes possible to explain the characteristics of Laos (an integrated set of indicators defining the performance of the whole country) in relation to the characteristics of the rural Laos and urban Laos. The characteristics of rural Laos, can be explained using the characteristics of three regions defined within Laos (Northern Laos, Central Laos and Southern Laos), which in turn can be defined (using an analogous package of indicators), starting from the characteristics of three main typologies of farming systems found in the regions.

A first attempt of geographically-distributed Multi-scale integrated analysis of societal and ecosystem metabolism (MuSIASEM): mapping human time and energy throughput in metropolitan Barcelona

This study presents a first attempt to extend the “Multi-scale integrated analysis of societal and ecosystem metabolism (MuSIASEM)” approach to a spatial dimension using GIS techniques in the Metropolitan area of Barcelona. We use a combination of census and commercial databases along with a detailed land cover map to create a layer of Common Geographic Units that we populate with the local values of human time spent in different activities according to MuSIASEM hierarchical typology. In this way, we mapped the hours of available human time, in regards to the working hours spent in different locations, putting in evidence the gradients in spatial density between the residential location of workers (generating the work supply) and the places where the working hours are actually taking place. We found a strong three-modal pattern of clumps of areas with different combinations of values of time spent on household activities and on paid work. We also measured and mapped spatial segregation between these two activities and put forward the conjecture that this segregation increases with higher energy throughput, as the size of the functional units must be able to cope with the flow of exosomatic energy. Finally, we discuss the effectiveness of the approach by comparing our geographic representation of exosomatic throughput to the one issued from conventional methods.

Gestió de la implantació d'un ERP en una empresa farmacèutica

En aquest projecte s'exposa un canvi de sistema de gestió en diferents departaments d'una empresa. Aquest canvi es concreta en una implantació d'un ERP, que és un sistema integrat que posseeix una base de dades centralitzada i evita les duplicitats i incongruències d'informació. El present document està organitzat en tres gran grups: el primer explica com gestionar un canvi de la filosofia de treball en companyies; el segon tracta sobre l'estudi de l'ERP i la seva aplicació pràctica; i per últim, els problemes que apareixen per culpa de la resistència al canvi per part dels usuaris finals.

Perceptions of Europe in political and economic elites: a geographical compared analysis of Germany, Spain and Poland

Elite perceptions about Europe are a very important point in order to understand the current European integration process, as well as the future perspectives for the continent. This study makes a comparison between the perceptions which political and economical elites in some European countries have about the European Union process and its mechanisms. The main goal is to identify the differences in positions of each type of elites, as well as the variations among three key countries. The database built thanks to the INTUNE (Integrated and United? A quest for Citizenship in an ¨ever closer Europe¨) Project Survey on European Elites and Masses, funded by the Sixth Framework Programme of the EU [Contract CIT 3-CT-2005-513421] have being used. The questionnaire was applied between February and May 2007, in a total of 18 European countries. The national teams got a total of almost 2000 valid responses at European level. In the analysis we have showed some general descriptive statistics about the perception of Europe taking as a reference two dimensions of the INTUNE project: identity (attachment to the national level, the meaning of being a truly national, and the threats from Turkey that EU is facing at this moment) and representation (trust in European and national institutions, preferences for a national or an European army). The results are presented distinguishing between political (national MP’s in low chambers) and economical elites (presidents of corporations, general managers…) and, at the same time, among three countries: Germany as an original member of the European Union; Spain, incorporated in 1986; and a new member, Poland, joining the EU in 2004.