International Journal of Scientific & Technology Research

Home About Us Scope Editorial Board Blog/Latest News Contact Us
10th percentile
Powered by  Scopus
Scopus coverage:
Nov 2018 to May 2020


IJSTR >> Volume 6 - Issue 7, July 2017 Edition

International Journal of Scientific & Technology Research  
International Journal of Scientific & Technology Research

Website: http://www.ijstr.org

ISSN 2277-8616

Design And Implementation Of Tool For Detecting Anti-Patterns In Relational Database

[Full Text]



Gaurav Kumar, Rahul Kumar Yadav, Sanjay Bhutungru



Anti-pattern, RDBMS, Design Pattern, SVM, SVMLearn.



Anti-patterns are poor solution to design and im-plementation problems. Developers may introduce anti-patterns in their software systems because of time pressure, lack of understanding, communication and or-skills. Anti-patterns create problems in software maintenance and development. Database anti-patterns lead to complex and time consuming query process-ing and loss of integrity constraints. Detecting anti-patterns could reduce costs, efforts and resources. Researchers have proposed approaches to detect anti-patterns in software development. But not much research has been done about database anti-patterns. This report presents two approaches to detect schema design anti-patterns in relational database. Our first approach is based on pattern matchingwe look into potential candidates based on schema patterns. Second approach is a machine learning based approach we generate features of possible anti-patterns and build SVMbased classifier to detect them. Here we look into these four anti-patterns a) Multi-valued attribute b) Nave tree based c) Entity Attribute Value and d)Polymorphic Association . We measure precision and recall of each approach and compare the results. SVM-based approach provides more precision and recall with more training dataset.



[1] AbdouMaiga, Nasir Ali, Neelesh Bhattacharya, Aminata Sabane1,Yann-Gael Gueheneuc, and EsmaAimeur, ” SMURF: A SVM-based IncrementalAnti-pattern Detection Approach”, 19th Working Conference on Reverse Engineering, 2012.

[2] AbdouMaiga, Nasir Ali,Neelesh Bhattacharya, Aminata Sabane1,Yann ”SVM for Antipattern Detection”,.

[3] ManjulaPeiris, James H. Hill ”Towards Detecting Software Performance Anti- patterns using Classification Techniques” .

[4] Robert Burbidge, Bernard Buxton ”An Introduction to Support Vector Machines for Data Mining”.

[5] Bo-yun Zhang, Jian-ping Yin, Jin-boHao, Ding-xing Zhang and Shu-lin Wang ”Using Support Vector Machine to Detect Unknown Computer Viruses” .

[6] Ivan Polek, Samuel Snopko and Ivan Kapustk ”Automatic identification of the antipatternsusing the rule-based approach” SISY 2012, 2012 IEEE 10th Jubilee International Symposium on Intelligent Systems and Informatics,September 20-22, 2012, Subotica, Serbia

[7] Maria Teresa Llano and Rob Pooley ”UML Specification and Correction of Object-Oriented Anti-patterns” 2009 Fourth International Conference of Software Engineering Advances .

[8] Vittorio Cortellessa?, Anne Martensy, Ralf Reussnery, CatiaTrubiani - Towards Identification of ”Guilty” Performance Antipatterns .

[9] John Long IBM ”Software Reuse Anti-patterns ”ACM SIGSOFT

[10] Ruben Wieman ”Anti-Pattern Scanner: An Approach to Detect Anti-Patterns andDesign”S