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 72
- Downloads 0
Effects of Climate Change on Wildlife: A Review Paper
Changing climate events and environment changes will significantly affect biological systems and the creatures that live inside them. As the temperature rises, earthly natural surroundings systems are expected to move aw...
The Importance of Happiness and Its Relevance
There has been a lot of interest in fulfillment all through the most recent decade filled by improvements in neuroscience and the evaluation of joy. Positive frontal cortex science has arisen as an obvious solicitation i...
Comparison of Design Response Spectra in SNI 1726:2012 and SNI 1726:2019
At the end of 2019, the Indonesian National Standards Agency issued new regulations regarding procedures for earthquake resistance planning in building and non-building structures or SNI 1726:2019. The existence of new r...
Intent Search: Survey on Various Methods of Image Re-ranking
Image re-ranking is an effective way for improving the result of web-based image search. To refine the text-based image search result image search re-ranking is the best approach. In this Paper, we give the different met...
Twitter Data Classification by Applying and Comparing Multiple Machine Learning Techniques
Having an average of five hundred million tweets sent out per day, twitter has become one of the largest platforms of data analysis for the researchers. Previously, various researches have been conducted on twitter data...