Automated schema matching techniques: an exploratory study

Manual schema matching is a problem for many database applications that use multiple data sources including data warehousing and e-commerce applications. Current research attempts to address this problem by developing algorithms to automate aspects of the schema-matching task. In this paper, an approach using an external dictionary facilitates automated discovery of the semantic meaning of database schema terms. An experimental study was conducted to evaluate the performance and accuracy of five schema-matching techniques with the proposed approach, called SemMA. The proposed approach and results are compared with two existing semi-automated schema-matching approaches and suggestions for future research are made

Towards Affordable Disclosure of Spoken Word Archives

This paper presents and discusses ongoing work aiming at affordable disclosure of real-world spoken word archives in general, and in particular of a collection of recorded interviews with Dutch survivors of World War II concentration camp Buchenwald. Given such collections, the least we want to be able to provide is search at different levels and a flexible way of presenting results. Strategies for automatic annotation based on speech recognition – supporting e.g., within-document search– are outlined and discussed with respect to the Buchenwald interview collection. In addition, usability aspects of the spoken word search are discussed on the basis of our experiences with the online Buchenwald web portal. It is concluded that, although user feedback is generally fairly positive, automatic annotation performance is still far from satisfactory, and requires additional research

Tools for producing formal specifications : a view of current architectures and future directions

During the last decade, one important contribution towards requirements engineering has been the advent of formal specification languages. They offer a well-defined notation that can improve consistency and avoid ambiguity in specifications. However, the process of obtaining formal specifications that are consistent with the requirements is itself a difficult activity. Hence various researchers are developing systems that aid the transition from informal to formal specifications. The kind of problems tackled and the contributions made by these proposed systems are very diverse. This paper brings these studies together to provide a vision for future architectures that aim to aid the transition from informal to formal specifications. The new architecture, which is based on the strengths of existing studies, tackles a number of key issues in requirements engineering such as identifying ambiguities, incompleteness, and reusability. The paper concludes with a discussion of the research problems that need to be addressed in order to realise the proposed architecture

New tools and methods for direct programmatic access to the dbSNP relational database

Genome-wide association studies often incorporate information from public biological databases in order to provide a biological reference for interpreting the results. The dbSNP database is an extensive source of information on single nucleotide polymorphisms (SNPs) for many different organisms, including humans. We have developed free software that will download and install a local MySQL implementation of the dbSNP relational database for a specified organism. We have also designed a system for classifying dbSNP tables in terms of common tasks we wish to accomplish using the database. For each task we have designed a small set of custom tables that facilitate task-related queries and provide entity-relationship diagrams for each task composed from the relevant dbSNP tables. In order to expose these concepts and methods to a wider audience we have developed web tools for querying the database and browsing documentation on the tables and columns to clarify the relevant relational structure. All web tools and software are freely available to the public at http://cgsmd.isi.edu/dbsnpq. Resources such as these for programmatically querying biological databases are essential for viably integrating biological information into genetic association experiments on a genome-wide scale

Learning Center Consortium 2003 Report

Learning Centers are central facilities, frequently located with an apartment community, where programs are available that support residents in attaining their American dreams - children succeeding in school, adults increasing their earning power, families holding savings accounts and moving into homeownership.This report presents the results of the first two years of the Multifamily Initiative's effort to study the question, "What impact do housing-based learning centers have on property operations, low-income households and their communities?" The long-term goals of this initiative effort are to set benchmarks for outcomes, standardize effective programs, document and optimize the impact of learning centers on property performance, and to build collaborative funding sources.Thanks to the participation of the nine founding housing organizations who have made learning centers part of their operations, and to consultants Fred Alsup and Janet Maccubbin, this report presents a detailed picture of the initial work to define and improve the impact of learning centers, share best practices and build efficient, replicable standards. It also provides information on the characteristics of learning centers, such as types of programs, capacity, areas of success and challenges

Integrating GIS and Remote Sensing with Ecosystem Research

In the Phase II Ecosystem Management Research Program in the Ouachita and Ozark National Forests, an interdisciplinary group of scientists are evaluating the effects and trade-offs of partial cutting methods in a replicated stand level study. Information from approximately 2,000 plots is being collected by more than fifty researchers during this five-year project with plans to continue data collection long term. To evaluate the effects of different management strategies and their interactions with forest resources, data must be brought into a common format and made available to all researchers. To this end, a data support system was developed which utilizes Geographic Information System (GIS), Global Positioning Systems (GPS) and remote sensing technologies. Aerial photography, along with digitized layers of stand and greenbelt boundaries, roads and streams, and GPSed silvicultural plot locations form a framework to which data from diverse research areas can be linked. Researchers can not only share information resources, but can graphically visualize and query both spatial and attribute data to reflect forest ecosystem changes under various management strategies. The methodology used to develop and configure this large, relational database into an easily accessible form usable in an interactive GIS program could be transferable to other areas of natural resource management