STP1140: Experience of Designing a Relational Materials Database

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

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

    Pages: 32    Published: Jan 1992


    Abstract

    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.

    Keywords:

    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


    Paper ID: STP23744S

    Committee/Subcommittee: E49.01

    DOI: 10.1520/STP23744S


    CrossRef ASTM International is a member of CrossRef.