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

Mining and exploiting domain-specific corpora in the PANACEA platform

The objective of the PANACEA ICT-2007.2.2 EU project is to build a platform that automates the stages involved in the acquisition,production, updating and maintenance of the large language resources required by, among others, MT systems. The development of a Corpus Acquisition Component (CAC) for extracting monolingual and bilingual data from the web is one of the most innovative building blocks of PANACEA. The CAC, which is the first stage in the PANACEA pipeline for building Language Resources, adopts an efficient and distributed methodology to crawl for web documents with rich textual content in specific languages and predefined domains. The CAC includes modules that can acquire parallel data from sites with in-domain content available in more than one language. In order to extrinsically evaluate the CAC methodology, we have conducted several experiments that used crawled parallel corpora for the identification and extraction of parallel sentences using sentence alignment. The corpora were then successfully used for domain adaptation of Machine Translation Systems.

Creació d'una aplicació col·laborativa orientada a web semàntica

L'objectiu d'aquest projecte es la creació d'una plataforma que ofereix un nou format per a presentar aquest tipus d'informació, i que a mes permet la integració d'ontologies per a poder classificar les diferents noticies que s'afegeixin al sistema.

Remote Control of Mobile Devices in Android Platform

Remote control systems are a very useful element to control and monitor devices quickly and easily. This paper proposes a new architecture for remote control of Android mobile devices, analyzing the different alternatives and seeking the optimal solution in each case. Although the area of remote control, in case of mobile devices, has been little explored, it may provide important advantages for testing software and hardware developments in several real devices. It can also allow an efficient management of various devices of different types, perform forensic security tasks, etc ... The main idea behind the proposed architecture was the design of a system to be used as a platform which provides the services needed to perform remote control of mobile devices. As a result of this research, a proof of concept was implemented. An Android application running a group of server programs on the device, connected to the network or USB interface, depending on availability. This servers can be controlled through a small client written in Java and runnable both on desktop and web systems.

CBS: an open platform that integrates predictive methods and epigenetics information to characterize conserved regulatory features in multiple Drosophila genomes.

Background: Information about the composition of regulatory regions is of great value for designing experiments to functionally characterize gene expression. The multiplicity of available applications to predict transcription factor binding sites in a particular locus contrasts with the substantial computational expertise that is demanded to manipulate them, which may constitute a potential barrier for the experimental community. Results: CBS (Conserved regulatory Binding Sites, http://compfly.bio.ub.es/CBS) is a public platform of evolutionarily conserved binding sites and enhancers predicted in multiple Drosophila genomes that is furnished with published chromatin signatures associated to transcriptionally active regions and other experimental sources of information. The rapid access to this novel body of knowledge through a user-friendly web interface enables non-expert users to identify the binding sequences available for any particular gene, transcription factor, or genome region. Conclusions: The CBS platform is a powerful resource that provides tools for data mining individual sequences and groups of co-expressed genes with epigenomics information to conduct regulatory screenings in Drosophila.

Diseño de una aplicación web para la gestión de una revista científica

Este proyecto tiene como finalidad el análisis, diseño y desarrollo de una aplicación web en base a una revista científica. La mecánica de la revista consiste en la propia revisión y edición de los artículos por parte de los usuarios dados de alta en el aplicativo. Los usuarios que componen la web, puede tener diferentes perfiles: autor, editor, revisor, técnico editor y administrador. Cada usuario tiene unas tareas específicas en el flujo de revisión y edición. El proyecto se ha desarrollado sobre la plataforma ASP.NET y SQL para el diseño de la base de datos.

Web services to link interlibrary software with OCLC WorldShare

Purpose - This article describes the use of web services to interconnect the GTBib interlibrary loan program with the OCLC WorldShare platform. Design/methodology/approach - We describe the current problem of duplication of procedures in libraries that have added their collections to the OCLC WorldCat catalogue in recent years and are therefore more likely to receive interlibrary loan requests through the WorldShare Platform. Findings - A solution that uses web services to insert and retrieve requests between the two systems is presented. Autonomous agents periodically check the status of the requests and keep them updated and synchronized. These agents also inform the library staff of any variation or inconsistency that is detected. Practical Implications - This technology reduces process management time by making it unnecessary to introduce the request data in both systems. Agents are used to check the consistency of statuses between the two systems, thus avoiding errors and omissions and improving the efficiency of the whole interlibrary loan process. Originality/value - This paper describes in detail the technical aspects of the solution as a reference for the development of future applications.

L'accés als recursos web des de les biblioteques

L’objecte central del present informe és descriure l’estat de la qüestió –tant a Catalunya com a altres països– de l’accés als recursos web des de les biblioteques. De fet, l’objectiu últim és presentar i analitzar la situació a l’estranger per tal d’adaptar les estratègies i els models de tractament i organització de recursos web a la realitat i les necessitats de les biblioteques catalanes.

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.

Portal web per a l'IES Pla d'en Boet de Mataró

Aquesta memòria tracta sobre el procediment de creació software que s’ha dut a terme per a implementar el portal web de l’IES Pla d’En Boet de Mataró, un institut públic subvencionat per la Generalitat de Catalunya. Aquest portal s’ha desenvolupat des de zero i s’ha hagut d’enllaçar amb altres aplicacions que han sigut requerides. El document conté l’anàlisi, disseny i l’implementació del portal web, i de tota la funcionalitat que l’envolta, que s’ha realitzat per satisfer els requeriments inicials. Conté, a més, les diferents anàlisis que s’han necessitat per tal d’integrar-lo amb una aplicació pròpia del centre i amb un sistema d’intercanvi de missatges, i com s’ha decidit fer-ho. S’intenta explicar alguna de les problemàtiques més importants que han aparegut al llarg del procés i que han afectat al seu desenvolupament. Les decisions preses per a resoldre-les també apareixen per avalar l’estudi realitzat. Finalment hi ha una valoració personal i una altra dels objectius aconseguits per veure que s’ha arribat a la solució final amb èxit.

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