Itemset Mining over Large Transactional Tables on the Relational Databases

Abstract

Most of the itemset mining approaches are memory-like and run outside of the database. On the other hand, when we deal with data warehouse the size of tables is extremely huge for memory copy. In addition, using a pure SQL-like approach is quite inefficient. Actually, those implementations rarely take advantages of database programming. Furthermore, RDBMS vendors offer a lot of features for taking control and management of the data. We purpose a pattern growth mining approach by means of database programming for finding all frequent itemsets. The main idea is to avoid one-at-a-time record retrieval from the database, saving both the copying and process context switching, expensive joins, and table reconstruction. The empirical evaluation of our approach shows that runs competitively with the most known itemset mining implementations based on SQL. Our performance evaluation was made with SQL Server 2000 (v.8) and T-SQL, throughout several synthetical datasets.

Authors and Affiliations

Arun Pratap Srivastava, Prof. (Dr) Mohd. Hussain

Keywords

Related Articles

EEG-Based Multi-Class Emotion Recognition using Hybrid LSTM Approach

Emotion recognition is a crucial task in human-computer interaction, psychology, and neuroscience. Electroencephalogram (EEG)-based multi-class emotion recognition is a novel approach that aims to identify and classify h...

Optimization and Analysis of Drive Shaft Using CAE Tools

Drive shaft or propeller shaft is the essential part of Automobiles. It is used to deliver torque from transmission to the differential and further to the wheel to cause the motion of the vehicle. The drive shaft is used...

Advancing Surgical Imaging with cGAN for Effective Defogging

Image-based defogging technology can significantly enhance intraoperative image quality and shows great promise in various medical fields. A new image removal algorithm based on conditional generative adversarial network...

A Review Article On Enhancing Email Spam Filter’s Accuracy Using Machine Learning

In today’s era, almost everyone is using emails on their daily basis. In our proposed research, we suggest a machine learning-based strategy for enhancing email spam filters' accuracy. Traditional rule-based filters have...

Enhancing Vehicle Navigation and Safety through Integration of Pre-Recorded Maps with Vehicle Control Unit

Powerful navigation and safety systems are vital to ensuring autonomous (DV) or semi-autonomous vehicles continue well in varied environmental conditions. However, in such a world those who depend on that internet connec...

Download PDF file
  • EP ID EP744572
  • DOI -
  • Views 11
  • Downloads 0

How To Cite

Arun Pratap Srivastava, Prof. (Dr) Mohd. Hussain (2013). Itemset Mining over Large Transactional Tables on the Relational Databases. International Journal of Innovative Research in Computer Science and Technology, 1(1), -. https://europub.co.uk/articles/-A-744572