An initial description of an evolving relational database schema is presented for the management of finite element model design and analysis data. The report presents a description of each relation including attribute names, data types, and definitions. The format of this report is such that future modifications and enhancements may be easily incorporated

Blackburn, C. L.

Fishwick, P. A.

Sutter, T. R.

English

NASA Technical Reports Server

NASA Contractor Report 172183 
.!:.~otot'ype .!ntegrated DEsign (PRIDE) System 
Reference Manual 
Volume 2 
Schema Definition 
Paul A. Fishwick, Thomas R. Sutter, and 
Charles l. Blackburn 
Kentron Technical Center 
Hampton, Virginia 23666 
Contract NAS1-16000 
July 1983 
111111111111111111111111111111111111111111111 
N!\s/\ 
National Aeronautics and 
Space Aclministration 
Langley !Research Center 
Hampton, Virginia 23665 
NF02535 
NASA-CR-172183 
19830025290 
o , I -, 'Co () 'Igor) r. ' ~ G ~ ~~ \ 0·.\ 
J.ANGLI.":Y RESEARCH CENTER 
LlBR,1,RY, NASA 
liAMelONt VIRGINIA, 
https://ntrs.nasa.gov/search.jsp?R=19830025290 2020-03-21T02:53:10+00:00Z
TABLE OF CONTENTS 
I. Summa ry ............................................................... 1 
II. Introduction •••••••.••••..•••••••.••••••••••••••••••••.•••••••••••• 3 
III. Archival Data ••••••..•.•.•••.•••••• ~ ••••••.•••••••••••••••••••••••• 5 
A. Material Properties (MAT-PROP) ••••••••••••••••••••••••••••••••• 5 
B. Wide Flange Beam Section Properties (WFL) •••••••••••••••••••••• 6 
C. 1 Beam Section Properties (I) •••••••••••••••••••••••••••••••••• 7 
D. Channel Beam Section Properties (CHN) ••••.•••••••••..•••••••••• 8 
E. An9le Beam Section Properties (ANG) •••••••••••••••••••••••••••• 9 
IV. AD-2000 to RIM Processor Relations •••••••••••••••••••••••••••••••• 10 
A. Beam/Rod Elements (BEAMS) ••••••.••••••••••••••••••••••••••••••• 10 
B. Triangular Elements (TRIANGLS) •••••••.••••••••..•••••••••••••.• 11 
C. Quadrilateral Elements (QUADS) .•••••••.••••••••.••••••••••••••• 12 
D. Node Locations (NODES) •.•.•••••••••••••••.••.•••.•.••.••••••••• 13 
E. Node Constraints (CONSTRN) •••••.•••••.•••••••••••••••.••••••.•• 14 
F. Noda 1 Loads (NODELOAD) ••.•••••••••••••••.••••••••••..•••••••••• 15 
G. Element Loads (ELEMLOAD) ......••••••••••••.••••••••••••••.••••• 16 
V. RIM to SPAR Processor Relations ••••.••.••••••••••••••••••••••.•••• 17 
A. Configuration Factors (CONFACT) .•••...••••..••.•••••••••..•.•.• 17 
VI. SPAR to RIM Processor Relations •.•••••••.•.•••••••••••••••••••••••. 18 
A. Static Displacements (STATDISP) ••••••••.•.••••.••••••••••••••.. 18 
B. Static Reactions (STATREAC) ••.••••••.••••••••••••.••..•••.••.•• 19 
C. Eigenvalues (EIGNVALS) ..••••••••••••••.••••••.••..••..••••.••• 20 
D. Ei genvectors (EIGNVECT) •.•..•.••.•.••••••••••.•••.•.••.•••••••• 21 
E. Beam Stresses (BEAMSTRS) ••.••••••...•••.••••..•••..•.•••••••••• 22 
F. Pl ate St resses (PLATSTRS) •••••••••.•..•••••••••••.••••••••••••• 23 
VI I. CONCLUDING REMARKS •••.••.•••...••••...•...••..•....•••..•.........• 24 
V I I I. REFERENCES. • • • • • • . • • • . • . • • . • • • • • • • • • • • • • . • • • • • • • • • • . • • • • • • . • • • • • • •• 25 
IX. FIGURES ...... ·· ..................................................... 26 
i 
1P 
;(<j~ ~ J 3.5~J 
I. SUMMARY 
An initial description of an evolving relational database schema is presented 
for the management of finite element model design and analysis data. The report 
presents a description of each relation including attribute names, data types, and 
definitions. The format of this report is such that future modifications and 
enhancements may be eas i ly incorporated. 
All Blank Pages 
Intentionally Left Blank 
To Keep Document Continuity 
II. INTRODUCTION 
This report represents the second volume in a three volume set describing the 
PRIDE (PRototype integrated DEsign) system (ref. 1 and 2). The three volumes are 
described below: 
Volume 1: PRIDE User's Manual -
Contains a description of the user interface to the PRIDE software 
(applications programs and associated pre- and post-processors). 
Volume ~~: PRIDE Reference Manual -
Contains a description of the relational database schema which 
forms the global basis for the integrated PRIDE system software. 
Volume 3: PRIDE Programmer's Manual -
Contains system information on the pre- and post-processor software 
that is relevant to individuals requiring an in-depth description 
of the PRIDE internals. 
Given the large quantities of design and analysis data present in most 
engineering applications, it is desirable to find methods for adequately managing 
the data. A relational data model (ref. 3) was chosen as a basis for handling 
engineering data since the relational model promotes a simple-to-use and effective 
query mechanism. The RIM (Relational information Manager) database management 
system (ref. 4) is being used within PRIDE. RIM is an outgrowth of the IPAD 
contractual development (ref. 5). It has been applied by integrating several 
engineering application programs with the RIM data manager to form the PRIDE 
system. 
The user's relational database is used for managing data and serves as the 
focal point during design and analysis. All of the engineering application 
programs are directly integrated with the database using the RIM FORTRAN program 
interface subroutines, so that the database serves as the global exchange and 
manipulation mechanism. An example of the role that the relational database 
management system plays in an integrated design system is depicted in figure 1. 
3 
This report describes the schema (a set of two-dimensional tables, called 
"relations") of the database currently implemented within PRIDE. Each relation is 
composed of a set of tuples (or rows) and a set of attributes (or columns). More 
detailed information concerning schemas and relations using RIM may be obtained 
from reference 4. 
4 
III. ARCHIVAL DATA 
A. MATERIAL PROPERTIES 
Relat"ion Naml~: "MAT-PROP" 
Description: Temperature independent material properties 
Relation contents: 
Attribute Name Type Contents 
MATERIAL TEXT 8 Material name 
SPEC-WT REAL Spec ifi c Wei ght 
VIELD- TE REAL Vi el d in Tens i on 
YIELD-CO REAL Vi el d in Compress ion 
VI ELD-SH REAL Vi el d in Shear 
ULT-TENS REAL Ultimate in Tension 
ULT-COMP REAL Ult i mate in Compression 
ULT-SHER REAL Ultimate in Shear 
ENDU-LIM REAL Endu ranee li mit 
MOD-ELAS REAL Modul us of Elasticity 
MOD-RIGI REAL Modulus of Ri 9i dity 
THERf'lICOE REAL Therma 1 Coefficient 
SPECHEAT REAL Spec ifi cHeat 
CONDUCT REAL Conduct i on Coefficient 
EMISSIV REAL Emi ss i vity 
ABSORP REAL Absorpt i vi ty 
DIFFCOMP REAL Diffuse Component 
5 
Re 1 at i on Name: "WFL II 
III. ARCHIVAL DATA 
B. WIDE FLANGE BEAMS 
Description: Wide flange beam data 
Relation contents: 
Attribute Name Nype Contents 
NOM-SIZE TEXT 8 Nomi na 1 Si ze 
WT/FT REAL Weight per foot 
AREA REAL Cross Sectional 
DEPTH REAL Depth of Beam 
FLANGE-W REAL Flange Width 
FLANGE-T REAL Flange Thickness 
WEB-THK REAL Web Th i ckness 
6 
Area 
Re 1 at i on Name: II I II 
III. ARCHIVAL DATA 
C. I BEAMS 
Description: beam data 
Relation contents: 
Attri bute Name Type Contents 
NOM-,S lZE TEXT 8 Nomi na 1 Si ze 
WT 1FT REAL Weight per foot 
AREA REAL Cross Sect i ona 1 
DEPTH REAL Depth of Beam 
FLANGE-W REAL Flange \~i dth 
FLANGE-T REAL Flange Thickness 
WEB-,THK REAL Web Tn; ck nes s 
7 
Area 
III. ARCHIVAL DATA 
D. CHANNEL BEAMS 
Re 1 at i on Name: "CHN" 
" 
Description: Channel beam data 
Relation contents: 
Attribute Name Type Contents 
NOM-SIZE TEXT 8 Nomi na 1 Si ze 
WT/FT REAL We; ght per foot 
AREA REAL Cross Sect i ona 1 Area 
DEPTH REAL Depth of Beam 
FLANGE-W REAL Flange Width 
FLANGE-T REAL Flange Th i ckness 
WEB-THK REAL Web Th i ckness 
8 
III. ARCHIVAL DATA 
E. ANGLE BEAMS 
Relation Name: IIANG II 
Description: Angle beam data 
Relation contents: 
Attribute Name Type Contents 
NOM-SIZE TEXT 8 Nom; na 1 Si ze 
THICKNES REAL Thickness 
WT/FT REAL Wei ght per foot 
AREA REAL Cross Sect; ona 1 Area 
9 
IV. AD-2000 TO RIM PROCESSOR RELATIONS 
A. BEAM/ROD ELEMENTS 
Relation Name: "BEAMS" 
Description: Two-node elements 
Relation contents: 
Attribute Name Type Contents 
CMPONENT INTEGER Level No. +1 as indicated by AD-2000 (Component #) 
ELEMENT# INTEGER Element number within "BEAMS" 
NODEl INTEGER Node #1 
NODE2 INTEGER Node #2 
EL-TYPE TEXT 8 Element type 
NOM-SIZE TEXT 8 Nominal size 
MATERIAL TEXT 8 Material 
10 
IV. AD-2000 TO RIM PROCESSOR RELATIONS 
B. TRIANGULAR ELEMENTS 
Relation Name: "TRIANGLS" 
Description: Three-node elements 
Relation contents: 
Attribute Name Type Contents 
CMPONENT INTEGER Level No. +1 as indicated 
(Component #) 
ELEMENT# INTEGER Element number within 
"TRIANGLS" 
NODEl INTEGER Node #1 
NODE2~ INTEGER Node #2 
NODE3 INTEGER Node #3 
EL- TYPE TEXT 8 Element type 
MATERIAL TEXT 8 Mater; al 
THICKNES REAL Th; ckness of element 
11 
by AD-200a 
IV. AD-2000 TO RIM PROCESSOR RELATIONS 
C. QUADRILATERAL ELEMENTS 
Relation Name: "QUADS" 
Description: Four-node elements 
Relation ~ontents: 
Attribute Name Type Contents 
CMPONENT INTEGER Level No. +1 as indicated by AD-2000 (Component #) 
ELEMENT# INTEGER Element number within "QUADS" 
NODE1 INTEGER Node #1 
NODE2 INTEGER Node #2 
NODE3 INTEGER Node #3 
NODE4 INTEGER Node #4 
EL-TYPE TEXT 8 Element type 
MATERIAL TEXT 8 Materi a 1 
THICKNES REAL Thickness of element 
12 
IV. AD-2000 TO RIM PROCESSOR RELATIONS 
D. NODE LOCATIONS 
RI~lation Name: uNODES u 
Description: Node numbers and coordinates 
Relation contents: 
Attribute Name 
NODE 
X 
Y 
Z 
Type 
INTEGER 
REAL 
REAL 
REAL 
13 
Contents 
Node number 
X location 
Y location 
Z location 
IV. AD-2000 TO RIM PROCESSOR RELATIONS 
E. NODE CONSTRAINTS 
Relation Name: "CONSTRN" 
Description: Nodal constraints 
Relation contents: 
Attribute Name Type 
NODE INTEGER 
X-DISP TEXT 4 
Y-DISP TEXT 4 
Z-D ISP TEXT 4 
X-ROT TEXT 4 
V-ROT TEXT 4 
Z-ROT TEXT 4 
Contents 
Node number 
Constrai ned 
Constrai ned 
Constrained 
Constrai ned 
Constrained 
Constrai ned 
The text attributes will contain one of two values: 
"N" --> this degree of freedom not constrained 
"V" --> this degree of freedom constrained 
14 
in X-displacement? 
in V-displacement? 
in Z-displacement? 
in X-rotat ion? 
in Y- rotat ion? 
in Z-rotation? 
IV. AD-2000 TO RIM PROCESSOR RELATIONS 
F.. NODAL LOADS 
Relation Name: "NODELOAD" 
Description: Nodal temperatures and loads 
Relation contents: 
Attribute Name Type Contents 
NODE INTEGER Node number 
FMDIRECT TEXT 4 Force or moment direction 
APPL-FOR REAL Applied force or moment 
TEMP REAL Nodal temperature 
CONDNUM INTEGER Condition # for this data 
15 
IV. AD-2000 TO RIM PROCESSOR RELATIONS 
G. ELEMENT LOADS 
Relation Name: "ELEMLOAD" 
Description: Element temperature or pressure loads 
RIM relation contents: 
Attribute Name Type Contents 
CMPONENT INTEGER Level No. +1 as indicated by AD-20aO 
(Component #) 
ELEMENT# INTEGER Element number 
HEATLOAD REAL Element heat load 
PRESLOAD REAL Element pressure load 
CONDNUM INTEGER Condition # for this data 
16 
V. RIM TO SPAR PROCESSOR RELATIONS 
A. CONFIGURATION FACTORS 
Relation Name: "CONFACT" 
Description: View factors 
Relation contents: 
Attri bute Name Type Contents 
IELEM# INTEGER Element# I 
JELEM# INTEGER Element# J 
VIEWFAC REAL Amount of heat energy leaving 
incident on element J 
CONDNUM INTEGER Condition # for this data 
17 
I and 
VI. SPAR TO RIM PROCESSOR RELATIONS 
A. STATIC DISPLACEMENTS 
Relation Name: IISTATDISp ll 
Description: Static displacement data 
Relation contents: 
Attri bute Name Type 
NODE INTEGER 
X-DISP REAL 
V-DISP REAL 
Z-D ISP REAL 
X-ROT REAL 
V-ROT REAL 
Z-ROT REAL 
CONDNUM INTEGER 
18 
Contents 
Node number 
Displacement in the x-di rect i on 
Displacement in the y-direction 
Displacement in the z-direction 
Rotat ion about the x-axi s 
Rotation about the y-axis 
Rotation about the z-axi s 
Con~ition # for this data 
VI. SPAR TO RIM PROCESSOR RELATIONS 
B. STATIC REACTIONS 
Relation Name: "STATREAC" 
Description: Static reaction data 
Relation contents: 
Attribute Name Type 
NODE INTEGER 
X-FORC REAL 
V-FORC REAL 
Z-FORC REAL 
X-MOM REAL 
V-MOM REAL 
Z-MOM REAL 
CONDNUM INTEGER 
19 
Contents 
Node number 
Force in the x-direction 
Force in the y-direction 
Force in the z-direction 
Moment about the x-axis 
Moment about the y-axis 
Moment about the z-axi s 
Condition # for this data 
VI. SPAR TO RIM PROCESSOR RELATIONS 
C. EIGENVALUES 
Relation Name: "EIGNVALS" 
Description: Eigenvalue data 
Relation contents: 
Attribute Name 
FREQ 
CONDNUM 
Type 
REAL 
INTEGER 
20 
Contents 
Frequency 
Condition # for this data 
VI. SPAR TO RIM PROCESSOR RELATIONS 
D. EIGENVECTORS 
Relation Name: "EIGNVECT" 
Description: Eigenvector data 
Relation contents: 
Attribute Name Type Contents 
NODE INTEGER Number 
X-DISP REAL X-component of the eigenvector 
V -D ISP REAL V-component of the eigenvector 
Z-D ISP REAL Z-component of the eigenvector 
X-ROT REAL X-axis rotational component of 
the eigenvector 
V-ROT REAL V-axis rotational component of 
the eigenvector 
Z-ROT REAL Z-axis rotational component of 
the eigenvector 
CONDNUM INTEGER Condition # for this data 
21 
VI. SPAR TO RIM PROCESSOR RELATIONS 
E. BEAM STRESSES 
Re 1 at i on Name: IIBEAMSTRS II 
Description: Beam forces 
Relation contents: 
Attribute Name Type Contents 
CMPONENT INTEGER Component # 
ELEMENT# INTEGER E1 ement # 
FORCIX REAL Force at end 1 in element x-axi s 
direction 
FORCIY REAL Force at end 1 in element y-axis 
direction 
FORClZ REAL Force at end 1 in element z-axis 
direction 
MOMIX REAL Moment at end 1 about element x-axi s 
MOMIY REAL Moment at end 1 about element y-axi s 
MOMIZ REAL Moment at end 1 about element z-axis 
FORC2X REAL Force at end 2 in element x-axis 
direction 
FORC2Y REAL Force at end 2 in element y-axis 
direction 
FORC 2Z REAL Force at end 2 in element z-axis 
direction 
MOM2X REAL Moment at end 2 about element x-axis 
MOM2Y REAL Moment at end 2 about element y-axis 
MOM2Z REAL Moment at end 2 about element z-axis 
CONDNUM INTEGER Condition # for this data 
22 
VI. SPAR TO RIM PROCESSOR RELATIONS 
F. PLATE STRESSES 
Rel,:ltion Niime: "PLATSTRS" 
Description: Stress resultants for 3 and 4 node elements 
Reldtion contents: 
Attlribute Name 
CMPONENT 
ELEJ~ENT# 
NXC 
NYC 
NXYC 
MXC 
MYC 
MXYC 
QXC 
QYC 
CONDNUM 
Type 
INTEGER 
INTEGER 
REAL 
REAL 
REAL 
REAL 
REAL 
REAL 
REAL 
REAL 
INTEGER 
23 
Contents 
Component # 
Element # 
St ress resul tant in x-di rect ion 
at center 
Stress resultant in y-direction 
at center 
Shear stress resultant at center 
Bending moment about x-axis at 
center 
Bending moment about y-axis at 
center 
Twisting moment at the center 
Transverse shear at center on x-face 
Transverse shear at center on y-face 
Condition # for this data 
VII. CONCLUDING REMARKS 
The schema presented in this report has been used for a wide variety of 
engineering applications. The schema is not completely fixed, however, since it is 
being updated as new attributes and relations are found to be essential in 
maintaining a complete data description. 
24 
VIII. REFERENCES 
1. Blackburn" C. L.; Storaasli, O. 0.; and Fulton, R. L: "The Role and Applica-
t i on of Data Base Management in Integrated Computer-Ai ded Des i gn" Presented 
at the AIAAjASMEjASCEjAHS 23rd Structures, Structural Dynamics, and Material 
ConferencE~, New Orl eans, LA, May 10-12, 1982. 
2. Fishwick, P. A.; and Blackburn, C. L.: "Managing Engineering Data Bases: The 
Re·lationa~ Approach" (CIME) Computers in Mechanical Engineering, Vol. 1, No. 
3, Jan. 1983. 
3. Codd, E. F.: "Relational Data Base: A Practical Foundation for 
Productivity" Communications of the ACM, Vol. 25, No.2, Feb. 1982. 
4. R 1M User's Gu ide. Academi c Computer Center, Uni vers i ty of Washi ngton, W33, 
Jan. 1980. 
5. Fulton, R. L: "IPAD Project Overview" NASA Conference Publication 2143, 
Sept. 17-19, 1980. 
25 
N 
'" 
P RID E 
EXECUTIVE 
HEA~ GRAPHICS LOADS I NCIIR) 
INPLOT) I NPLOTl 
"""""" ...... , """............ \ / / ,...../ 
'...... ...... \ / // ",..../ 
............ '...... \ / / "../ 
............. ...... \ / // ..... ",/ 
"'u", "'@{, ~ )E0 /~///--~_/ 
.................... ......, \ / /' ..... / / // ..... / 
............. ....... \ /1 ",.""/ ,///// 
.............. ............. \ 
.................... '....... \ / // ..... / 
DATA PATH -_ ...... , '& .f _/ _// 
® PRE- AND PDST-PROCESSOR RELATIONAL INFORMATION 
MANAGEMENT 
SYSTEM 
Figure 1. - An example of the role of the relational data manager. 
// 
...... 
x 
'"1"1 
...... 
en 
c: 
;;:0 
f'T'I 
VI 
1. Report No. 
NASA CR-·172183 I 2. Governme~~ Accession No. 
4. Title and Subtitl~ 
PROTOTYPE INTEGRATED DESIGN SYSTEM 
REFERENCE MANUAL: VOLUME 2 - SCHEMA DEFINITION 
7. Author(s) 
3. Recipient's Catalog No. 
5. Report Date 
JulY 1983 
6. Performing Organization Code 
B. Performing Organization Report No. 
Paul A. Fishwic:k, Thomas R. Sutter, Charles L. Blackburn ...---____________ • 
1-----.-----------------------------1 to. Work Unit No. 
9. Performing Organization Name and Address 
Kentron Technical Center 
Hampton, VA 23666 11. Contract or Grant No. 
NASl-16000 
~----,-----------------------------_1 13. Type of Report and Period Collered 
12. Sponsoring Agency Name and Address 
National Aeronautics and Space Administration 
Washington, DC 20546 
Contractor Report 
14. Sponsoring Agency Code 
~ ______ -----_____ - __ ----------.---------~--_-----L------------------------~ 15. Supplementilry Notes 
Langley Technical Monitor: Timothy Roo Rau 
Final Report 
~------------------------------.--------------------------------------------~ 16. Abstract 
An initial description of an evolving relational database schema is 
presented for the management of finite element model design and analysis data. 
The rE!port presents a description of each relation including attribute names, 
data types, and definitions. The format of this report is such that future 
modifications and enhancements may be easily incorporated. 
~~--~-----------------------------~~------------------------------------_4 17. Key Words (Suggested by Author(s)) lB. Distribution Statement 
Relational data management 
Finite element model ing 
Integrated design 
Data base schema 
19. Security Oassif. (of this report) , 
Unclassified 
20. Security Classif, (of this page) 
Unclassified 
Unclassified - Unlimited 
Subject Category 61 
21. No. of Pages 
28 
22. Price 
A03 
N-305 For sale by the National Technica~ !nfor''r,;:;tic<~ <iervice, Sprirgie!d, Virginia 22161 
End of Document 


Protoptype integrated design (Pride) system reference manual. Volume 2: Schema definition

Abstract

Similar works

Full text

Available Versions

NASA Technical Reports Server