In order to accommodate today's demands of shortening product life cycle and rapid technology changes, integrated sys tems are being employed by manufacturers to support concurrent engineering (CE). In this paper, authors propose a distributed CE en vironment using STEP and database configuration methodologies. The CE environment consists of hierarchically organized database systems in which integrity of the data is maintained throughout. The working data are not allowed to be referenced by other down stream application systems until they are matured enough to be released into a global database. For efficient validation, the integrity constraints are distributed into local and global schemata. They (integrity constraints) are written in EXPRESS and are validated at both places (in local and global databases). A prototype has been built to demonstrate the major features of this distributed CE environment. By maintaining the integrity of the product data, undesirable propagation of illegal data to other application systems is prevented. Sepa rate triggering mechanisms are devised using the dependency of constraints to three different data operations: insertion, deletion, and update.
B. Prasad, 1996. Concurrent Engineering Fundamentals, Volume I: Integrated Product and Process Organization, Prentice Hall, New Jersey.
2.
D. Carter and B. Baker, 1992. Concurrent Engineering: The Product Development Environment for the 1990s, Addison-Wesley Publishing Company , Reading, Massachusetts.
3.
N. Matta, O. Corby and B. Prasad, 1998. "A Generic Library of Knowledge Components to Manage Conflicts in CE Tasks," Concurrent Engineering: Research and Applications, Vol. 6, No. 4, Technomic Publishing Company, Inc.
4.
A. McKay, M. Bloor and A. de Pennington , 1996. "A Framework for Product Data,"IEEE Transactions on Knowledge and Data Engineering , Vol. 8, No. 5.
5.
Y. Chen, C. Liao and B. Prasad, 1998. "A Systematic Approach of Virtual Enterprising through Knowledge Management Techniques," Concurrent Engineering: Research and Applications, Vol. 6, No. 3, Technomic Publishing Company, Inc.
6.
Iso, Industrial Automation Systems and Integration Product Data Representation and Exchange Part 1: Overview and Fundamental Principles, Geneva, 1994.
7.
Iso, Industrial Automation Systems and Integration Product Data Representation and Exchange Part 22: Implementation Methods: Standard Data Access Interface Specification (Final Draft International Standard), Geneva, 1998.
8.
Iso, Industrial Automation Systems and Integration Product Data Representation and Exchange Part 11: Description Methods: The EXPRESS Language Reference Manual, Geneva, 1994.
9.
B. Prasad, 1997. Concurrent Engineering Fundamentals, Volume II: Integrated Product Development, Prentice Hall, New Jersey.
10.
M. Hardwick , D. Spooner, T. Rando and K.C. Morris, 1996. "Sharing Manufacturing Information in Virtual Enterprises,"Communications of the ACM, Vol. 39, No. 2, pp. 46-54.
11.
J. Wu, T. Liu and G. Fisher, "An Integration of CAE and CAM Applications Using PDES/STEP Information Model," Technical Report, Center of Computer-Aided Design, The University of Iowa, Iowa City, IA, 1992.
12.
Y. Zhang, C. Zhang and H.P. Wang, 1998. "Interoperation of STEP Application Protocols for Product Data Management," Concurrent Engineering: Research and Applications, Vol. 6, No. 2, Technomic Publishing Company, Inc.
13.
B. Prasad, F. Wang and J. Deng, 1997. "Towards a Computer-Supported Cooperative Environment for Concurrent Engineering," Concurrent Engineering: Research and Applications, Vol. 5, No. 3, Technomic Publishing Company, Inc.
14.
J. Vuoskoski et. al., 1994. "Using EXPRESS in High Energy Physics Research Environment," in P. Wilson, editor, Proc. Fourth International EXPRESS User Group Conference , Meeting Associates, Clifton Park, N.Y.
15.
T. Divoux et. al., 1994. "Using EXPRESS: to Define MMS Manufacturing Communication," in P. Wilson, editor, Proc. Fourth International EXPRESS User Group Conference, Meeting Associates, Clifton Park, N.Y.
16.
F. Schoenefeld and C. Bohm, 1993. "Using EXPRESS Database Technology for Accessing NCBI Genomic Data," in P. Wilson, editor, Proc. Third International EXPRESS User Group Conference , Meeting Associates, Clifton Park, N.Y .
17.
M. Eberl, 1994. "Integrated System for Furniture Manufacturing,"Proc. of International Conference on Data and Knowledge Systems for Manufacturing and Engineering, Hong Kong, pp. 383-388.
18.
W. Mueller, G. Lehrenfeld and N. Wiechers, 1993. "Parallel Validation of STEP Files," Proc. Third International EXPRESS User Group Conference, Meeting Associates, Clifton Park, N.Y.
19.
S.B. Yoo and S.K. Cha, 1993. "Checking EXPRESS Constraints in a Heterogeneous Database Environment," Proc. Third International EXPRESS User Group Conference, Meeting Associates, Clifton Park, N.Y .
20.
J. Alt, 1994. "Optimizing EXPRESS Rule Evaluation with File-Grained Dynamic Materialization in CAD Applications," Proc. Fourth International EXPRESS User Group Conference, Meeting Associates, Clifton Park, N.Y.
21.
Henschen, W.McCune and S. Naqvi, 1984. "Compiling Constraint-Checking Programs from First-Order Formulas,"Advances in Database Theory , Vol. 2, H. Gallaire, J. Minker and J-M. Nicolas, eds., Plenum Press, pp. 145-170.
22.
H. Jagadish and X. Qian, 1992. "Integrity Maintenance in an Object-Oriented Database,"Proc. ACM-SIGMOD 1992 Int'l Conf. on Management of Data, pp. 469-480.
23.
F. Cacace, S. Ceri, S. Crespi-Reghizzi, L. Tanca and R. Zicari, 1990. "Integrating Object-Oriented Data Modeling with a Rule-Based Programming Paradigm,"Proc. ACM-SIGMOD 1990 Int'l Conf. on Management of Data, pp. 225-236.
24.
S. Urban, A. Karadimce and R. Nannapaneni, 1992. "The Implementation and Evaluation of Integrity Maintenance Rules in an Object-Oriented Database,"Proc. Eight Int'l Conf. on Data Engineering, pp. 565-572.
25.
A. Sheth and J. Larson, 1990. "Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases,"ACM Computing Surveys, Vol. 22, No. 3, pp. 183-236.
26.
J. Blakeley , N. Coburn and P. Larson, 1989. "Updating Derived Relations: Detecting Irrelevant and Autonomously Computable Updates,"ACM Trans. on Database Systems, Vol. 14, No. 3, pp. 369-400.
27.
A. Gupta and J. Widom, 1993. "Local Verification of Global Integrity Constraints in Distributed Databases,'' Proc. ACM-SIGMOD 1993 Int'l Conf. on Management of Data, pp. 49-58.
28.
G. Blelloch , 1986. "CIS: a Massively Concurrent Rule-Based System,"Proc. Fifth Nat'l Conf. Artificial Intelligence, AAAI, pp.735-741.
29.
NIST, STEP Class Library (SCL) (http://www.nist.gov/scl), 1999.
30.
J. Hammer, H. Garcia-Molina, J. Widom, W. Labio and Y. Zhuge, 1995. "The Stanford Data Warehousing Project,"IEEE Data Engineering Bulletin, June.
31.
Y. Zhuge, H. Garcia-Molina, J. Hammer and J. Widom, 1995. "View Maintenance in a Warehousing Environment,"Proc. ACM SIGMOD Int'l Conf. On Management of Data, San Jose, California , June.
