Implementing a Relational Database for an Accelerated-Life-Test Facility

Research output: Contribution to journalArticle

3 Citations (Scopus)

Abstract

This paper describes the design of a relational database and associated command structure for an accelerated-life-test facility. The primary goals of the design were to: 1) improve data integrity, and 2) provide a complete & consistent historical record of reliability test results. The intended reader is not the database expert, but the engineer who wants to understand the issues involved in automating the reliability-data collection & reporting process. The paper - • shows (via the story of a particular reliability database design) in a tutorial fashion how to use system requirements and the formalisms of the relational model to create a database system for engineering tests • serves as a guide for developing relational database applications for other engineering & production activities. The paper makes three primary contributions by showing: • A practical method for constructing a relational database. The method is based on an IDEF0 representation of the testing process, which is easier for the database novice to understand & implement than the usual approaches of data flow or entity-relationship diagrams. • The value of a particular database structure for maintaining engineering test database integrity: A table for test measurements, a table for kinds of test measurements, and a table for test measurement procedures. • How to write data entry/reporting application programs that maintain data integrity and ease the user's input burden. While specific issues in reliability testing are discussed, the methodology to construct the database and user interface applies broadly.

Original languageEnglish (US)
Pages (from-to)11-21
Number of pages11
JournalIEEE Transactions on Reliability
Volume43
Issue number1
DOIs
StatePublished - Jan 1 1994

Fingerprint

Test facilities
Testing
Application programs
User interfaces
Data acquisition
Engineers

All Science Journal Classification (ASJC) codes

  • Safety, Risk, Reliability and Quality
  • Electrical and Electronic Engineering

Cite this

@article{65d97b005da24b2c84a1a88891a534af,
title = "Implementing a Relational Database for an Accelerated-Life-Test Facility",
abstract = "This paper describes the design of a relational database and associated command structure for an accelerated-life-test facility. The primary goals of the design were to: 1) improve data integrity, and 2) provide a complete & consistent historical record of reliability test results. The intended reader is not the database expert, but the engineer who wants to understand the issues involved in automating the reliability-data collection & reporting process. The paper - • shows (via the story of a particular reliability database design) in a tutorial fashion how to use system requirements and the formalisms of the relational model to create a database system for engineering tests • serves as a guide for developing relational database applications for other engineering & production activities. The paper makes three primary contributions by showing: • A practical method for constructing a relational database. The method is based on an IDEF0 representation of the testing process, which is easier for the database novice to understand & implement than the usual approaches of data flow or entity-relationship diagrams. • The value of a particular database structure for maintaining engineering test database integrity: A table for test measurements, a table for kinds of test measurements, and a table for test measurement procedures. • How to write data entry/reporting application programs that maintain data integrity and ease the user's input burden. While specific issues in reliability testing are discussed, the methodology to construct the database and user interface applies broadly.",
author = "Barton, {Russell Richard}",
year = "1994",
month = "1",
day = "1",
doi = "10.1109/24.285102",
language = "English (US)",
volume = "43",
pages = "11--21",
journal = "IEEE Transactions on Reliability",
issn = "0018-9529",
publisher = "Institute of Electrical and Electronics Engineers Inc.",
number = "1",

}

Implementing a Relational Database for an Accelerated-Life-Test Facility. / Barton, Russell Richard.

In: IEEE Transactions on Reliability, Vol. 43, No. 1, 01.01.1994, p. 11-21.

Research output: Contribution to journalArticle

TY - JOUR

T1 - Implementing a Relational Database for an Accelerated-Life-Test Facility

AU - Barton, Russell Richard

PY - 1994/1/1

Y1 - 1994/1/1

N2 - This paper describes the design of a relational database and associated command structure for an accelerated-life-test facility. The primary goals of the design were to: 1) improve data integrity, and 2) provide a complete & consistent historical record of reliability test results. The intended reader is not the database expert, but the engineer who wants to understand the issues involved in automating the reliability-data collection & reporting process. The paper - • shows (via the story of a particular reliability database design) in a tutorial fashion how to use system requirements and the formalisms of the relational model to create a database system for engineering tests • serves as a guide for developing relational database applications for other engineering & production activities. The paper makes three primary contributions by showing: • A practical method for constructing a relational database. The method is based on an IDEF0 representation of the testing process, which is easier for the database novice to understand & implement than the usual approaches of data flow or entity-relationship diagrams. • The value of a particular database structure for maintaining engineering test database integrity: A table for test measurements, a table for kinds of test measurements, and a table for test measurement procedures. • How to write data entry/reporting application programs that maintain data integrity and ease the user's input burden. While specific issues in reliability testing are discussed, the methodology to construct the database and user interface applies broadly.

AB - This paper describes the design of a relational database and associated command structure for an accelerated-life-test facility. The primary goals of the design were to: 1) improve data integrity, and 2) provide a complete & consistent historical record of reliability test results. The intended reader is not the database expert, but the engineer who wants to understand the issues involved in automating the reliability-data collection & reporting process. The paper - • shows (via the story of a particular reliability database design) in a tutorial fashion how to use system requirements and the formalisms of the relational model to create a database system for engineering tests • serves as a guide for developing relational database applications for other engineering & production activities. The paper makes three primary contributions by showing: • A practical method for constructing a relational database. The method is based on an IDEF0 representation of the testing process, which is easier for the database novice to understand & implement than the usual approaches of data flow or entity-relationship diagrams. • The value of a particular database structure for maintaining engineering test database integrity: A table for test measurements, a table for kinds of test measurements, and a table for test measurement procedures. • How to write data entry/reporting application programs that maintain data integrity and ease the user's input burden. While specific issues in reliability testing are discussed, the methodology to construct the database and user interface applies broadly.

UR - http://www.scopus.com/inward/record.url?scp=0028388564&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0028388564&partnerID=8YFLogxK

U2 - 10.1109/24.285102

DO - 10.1109/24.285102

M3 - Article

AN - SCOPUS:0028388564

VL - 43

SP - 11

EP - 21

JO - IEEE Transactions on Reliability

JF - IEEE Transactions on Reliability

SN - 0018-9529

IS - 1

ER -