A non-intrusive and reactive architecture to support real-time ETL processes in data warehousing environments.

Nowadays, organizations are very interested to gather data for strategic decision-making. Data are disposable in operational sources, which are distributed, heterogeneous, and autonomous. These data are gathered through ETL processes, which occur traditionally in a pre-defined time, that is, once a day, once a week, once a month or in a specific period of time. On the other hand, there are special applications for which data needs to be obtained in a faster way and sometimes even immediately after the data are generated in the operation data sources, such as health systems and digital agriculture. Thus, the conventional ETL process and the disposable techniques are incapable of making the operational data delivered in real-time, providing low latency, high availability, and scalability. As our proposal, we present an innovative architecture, named Data Magnet, to cope with real-time ETL processes. The experimental tests performed in the digital agriculture domain using real and synthetic data showed that our proposal was able to deal in real-time with the ETL process. The Data Magnet provided great performance, showing an almost constant elapsed time for growing data volumes. Besides, Data Magnet provided significant performance gains over the traditional trigger technique.

HPTLC-based fingerprinting: An alternative approach for fructooligosaccharides metabolism profiling.

Fructans are categorized as fructose-based metabolites with no more than one glucose in their structure. Agave species possess a mixture of linear and ramified fructans with different degrees of polymerization. Among them, fructooligosaccharides are fructans with low degree of polymerization which might be approachable by high performance thin layer chromatography (HPTLC). Thus, this study used two emblematic Agave species collected at different ages as models to explore the feasibility of HPTLC-based fingerprinting to characterize fructooligosaccharides (FOS) production, accumulation, and behavior through time. To do so, high performance anion exchange was also used as analytical reference to determine the goodness and robustness of HPTLC data. The multivariate data analysis showed separation of samples dictated by species and age effects detected by both techniques. Moreover, linear correlations between the increase of the age in agave and their carbohydrate fraction was established in both species by both techniques. Oligosaccharides found to be correlated to species and age factors, these suggest changes in specific carbohydrate metabolism enzymes. Thus, HPTLC was proven as a complementary or stand-alone fingerprinting platform for fructooligosaccharides characterization in biological mixtures. However, the type of derivatizing reagent and the extraction color channel determined the goodness of the model used to scrutinize agavin fructooligosaccharides (aFOS).

Modeling Mortality Based on Pollution and Temperature Using a New Birnbaum-Saunders Autoregressive Moving Average Structure with Regressors and Related-Sensors Data.

Environmental agencies are interested in relating mortality to pollutants and possible environmental contributors such as temperature. The Gaussianity assumption is often violated when modeling this relationship due to asymmetry and then other regression models should be considered. The class of Birnbaum-Saunders models, especially their regression formulations, has received considerable attention in the statistical literature. These models have been applied successfully in different areas with an emphasis on engineering, environment, and medicine. A common simplification of these models is that statistical dependence is often not considered. In this paper, we propose and derive a time-dependent model based on a reparameterized Birnbaum-Saunders (RBS) asymmetric distribution that allows us to analyze data in terms of a time-varying conditional mean. In particular, it is a dynamic class of autoregressive moving average (ARMA) models with regressors and a conditional RBS distribution (RBSARMAX). By means of a Monte Carlo simulation study, the statistical performance of the new methodology is assessed, showing good results. The asymmetric RBSARMAX structure is applied to the modeling of mortality as a function of pollution and temperature over time with sensor-related data. This modeling provides strong evidence that the new ARMA formulation is a good alternative for dealing with temporal data, particularly related to mortality with regressors of environmental temperature and pollution.

Lot-Size Models with Uncertain Demand Considering Its Skewness/Kurtosis and Stochastic Programming Applied to Hospital Pharmacy with Sensor-Related COVID-19 Data.

Governments have been challenged to provide timely medical care to face the COVID-19 pandemic. Under this pandemic, the demand for pharmaceutical products has changed significantly. Some of these products are in high demand, while, for others, their demand falls sharply. These changes in the random demand patterns are connected with changes in the skewness (asymmetry) and kurtosis of their data distribution. Such changes are critical to determining optimal lots and inventory costs. The lot-size model helps to make decisions based on probabilistic demand when calculating the optimal costs of supply using two-stage stochastic programming. The objective of this study is to evaluate how the skewness and kurtosis of the distribution of demand data, collected through sensors, affect the modeling of inventories of hospital pharmacy products helpful to treat COVID-19. The use of stochastic programming allows us to obtain results under demand uncertainty that are closer to reality. We carry out a simulation study to evaluate the performance of our methodology under different demand scenarios with diverse degrees of skewness and kurtosis. A case study in the field of hospital pharmacy with sensor-related COVID-19 data is also provided. An algorithm that permits us to use sensors when submitting requests for supplying pharmaceutical products in the hospital treatment of COVID-19 is designed. We show that the coefficients of skewness and kurtosis impact the total costs of inventory that involve order, purchase, holding, and shortage. We conclude that the asymmetry and kurtosis of the demand statistical distribution do not seem to affect the first-stage lot-size decisions. However, demand patterns with high positive skewness are related to significant increases in expected inventories on hand and shortage, increasing the costs of second-stage decisions. Thus, demand distributions that are highly asymmetrical to the right and leptokurtic favor high total costs in probabilistic lot-size systems.

A Two-Stage Location Problem with Order Solved Using a Lagrangian Algorithm and Stochastic Programming for a Potential Use in COVID-19 Vaccination Based on Sensor-Related Data.

Healthcare service centers must be sited in strategic locations that meet the immediate needs of patients. The current situation due to the COVID-19 pandemic makes this problem particularly relevant. Assume that each center corresponds to an assigned place for vaccination and that each center uses one or more vaccine brands/laboratories. Then, each patient could choose a center instead of another, because she/he may prefer the vaccine from a more reliable laboratory. This defines an order of preference that might depend on each patient who may not want to be vaccinated in a center where there are only her/his non-preferred vaccine brands. In countries where the vaccination process is considered successful, the order assigned by each patient to the vaccination centers is defined by incentives that local governments give to their population. These same incentives for foreign citizens are seen as a strategic decision to generate income from tourism. The simple plant/center location problem (SPLP) is a combinatorial approach that has been extensively studied. However, a less-known natural extension of it with order (SPLPO) has not been explored in the same depth. In this case, the size of the instances that can be solved is limited. The SPLPO considers an order of preference that patients have over a set of facilities to meet their demands. This order adds a new set of constraints in its formulation that increases the complexity of the problem to obtain an optimal solution. In this paper, we propose a new two-stage stochastic formulation for the SPLPO (2S-SPLPO) that mimics the mentioned pandemic situation, where the order of preference is treated as a random vector. We carry out computational experiments on simulated 2S-SPLPO instances to evaluate the performance of the new proposal. We apply an algorithm based on Lagrangian relaxation that has been shown to be efficient for large instances of the SPLPO. A potential application of this new algorithm to COVID-19 vaccination is discussed and explored based on sensor-related data. Two further algorithms are proposed to store the patient's records in a data warehouse and generate 2S-SPLPO instances using sensors.

Disjoint and Functional Principal Component Analysis for Infected Cases and Deaths Due to COVID-19 in South American Countries with Sensor-Related Data.

In this paper, we group South American countries based on the number of infected cases and deaths due to COVID-19. The countries considered are: Argentina, Bolivia, Brazil, Chile, Colombia, Ecuador, Peru, Paraguay, Uruguay, and Venezuela. The data used are collected from a database of Johns Hopkins University, an institution that is dedicated to sensing and monitoring the evolution of the COVID-19 pandemic. A statistical analysis, based on principal components with modern and recent techniques, is conducted. Initially, utilizing the correlation matrix, standard components and varimax rotations are calculated. Then, by using disjoint components and functional components, the countries are grouped. An algorithm that allows us to keep the principal component analysis updated with a sensor in the data warehouse is designed. As reported in the conclusions, this grouping changes depending on the number of components considered, the type of principal component (standard, disjoint or functional) and the variable to be considered (infected cases or deaths). The results obtained are compared to the k-means technique. The COVID-19 cases and their deaths vary in the different countries due to diverse reasons, as reported in the conclusions.

Prognostic value of hepatic encephalopathy for survival of patients with liver failure: A systematic review and meta-analysis.

INTRODUCTION AND OBJECTIVES: The aim of this paper was to evaluate the association of hepatic encephalopathy with survival of patients with liver failure. MATERIALS AND METHODS: We retrieved the relevant articles from the PubMed, Embase and Cochrane Library, up to May 2017. The pooled odds ratio (OR) as well as their 95% confidence intervals (CI) was calculated by the software of R package version 3.12. RESULTS: Total 13 studies with 2071 liver failure patients were included and reanalyzed in this meta-analysis. The results proved the prognostic value of hepatic encephalopathy for survival of patients with liver failure (OR=5.62, 95%CI=6.30-9.82, P<0.001). The subgroup analyses showed that the type of liver failure and the follow up duration may be the factor influencing the association between hepatic encephalopathy and survival of patients with liver failure. CONCLUSIONS: The results proved that hepatic encephalopathy was a prognostic factor of survival in patients with liver failure.