The ability to share data among the numerous software applications used to design and analyze products is an important aspect of computer integrated manufacturing. In the past, data sharing has been implemented by direct translation of data files, through neutral data formats, and through central shared databases. This paper describes a data sharing architecture that addresses some of the limitations of these systems. It employs a database management system as a central repository for part data in an application independent format. A configurable translator, called Datatrans, is used to transfer data between the database management system and native application data files. In this way software from multiple independent vendors or legacy software can be supported, because applications need not incorporate code specific to any database management system nor have knowledge of the centralized database schema. The translator uses grammars to define and recognize the data to be translated. The grammar is augmented with commands that are passed to the front-end of the database management system or to application programs to store and retrieve data. Thus the query language and the application commands serve as a high level interface to the underlying database and application data files. Entity transformations that are beyond the scope of a grammatical description are performed by database methods, which are available to all applications. An implementation of the system demonstrates the feasibility of this approach.

Issue Section:
Technical Papers
Keywords:
manufacturing processes, computer aided analysis, computer software, database management systems, grammars
Topics:
Computer software, Computer-integrated manufacturing, Database management systems, Databases
1.
Korenjak, A. J., and Teger, A. H., 1975, “An Integrated CAD Data Base System,” Proceedings of the 12th Design Automation Conference, IEEE, pp. 399–406.
2.
Beeby
,
W.
,
1982
, “
The Future of Integrated CAD/CAM Systems: the Boeing Perspective
,”
IEEE Comput. Graphics Appl.
,
2
, No.
1
, pp.
51
–
56
.
3.
Blackburn
,
C. L.
,
Storaasli
,
O. O.
, and
Fulton
,
R. E.
,
1983
, “
The Role and Application of Data Base Management in Integrated Computer-Aided Design
,”
J. Aircr.
,
20
, No.
8
, pp.
717
–
725
.
4.
Taylor, D. L., 1988, “Integrated Mechanical Analysis Project,” Proceedings, 1988 ASME Computers in Engineering Conference, ASME, New York, N. Y., pp. 189–196.
5.
Lapointe, J., 1985, “An Information Based Approach to Integrated Computer-Aided Engineering,” Masters Thesis, The University of Rhode Island.
6.
Sidle, T. W., 1980, “Weaknesses of Commercial Data Base Management Systems in Engineering Applications,” Proceedings of the 17th Design Automation Conference, pp. 57–61.
7.
Frank, U., and Klein. S., 1992, “Three Integrated Tools for Designing and Prototyping Object-oriented Enterprise Models,” NTIS Report GMD-689, US Department of Commerce.
8.
Gilliam
,
C.
,
1994
, “
An Approach for Using OMT in the Development of Large Systems
,”
Journal of Object-Oriented Programming
,
6
, No.
9
, pp.
56
–
59
.
9.
Shah
,
J. J.
, and
Rogers
,
M. T.
,
1988
, “
Functional Requirements and Conceptual Design of the Feature-Based Modeling System
,”
Computer-Aided Engineering Journal
,
5
, No.
1
, pp.
9
–
15
.
10.
Whelan, P. T., and Fulton, R. E., 1988, “Experiences With Relational and Object Oriented DBMS s for CAD/CAM Data,” Managing Engineering Data: Emerging Issues, The 1988 ASME International Computers in Engineering Conference and Exhibition, ASME, New York, N.Y., pp. 13–18.
11.
Yang, Y. K., 1988, “A Natural Data Organization for a CSG-Based CAD Database,” Proceedings, 1988 ASME Conference on Computers in Engineering, ASME, New York, New York, pp. 301–307.
12.
Spooner
,
D. L.
, and
Hardwick
,
M.
,
1997
, “
Using Views for Product Data Exchange
,”
IEEE Comput. Graphics Appl.
,
17
, No.
5
, pp.
58
–
65
.
13.
Ryan, S. A., 1992, “PDES/STEP: A Status Report,” Engineering Data Management: Key to Integrated Product Development, Proceedings of the 1992 ASME International Computers in Engineering Conference and Exposition, T. R. Chase et al. ed., ASME, New York, N. Y., pp. 43–47.
14.
Aho, A. V., Sethi, R., and Ullmann, J. D., 1986, Compilers, Principles, Techniques, and Tools. Addison-Wesley, Reading MA.
15.
AutoCAD, 1988, AutoCAD Release 10 Reference Manual, AutoDesk Incorporated.
16.
ANSYS, 1994, ANSYS Version 5.0 Users Manual, Swanson Analysis Systems Incorporated.
17.
Stonebraker, M., 1987, “The POSTGRES Storage System,” Proceedings of the 1987 VLDB Conference, Brighton England.
18.
Huang, J., Wang, T., Wan, L., Zhang, X., and Zhou, J., 1994, “Step-based CAD/CAPP/CAM Integrated Systems: CADMIS,” Engineering Data Management: Integrating the Engineering Enterprise, ASME.
Copyright © 2002
 by ASME
You do not currently have access to this content.