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.
All Science Journal Classification (ASJC) codes
- Safety, Risk, Reliability and Quality
- Electrical and Electronic Engineering