Skip to main content
SpringerLink
Log in

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

  • Original Research
  • Published:
Life Cycle Reliability and Safety Engineering Aims and scope Submit manuscript

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  • Arres B, Kabachi N, Boussaid O (2015) A data pre-partitioning and distribution optimization approach for distributed data warehouses. In: Proceedings of the international conference on parallel and distributed processing techniques and applications, pp 454–461

  • Ashraf I, Khokhar AS, Lundberg L (2013) Impact of data distribution on response time in telecom databases. Int J Eng Res Appl 3(6):404–412

    Google Scholar 

  • Bhuyar PR, Gawande AD, Deshmukh AB (2012) Horizontal fragmentation technique in distributed database. Int J Sci Res Publ 2(5):1–7

    Google Scholar 

  • Brauers WKM, Zavadskas EK (2006) The MOORA method and its application to privatization in a transition economy. Control Cybern 35(2):445–469

    MATH  MathSciNet  Google Scholar 

  • Brauers WKM, Zavadskas EK (2012) Robustness of MULTIMOORA: a method for multi-objective optimization. Informatica 23(1):1–25

    MATH  MathSciNet  Google Scholar 

  • Ceri S, Pelagatti G (1984) Distributed databases principles and system, 1st edn. McGraw-Hill, New York

    MATH  Google Scholar 

  • Chen K, Zhou Y, Cao Y (2015) Online data partitioning in distributed database systems. In: EDBT, pp 1–12

  • Cheng CH, Lee WK, Wong KF (2002) A genetic algorithm-based clustering approach for database partitioning. IEEE Trans Syst Man Cybern 32(3):215–230

    Article  Google Scholar 

  • Gadakh VS (2011) Application of MOORA method for parametric optimization of milling process. Int J Appl Eng Res 1(4):743–758

    Google Scholar 

  • Goel S, Buyya R (2006) Data replication strategies in wide area distributed systems. Enterprise service computing: from concept to deployment, p 17

  • Görener A, Dinçer H, Hacıoğlu U (2013) Application of multi-objective optimization on the basis of ratio analysis (MOORA) method for bank branch location selection. Int J Financ Bank Stud 2(2):41–52

    Google Scholar 

  • Gupta V, Kapur PK, Kumar D (2016) Modelling and measuring code smells in enterprise applications using TISM and two-way assessment. Int J Syst Assur Eng Manag 7(3):332–340

    Article  Google Scholar 

  • Jin MH, Horng JT (2002) Evaluating the performance of a distributed database of repetitive elements in complete genomes. J Inform Sci Eng 18:533–539

    Google Scholar 

  • Kamal JM, Murshed M (2014) Distributed database management systems: architectural design choices for the cloud. In: Cloud computing. Springer International Publishing, pp 23–50

  • Kapur PK, Garg RB, Kumar S (1999) Contributions to hardware and software reliability. World Scientific, Singapore

    Book  MATH  Google Scholar 

  • Kapur PK, Pham H, Gupta A, Jha PC (2011) Software reliability assessment with OR applications. Springer, London

    Book  MATH  Google Scholar 

  • Kapur PK, Nagpal S, Khatri SK (2014) Critical success factor utility based tool for ERP health assessment—a general framework. Int J Syst Assur Eng Manag 5(2):133–148

    Article  Google Scholar 

  • Kumar D, Gupta V, Kapur PK (2015) Assessment of quality factors in enterprise application integration. In: 4th international conference on reliability, infocom technologies and optimization (ICRITO), IEEE, Noida, India, pp 1–6

  • Kundakci N (2016) Combined multi-criteria decision making approach based on MACBETH and MULTI-MOORA methods. J Oper Res Stat Econ Manag Inform Syst 4(1):17–26

    Google Scholar 

  • Mazilu MC (2010) Database replication. Database Syst J 1(2):33–38

    Google Scholar 

  • Navathe S, Ceri S, Wiederhold G, Dou J (1984) Vertical partitioning algorithms for database design. ACM Trans Database Syst (TODS) 9(4):680–710

    Article  Google Scholar 

  • Navathe S, Karlapalem K, Ra M (1995) A mixed fragmentation methodology for initial distributed database design. J Comput Softw Eng 3(4):395–426

    Google Scholar 

  • Ozsu MT, Valduriez P (1991) Distributed database systems: where are we now? IEEE Comput 24(8):68–78

    Article  Google Scholar 

  • Ozsu MT, Valduriez P (1999) Principles of distributed database systems, 2nd edn. Prentice-Hall, New Jersey

    Google Scholar 

  • Rababaah H, Hakimzadeh DH (2005) Distributed databases fundamentals and research. Advanced Database-B561. Spring

  • Reddy BA, Reddy PR (2012) Effective data distribution techniques for multi-cloud storage in cloud computing. Int J Eng Res Appl 2(5):1130–1134

    Google Scholar 

  • Saaty TL (2008) Decision making with the analytic hierarchy process. Int J Ser Sci 1(1):83–98

    MathSciNet  Google Scholar 

  • Seema, Kaur R, Kumar D (2014) Designing a mathematical model using fuzzy based MOORA method for supplier selection. Int J Adv Eng Technol 5(1):16–24

    Google Scholar 

  • Somerville I (2001) Software engineering, 6th edn. Addison-Wesley, Boston

    Google Scholar 

  • Srivastava A, Shankar U, Tiwari SK (2012) Transaction management in homogenous distributed real-time replicated database systems. Int J Adv Res Comput Sci Softw Eng 2(6):190–196

    Google Scholar 

  • Wang T, Yang B, Gao J, Yang D (2008) Effective data distribution and reallocation strategies for fast query response in distributed query-intensive data environments. In: Asia-Pacific web conference, Springer, Berlin, pp 548–559

  • Ye H, Kerhervé B, Bochmann GV, Bourne D (2001) Data distribution strategies for providing database scalability in e-commerce applications. In: Third international workshop on advanced issues of E-commerce and web-based information systems, WECWIS 2001. IEEE, pp 86–88

  • Zadeh LA (1965) Fuzzy sets. Int J Inform Control 8:338–353

    Article  MATH  Google Scholar 

Download references

Acknowledgements

Authors of this paper are sincerely grateful to The Founder President of Amity University, Dr. Ashok K. Chauhan, who has overwhelmingly shown his keen interest in fostering research in the Amity Universe and has always been a motivation for achieving greater triumphs.

Author information

Authors and Affiliations

  1. Amity Institute of Information Technology, Amity University, Noida, India

    Viral Gupta & Deepak Kumar

  2. Centre for Interdisciplinary Research, Amity University, Noida, India

    P. K. Kapur

Authors
  1. Viral Gupta
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. P. K. Kapur
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Deepak Kumar
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Viral Gupta.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Gupta, V., Kapur, P.K. & Kumar, D. Measuring and evaluating data distribution strategies using an integrated approach of fuzzy based MOORA and AHP. Life Cycle Reliab Saf Eng 6, 37–45 (2017). https://doi.org/10.1007/s41872-017-0004-x

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s41872-017-0004-x

Keywords

Search

Navigation