Itemset Mining over Large Transactional Tables on the Relational Databases
Journal Title: International Journal of Innovative Research in Computer Science and Technology - Year 2013, Vol 1, Issue 1
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
- EP ID EP744572
- DOI -
- Views 32
- Downloads 0
Automatic Fruit Defect Detection Using HSV and RGB Color Space Model
This paper presents the development and application of image analysis and computer vision system in defect detection of fruit surface in the agricultural field. Computer vision is a rapid, consistent inspection technique...
Study on the Anti-snake venom property of Cabbage
Snake poison causes death and tissue disfiguration among the rural people. Though anti-dote or anti-snake venom serum is freely accessible at government health care facilities but is hampered by poor handling, storage an...
Floating Gate MOSFET Based Differential Amplifier and Impact of Body Bias
In this work, a floating gate MOSFET (FGFET) based single-ended differential amplifier with current mirror active load is designed and analyzed along with the body bias. The input transistors of the differential block ar...
Overview on Green Concrete Comprised of Farming Waste Residues
The rising global market for construction has resulted in an increase in the usage of concrete. On the other hand, traditional concrete-making materials are not totally ecologically friendly, driving research towards gre...
Prediction of Health Care Data Using Efficient Machine Learning Algorithms
Every clinical decision relies on the doctor's expertise and comprehension.This standard procedure may, despite appearances, lead to errors, biases, and increased costs that compromise the patients' Quality of Service (Q...