Prediction in OLAP Data Cubes

2016 ◽  
Vol 15 (02) ◽  
pp. 1650022
Author(s):  
Fatima Zahra Salmam ◽  
Mohamed Fakir ◽  
Rahhal Errattahi
Keyword(s):  
Data Mining ◽  
Missing Values ◽  
Knowledge Extraction ◽  
Data Cube ◽  
Multidimensional Data ◽  
Average Error ◽  
Aggregated Data ◽  
Data Cubes ◽  
Data Mining Algorithms ◽  
Mining Algorithms

Online analytical processing (OLAP) provides tools to explore data cubes in order to extract the interesting information, it refers to techniques used to query, visualise and synthesise the multidimensional data. Nevertheless OLAP is limited on visualisation, structuring and exploring manually the data cubes. On the other side, data mining allows algorithms that offer automatic knowledge extraction, such as classification, explanation and prediction algorithms. However, OLAP is not capable of explaining and predicting events from existing data; therefore, it is possible to make a more efficient online analysis by coupling data mining and OLAP to allow the user to assist in this new task of knowledge extraction. In this paper, we will carry on within works achieved in this theme and we suggest to extend the abilities of OLAP to prediction (enhancing the OLAP abilities and techniques by introducing a predictive model based on a data mining algorithms). The model is calculated on the aggregated data, and prediction is done on detailed missing data. Our approach is based on regression trees and neural networks; it consists to predict facts having a missed measures value in the data cubes. The user will have in his disposition, a new platform called PredCube, that offers the possibility to query, visualise and synthesise the multidimensional data, and also to predict missing values in the data cube using three data mining methods, and evaluate the quality of the prediction by comparing the average error and the execution time given by each one.

Applying data mining algorithms to inpatient dataset with missing values

2007 ◽  
Vol 21 (1) ◽  
pp. 81-92 ◽  
Author(s):  
Peng Liu ◽  
Elia El‐Darzi ◽  
Lei Lei ◽  
Christos Vasilakis ◽  
Panagiotis Chountas ◽  
...  
Keyword(s):  
Data Mining ◽  
Missing Values ◽  
Data Mining Algorithms ◽  
Mining Algorithms

Novel Adverse Events of Iloperidone: A Disproportionality Analysis in US Food and Drug Administration Adverse Event Reporting System (FAERS) Database

2019 ◽  
Vol 14 (1) ◽  
pp. 21-26 ◽  
Author(s):  
Viswam Subeesh ◽  
Eswaran Maheswari ◽  
Hemendra Singh ◽  
Thomas Elsa Beulah ◽  
Ann Mary Swaroop
Keyword(s):  
Data Mining ◽  
Adverse Event ◽  
Adverse Events ◽  
Reporting System ◽  
Adverse Event Reporting System ◽  
Adverse Event Reporting ◽  
Disproportionality Analysis ◽  
Positive Signal ◽  
Data Mining Algorithms ◽  
Mining Algorithms

Background: The signal is defined as “reported information on a possible causal relationship between an adverse event and a drug, of which the relationship is unknown or incompletely documented previously”. Objective: To detect novel adverse events of iloperidone by disproportionality analysis in FDA database of Adverse Event Reporting System (FAERS) using Data Mining Algorithms (DMAs). Methodology: The US FAERS database consists of 1028 iloperidone associated Drug Event Combinations (DECs) which were reported from 2010 Q1 to 2016 Q3. We consider DECs for disproportionality analysis only if a minimum of ten reports are present in database for the given adverse event and which were not detected earlier (in clinical trials). Two data mining algorithms, namely, Reporting Odds Ratio (ROR) and Information Component (IC) were applied retrospectively in the aforementioned time period. A value of ROR-1.96SE>1 and IC- 2SD>0 were considered as the threshold for positive signal. Results: The mean age of the patients of iloperidone associated events was found to be 44years [95% CI: 36-51], nevertheless age was not mentioned in twenty-one reports. The data mining algorithms exhibited positive signal for akathisia (ROR-1.96SE=43.15, IC-2SD=2.99), dyskinesia (21.24, 3.06), peripheral oedema (6.67,1.08), priapism (425.7,9.09) and sexual dysfunction (26.6-1.5) upon analysis as those were well above the pre-set threshold. Conclusion: Iloperidone associated five potential signals were generated by data mining in the FDA AERS database. The result requires an integration of further clinical surveillance for the quantification and validation of possible risks for the adverse events reported of iloperidone.

scholarly journals Simple Correlation Between Weather and COVID-19 Pandemic Using Data Mining Algorithms

2020 ◽  
Vol 982 ◽  
pp. 012015
Author(s):  
Ari Fadli ◽  
Azis Wisnu Widhi Nugraha ◽  
Muhammad Syaiful Aliim ◽  
Acep Taryana ◽  
Yogiek Indra Kurniawan ◽  
...  
Keyword(s):  
Data Mining ◽  
Simple Correlation ◽  
Data Mining Algorithms ◽  
Using Data ◽  
Mining Algorithms

Predicting effects of selected impregnation processes on the observed bending strength of wood, with use of data mining models

BioResources ◽  
2021 ◽  
Vol 16 (3) ◽  
pp. 4891-4904
Author(s):  
Selahattin Bardak ◽  
Timucin Bardak ◽  
Hüseyin Peker ◽  
Eser Sözen ◽  
Yildiz Çabuk
Keyword(s):  
Data Mining ◽  
Goodness Of Fit ◽  
Bending Strength ◽  
Wood Preservation ◽  
Ambient Conditions ◽  
Data Mining Algorithms ◽  
Use Of Data ◽  
The Cost ◽  
Mining Algorithms ◽  
The Relationship

Wood materials have been used in many products such as furniture, stairs, windows, and doors for centuries. There are differences in methods used to adapt wood to ambient conditions. Impregnation is a widely used method of wood preservation. In terms of efficiency, it is critical to optimize the parameters for impregnation. Data mining techniques reduce most of the cost and operational challenges with accurate prediction in the wood industry. In this study, three data-mining algorithms were applied to predict bending strength in impregnated wood materials (Pinus sylvestris L. and Millettia laurentii). Models were created from real experimental data to examine the relationship between bending strength, diffusion time, vacuum duration, and wood type, based on decision trees (DT), random forest (RF), and Gaussian process (GP) algorithms. The highest bending strength was achieved with wenge (Millettia laurentii) wood in 10 bar vacuum and the diffusion condition during 25 min. The results showed that all algorithms are suitable for predicting bending strength. The goodness of fit for the testing phase was determined as 0.994, 0.986, and 0.989 in the DT, RF, and GP algorithms, respectively. Moreover, the importance of attributes was determined in the algorithms.

Sign in / Sign up

Export Citation Format

Share Document