E-R Approach to Distributed Heterogeneous Database Systems for Integrated Manufacturing

A critical step towards computer integrated manufacturing (CIM) is the integration of computer-aided design (CAD) and computer-aided manufacturing (CAM). Well developed CAD, CAM, and Business data processing systems generally exist in an organization. These systems represent years of work and very large investment for the organization. Thus a necessary condition for integration is defining schemes through which existing engineering and non-engineering data can be represented and manipulated in an integrated way. In this paper a Common Data Model (CDM) approach to distributed heterogeneous database is adopted for CAD/CAM integration and an Extended-Entity- Category-Relationship (EECS) Model (an extension of ER model) is proposed. The use of EECR model as a common conceptual data model for representing engineering and non-engineering data is discussed.

[1]  Won Kim,et al.  Object-Oriented Concepts, Databases, and Applications , 1989 .

[2]  Jay Banerjee,et al.  Composite object support in an object-oriented database system , 1987, OOPSLA '87.

[3]  Shamkant B. Navathe,et al.  A Methodology for View Inegration in Logical Database Design , 1982, VLDB.

[4]  Arlette Ferrier,et al.  Heterogeneity in the Distributed Database Management System SIRIUS-DELTA , 1982, VLDB.

[5]  Terry A. Landers,et al.  An Overview of MULTIBASE , 1986, DDB.

[6]  Alejandro P. Buchmann.  Current trends in CAD databases , 1984 .

[7]  Won Kim,et al.  Versions and change notification in an object-oriented database system , 1988, 25th ACM/IEEE, Design Automation Conference.Proceedings 1988..

[8]  Virgil D. Gligor,et al.  Interconnecting Heterogeneous Database Management Systems , 1984, Computer.

[9]  H. R. Johnson,et al.  A DBMS Facility for Handling Structured Engineering Entities , 1983, Engineering Design Applications.

[10]  Sushil Jajodia,et al.  Translation of entity-relationship diagrams into relational structures , 1984, J. Syst. Softw..

[11]  Gideon Halevi.  The role of computers in manufacturing processes , 1980 .

[12]  Umeshwar Dayal,et al.  Using the Entity-Relationship Model for Implementing Multi-Model Database Systems , 1981, ER.

[13]  Iris Kameny,et al.  A metadata management system to support data interoperability, reuse and sharing , 1994 .

[14]  Laurian M. Chirica,et al.  The entity-relationship model: toward a unified view of data , 1975, SIGF.