You are being redirected because this document is part of your ASTM Compass® subscription.
    This document is part of your ASTM Compass® subscription.


    Experience of Designing a Relational Materials Database

    Published: 0

      Format Pages Price  
    PDF (668K) 32 $25   ADD TO CART
    Complete Source PDF (8.8M) 497 $85   ADD TO CART


    This paper describes the design of a database for Engineering and Manufacturing Materials data in a tabular (relational) format. The freedom permitted by a relational (rather than hierarchical) data model allows better use of the computer's ability to handle n-dimensional and complex networks of information.

    The following features arc described: • The use of Information Engineering. • The separation of independant variables from property identifiers, to allow extensive scope for storage, interpolation and presentation of complex data. The use of ‘inheritance’ to allow storage and maintenance of generic information (in a manner which is analogous to class-instance object oriented systems). • The capability of holding data of varying quality and for differing applications (design and specification data) within the same database. • The use of direct document publishing. • The integration with company wide systems referencing materials information.

    It will be noted that these features arc based on the study of the structure of the materials information and are believed to be generic solutions to the modelling of Materials Property Data.


    materials data, data banks, relational databases, normalised, data quality, information integration, design data, material specifications, CASE, document publishing, inheritancc, object oriented, Information Engineering, IEF, CALS, STEP, independant variables

    Author Information:

    Bamkin, RJ
    Corporate Specialist, Materials Information Systems for Rolls-Royce plc, Derby,

    MacRae, SCF
    Senior Systems Analyst, Rolls-Royce plc, Derby,

    Committee/Subcommittee: E49.01

    DOI: 10.1520/STP23744S