Measuring and evaluating data distribution strategies using an integrated approach of fuzzy based MOORA and AHP

Data distribution helps in achieving higher availability, reliability and increased performance of an enterprise application that is geographically dispersed. There are various data distribution strategies available and selection of a most suitable strategy for an enterprise is a multi-criteria decision-making problem. The selection problem of data distribution strategy is very complex because it depends on multiple conflicting criteria. It is essential to strike a right balance between conflicting criteria and select the most suitable data distribution strategy. This research paper presents a framework for measuring and selecting most suitable data distribution strategy using an integrated approach of fuzzy based multi-objective optimization on the basis of ratio analysis and analytic hierarchy process. A real world problem from an enterprise was undertaken to illustrate the results of the proposed methodology. In this paper, five data distribution strategies and six criteria were considered. The methodology used in this paper acts as an important tool for the practitioners to measure and evaluate the most suitable data distribution strategy in an enterprise and improve the overall quality.

[1]  Kam-Fai Wong,et al.  A genetic algorithm-based clustering approach for database partitioning , 2002, IEEE Trans. Syst. Man Cybern. Part C.

[2]  Patrick Valduriez,et al.  Principles of distributed database systems (2nd ed.) , 1999 .

[3]  Sekhar Reddy Effective Data Distribution Techniques for Multi-Cloud Storage in Cloud Computing , 2012 .

[4]  Patrick Valduriez,et al.  Principles of Distributed Database Systems , 1990 .

[5]  Ricardo Jiménez-Peris,et al.  Database Replication , 2010, Dababase Replication.

[6]  Ian Sommerville,et al.  Software engineering (6th ed.) , 2001 .

[7]  Deepak Kumar,et al.  Assessment of quality factors in enterprise application integration , 2015, 2015 4th International Conference on Reliability, Infocom Technologies and Optimization (ICRITO) (Trends and Future Directions).

[8]  Jun Gao,et al.  Effective Data Distribution and Reallocation Strategies for Fast Query Response in Distributed Query-Intensive Data Environments , 2008, APWeb.

[9]  Hasan Dinçer,et al.  Application of Multi-Objective Optimization on the Basis of Ratio Analysis (MOORA) Method for Bank Branch Location Selection , 2013 .

[10]  S. Kumar,et al.  Contributions to Hardware and Software Reliability , 1999, Series on Quality, Reliability and Engineering Statistics.

[11]  Stefano Ceri,et al.  Distributed Databases: Principles and Systems , 1984 .

[12]  Jorng-Tzong Horng,et al.  Evaluating the Performance of a Distributed Database of Repetitive Elements in Complete Genomes , 2002, J. Inf. Sci. Eng..

[13]  Thomas L. Saaty,et al.  DECISION MAKING WITH THE ANALYTIC HIERARCHY PROCESS , 2008 .

[14]  P. C. Jha,et al.  Software Reliability Assessment with OR Applications , 2011 .

[15]  Gregor von Bochmann,et al.  Data distribution strategies for providing database scalability in e-commerce applications , 2001, Proceedings Third International Workshop on Advanced Issues of E-Commerce and Web-Based Information Systems. WECWIS 2001.

[16]  Lotfi A. Zadeh,et al.  Fuzzy Sets , 1996, Inf. Control..

[17]  Edmundas Kazimieras Zavadskas,et al.  Robustness of MULTIMOORA: A Method for Multi-Objective Optimization , 2012, Informatica.

[18]  Edmundas Kazimieras Zavadskas,et al.  The MOORA method and its application to privatization in a transition economy , 2006 .

[19]  A. D. Gawande,et al.  Horizontal Fragmentation Technique in Distributed Database , 2012 .

[20]  Ashish Srivastava,et al.  Transaction Management in Homogenous Distributed Real-Time Replicated Database Systems , 2012 .

[21]  Patrick Valduriez,et al.  Distributed database systems: where are we now? , 1991, Computer.

[22]  P. K. Kapur,et al.  Critical success factor utility based tool for ERP health assessment: a general framework , 2014, Int. J. Syst. Assur. Eng. Manag..

[23]  Yu Cao,et al.  Online Data Partitioning in Distributed Database Systems , 2015, EDBT.

[24]  Manzur Murshed,et al.  Distributed Database Management Systems: Architectural Design Choices for the Cloud , 2014 .

[25]  Deepak Kumar,et al.  Modelling and measuring code smells in enterprise applications using TISM and two-way assessment , 2016, Int. J. Syst. Assur. Eng. Manag..

[26]  Nilsen Kundakci,et al.  COMBINED MULTI-CRITERIA DECISION MAKING APPROACH BASED ON MACBETH AND MULTI-MOORA METHODS , 2016 .

[27]  Shamkant B. Navathe,et al.  Vertical partitioning algorithms for database design , 1984, TODS.