Browse Prior Art Database

Failure Analysis Tracking System

IP.com Disclosure Number: IPCOM000106576D
Original Publication Date: 1993-Nov-01
Included in the Prior Art Database: 2005-Mar-21
Document File: 2 page(s) / 78K

Publishing Venue

IBM

Related People

Clark, RA: AUTHOR [+2]

Abstract

The invention disclosure herein facilitates the storage, retrieval, and maintenance of a variable set of data. Most data base management systems use a fixed field approach. This limits the application to the ability to store information only in the predefined fields. These predefined fields are of predefined length and data type. A data base management system that would store an ever changing set of data was required. In other words, the attributes that are being collected today may differ from the attributes that will be collected tomorrow, and the attributes that are being collected for one record may differ from the attributes that are being collected for another. In order to this, we use what we call a variable attribute approach.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 52% of the total text.

Failure Analysis Tracking System

      The invention disclosure herein facilitates the storage,
retrieval, and maintenance of a variable set of data.  Most data base
management systems use a fixed field approach.  This limits the
application to the ability to store information only in the
predefined fields.  These predefined fields are of predefined length
and data type.  A data base management system that would store an
ever changing set of data was required.  In other words, the
attributes that are being collected today may differ from the
attributes that will be collected tomorrow, and the attributes that
are being collected for one record may differ from the attributes
that are being collected for another.  In order to this, we use what
we call a variable attribute approach.

      Following is the data base architecture for the variable
attribute data base management system.  A relational data base is
used for the system being discussed.  There are three main tables
involved in the system, a Master Record table, a Detail Record table,
and a System Administration table.  Each of these tables are linked
together through the use of common fields.  Each logical record in
the data base cosists of one master record, and many detail records.
The System Administration table keeps tract of which detail records
are being collected for each master record.

      The Master Record table is used to store key information for
each record, and information that is going to be kept for all or most
logical records in the database.  The Insertion Timestamp of each
master record is stored, and is used to link each master record to
its detail records.  A Master Record will look like:

         KEYFIELD - Key field of logical record.

         INSSTAMP - Timestamp of insertion of Master Record.  Will
                    link Master Record to Detail Record.

         CATEGORY - Category of Master Record.  Used to link Master
                    Record to System Admin Record.

         OTHER01  - Fixed field of other information.  (optional)

         OTHER02  - Fixed field of other information.  (optional)

      Each master record has many detail recor...