Modernizing Secure OLAP Applications with a Model-Driven Approach

The majority of the organizations store their historical business information in data warehouses which are queried to make strategic decisions by using online analytical processing (OLAP) tools. This information has to be correctly assured against unauthorized accesses, but nevertheless there are a great amount of legacy OLAP applications that have been developed without considering security aspects or these have been incorporated once the system was implemented. This work defines a reverse engineering process that allows us to obtain the conceptual model corresponding to a legacy OLAP application, and also analyses and represents the security aspects that could have established. This process has been aligned with a model-driven architecture for developing secure OLAP applications by defining the transformations needed to automatically apply it. Once the conceptual model has been extracted, it can be easily modified and improved with security, and automatically transformed to generate the new implementation.

Enhancing QA systems with complex temporal question processing capabilities

This paper presents a multilayered architecture that enhances the capabilities of current QA systems and allows different types of complex questions or queries to be processed. The answers to these questions need to be gathered from factual information scattered throughout different documents. Specifically, we designed a specialized layer to process the different types of temporal questions. Complex temporal questions are first decomposed into simple questions, according to the temporal relations expressed in the original question. In the same way, the answers to the resulting simple questions are recomposed, fulfilling the temporal restrictions of the original complex question. A novel aspect of this approach resides in the decomposition which uses a minimal quantity of resources, with the final aim of obtaining a portable platform that is easily extensible to other languages. In this paper we also present a methodology for evaluation of the decomposition of the questions as well as the ability of the implemented temporal layer to perform at a multilingual level. The temporal layer was first performed for English, then evaluated and compared with: a) a general purpose QA system (F-measure 65.47% for QA plus English temporal layer vs. 38.01% for the general QA system), and b) a well-known QA system. Much better results were obtained for temporal questions with the multilayered system. This system was therefore extended to Spanish and very good results were again obtained in the evaluation (F-measure 40.36% for QA plus Spanish temporal layer vs. 22.94% for the general QA system).

Image processing for safety assessment in Civil Engineering

Behaviour analysis of construction safety systems is of fundamental importance to avoid accidental injuries. Traditionally, measurements of dynamic actions in Civil Engineering have been done through accelerometers, but high-speed cameras and image processing techniques can play an important role in this area. Here, we propose using morphological image filtering and Hough transform on high-speed video sequence as tools for dynamic measurements on that field. The presented method is applied to obtain the trajectory and acceleration of a cylindrical ballast falling from a building and trapped by a thread net. Results show that safety recommendations given in construction codes can be potentially dangerous for workers.

Corn stover thermal decomposition in pyrolytic and oxidant atmosphere

The pyrolysis and combustion of corn stover were studied by dynamic thermogravimetry and derivate thermogravimetry (TG-DTG) at heating rates of 5, 10, 20 and 50 K min−1 at atmospheric pressure. For the simulation of pyrolysis and combustion processes a kinetic model based on the distribution of activation energies was used, with three pools of reactants (three pseudocomponents) because of the complexity of the biomass samples of agricultural origin. The experimental thermogravimetric data of pyrolysis and combustion processes were simultaneously fitted to determine a single set of kinetic parameters able to describe both processes at the different heating rates. The model proposed achieves a good correlation between the experimental and calculated curves, with an error of less than 4% for fitting four heating rates simultaneously. The experimental results and kinetic parameters may provide useful data for the design of thermo decomposition processing system using corn stover as feedstock. On the other hand, analysis of the main compounds in the evolved gas is given by means of a microcromatograph.

Optimisation of analytical methods for the characterisation of oranges, clementines and citrus hybrids cultivated in Spain on the basis of their composition in ascorbic acid, citric acid and major sugars

Three HPLC methods were optimised for the determination of citric acid, succinic acid and ascorbic acid using a photodiode array detector and fructose, glucose and sucrose using a refractive index in twenty eight citrus juices. The analysis was completed in <16 min. Two different harvests were taken into account for this study. For the season 2011, ascorbic acid content was comprised between 19.4 and 59 mg vitamin C/100 mL; meanwhile for the season 2012, the content was slightly higher for most of the samples ranging from 33.5 to 85.3 mg vitamin C/100 mL. Moreover, the citric acid content in orange juices ranged between 9.7 and 15.1 g L−1, while for clementines the content was clearly lower (i.e. from 3.5 to 8.4 g L−1). However, clementines showed the highest sucrose content with values near to 6 g/100 mL. Finally, a cluster analysis was applied to establish a classification of the citrus species.

The Gaia-ESO Survey: processing FLAMES-UVES spectra

The Gaia-ESO Survey is a large public spectroscopic survey that aims to derive radial velocities and fundamental parameters of about 105 Milky Way stars in the field and in clusters. Observations are carried out with the multi-object optical spectrograph FLAMES, using simultaneously the medium-resolution (R ~ 20 000) GIRAFFE spectrograph and the high-resolution (R ~ 47 000) UVES spectrograph. In this paper we describe the methods and the software used for the data reduction, the derivation of the radial velocities, and the quality control of the FLAMES-UVES spectra. Data reduction has been performed using a workflow specifically developed for this project. This workflow runs the ESO public pipeline optimizing the data reduction for the Gaia-ESO Survey, automatically performs sky subtraction, barycentric correction and normalisation, and calculates radial velocities and a first guess of the rotational velocities. The quality control is performed using the output parameters from the ESO pipeline, by a visual inspection of the spectra and by the analysis of the signal-to-noise ratio of the spectra. Using the observations of the first 18 months, specifically targets observed multiple times at different epochs, stars observed with both GIRAFFE and UVES, and observations of radial velocity standards, we estimated the precision and the accuracy of the radial velocities. The statistical error on the radial velocities is σ ~ 0.4 km s-1 and is mainly due to uncertainties in the zero point of the wavelength calibration. However, we found a systematic bias with respect to the GIRAFFE spectra (~0.9 km s-1) and to the radial velocities of the standard stars (~0.5 km s-1) retrieved from the literature. This bias will be corrected in the future data releases, when a common zero point for all the set-ups and instruments used for the survey is be established.

Applying semantic knowledge to the automatic processing of temporal expressions and events in natural language

This paper addresses the problem of the automatic recognition and classification of temporal expressions and events in human language. Efficacy in these tasks is crucial if the broader task of temporal information processing is to be successfully performed. We analyze whether the application of semantic knowledge to these tasks improves the performance of current approaches. We therefore present and evaluate a data-driven approach as part of a system: TIPSem. Our approach uses lexical semantics and semantic roles as additional information to extend classical approaches which are principally based on morphosyntax. The results obtained for English show that semantic knowledge aids in temporal expression and event recognition, achieving an error reduction of 59% and 21%, while in classification the contribution is limited. From the analysis of the results it may be concluded that the application of semantic knowledge leads to more general models and aids in the recognition of temporal entities that are ambiguous at shallower language analysis levels. We also discovered that lexical semantics and semantic roles have complementary advantages, and that it is useful to combine them. Finally, we carried out the same analysis for Spanish. The results obtained show comparable advantages. This supports the hypothesis that applying the proposed semantic knowledge may be useful for different languages.

Conversion of low density polyethylene into fuel through co-processing with vacuum gas oil in a fluid catalytic cracking riser reactor

In this work, mixtures of vacuum gas oil and low density polyethylene, a major component of common industrial and consumer household plastics, were pyrolytically co-processed in a fluid catalytic cracking (FCC) riser reactor as a viable alternative for the energy and petrochemical revalorisation of plastic wastes into valuable petrochemical feedstocks and fuel within an existing industrial technology. Using equilibrium FCC catalyst, the oil–polymer blends were catalytically cracked at different processing conditions of temperatures between 773 K and 973 K and catalyst feed ratios of 5:1, 7:1 and 10:1. The influence of each of these processing parameters on the cracking gas and liquid yield patterns were studied and presented. Further analysed and presented are the different compositional distributions of the obtained liquids and gaseous products. The analysis of the results obtained revealed that with very little modifications to existing process superstructure, yields and compositional distributions of products from the fluid catalytic cracking of the oil–polymer blend in many cases were very similar to those of the processed oil feedstock, bringing to manifest the viability of the feedstock co-processing without significant detriments to FCC product yields and quality.

Processing and Characterization of Nano-biocomposites Based on Mater-Bi® with Layered Silicates

The development of new nano-biocomposites has been one of the main research areas of interest in polymer science in recent years, since they can combine the intrinsic biodegradable nature of matrices with the ability to modify their properties by the addition of selected nano-reinforcements. In this work, the addition of mineral nanoclays (montmorillonites and sepiolites) to a commercial starch-based matrix is proposed. A complete study on their processing by melt-intercalation techniques and further evaluation of the main properties of nano-biocomposites has been carried out. The results reported show an important influence of the nano-biocomposites morphology on their final properties. In particular, the rheological and viscoelastic characteristics of these systems are very sensitive to the dispersion level of the nanofiller, but it is possible to assess that the material processing behaviour is not compromised by the presence of these nano-reinforcements. In general, both nanofillers had a positive influence in the materials final properties. Mechanical performance shows improvements in terms of elastic modulus, without important limitations in terms of ductility. Thermal properties are improved in terms of residual mass after degradation and low improvements are also observed in terms of oxygen barrier properties.

Guidelines for the design of efficient sono-microreactors

Possible drawbacks of microreactors are inefficient reactant mixing and the clogging of microchannels when solid-forming reactions are carried out or solid (catalysts) suspensions are used. Ultrasonic irradiation has been successfully implemented for solving these problems in microreactor configurations ranging from capillaries immersed in ultrasonic baths to devices with miniaturized piezoelectric transducers. Moving forward in process intensification and sustainable development, the acoustic energy implementation requires a strategy to optimize the microreactor from an ultrasound viewpoint during its design. In this work, we present a simple analytical model that can be used as a guide to achieving a proper acoustic design of stacked microreactors. An example of this methodology was demonstrated through finite element analysis and it was compared with an experimental study found in the literature.

Novel image processing approach to detect malaria

In this paper we present a novel image processing algorithm providing good preliminary capabilities for in vitro detection of malaria. The proposed concept is based upon analysis of the temporal variation of each pixel. Changes in dark pixels mean that inter cellular activity happened, indicating the presence of the malaria parasite inside the cell. Preliminary experimental results involving analysis of red blood cells being either healthy or infected with malaria parasites, validated the potential benefit of the proposed numerical approach.

Bio-based PLA_PHB plasticized blend films: Processing and structural characterization

Bio-based films formed by poly(lactic acid) (PLA) and poly(3-hydroxybutyrate) (PHB) plasticized with an oligomer of the lactic acid (OLA) were used as supporting matrices for an antibacterial agent (carvacrol). This paper reports the main features of the processing and physico-chemical characterization of these innovative biodegradable material based films, which were extruded and further submitted to filmature process. The effect of the addition of carvacrol and OLA on their microstructure, chemical, thermal and mechanical properties was assessed. The presence of these additives did not affect the thermal stability of PLA_PHB films, but resulted in a decrease in their crystallinity and in the elastic modulus for the active formulations. The obtained results showed the effective presence of additives in the PLA or the PLA_PHB matrix after processing at high temperatures, making them able to be used in active and bio-based formulations with antioxidant/antimicrobial performance.

Advances in camera trap data management tools: Towards collaborative development and integration with GIS

Camera traps have become a widely used technique for conducting biological inventories, generating a large number of database records of great interest. The main aim of this paper is to describe a new free and open source software (FOSS), developed to facilitate the management of camera-trapped data which originated from a protected Mediterranean area (SE Spain). In the last decade, some other useful alternatives have been proposed, but ours focuses especially on a collaborative undertaking and on the importance of spatial information underpinning common camera trap studies. This FOSS application, namely, “Camera Trap Manager” (CTM), has been designed to expedite the processing of pictures on the .NET platform. CTM has a very intuitive user interface, automatic extraction of some image metadata (date, time, moon phase, location, temperature, atmospheric pressure, among others), analytical (Geographical Information Systems, statistics, charts, among others), and reporting capabilities (ESRI Shapefiles, Microsoft Excel Spreadsheets, PDF reports, among others). Using this application, we have achieved a very simple management, fast analysis, and a significant reduction of costs. While we were able to classify an average of 55 pictures per hour manually, CTM has made it possible to process over 1000 photographs per hour, consequently retrieving a greater amount of data.