Traducción técnica del capítulo III del libro Advanced Data Warehouse design: from conventional to spatial and temporal applications

The proposal to work on this final project came after several discussions held with Dr. Elzbieta Malinowski Gadja, who in 2008 published the book entitled Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications (Data-Centric Systems and Applications). The project was carried out under the technical supervision of Dr. Malinowski and the direct beneficiary was the University of Costa Rica (UCR) where Dr. Malinowski is a professor at the Department of Computer Science and Informatics. The purpose of this project was twofold: First, to translate chapter III of said book with the intention of generating educational material for the use of the UCR and, second, to venture in the field of technical translation related to data warehouse. For the first component, the goal was to generate a final product that would eventually serve as an educational tool for the post-graduate courses of the UCR. For the second component, this project allowed me to acquire new skills and put into practice techniques that have helped me not only to perfom better in my current job as an Assistant Translator of the Inter-American BAnk (IDB), but also to use them in similar projects. The process was lenggthy and required torough research and constant communication with the author. The investigation focused on the search of terms and definitions to prepare the glossary, which was the basis to start the translation project. The translation process itself was carried out by phases, so that comments and corrections by the author could be taken into account in subsequent stages. Later, based on the glossary and the translated text, illustrations had been created in the Visio software were translated. In addition to the technical revision by the author, professor Carme Mangiron was in charge of revising the non-technical text. The result was a high-quality document that is currently used as reference and study material by the Department of Computer Science and Informatics of Costa Rica.

Clustering of grape yield maps to delineate site-specific management zones

Zonal management in vineyards requires the prior delineation of stable yield zones within the parcel. Among the different methodologies used for zone delineation, cluster analysis of yield data from several years is one of the possibilities cited in scientific literature. However, there exist reasonable doubts concerning the cluster algorithm to be used and the number of zones that have to be delineated within a field. In this paper two different cluster algorithms have been compared (k-means and fuzzy c-means) using the grape yield data corresponding to three successive years (2002, 2003 and 2004), for a ‘Pinot Noir’ vineyard parcel. Final choice of the most recommendable algorithm has been linked to obtaining a stable pattern of spatial yield distribution and to allowing for the delineation of compact and average sized areas. The general recommendation is to use reclassified maps of two clusters or yield classes (low yield zone and high yield zone) and, consequently, the site-specific vineyard management should be based on the prior delineation of just two different zones or sub-parcels. The two tested algorithms are good options for this purpose. However, the fuzzy c-means algorithm allows for a better zoning of the parcel, forming more compact areas and with more equilibrated zonal differences over time.

Traducción técnica del capítulo III del libro Advanced Data Warehouse design: from conventional to spatial and temporal applications

The proposal to work on this final project came after several discussions held with Dr. Elzbieta Malinowski Gadja, who in 2008 published the book entitled Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications (Data-Centric Systems and Applications). The project was carried out under the technical supervision of Dr. Malinowski and the direct beneficiary was the University of Costa Rica (UCR) where Dr. Malinowski is a professor at the Department of Computer Science and Informatics. The purpose of this project was twofold: First, to translate chapter III of said book with the intention of generating educational material for the use of the UCR and, second, to venture in the field of technical translation related to data warehouse. For the first component, the goal was to generate a final product that would eventually serve as an educational tool for the post-graduate courses of the UCR. For the second component, this project allowed me to acquire new skills and put into practice techniques that have helped me not only to perfom better in my current job as an Assistant Translator of the Inter-American BAnk (IDB), but also to use them in similar projects. The process was lenggthy and required torough research and constant communication with the author. The investigation focused on the search of terms and definitions to prepare the glossary, which was the basis to start the translation project. The translation process itself was carried out by phases, so that comments and corrections by the author could be taken into account in subsequent stages. Later, based on the glossary and the translated text, illustrations had been created in the Visio software were translated. In addition to the technical revision by the author, professor Carme Mangiron was in charge of revising the non-technical text. The result was a high-quality document that is currently used as reference and study material by the Department of Computer Science and Informatics of Costa Rica.

The spatial effect of intra-metropolitan agglomeration economies

This study deals with the role of spatial accessibility to agglomeration economies in the change in spatial structure of industrial employment for the case of the Barcelona Metropolitan Region of Barcelona (BMR). Using the growth in gross density of municipal employment between 1986 and 1996 for seven manufacturing industries as an indicator of changes in the spatial structure of employment, an exploration is made of the spatial impact of agglomeration economies operating on a local scale the municipality and three areas 5, 8 and 12 kilometres away surrounding the municipality itself - , agglomeration economies emerging from CBD and the main specialised subcentres in the region, and the network economies associated with the total jobs in the region, access to which depends on the distance from the main transport infrastructures

Quantifying rock fabrics: a test of autocorrelation of the spatial distribution of cristals

A novel test of spatial independence of the distribution of crystals or phases in rocksbased on compositional statistics is introduced. It improves and generalizes the commonjoins-count statistics known from map analysis in geographic information systems.Assigning phases independently to objects in RD is modelled by a single-trial multinomialrandom function Z(x), where the probabilities of phases add to one and areexplicitly modelled as compositions in the K-part simplex SK. Thus, apparent inconsistenciesof the tests based on the conventional joins{count statistics and their possiblycontradictory interpretations are avoided. In practical applications we assume that theprobabilities of phases do not depend on the location but are identical everywhere inthe domain of de nition. Thus, the model involves the sum of r independent identicalmultinomial distributed 1-trial random variables which is an r-trial multinomialdistributed random variable. The probabilities of the distribution of the r counts canbe considered as a composition in the Q-part simplex SQ. They span the so calledHardy-Weinberg manifold H that is proved to be a K-1-affine subspace of SQ. This isa generalisation of the well-known Hardy-Weinberg law of genetics. If the assignmentof phases accounts for some kind of spatial dependence, then the r-trial probabilitiesdo not remain on H. This suggests the use of the Aitchison distance between observedprobabilities to H to test dependence. Moreover, when there is a spatial uctuation ofthe multinomial probabilities, the observed r-trial probabilities move on H. This shiftcan be used as to check for these uctuations. A practical procedure and an algorithmto perform the test have been developed. Some cases applied to simulated and realdata are presented.Key words: Spatial distribution of crystals in rocks, spatial distribution of phases,joins-count statistics, multinomial distribution, Hardy-Weinberg law, Hardy-Weinbergmanifold, Aitchison geometry

Spectrum of gluten sensitive enteropathy in first degree relatives of patients with coeliac disease: clinical relevance of lymphocytic enteritis.

Background: Limited data on a short series of patients suggest that lymphocytic enteritis (classically considered as latent coeliac disease) may produce symptoms of malabsorption, although the true prevalence of this situation is unknown. Serological markers of coeliac disease are of little diagnostic value in identifying these patients. Aims: To evaluate the usefulness of human leucocyte antigen-DQ2 genotyping followed by duodenal biopsy for the detection of gluten-sensitive enteropathy in first-degree relatives of patients with coeliac disease and to assess the clinical relevance of lymphocytic enteritis diagnosed with this screening strategy. Patients and methods: 221 first-degree relatives of 82 DQ2+ patients with coeliac disease were consecutively included. Duodenal biopsy (for histological examination and tissue transglutaminase antibody assay in culture supernatant) was carried out on all DQ2+ relatives. Clinical features, biochemical parameters and bone mineral density were recorded. Results: 130 relatives (58.8%) were DQ2+, showing the following histological stages: 64 (49.2%) Marsh 0; 32 (24.6%) Marsh I; 1 (0.8%) Marsh II; 13 (10.0%) Marsh III; 15.4% refused the biopsy. 49 relatives showed gluten sensitive enteropathy, 46 with histological abnormalities and 3 with Marsh 0 but positive tissue transglutaminase antibody in culture supernatant. Only 17 of 221 relatives had positive serological markers. Differences in the diagnostic yield between the proposed strategy and serology were significant (22.2% v 7.2%, p<0.001). Relatives with Marsh I and Marsh II¿III were more often symptomatic (56.3% and 53.8%, respectively) than relatives with normal mucosa (21.1%; p=0.002). Marsh I relatives had more severe abdominal pain (p=0.006), severe distension (p=0.047) and anaemia (p=0.038) than those with Marsh 0. The prevalence of abnormal bone mineral density was similar in relatives with Marsh I (37%) and Marsh III (44.4%). Conclusions: The high number of symptomatic patients with lymphocytic enteritis (Marsh I) supports the need for a strategy based on human leucocyte antigen-DQ2 genotyping followed by duodenal biopsy in relatives of patients with coeliac disease and modifies the current concept that villous atrophy is required to prescribe a gluten-free diet.

High-SNR analytical performance of spatial multiplexing MIMO systems with CSI

In this paper, we investigate the average andoutage performance of spatial multiplexing multiple-input multiple-output (MIMO) systems with channel state information at both sides of the link. Such systems result, for example, from exploiting the channel eigenmodes in multiantenna systems. Dueto the complexity of obtaining the exact expression for the average bit error rate (BER) and the outage probability, we deriveapproximations in the high signal-to-noise ratio (SNR) regime assuming an uncorrelated Rayleigh flat-fading channel. Moreexactly, capitalizing on previous work by Wang and Giannakis, the average BER and outage probability versus SNR curves ofspatial multiplexing MIMO systems are characterized in terms of two key parameters: the array gain and the diversity gain. Finally, these results are applied to analyze the performance of a variety of linear MIMO transceiver designs available in the literature.

The Spatial effects of transportation on industrial employment

This paper examines the direct and indirect impacts of transport infrastructure on industrial employment. We estimate regressions with spatial econometric methods using data from the Spanish regions for the period 1995-2008. We find that the density of motorways and the amount of port traffic (particularly general non-containerized and container traffic) are significant determinants of industrial employment in the region, while the effects of railway density and the amount of airport traffic are unclear. Our empirical analysis shows the existence of significant negative spatial spillovers for the density of motorways and levels of container port traffic while the impact of general non-containerized port traffic seems to be mainly local.

Equivalent representation form of oscillators with elastic and damping nonlinear terms

In this work we consider the nonlinear equivalent representation form of oscillators that exhibit nonlinearities in both the elastic and the damping terms. The nonlinear damping effects are considered to be described by fractional power velocity terms which provide better predictions of the dissipative effects observed in some physical systems. It is shown that their effects on the system dynamics response are equivalent to a shift in the coefficient of the linear damping term of a Duffing oscillator. Then, its numerical integration predictions, based on its equivalent representation form given by the well-known forced, damped Duffing equation, are compared to the numerical integration values of its original equations of motion. The applicability of the proposed procedure is evaluated by studying the dynamics response of four nonlinear oscillators that arise in some engineering applications such as nanoresonators, microresonators, human wrist movements, structural engineering design, and chain dynamics of polymeric materials at high extensibility, among others

The spatial inequality of wage income in Barcelona Metropolitan Area

ABSTRACT The measure and estimation of income levels in Barcelona Metropolitan Area (BMA) goes back a long way. Using different approaches and focusing on different municipalities, there is a lot of work in the field. The majority of the literature has focused on the estimation of income levels using variables related to consumption. The empirical evidence on wage differentials has shown an important growth during 80’s and 90’s especially in United Kingdom and USA. Less is known on spatial distribution of inequality. This paper presents a new data set for analyzing spatial distribution of wage income. This data is obtained by matching Wage Structure Survey (WSS) with data from Census disaggregated by census tracts. In this way we have a unique data set with wage incomes for every census track for 36 municipalities belonging to BMA. We develop a descriptive analysis of spatial distribution, testing for spatial autocorrelation and use the family of Generalised Entropy Indices to measure inequality. Properties of the index allow us to decompose inequality into inter and intra-municipality measures. Since we have two cross-sectional data for WSS (1995-2002) we can also analyze the evolution of the inequality in this period of economic growth. Key words: spatial distribution of wages, spatial autocorrelation, inequality indices.

Why do creative industries cluster? An analysis of the determinants of clustering of creative industries

Creative industries tend to concentrate mainly around large- and medium-sized cities, forming creative local production systems. The text analyses the forces behind clustering of creative industries to provide the first empirical explanation of the determinants of creative employment clustering following a multidisciplinary approach based on cultural and creative economics, evolutionary geography and urban economics. A comparative analysis has been performed for Italy and Spain. The results show different patterns of creative employment clustering in both countries. The small role of historical and cultural endowments, the size of the place, the average size of creative industries, the productive diversity and the concentration of human capital and creative class have been found as common factors of clustering in both countries.

Interacting software-agents to support a kind of expert supervision systems

Expert supervision systems are software applications specially designed to automate process monitoring. The goal is to reduce the dependency on human operators to assure the correct operation of a process including faulty situations. Construction of this kind of application involves an important task of design and development in order to represent and to manipulate process data and behaviour at different degrees of abstraction for interfacing with data acquisition systems connected to the process. This is an open problem that becomes more complex with the number of variables, parameters and relations to account for the complexity of the process. Multiple specialised modules tuned to solve simpler tasks that operate under a co-ordination provide a solution. A modular architecture based on concepts of software agents, taking advantage of the integration of diverse knowledge-based techniques, is proposed for this purpose. The components (software agents, communication mechanisms and perception/action mechanisms) are based on ICa (Intelligent Control architecture), software middleware supporting the build-up of applications with software agent features

Estimation of protein coding density in a corpus of DNA sequence data

A number of experimental methods have been reported for estimating the number of genes in a genome, or the closely related coding density of a genome, defined as the fraction of base pairs in codons. Recently, DNA sequence data representative of the genome as a whole have become available for several organisms, making the problem of estimating coding density amenable to sequence analytic methods. Estimates of coding density for a single genome vary widely, so that methods with characterized error bounds have become increasingly desirable. We present a method to estimate the protein coding density in a corpus of DNA sequence data, in which a ‘coding statistic’ is calculated for a large number of windows of the sequence under study, and the distribution of the statistic is decomposed into two normal distributions, assumed to be the distributions of the coding statistic in the coding and noncoding fractions of the sequence windows. The accuracy of the method is evaluated using known data and application is made to the yeast chromosome III sequence and to C.elegans cosmid sequences. It can also be applied to fragmentary data, for example a collection of short sequences determined in the course of STS mapping.

Conserved chromosomal clustering of genes governed by chromatin regulators in Drosophila

BACKGROUND: The trithorax group (trxG) and Polycomb group (PcG) proteins are responsible for the maintenance of stable transcriptional patterns of many developmental regulators. They bind to specific regions of DNA and direct the post-translational modifications of histones, playing a role in the dynamics of chromatin structure. RESULTS: We have performed genome-wide expression studies of trx and ash2 mutants in Drosophila melanogaster. Using computational analysis of our microarray data, we have identified 25 clusters of genes potentially regulated by TRX. Most of these clusters consist of genes that encode structural proteins involved in cuticle formation. This organization appears to be a distinctive feature of the regulatory networks of TRX and other chromatin regulators, since we have observed the same arrangement in clusters after experiments performed with ASH2, as well as in experiments performed by others with NURF, dMyc, and ASH1. We have also found many of these clusters to be significantly conserved in D. simulans, D. yakuba, D. pseudoobscura and partially in Anopheles gambiae. CONCLUSION: The analysis of genes governed by chromatin regulators has led to the identification of clusters of functionally related genes conserved in other insect species, suggesting this chromosomal organization is biologically important. Moreover, our results indicate that TRX and other chromatin regulators may act globally on chromatin domains that contain transcriptionally co-regulated genes.

Toleration and the fair terms of engagement with diversity

The aim of this paper is to examine the various controversies over the genuineproblems of toleration in a plurally diverse polity as both historically andconceptually, toleration is one of the foundational characteristics that defines thevery essence of a plurally diverse polity and the basic virtue associated with a liberalconception of citizenship. In section 1, I present the main philosophical andconceptual issues related to the toleration-based approach to diversity in liberalpolitical theory. In section 2 I identify the conditions and the circumstances oftoleration. I articulate in Section 3 the most pressing objections against toleration. Ipresent in section 4 two competing approaches to the toleration-based approach todiversity is faced with. In the concluding section, I outline a modified conception oftoleration that mediates between different requirements associated with the twoprincipled commitments of the liberal version of the rights-based conception ofcitizenship.