Skip to main content
SpringerLink
Log in

Reliability, availability and maintainability analysis of hot standby database systems

  • Original Article
  • Published:
International Journal of System Assurance Engineering and Management Aims and scope Submit manuscript

Abstract

The prominent objective of the present study is to assess the reliability, availability and maintainability of a hot standby database system by analyzing the failure data of the system. This study is also helpful in predicting the maintenance schedules and adopting effective maintenance strategies based on repair data recorded for the thirty months of a Database system. The reliability, availability, and maintainability of the system have been evaluated with the help of basic probability arguments. The parameters of well-known probability distributions have been estimated. The statistical analysis, trend and serial correlation, reliability, and maintainability analysis of the primary unit and hot standby unit are performed. It is observed that the database system was available for use at approximately 99.9997628% time. It is observed that no serial and trend correlation present in the failure and repair data. The best fit for the time between failures (TBF) of primary and hot standby units is Weibull Distribution having Anderson–Darling (AD) values 0.486 and 1.161 respectively. Though, best fitted distribution for the TTR of hot standby unit is 3-Parameter Loglogistic Distribution having AD value 1.112 while for primary unit is 3-Parameter Weibull distribution with AD value 1.004. Furthermore, as RAM analysis has been done to increase database system performance, so database designers and managers can use the findings of the present study.

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

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7

Similar content being viewed by others

Data availability

The data is associated with the manuscript but due to confidentiality can nt be submitted in any repository.

References

  • Ben-Daya M, Duffua OS, Raouf A, Knezevic J, Ait-Kadi D (2009) Handbook of maintenance management and engineering. Springer-Verlag London Limited, New York

    Book  Google Scholar 

  • Choudhary D, Tripathi M, Shankar R (2019) Reliability, availability and maintainability analysis of a cement plant: a case study. Int J Qual Reliab Manage 36:298–313

    Article  Google Scholar 

  • Dahiya O, Kumar A, Saini M (2019) Mathematical modeling and performance evaluation of A-pan crystallization system in a sugar industry. SN Appl Sci 1(4):1–9

    Article  Google Scholar 

  • Ebeling CE (2004) An introduction to reliability and maintainability engineering. Tata McGraw-Hill Education, New York

    Google Scholar 

  • Goyal D, Kumar A, Saini M, Joshi H (2019) Reliability, maintainability and sensitivity analysis of physical processing unit of sewage treatment plant. SN Appl Sci 1(11):1–10

    Article  Google Scholar 

  • Gupta N, Saini M, Kumar A (2020) Operational availability analysis of generators in steam turbine power plants. SN Appl Sci 2(4):1–11

    Article  Google Scholar 

  • Jagtap HP, Bewoor AK, Kumar R, Ahmadi MH, Assad MEH, Sharifpur M (2021) RAM analysis and availability optimization of thermal power plant water circulation system using PSO. Energy Rep 7:1133–1153

    Article  Google Scholar 

  • Jakkula B, Mandela G, Chivukula S (2022) Reliability, availability and maintainability (RAM) investigation of Load Haul Dumpers (LHDs): a case study. Int J Syst Assur Eng Manag 13:504–515. https://doi.org/10.1007/s13198-021-01154-3

    Article  Google Scholar 

  • Kajal S, Tewari PC (2014) Performance optimisation of a multistate operating system with hot redundancy. Int J Intell Enterp 2(4):294–310

    Google Scholar 

  • Kumar A, Saini M (2018a) Fuzzy availability analysis of a marine power plant. Mater Today Proc 5(11):25195–25202

    Article  Google Scholar 

  • Kumar A, Saini M (2018b) Analysis of some reliability measures of single-unit systems subject to abnormal environmental conditions and arbitrary distribution for failure and repair activities. J Inf Optim Sci 39(2):545–559

    MathSciNet  Google Scholar 

  • Kumar A, Saini M (2018c) Mathematical modeling of sugar plant: a fuzzy approach. Life Cycle Reliab Saf Eng 7(1):11–22

    Article  MathSciNet  Google Scholar 

  • Kumar A, Saini M (2018d) Stochastic modeling and cost-benefit analysis of computing device with fault detection subject to expert repair facility. Int J Inf Technol 10(3):391–401

    MathSciNet  Google Scholar 

  • Kumar A, Saini M, Malik SC (2015) Performance analysis of a computer system with imperfect fault detection of hardware. Proced Comput Sci 45:602–610

    Article  Google Scholar 

  • Kumar A, Chhillar SK, Malik SC (2016) Analysis of a single-unit system with degradation and maintenance. J Stat Manag Syst 19(2):151–161

    Google Scholar 

  • Kumar A, Goyal D, Saini M (2020a) Reliability and maintainability analysis of power generating unit of sewage treatment plant. Int J Stat Reliab Eng 7(1):41–48

    Google Scholar 

  • Kumar I, Kumar A, Saini M (2020b) Analysis of performance measures of computer systems with priority and maximum operation time. In: Tuba M, Akashe S, Joshi A (eds) Information and communication technology for sustainable development. Springer, Singapore, pp 1–11

    Google Scholar 

  • Kumar A, Garg R, Barak MS (2021a) Reliability measures of a cold standby system subject to refreshment. Int J Syst Assur Eng Manag. https://doi.org/10.1007/s13198-021-01317-2

    Article  Google Scholar 

  • Kumar A, Saini M, Saini DK, Badiwal N (2021b) Cyber physical systems-reliability modelling: critical perspective and its impact. Int J Syst Assur Eng Manage 12(6):1334–1347. https://doi.org/10.1007/s13198-021-01305-6

    Article  Google Scholar 

  • Li Y, Zhu C, Wang Z (2020) Reliability analysis and imprecise component importance measure of redundant systems of OWTs based on component swapping. Appl Sci 10(4):1432

    Article  Google Scholar 

  • Malik S, Tewari PC (2021) Performability and maintenance decisions for coal ash handling system of a subcritical thermal power plant. Int J Syst Assur Eng Manag. https://doi.org/10.1007/s13198-021-01097-9

    Article  Google Scholar 

  • MIL-HDBK-189 (1981) Reliability growth management. Headquartes, US Army Communication Research and Development Command, ATTN: DRDCO-PT, Fort Monmouth, NJ

  • Mishra D, Satapathy S (2021) Reliability and maintenance of agricultural machinery by MCDM approach. Int J Syst Assur Eng Manag. https://doi.org/10.1007/s13198-021-01256-y

    Article  Google Scholar 

  • Mohammed A, Ghaithan A, Al-Saleh M, Al-Ofi K (2020) Reliability-based preventive maintenance strategy of truck unloading systems. Appl Sci 10(19):6957

    Article  Google Scholar 

  • Pérès F, Noyes D (2003) Evaluation of a maintenance strategy by the analysis of the rate of repair. Qual Reliab Eng Int 19(2):129–148

    Article  Google Scholar 

  • Saini M, Kumar A (2019) Performance analysis of evaporation system in sugar industry using RAMD analysis. J Braz Soc Mech Sci Eng 41(4):1–10

    Article  Google Scholar 

  • Saini M, Kumar A (2020) Stochastic modeling of a single-unit system operating under different environmental conditions subject to inspection and degradation. Proc Natl Acad Sci, India, Sect A 90(2):319–326

    Article  MathSciNet  MATH  Google Scholar 

  • Saini M, Kumar A, Shankar VG (2020) A study of microprocessor systems using RAMD approach. Life Cycle Reliab Saf Eng 9(2):181–194

    Article  Google Scholar 

  • Saini M, Dahiya O, Kumar A (2021a) Modeling and availability analysis of data center: a fuzzy approach. Int J Inf Technol 13(6):2453–2460

    Google Scholar 

  • Saini M, Devi K, Kumar A (2021b) Stochastic modeling and profit evaluation of a redundant system with priority subject to weibull densities for failure and repair. In: Senjyu T, Mahalle PN, Perumal T, Joshi A (eds) Information and communication technology for intelligent systems, ICTIS 2020. Smart Innovation, Systems and Technologies, vol 195. Springer, Singapore. https://doi.org/10.1007/978-981-15-7078-0_2

    Chapter  Google Scholar 

  • Saini M, Kumar A, Sinwar D (2022) Parameter estimation, reliability and maintainability analysis of sugar manufacturing plant. Int J Syst Assur Eng Manag 13:231–249. https://doi.org/10.1007/s13198-021-01216-6

    Article  Google Scholar 

  • Sharma SP, Kumar D (2010) RAM analysis of repairable industrial systems utilizing uncertain data. Appl Soft Comput 10(4):1208–1221

    Article  Google Scholar 

  • Singh S (2013) Reliability analysis of some automated ststems. Ph.D. thesis. M.D.University Rohtak

  • Tsarouhas P (2007) Implementation of total productive maintenance in food industry: a case study. J Qual Maint Eng 13:5–18

    Article  Google Scholar 

  • Tsarouhas PH (2015) Maintainability analysis in the yogurt industry. Int J Syst Assur Eng Manage 6(2):119–128

    Article  Google Scholar 

  • Tsarouhas P (2018) Reliability, availability and maintainability (RAM) analysis for wine packaging production line. Int J Qual Reliab Manage 35:821–842

    Article  Google Scholar 

  • Tsarouhas P (2020) Reliability, availability, and maintainability (RAM) study of an ice cream industry. Appl Sci 10(12):4265

    Article  Google Scholar 

  • Vagenas N, Runciman N, Clément SR (1997) A methodology for maintenance analysis of mining equipment. Int J surf Min Reclam Environ 11(1):33–40

    Article  Google Scholar 

  • Yusuf I, Ismail AL, Lawan MA, Ali UA, Nasir S (2021) Reliability modelling and analysis of client–server system using Gumbel-Hougaard family copula. Life Cycle Reliab Saf Eng 10:1–14

    Article  Google Scholar 

Download references

Funding

The author(s) received no specific funding for this study.

Author information

Authors and Affiliations

  1. Department of Mathematics & Statistics, Manipal University Jaipur, Jaipur, 303007, India

    Monika Saini, Jitendra Yadav & Ashish Kumar

Authors
  1. Monika Saini
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Jitendra Yadav
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Ashish Kumar
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Ashish Kumar.

Ethics declarations

Conflicts of interest

The authors declare that they have no conflicts of interest to report regarding the present study.

Research involving human participants and/or animals.

The authors declare that this work does not involve human participants and/or animals in any capacity.

Informed consent

The authors declare that this work does not involve any survey or participants in any capacity.

Additional information

Publisher's Note

Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Saini, M., Yadav, J. & Kumar, A. Reliability, availability and maintainability analysis of hot standby database systems. Int J Syst Assur Eng Manag 13, 2458–2471 (2022). https://doi.org/10.1007/s13198-022-01657-7

Download citation

  • Received:

  • Revised:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s13198-022-01657-7

Keywords

Search

Navigation