Design And Implementation Of Tool For Detecting Anti-Patterns In Relational Database
[Full Text]
AUTHOR(S)
Gaurav Kumar, Rahul Kumar Yadav, Sanjay Bhutungru
KEYWORDS
Anti-pattern, RDBMS, Design Pattern, SVM, SVMLearn.
ABSTRACT
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.
REFERENCES
[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
|