Constraint Enforcement in a Structural Design Data Base
Publication: Journal of Structural Engineering
Volume 112, Issue 12
Abstract
During the design of a commercial structure large amounts of information pertaining to all aspects of the project must be stored, accessed, and operated upon. A data base management system (DBMS), composed of a central repository of data and the associated software for controlling access to it, provides one way to generate, represent, manage, and use this information. This paper uses the relational database model to represent structural design data and constraints. Data integrity is defined and its enforcement through the use of engineering design constraints is described. A model that enables the engineer to incorporate design constraints into a relational database is presented. The use of constraints in both passive checking and active design modes is explored. An example is presented that demonstrates the concepts discussed using a commercially available DBMS designed for use by the engineering community.
Get full access to this article
View all available purchase options and get full access to this article.
References
1.
Boeing Computer Services Company (BCS). (1983). BCS RIM Relational Information Management Systems Version 6.0 Users Guide. Seattle, Wash.
2.
Date, C. J. (1981). An Introduction to Database Systems, Addison Wesley Publishing Co., Reading, Mass.
3.
Erickson, W. J., Gray, F. P., Limbach, G. (1981). Relational Information Management System. Version 5.0 edition, Boeing Commercial Airplane Company, Seattle, Wash.
4.
Fenves, S. J. and Wright, R. N. (1977). “The Representation and Use of Design Specificaitons.” Structural and Geotechnical Mechanics, Prentice‐Hall, Inc., Englewood Cliffs, N.J., 277–304.
5.
Fenves, S. J. and Rasdorf, W. J. (1982). “Role of Database Management Systems in Structural Design.” Proceedings of the IABSE Colloqium on Informatics in Structural Engineering, International Association of Bridge and Structural Engineers, Bergamo, Italy, 229–242.
6.
Fenves, S. J. and Rasdorf, W. J. (1985). “Treatment of Engineering Design Constraints in a Relational Database.” Engineering With Computers, Apr.
7.
Holtz, N. M. (1982). “Symbolic Manipulation of Design Constraints—An Aid to Consistency Management.” Technical Report DRC‐02‐012‐82, Design Research Center, Carnegie‐Mellon Univ., Pittsburgh, Pa.
8.
Johnson, R. C. (1981). “Object‐Oriented Language Feels Natural.” Electronics, July, 106–108.
9.
Rasdorf, W. J. (1982). “Structure and Integrity of a Structural Engineering Design Database.” Technical Report DRC‐02‐14‐82, Design Research Center, Carnegie‐Mellon Univ., Pittsburgh, Pa.
10.
Rasdorf, W. J. and Fenves, S. J. (1983). “Organization of a Structural Engineering Design Database.” Proceedings, Eighth Conf. on Electronic Computation, ASCE, New York, N.Y., 559–571.
11.
Rasdorf, W. J., and Salley, G. C. (1985). “Generative Engineering Databases—Toward Expert Systems.” Computers and Structures, Pergamon Press, Inc., New York, N.Y., Vol. 20, No. 1–3, 11–15.
12.
Sandberg, G. (1981). “A Primer on Relational Database Concepts.” IBM Systems Journal, 20(1), 23–40.
13.
Schaefer, M. J. (1982). “Constraint Processing Alternatives in an Engineering Design Database.” Technical Report DRC‐01‐13‐82, Design Research Center, Carnegie‐Mellon Univ., Pittsburgh, Pa.
14.
Schaefer, M. J. Rehak, D. R., Fenves, S. J. (1982). “A Tutorial on Relational Databases Using Structural Engineering Examples.” Technical Report DRC‐12‐09‐82, Design Research Center, Carnegie‐Mellon Univ., Pittsburgh, Pa.
15.
Ullman, J. D. (1980). Principles of Database Systems, Computer Science Press, Inc., Potomac, Md.
Information & Authors
Information
Published In
Copyright
Copyright © 1986 ASCE.
History
Published online: Dec 1, 1986
Published in print: Dec 1986
Authors
Metrics & Citations
Metrics
Citations
Download citation
If you have the appropriate software installed, you can download article citation data to the citation manager of your choice. Simply select your manager software from the list below and click Download.