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.

Readout electronics for low dark count pixel detectors based on geiger mode avalanche photodiodes fabricated in conventional CMOS technologies for future linear colliders

The high sensitivity and excellent timing accuracy of Geiger mode avalanche photodiodes makes them ideal sensors as pixel detectors for particle tracking in high energy physics experiments to be performed in future linear colliders. Nevertheless, it is well known that these sensors suffer from dark counts and afterpulsing noise, which induce false hits (indistinguishable from event detection) as well as an increase of the necessary area of the readout system. In this work, we present a comparison between APDs fabricated in a high voltage 0.35 µm and a high integration 0.13 µm commercially available CMOS technologies that has been performed to determine which of them best fits the particle collider requirements. In addition, a readout circuit that allows low noise operation is introduced. Experimental characterization of the proposed pixel is also presented in this work.

Low dark count geiger mode avalanche photodiodes fabricated in conventional CMOS technologies

Avalanche photodiodes operated in the Geiger mode present very high intrinsic gain and fast time response, which make the sensor an ideal option for those applications in which detectors with high sensitivity and velocity are required. Moreover, they are compatible with conventional CMOS technologies, allowing sensor and front-end electronics integration within the pixel cell. Despite these excellent qualities, the photodiode suffers from high intrinsic noise, which degrades the performance of the detector and increases the memory area to store the total amount of information generated. In this work, a new front-end circuit that allows low reverse bias overvoltage sensor operation to reduce the noise in Geiger mode avalanche photodiode pixel detectors is presented. The proposed front-end circuit also enables to operate the sensor in the gated acquisition mode to further reduce the noise. Experimental characterization of the fabricated pixel with the conventional HV-AMS 0.35µm technology is also presented in this article.

Removal of phenol and conventional pollutants from aqueous effluent by chitosan and chitin

The present study deals with phenol adsorption on chitin and chitosan and removal of contaminants from wastewater of a petroleum refinery. The adsorption kinetic data were best fitted to first- and second-order models for chitosan and chitin, respectively. The results of adsorption isotherms showed Langmuir model more appropriately described than a Freundlich model for both adsorbents. The adsorption capacity was 1.96 and 1.26 mg/g for chitin and chitosan, respectively. Maximum removal of phenol was about 70-80% (flow rate: 1.5 mL/min, bed height: 18.5 cm, and 30 mg/L of phenol. Wastewater treatment with chitin in a fixed-bed system showed reductions of about 52 and 92% for COD and oil and greases, and for chitosan 65 and 67%, respectively. The results show improvement of the effluent quality after treatment with chitin and chitosan.

Influência das condições de resfriamento sobre as propriedades superficiais e eletroquímicas de anodos dimensionalmente estáveis

Surface and electrochemical properties of the dimensionally stable anode Ti/(Ru0.3Ti0.7)O2 were studied as a function of the annealing temperature using different conditions in order to perform the cooling process of the oxide films (conventional thermal shock and the slow cooling processes). It was found that surface and electrochemical properties for the oxygen evolution reaction are both affected through the cooling process, being the electrode prepared at 400 ºC using the slow cooling process the less susceptible to wear. The Tafel slope obtained in the high overpotential domain was analysed in light of the apparent charge transfer coefficient.

Determination of polyphenol contents and antioxidant capacity of no-alcoholic red grape products (vitis labrusca) from conventional and organic crops

The polyphenol contents and antioxidant capacity of Brazilian red grape juices and wine vinegars were analyzed. Additionally, it was analyzed the human polyphenol absorption and acute effect in plasmatic oxidative metabolism biomarkers after juice ingestion. The organic Bordo grape juice (GBO) presented a higher level of trans-resveratrol, quercitin, rutin, gallic acid, caffeic acid and total flavonoids then other juices and vinegars as well as antioxidant capacity. The plasmatic polyphenol increased 27.2% after GBO juice ingestion. The results showed that juices and vinegars from Brazilian crops present similar chemical and functional properties described in studies performed in other countries.

Interaction between cationic and conventional nonionic surfactants in the mixed micelle and monolayer formed in aqueous medium

Mixed micellization and surface properties of cationic and nonionic surfactants dimethyl decyl-, tetradecyl- and hexadecyl phosphineoxide mixtures are studied using conductivity and surface tension measurements. The models of Rubingh, Rosen, and Clint, are used to obtain the interaction parameter, minimum area per molecule, mixed micelle composition, free energies of mixing and activity coefficients. The micellar mole fractions were always higher than ideal values indicating high contributions of cationics in mixed micelles. Activity coefficients were less than unity indicating synergism in micelles. The negative free energies of mixing showed the stability of the surfactants in the mixed micelles.

Kinetic modeling of the biosorption of Cd2+ ions from aqueous solutions onto Eichhornia crassipes roots using potentiometry: low-cost alternative to conventional methods

This work presents the use of potentiometric measurements for kinetic studies of biosorption of Cd2+ ions from aqueous solutions on Eichhornia crassipes roots. The open circuit potential of the Cd/Cd2+ electrode of the first kind was measured during the bioadsorption process. The amount of Cd2+ ions accumulated was determined in real time. The data were fit to different models, with the pseudo-second-order model proving to be the best in describing the data. The advantages and limitations of the methodology proposed relative to the traditional method are discussed.

Conventional and novel cardiovascular risk factors in young Finns and their associations with structural and functional vascular changes of subclinical atherosclerosis. The Cardiovascular Risk in Young Finns Study

Background: Atherosclerosis begins in early life progressing from asymptomatic to symptomatic as we age. Although substantial progress has been made in identifying the determinants of atherosclerosis in middle to older age adults at increased cardiovascular risk, there is lack of data examining determinants and prediction of atherosclerosis in young adults. Aims: The current study was designed to investigate levels of cardiovascular risk factors in young adults, subclinical measures of atherosclerosis, and prediction of subclinical arterial changes with conventional risk factor measures and novel metabolic profiling of serum samples. Subjects and Methods: This thesis utilised data from the follow-ups performed in 2001 and 2007 in the Cardiovascular Risk in Young Finns study, a Finnish population-based prospective cohort study that examined 2,204 subjects who were aged 30-45 years in 2007. Subclinical atherosclerosis was studied using noninvasive ultrasound measurements of carotid intima-media thickness (IMT), carotid arterial distensibility (CDist) and brachial flow-mediated dilation (FMD). Measurements included conventional risk factors and metabolic profiling using highthroughput nuclear magnetic resonance (NMR) methods that provided data on 42 lipid markers and 16 circulating metabolites. Results: Trends in lipids were favourable between 2001 and 2007, whereas waist circumference, fasting glucose, and blood pressure levels increased. To study the stability of noninvasive ultrasound markers, 6-year tracking (the likelihood to maintain the original fractile over time) in 6 years was examined. IMT tracked more strongly than CDist and FMD. Cardiovascular risk scores (Framingham, SCORE, Finrisk, Reynolds and PROCAM) predicted subclinical atherosclerosis equally. Lipoprotein subclass testing did not improve the prediction of subclinical atherosclerosis over and above conventional risk factors. However, circulating metabolites improved risk stratification. Tyrosine and docosahexaenoic acid were found to be novel biomarkers of high IMT. Conclusions: Prediction of cardiovascular risk in young Finnish adults can be performed with any of the existing risk scores. The addition of metabonomics to risk stratification improves prediction of subclinical changes and enables more accurate targeting of prevention at an early stage.

Temporal variability of soil CO2 emission after conventional and reduced tillage described by an exponential decay in time model

To study Assessing the impact of tillage practices on soil carbon losses dependents it is necessary to describe the temporal variability of soil CO2 emission after tillage. It has been argued that large amounts of CO2 emitted after tillage may serve as an indicator for longer-term changes in soil carbon stocks. Here we present a two-step function model based on soil temperature and soil moisture including an exponential decay in time component that is efficient in fitting intermediate-term emission after disk plow followed by a leveling harrow (conventional), and chisel plow coupled with a roller for clod breaking (reduced) tillage. Emission after reduced tillage was described using a non-linear estimator with determination coefficient (R²) as high as 0.98. Results indicate that when emission after tillage is addressed it is important to consider an exponential decay in time in order to predict the impact of tillage in short-term emissions.

Control system for forced-air cooling of horticultural products

This work is a study of the implementation of a classical controller using a tuning method referred to as IMC (Internal Model Control) and aimed at the reduction of electrical energy consumption by the appropriate relation between energy consumption and the cooling time with forced air. The supervisory system installed was able to manipulate the variable of frequency of the signal power of the exhaust fan engine (forced air module), to accelerate or decelerate the loss of heat from the product to be cooled by airflow variation that passes through the mass of the produce. The results demonstrated a reduction in energy consumption from 64% and an increase of only 8% in the cooling time to the system using PI/IMC (Proportional - Integral with IMC) tuning method compared with the system in its operating nominal condition. This PI/IMC control may be implemented directly in a frequency converter, without the need to purchase a computer or PLC (programmable logic controller) to run the dedicated application, increasing its economical viability.

Modeling and simulation of forced-air cooling of strawberries using variable convective coefficient

In the forced-air cooling process of fruits occurs, besides the convective heat transfer, the mass transfer by evaporation. The energy need in the evaporation is taken from fruit that has its temperature lowered. In this study it has been proposed the use of empirical correlations for calculating the convective heat transfer coefficient as a function of surface temperature of the strawberry during the cooling process. The aim of this variation of the convective coefficient is to compensate the effect of evaporation in the heat transfer process. Linear and exponential correlations are tested, both with two adjustable parameters. The simulations are performed using experimental conditions reported in the literature for the cooling of strawberries. The results confirm the suitability of the proposed methodology.

Crop coefficient and water consumption of eggplant in no-tillage system and conventional soil preparation

Under organic management in Seropédica-RJ, Brazil, using a weighing lysimeter, the crop coefficients (kc), the maximum evapotranspiration and the productivity of eggplant cultivation under two cropping systems (no tillage with straw plus soil with conventional preparation) were determined. A whole randomized layout with two treatments (no tillage and conventional) and five replicates during 134 days of cultivation were adopted. There were no significant differences in the eggplant cultivation in the two cropping systems, with a maximum commercial productivity obtained from 47.42 Mg ha-1 for the no-tillage system, and 47.91 Mg ha-1 for the conventional tillage. The accumulated ETc was 285.15 and 323.44 mm for the no-tillage and conventional, respectively. The crop coefficients value for the phases: 1 - transplanting, flowering, 2 - flowering-fruiting, 3 - fruit- first harvesting, 4- first harvesting of the final crop cycle was 0.83, 0.77, 0.90 and 0.97 in no-tillage system for the respective phases and for the conventional one 0.81, 1.14, 1.17 and 1.05 for the same steps described above.

The impact of evaporative cooling on the thermoregulation and sensible heat loss of sows during farrowing

Pigs are more sensitive to high environmental temperatures explained by the inability of sweating and panting properly when compared to other species of farmed livestock. The evaporative cooling system might favor the thermal comfort of animals during exposure to extreme environmental heat and reduce the harmful effects of heat stress. The purpose of this study was to assess the sensible heat loss and thermoregulation parameters from lactating sows during summer submitted to two different acclimatization systems: natural and evaporative cooling. The experiment was carried out in a commercial farm with 72 lactating sows. The ambient variables (temperature, relative humidity and air velocity) and sows physiological parameters (rectal temperature, surface temperature and respiratory rate) were monitored and then the sensible heat loss at 21days lactation was calculated. The results of rectal temperature did not differ between treatments. However, the evaporative cooling led to a significant reduction in surface temperature and respiratory rate and a significant increase in the sow's sensible heat loss. It was concluded that the use of evaporative cooling system was essential to increase sensible heat loss; thus, it should reduce the negative effects of heat on the sows' thermoregulation during summer.

Surface transformation hardening of carbon steel with high power fiber laser

This study investigated the surface hardening of steels via experimental tests using a multi-kilowatt fiber laser as the laser source. The influence of laser power and laser power density on the hardening effect was investigated. The microhardness analysis of various laser hardened steels was done. A thermodynamic model was developed to evaluate the thermal process of the surface treatment of a wide thin steel plate with a Gaussian laser beam. The effect of laser linear oscillation hardening (LLOS) of steel was examined. An as-rolled ferritic-pearlitic steel and a tempered martensitic steel with 0.37 wt% C content were hardened under various laser power levels and laser power densities. The optimum power density that produced the maximum hardness was found to be dependent on the laser power. The effect of laser power density on the produced hardness was revealed. The surface hardness, hardened depth and required laser power density were compared between the samples. Fiber laser was briefly compared with high power diode laser in hardening medium-carbon steel. Microhardness (HV0.01) test was done on seven different laser hardened steels, including rolled steel, quenched and tempered steel, soft annealed alloyed steel and conventionally through-hardened steel consisting of different carbon and alloy contents. The surface hardness and hardened depth were compared among the samples. The effect of grain size on surface hardness of ferritic-pearlitic steel and pearlitic-cementite steel was evaluated. In-grain indentation was done to measure the hardness of pearlitic and cementite structures. The macrohardness of the base material was found to be related to the microhardness of the softer phase structure. The measured microhardness values were compared with the conventional macrohardness (HV5) results. A thermodynamic model was developed to calculate the temperature cycle, Ac1 and Ac3 boundaries, homogenization time and cooling rate. The equations were numerically solved with an error of less than 10-8. The temperature distributions for various thicknesses were compared under different laser traverse speed. The lag of the was verified by experiments done on six different steels. The calculated thermal cycle and hardened depth were compared with measured data. Correction coefficients were applied to the model for AISI 4340 steel. AISI 4340 steel was hardened by laser linear oscillation hardening (LLOS). Equations were derived to calculate the overlapped width of adjacent tracks and the number of overlapped scans in the center of the scanned track. The effect of oscillation frequency on the hardened depth was investigated by microscopic evaluation and hardness measurement. The homogeneity of hardness and hardened depth with different processing parameters were investigated. The hardness profiles were compared with the results obtained with conventional single-track hardening. LLOS was proved to be well suitable for surface hardening in a relatively large rectangular area with considerable depth of hardening. Compared with conventional single-track scanning, LLOS produced notably smaller hardened depths while at 40 and 100 Hz LLOS resulted in higher hardness within a depth of about 0.6 mm.