Predicting your next OLAP query based on recent analytical sessions

International audienceIn Business Intelligence systems, users interact with data warehouses by formulating OLAP queries aimed at exploring multidimensional data cubes. Being able to predict the most likely next queries would provide a way to recommend interesting queries to users on the one hand, and could improve the efficiency of OLAP sessions on the other. In particular, query recommendation would proactively guide users in data exploration and improve the quality of their interactive experience. In this paper, we propose a framework to predict the most likely next query and recommend this to the user. Our framework relies on a probabilistic user behavior model built by analyzing previous OLAP sessions and exploiting a query similarity metric. To gain insight in the recommendation precision and on what parameters it depends, we evaluate our approach using different quality assessments

3D Hydrogeological Model Building Using Airborne Electromagnetic Data

We develop a 3D geological modelling procedure supported by the combination of helicopter time-domain electromagnetic data, seismic reflection data, and water well records for the Spiritwood buried valley aquifer system in Manitoba, Canada. Our procedure is an innovative hybrid of knowledge-driven and data-driven schemes that provides a clear protocol for incorporating different types of geophysical data into a 3D stratigraphic model framework. The limited spatial density of water well bedrock observations precludes detection of the buried valley bedrock topography and renders the water well records alone inadequate for accurate hydrogeological model building. The expert interpretation of the geophysical data allows for leveraging of a spatially extensive dataset with rich information content that would be otherwise difficult to utilize for lithostratigraphic classification

MULTIDISCIPLINARY STUDY OF SUBSIDENCE AND SINKHOLE OCCURRENCES IN THE ACQUE ALBULE BASIN (ROMA, ITALY)

Abstract We present the results of a combined analysis of remote sensing and geophysical‐geotechnical data carried out in the Acque Albule Basin, a sinkhole prone area located close to the city of Roma, where a wide travertine wedge is present. We carried out geophysical measurements and borehole drillings over two test areas to image the subsoil where paroxysmal surficial dynamics occur. One site is marked by subsidence occurring at least since the early 2000s, whereas the other site hosts the "La Regina" and "Colonnelle" sinkhole lakes, which discharge sulfur‐carbonated waters. The stability of these two sites threatens highway, railway, and airport facilities, and this study helps to assess the geological hazard. For example, InSAR and LiDAR data helped define wide scale subsidence over the last 20 years and previously undetected small‐scale morphologies. Geophysical measurements of the latter revealed shallow and deep dissolution affecting the travertine and driving surficial paroxysmal events. Both study sites were found to lie inside a large depression located at the junction between Jurassic carbonate and Plio‐Pleistocene units in association with paleo karst morphologies in the travertine deposits and affected by the present‐past spillage of sulfurous waters. Given these elements, multidisciplinary geophysical observations are crucial for assessing and mitigating the geological risk and guiding land use planning and management

Mining and Modeling Database User Access Patterns

Abstract. We present our approach to mining and modeling the behavior of data-base users. In particular, we propose graphic models to capture the database user’s dynamic behavior and focus on applying data mining techniques to the problem of mining and modeling database user behaviors from database trace logs. The experimental results show that our approach can discover and model user behav-iors successfully.

Blast-induced liquefaction in silty sands for full-scale testing of ground improvement methods: Insights from a multidisciplinary study

In the engineering geology field increased attention has been posed in recent years to potential liquefaction mitigation interventions in susceptible sand formations. In silty sands this is a major challenge because, as the fines content increases, vibratory methods for densification become progressively less effective. An alternative mitigation technique can be the installation of Rammed Aggregate Pier\uae (RAP) columns that can increase the resistance of the soil, accounting for its lateral stress increase and for the stiffness increase from soil and RAP composite response. To investigate the influence of these factors on liquefaction resistance, full-scale blast tests were performed at a silty sand site in Bondeno (Ferrara, Italy) where liquefaction was observed after the 2012 Emilia-Romagna earthquake. A multidisciplinary team of forty researchers carried out devoted experimental activities aimed at better understanding the liquefaction process at the field scale and the effectiveness of the treatment using inter-related methods. Both natural and improved areas were investigated by in-situ tests and later subjected to controlled blasting. The blast tests were monitored with geotechnical and geophysical instrumentation, topographical surveying and geological analyses on the sand boils. Results showed the RAP effectiveness due to the improvement of soil properties within the liquefiable layer and a consequent reduction of the blast-induced liquefaction settlements, likely due to soil densification and increased lateral stress. The applied multidisciplinary approach adopted for the study allowed better understanding of the mechanism involved in the liquefaction mitigation intervention and provided a better overall evaluation of mitigation effectiveness

A systems-level analysis highlights microglial activation as a modifying factor in common epilepsies

Aims: The causes of distinct patterns of reduced cortical thickness in the common human epilepsies, detectable on neuroimaging and with important clinical consequences, are unknown. We investigated the underlying mechanisms of cortical thinning using a systems-level analysis. Methods: Imaging-based cortical structural maps from a large-scale epilepsy neuroimaging study were overlaid with highly spatially resolved human brain gene expression data from the Allen Human Brain Atlas. Cell-type deconvolution, differential expression analysis and cell-type enrichment analyses were used to identify differences in cell-type distribution. These differences were followed up in post-mortem brain tissue from humans with epilepsy using Iba1 immunolabelling. Furthermore, to investigate a causal effect in cortical thinning, cell-type-specific depletion was used in a murine model of acquired epilepsy. Results: We identified elevated fractions of microglia and endothelial cells in regions of reduced cortical thickness. Differentially expressed genes showed enrichment for microglial markers and, in particular, activated microglial states. Analysis of post-mortem brain tissue from humans with epilepsy confirmed excess activated microglia. In the murine model, transient depletion of activated microglia during the early phase of the disease development prevented cortical thinning and neuronal cell loss in the temporal cortex. Although the development of chronic seizures was unaffected, the epileptic mice with early depletion of activated microglia did not develop deficits in a non-spatial memory test seen in epileptic mice not depleted of microglia. Conclusions: These convergent data strongly implicate activated microglia in cortical thinning, representing a new dimension for concern and disease modification in the epilepsies, potentially distinct from seizure control

A systems-level analysis highlights microglial activation as a modifying factor in common epilepsies

Aims: The causes of distinct patterns of reduced cortical thickness in the common human epilepsies, detectable on neuroimaging and with important clinical consequences, are unknown. We investigated the underlying mechanisms of cortical thinning using a systems-level analysis. // Methods: Imaging-based cortical structural maps from a large-scale epilepsy neuroimaging study were overlaid with highly spatially resolved human brain gene expression data from the Allen Human Brain Atlas. Cell-type deconvolution, differential expression analysis and cell-type enrichment analyses were used to identify differences in cell-type distribution. These differences were followed up in post-mortem brain tissue from humans with epilepsy using Iba1 immunolabelling. Furthermore, to investigate a causal effect in cortical thinning, cell-type specific depletion was used in a murine model of acquired epilepsy. // Results: We identified elevated fractions of microglia and endothelial cells in regions of reduced cortical thickness. Differentially expressed genes showed enrichment for microglial markers, and in particular, activated microglial states. Analysis of post-mortem brain tissue from humans with epilepsy confirmed excess activated microglia. In the murine model, transient depletion of activated microglia during the early phase of the disease development prevented cortical thinning and neuronal cell loss in the temporal cortex. Although the development of chronic seizures was unaffected, the epileptic mice with early depletion of activated microglia did not develop deficits in a non-spatial memory test seen in epileptic mice not depleted of microglia. // Conclusions: These convergent data strongly implicate activated microglia in cortical thinning, representing a new dimension for concern and disease modification in the epilepsies, potentially distinct from seizure control

A database of the coseismic effects following the 30 October 2016 Norcia earthquake in Central Italy

We provide a database of the coseismic geological surface effects following the Mw 6.5 Norcia earthquake that hit central Italy on 30 October 2016. This was one of the strongest seismic events to occur in Europe in the past thirty years, causing complex surface ruptures over an area of >400 km 2. The database originated from the collaboration of several European teams (Open EMERGEO Working Group; about 130 researchers) coordinated by the Istituto Nazionale di Geofisica e Vulcanologia. The observations were collected by performing detailed field surveys in the epicentral region in order to describe the geometry and kinematics of surface faulting, and subsequently of landslides and other secondary coseismic effects. The resulting database consists of homogeneous georeferenced records identifying 7323 observation points, each of which contains 18 numeric and string fields of relevant information. This database will impact future earthquake studies focused on modelling of the seismic processes in active extensional settings, updating probabilistic estimates of slip distribution, and assessing the hazard of surface faulting