Explanation in OLAP Data Cubes

2014 ◽  
Vol 7 (4) ◽  
pp. 63-78 ◽  
Author(s):  
Rahhal Errattahi ◽  
Mohammed Fakir ◽  
Fatima Zahra Salmam

OLAP is an important technology that offers a fast and interactive data navigation, it also provides tools to explore data cubes in order to extract interesting information from a multidimensional data structures. However, the OLAP exploration is done manually, without tools that could automatically extract relevant information from the cube. In addition OLAP is not capable of explaining relationships that could exist within data. This paper presents a new approach to coupling between data mining and online analytical processing. Its approach provides the explanation in OLAP data cubes by using the association rules between the inter-dimensional predicates. The mining process could be done by one of the two algorithms, Apriori and Fp-Growth, in which aggregate measures to calculate support and confidence are exploited. It also evaluates the interestingness of mined association rules according to the Lift criteria.

2008 ◽  
pp. 303-335
Author(s):  
Haorianto Cokrowijoyo Tjioe ◽  
David Taniar

Data mining applications have enormously altered the strategic decision-making processes of organizations. The application of association rules algorithms is one of the well-known data mining techniques that have been developed to cope with multidimensional databases. However, most of these algorithms focus on multidimensional data models for transactional data. As data warehouses can be presented using a multidimensional model, in this paper we provide another perspective to mine association rules in data warehouses by focusing on a measurement of summarized data. We propose four algorithms — VAvg, HAvg, WMAvg, and ModusFilter — to provide efficient data initialization for mining association rules in data warehouses by concentrating on the measurement of aggregate data. Then we apply those algorithms both on a non-repeatable predicate, which is known as mining normal association rules, using GenNLI, and a repeatable predicate using ComDims and GenHLI, which is known as mining hybrid association rules.


Author(s):  
Martin Burgard ◽  
Franca Piazza

The increased use of information technology leads to the generation of huge amounts of data which have to be stored and analyzed by appropriate systems. Data warehouse systems allow the storage of these data in a special multidimensional data base. Based on a data warehouse, business intelligence systems provide different analysis methods such as online analytical processing (OLAP) and data mining to analyze these data. Although these systems are already widely used and the usage is still growing, their application in the area of electronic human resource management (e-HRM) is rather scarce. Therefore, the objective of this article is to depict the components and functionality of these systems and to illustrate the application possibilities and benefits of these systems by selected application examples in the context of e-HRM.


Author(s):  
Carson K.-S. Leung ◽  
Fan Jiang ◽  
Edson M. Dela Cruz ◽  
Vijay Sekar Elango

Collaborative filtering uses data mining and analysis to develop a system that helps users make appropriate decisions in real-life applications by removing redundant information and providing valuable to information users. Data mining aims to extract from data the implicit, previously unknown and potentially useful information such as association rules that reveals relationships between frequently co-occurring patterns in antecedent and consequent parts of association rules. This chapter presents an algorithm called CF-Miner for collaborative filtering with association rule miner. The CF-Miner algorithm first constructs bitwise data structures to capture important contents in the data. It then finds frequent patterns from the bitwise structures. Based on the mined frequent patterns, the algorithm forms association rules. Finally, the algorithm ranks the mined association rules to recommend appropriate merchandise products, goods or services to users. Evaluation results show the effectiveness of CF-Miner in using association rule mining in collaborative filtering.


2019 ◽  
Vol 12 (1) ◽  
pp. 9-12
Author(s):  
Carmen Ana Anton ◽  
Oliviu Matei ◽  
Anca Diana Avram

Abstract In the information industry there is a huge amount of data which can be used to obtain relevant information necessary for them to be processed, cleaned and analyzed. This survey paper presents different data extraction research that can be applied in various areas. The main point is to determine a new approach and to be the starting point for new experiments in agriculture predictions. The collaborative data mining approach assumes that correlated units or devices will have similar behavior that can be determined with an acceptable approximation.


Sign in / Sign up

Export Citation Format

Share Document