Reliability, availability and maintainability analysis of hot standby database systems

Monika Saini, Jitendra Yadav and Ashish Kumar ()
Additional contact information
Monika Saini: Manipal University Jaipur
Jitendra Yadav: Manipal University Jaipur
Ashish Kumar: Manipal University Jaipur

International Journal of System Assurance Engineering and Management, 2022, vol. 13, issue 5, No 25, 2458-2471

Abstract: 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.

Keywords: Anderson–Darling test; Percentile value; Parameter estimation; Serial correlation; TBF and TTR data (search for similar items in EconPapers)
Date: 2022
References: View references in EconPapers View complete reference list from CitEc
Citations:

Downloads: (external link)
http://link.springer.com/10.1007/s13198-022-01657-7 Abstract (text/html)
Access to the full text of the articles in this series is restricted.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:spr:ijsaem:v:13:y:2022:i:5:d:10.1007_s13198-022-01657-7

Ordering information: This journal article can be ordered from
http://www.springer.com/engineering/journal/13198

DOI: 10.1007/s13198-022-01657-7

Access Statistics for this article

International Journal of System Assurance Engineering and Management is currently edited by P.K. Kapur, A.K. Verma and U. Kumar

More articles in International Journal of System Assurance Engineering and Management from Springer, The Society for Reliability, Engineering Quality and Operations Management (SREQOM),India, and Division of Operation and Maintenance, Lulea University of Technology, Sweden
Bibliographic data for series maintained by Sonal Shukla () and Springer Nature Abstracting and Indexing ().