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 91
- Downloads 0
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...
Gamification in the Classroom
Technology Enhanced Language Learning (TELL) is the buzzword of new learning strategies in the classroom. Game-based applications used in the classroom can investigate the interest generated and performance in learning....
Virtual Reallity in Gaming
Augmented reality (VR) gaming is another sort of PC game which utilizes computer generated reality (VR) innovations that can give clients a totally practical, first-individual viewpoint of the game activity. Designing mu...
A New Technique of Automated Sericulture Based on IoT
Seasonal variations in environmental factors have a significant impact on genotypic expressions in forms of the phenotypic outputs in silkworm crops, such as a cocoon’s weights, shell’s weights, & cocoon’s shells ratios....
A Brief Review on Machine Learning and Its Various Techniques
The word "learning" in ML (Machine Learning) refers to the process through which computers analyze current data and learn new skills and knowledge from it. ML systems use algorithms to look for patterns in datasets that...