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.

A flood geodatabase and its climatological applications: the case of Catalonia for the last century

Floods are the natural hazards that produce the highest number of casualties and material damage in the Western Mediterranean. An improvement in flood risk assessment and study of a possible increase in flooding occurrence are therefore needed. To carry out these tasks it is important to have at our disposal extensive knowledge on historical floods and to find an efficient way to manage this geographical data. In this paper we present a complete flood database spanning the 20th century for the whole of Catalonia (NE Spain), which includes documentary information (affected areas and damage) and instrumental information (meteorological and hydrological records). This geodatabase, named Inungama, has been implemented on a GIS (Geographical Information System) in order to display all the information within a given geographical scenario, as well as to carry out an analysis thereof using queries, overlays and calculus. Following a description of the type and amount of information stored in the database and the structure of the information system, the first applications of Inungama are presented. The geographical distribution of floods shows the localities which are more likely to be flooded, confirming that the most affected municipalities are the most densely populated ones in coastal areas. Regarding the existence of an increase in flooding occurrence, a temporal analysis has been carried out, showing a steady increase over the last 30 years.

Appropriateness of colonoscopy in Europe (EPAGE II). Chronic diarrhea and known inflammatory bowel disease.

BACKGROUND AND STUDY AIMS: To summarize the published literature on assessment of appropriateness of colonoscopy for investigation of chronic diarrhea, management of patients with known inflammatory bowel disease (IBD), and for colorectal cancer (CRC) surveillance in such patients, and to report report appropriateness criteria developed by an expert panel, the 2008 European Panel on the Appropriateness of Gastrointestinal Endoscopy, EPAGE II. METHODS: A systematic search of guidelines, systematic reviews, and primary studies regarding the evaluation of chronic diarrhea, the management of IBD, and colorectal cancer surveillance in IBD was performed. The RAND/UCLA Appropriateness Method was applied to develop appropriateness criteria for colonoscopy for these conditions. RESULTS: According to the literature, colonoscopic evaluation may be justified for patients aged > 50 years with recent-onset chronic diarrhea or with alarm symptoms. Surveillance colonoscopy for CRC should be offered to all patients with extensive ulcerative colitis or colonic Crohn's disease of 8 years' duration, and to all patients with less extensive disease of 15 years' duration. Intervals for surveillance colonoscopy depend on duration of evolution, initial diagnosis, and histological findings. The EPAGE II criteria also confirmed the appropriateness of diagnostic colonoscopy for diarrhea of > 4 weeks' duration. They also suggest that, in addition to assessing extent of IBD by colonoscopy, further colonoscopic examination is appropriate in the face of persistent or worsening symptoms. Surveillance colonoscopy in IBD patients was generally appropriate after a lapse of 2 years. In the presence of dysplasia at previous colonoscopy, it was not only appropriate but necessary. CONCLUSIONS: Despite or perhaps because of the limitations of the available published studies, the panel-based EPAGE II (http://www.epage.ch) criteria can help guide appropriate colonoscopy use in the absence of strong evidence from the literature.

Individual patient data systematic review and meta-analysis of optic nerve sheath diameter ultrasonography for detecting raised intracranial pressure: protocol of the ONSD research group.

BACKGROUND: The purpose of the optic nerve sheath diameter (ONSD) research group project is to establish an individual patient-level database from high quality studies of ONSD ultrasonography for the detection of raised intracranial pressure (ICP), and to perform a systematic review and an individual patient data meta-analysis (IPDMA), which will provide a cutoff value to help physicians making decisions and encourage further research. Previous meta-analyses were able to assess the diagnostic accuracy of ONSD ultrasonography in detecting raised ICP but failed to determine a precise cutoff value. Thus, the ONSD research group was founded to synthesize data from several recent studies on the subject and to provide evidence on the diagnostic accuracy of ONSD ultrasonography in detecting raised ICP. METHODS: This IPDMA will be conducted in different phases. First, we will systematically search for eligible studies. To be eligible, studies must have compared ONSD ultrasonography to invasive intracranial devices, the current reference standard for diagnosing raised ICP. Subsequently, we will assess the quality of studies included based on the QUADAS-2 tool, and then collect and validate individual patient data. The objectives of the primary analyses will be to assess the diagnostic accuracy of ONSD ultrasonography and to determine a precise cutoff value for detecting raised ICP. Secondly, we will construct a logistic regression model to assess whether patient and study characteristics influence diagnostic accuracy. DISCUSSION: We believe that this IPD MA will provide the most reliable basis for the assessment of diagnostic accuracy of ONSD ultrasonography for detecting raised ICP and to provide a cutoff value. We also hope that the creation of the ONSD research group will encourage further study. TRIAL REGISTRATION: PROSPERO registration number: CRD42012003072.

Total fatty acid composition in the characterization and identification of orchid mycorrhizal fungi Epulorhiza spp.

Rhizoctonia-like fungi are the main mycorrhizal fungi in orchid roots. Morphological characterization and analysis of conserved sequences of genomic DNA are frequently employed in the identification and study of fungi diversity. However, phytopathogenic Rhizoctonia-like fungi have been reliably and accurately characterized and identified through the examination of the fatty acid composition. To evaluate the efficacy of fatty acid composition in characterizing and identifying Rhizoctonia-like mycorrhizal fungi in orchids, three Epulorhiza spp. mycorrhizal fungi from Epidendrum secundum, two unidentified fungi isolated from Epidendrum denticulatum, and a phytopathogenic fungus, Ceratorhiza sp. AGC, were grouped based on the profile of their fatty acids, which was assessed by the Euclidian and Mahalanobis distances and the UPGMA method. Dendrograms distinguished the phytopathogenical isolate of Ceratorhiza sp. AGC from the mycorrhizal fungi studied. The symbionts of E. secundum were grouped into two clades, one containing Epulorhiza sp.1 isolates and the other the Epulorhiza sp.2 isolate. The similarity between the symbionts of E. denticulatum and Epulorhiza spp. fungi suggests that symbionts found in E. denticulatum may be identified as Epulorhiza. These results were corroborated by the analysis of the rDNA ITS region. The dendrogram constructed based on the Mahalanobis distance differentiated the clades most clearly. Fatty acid composition analysis proved to be a useful tool for characterizing and identifying Rhizoctonia-like mycorrhizal fungi.

CLIL Materials in Chemistry and English: Iodometric Titrations

Content and Language Integrated Learning (CLIL)Materials in Chemistry and English following the principles of CLIL / Content-based Instruction and Task-based Learning

Hwyneeds: Methodology, Analysis and Evaluation, March 2001

The quadrennial need study was developed to assist in identifying county highway financial needs (construction, rehabilitation, maintenance, and administration) and in the distribution of the road use tax fund (RUTF) among the counties in the state. During the period since the need study was first conducted using HWYNEEDS software, between 1982 and 1998, there have been large fluctuations in the level of funds distributed to individual counties. A recent study performed by Jim Cable (HR-363, 1993), found that one of the major factors affecting the volatility in the level of fluctuations is the quality of the pavement condition data collected and the accuracy of these data. In 1998, the Center for Transportation Research and Education researchers (Maze and Smadi) completed a project to study the feasibility of using automated pavement condition data collected for the Iowa Pavement Management Program (IPMP) for the paved county roads to be used in the HWYNEEDS software (TR-418). The automated condition data are objective and also more current since they are collected in a two year cycle compared to the 10-year cycle used by HWYNEEDS right now. The study proved the use of the automated condition data in HWYNEEDS would be feasible and beneficial in educing fluctuations when applied to a pilot study area. In another recommendation from TR-418, the researchers recommended a full analysis and investigation of HWYNEEDS methodology and parameters (for more information on the project, please review the TR-418 project report). The study reported in this document builds on the previous study on using the automated condition data in HWYNEEDS and covers the analysis and investigation of the HWYNEEDS computer program methodology and parameters. The underlying hypothesis for this study is thatalong with the IPMP automated condition data, some changes need to be made to HWYNEEDS parameters to accommodate the use of the new data, which will stabilize the process of allocating resources and reduce fluctuations from one quadrennial need study to another. Another objective of this research is to investigate the gravel roads needs and study the feasibility of developing a more objective approach to determining needs on the counties gravel road network. This study identifies new procedures by which the HWYNEEDS computer program is used to conduct the quadrennial needs study on paved roads. Also, a new procedure will be developed to determine gravel roads needs outside of the HWYNEED program. Recommendations are identified for the new procedures and also in terms of making changes to the current quadrennial need study. Future research areas are also identified.

A systematic review of longitudinal population-based studies on the predictors of smoking cessation in adolescent and young adult smokers.

OBJECTIVE: To describe the determinants of self-initiated smoking cessation of duration of at least 6 months as identified in longitudinal population-based studies of adolescent and young adult smokers. METHODS: A systematic search of the PubMed and EMBASE databases using smoking, tobacco, cessation, quit and stop as keywords was performed. Limits included articles related to humans, in English, published between January 1984 and August 2010, and study population aged 10-29 years. A total of 4502 titles and 871 abstracts were reviewed independently by 2 and 3 reviewers, respectively. Nine articles were retained for data abstraction. Data on study location, timeframe, duration of follow-up, number of data collection points, sample size, age/grade of participants, number of quitters, smoking status at baseline, definition of cessation, covariates and analytic method were abstracted from each article. The number of studies that reported a statistically significant association between each determinant investigated and cessation were tabulated, from among all studies that assessed the determinant. RESULTS: Despite heterogeneity in methods across studies, five factors robustly predicted quitting across studies in which the factor was investigated: not having friends who smoke, not having intentions to smoke in the future, resisting peer pressure to smoke, being older at first use of cigarette and having negative beliefs about smoking. CONCLUSIONS: The literature on longitudinal predictors of cessation in adolescent and young adult smokers is not well developed. Cessation interventions for this population will remain less than optimally effective until there is a solid evidence base on which to develop interventions.

Case studies and mathematical models of ecological speciation. 1. Cichlids in a crater lake.

A recent study of a pair of sympatric species of cichlids in Lake Apoyo in Nicaragua is viewed as providing probably one of the most convincing examples of sympatric speciation to date. Here, we describe and study a stochastic, individual-based, explicit genetic model tailored for this cichlid system. Our results show that relatively rapid (<20,000 generations) colonization of a new ecological niche and (sympatric or parapatric) speciation via local adaptation and divergence in habitat and mating preferences are theoretically plausible if: (i) the number of loci underlying the traits controlling local adaptation, and habitat and mating preferences is small; (ii) the strength of selection for local adaptation is intermediate; (iii) the carrying capacity of the population is intermediate; and (iv) the effects of the loci influencing nonrandom mating are strong. We discuss patterns and timescales of ecological speciation identified by our model, and we highlight important parameters and features that need to be studied empirically to provide information that can be used to improve the biological realism and power of mathematical models of ecological speciation.

Genome-wide association identifies nine common variants associated with fasting proinsulin levels and provides new insights into the pathophysiology of type 2 diabetes.

OBJECTIVE: Proinsulin is a precursor of mature insulin and C-peptide. Higher circulating proinsulin levels are associated with impaired β-cell function, raised glucose levels, insulin resistance, and type 2 diabetes (T2D). Studies of the insulin processing pathway could provide new insights about T2D pathophysiology. RESEARCH DESIGN AND METHODS: We have conducted a meta-analysis of genome-wide association tests of ∼2.5 million genotyped or imputed single nucleotide polymorphisms (SNPs) and fasting proinsulin levels in 10,701 nondiabetic adults of European ancestry, with follow-up of 23 loci in up to 16,378 individuals, using additive genetic models adjusted for age, sex, fasting insulin, and study-specific covariates. RESULTS: Nine SNPs at eight loci were associated with proinsulin levels (P < 5 × 10(-8)). Two loci (LARP6 and SGSM2) have not been previously related to metabolic traits, one (MADD) has been associated with fasting glucose, one (PCSK1) has been implicated in obesity, and four (TCF7L2, SLC30A8, VPS13C/C2CD4A/B, and ARAP1, formerly CENTD2) increase T2D risk. The proinsulin-raising allele of ARAP1 was associated with a lower fasting glucose (P = 1.7 × 10(-4)), improved β-cell function (P = 1.1 × 10(-5)), and lower risk of T2D (odds ratio 0.88; P = 7.8 × 10(-6)). Notably, PCSK1 encodes the protein prohormone convertase 1/3, the first enzyme in the insulin processing pathway. A genotype score composed of the nine proinsulin-raising alleles was not associated with coronary disease in two large case-control datasets. CONCLUSIONS: We have identified nine genetic variants associated with fasting proinsulin. Our findings illuminate the biology underlying glucose homeostasis and T2D development in humans and argue against a direct role of proinsulin in coronary artery disease pathogenesis.

CLIL Materials in Chemistry and English: Iodometric Titrations

Content and Language Integrated Learning (CLIL)Materials in Chemistry and English following the principles of CLIL / Content-based Instruction and Task-based Learning

Stochastic models and numerical algorithms for a class of regulatory gene networks.

Regulatory gene networks contain generic modules, like those involving feedback loops, which are essential for the regulation of many biological functions (Guido et al. in Nature 439:856-860, 2006). We consider a class of self-regulated genes which are the building blocks of many regulatory gene networks, and study the steady-state distribution of the associated Gillespie algorithm by providing efficient numerical algorithms. We also study a regulatory gene network of interest in gene therapy, using mean-field models with time delays. Convergence of the related time-nonhomogeneous Markov chain is established for a class of linear catalytic networks with feedback loops.

Metric Training for the Transportation Industry Module II - Construction and Maintenance Operations and Reporting, HR-376

"Metric Training For The Highway Industry", HR-376 was designed to produce training materials for the various divisions of the Iowa DOT, local government and the highway construction industry. The project materials were to be used to introduce the highway industry in Iowa to metric measurements in their daily activities. Five modules were developed and used in training over 1,000 DOT, county, city, consultant and contractor staff in the use of metric measurements. The training modules developed deal with the planning through operation areas of highway transportation. The materials and selection of modules were developed with the aid of an advisory personnel from the highway industry. Each module is design as a four hour block of instruction and a stand along module for specific types of personnel. Each module is subdivided into four chapters with chapter one and four covering general topics common to all subjects. Chapters two and three are aimed at hands on experience for a specific group and subject. This module includes: Module 2 - Construction and Maintenance Operations and Reporting. This module provides hands on examples of applications of metric measurements in the construction and maintenance field operations.

Metric Training for the Transportation Industry Module III - Road and Bridge Design, HR-376

"Metric Training For The Highway Industry", HR-376 was designed to produce training materials for the various divisions of the Iowa DOT, local government and the highway construction industry. The project materials were to be used to introduce the highway industry in Iowa to metric measurements in their daily activities. Five modules were developed and used in training over 1,000 DOT, county, city, consultant and contractor staff in the use of metric measurements. The training modules developed deal with the planning through operation areas of highway transportation. The materials and selection of modules were developed with the aid of an advisory personnel from the highway industry. Each module is design as a four hour block of instruction and a stand along module for specific types of personnel. Each module is subdivided into four chapters with chapter one and four covering general topics common to all subjects. Chapters two and three are aimed at hands on experience for a specific group and subject. This module includes: Module 3 - Road and Bridge Design. This module provides hands on examples of how to use metric measurements in the design of roads and structures.

Metric Training for the Transportation Industry Module IV - Transportation Planning and Traffic Monitoring, HR-376

"Metric Training For The Highway Industry", HR-376 was designed to produce training materials for the various divisions of the Iowa DOT, local government and the highway construction industry. The project materials were to be used to introduce the highway industry in Iowa to metric measurements in their daily activities. Five modules were developed and used in training over 1,000 DOT, county, city, consultant and contractor staff in the use of metric measurements. The training modules developed deal with the planning through operation areas of highway transportation. The materials and selection of modules were developed with the aid of an advisory personnel from the highway industry. Each module is design as a four hour block of instruction and a stand along module for specific types of personnel. Each module is subdivided into four chapters with chapter one and four covering general topics common to all subjects. Chapters two and three are aimed at hands on experience for a specific group and subject. This module includes: Module 4 - Transportation Planning and Traffic Monitoring. Hands on examples of applications of metric measurements in the development of planning reports and traffic data collection are included in this module.