1993. Parametric Equation Determination: A Relational Database Approach Using Dynamic Views
$20.00
SAWE Members get a $200 store credit each year.*
*Store credit coupon available at checkout, click the button in your shopping cart to apply the coupon.
Not applicable to SAWE textbooks and current conference technical papers.
Paper
Abstract
The process discussed in this paper utilizes INGRES relational database technology to efficiently store and retrieve data used in an engineering process. An INGRES 4GL user frame is used to organize the columns into the desired data sets (views) and to facilitate the engineering analysis. A 3GL ”C” procedure is used to create the view. These database views may contain several columns from one table or they may contain columns from several tables. The views are created dynamically with the use of pop-up menus and cursor selections. The views are used for data retrieval and are stored for repeated use and/or editing. Advantages of this method over traditional methods are non-duplication of work and facilitated data handling. Additional advantages are the removal of the Database Administrator (DBA) from the ”view” creation process and added flexibility for the user.