IDEAS home Printed from https://ideas.repec.org/a/spr/ijsaem/v13y2022i5d10.1007_s13198-022-01657-7.html
   My bibliography  Save this article

Reliability, availability and maintainability analysis of hot standby database systems

Author

Listed:
  • Monika Saini

    (Manipal University Jaipur)

  • Jitendra Yadav

    (Manipal University Jaipur)

  • Ashish Kumar

    (Manipal University Jaipur)

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.

Suggested Citation

  • Monika Saini & Jitendra Yadav & Ashish Kumar, 2022. "Reliability, availability and maintainability analysis of hot standby database systems," International Journal of System Assurance Engineering and Management, Springer;The Society for Reliability, Engineering Quality and Operations Management (SREQOM),India, and Division of Operation and Maintenance, Lulea University of Technology, Sweden, vol. 13(5), pages 2458-2471, October.
    • Handle: RePEc:spr:ijsaem:v:13:y:2022:i:5:d:10.1007_s13198-022-01657-7
    DOI: 10.1007/s13198-022-01657-7
    as

    Download full text from publisher

    File URL: http://link.springer.com/10.1007/s13198-022-01657-7
    File Function: Abstract
    Download Restriction: Access to the full text of the articles in this series is restricted.
    File URL: https://libkey.io/10.1007/s13198-022-01657-7?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    As the access to this document is restricted, you may want to search for a different version of it.

    References listed on IDEAS

    as
    1. Monika Saini & Ashish Kumar & Deepak Sinwar, 2022. "Parameter estimation, reliability and maintainability analysis of sugar manufacturing plant," International Journal of System Assurance Engineering and Management, Springer;The Society for Reliability, Engineering Quality and Operations Management (SREQOM),India, and Division of Operation and Maintenance, Lulea University of Technology, Sweden, vol. 13(1), pages 231-249, February.
    2. Balaraju Jakkula & Govinda Raj Mandela & Suryanarayana Murthy Chivukula, 2022. "Reliability, availability and maintainability (RAM) investigation of Load Haul Dumpers (LHDs): a case study," International Journal of System Assurance Engineering and Management, Springer;The Society for Reliability, Engineering Quality and Operations Management (SREQOM),India, and Division of Operation and Maintenance, Lulea University of Technology, Sweden, vol. 13(1), pages 504-515, February.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.

      Corrections

      All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:spr:ijsaem:v:13:y:2022:i:5:d:10.1007_s13198-022-01657-7. See general information about how to correct material in RePEc.

      If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

      If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

      If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

      For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Sonal Shukla or Springer Nature Abstracting and Indexing (email available below). General contact details of provider: http://www.springer.com .

      Please note that corrections may take a couple of weeks to filter through the various RePEc services.

      IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.