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

Centralized Database: A Prerequisite for Security and Sustainable Development in Nigeria

The volume of data organizations and government agencies usually collect and store are increasing rapidly. Centralized database according to Elmasri and Navathe [1] stores data or information in a particular location wit...

The Emerging Role of AI in Business Management Optimization

The technologies make the productive quality is smart and easy via Artificial Intelligence (AI) and which is possible with AI. In this era AI is used in all sectors and it is one of the fast increasing fields which is ac...

A Comprehensive Review- Building A Secure Social Media Environment for Kids- Automated Content Filtering with Biometric Feedback

This review paper is all about how important it is to use smart technology to keep kids safe on social media while helping them learn better. By adding things like better controls for parents, filters that stop bad stuff...

Security Issue on “Secure Data Storage and Transaction Logs” In Big Data

paper proposed the security issue on secure data storage and transaction logs in associated with data storage, management, and processing, though security not available in various things in big data unauthorized access m...

Congestion Modelling and Level of Service Assessment of Urban Roads in Mixed Traffic Conditions

In urban locations around the world, traffic congestion is a problem. Congestion has increased as a result of inadequate public transportation, stalled development of the road infrastructure, and increased use of private...

Download PDF file
  • EP ID EP744572
  • DOI -
  • Views 78
  • 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