Integration has become a self-evident goal in today's manufacturing enterprises. Since the late 1970s, numerous efforts have been launched world-wide to develop, employ, and deploy integration technology as a strategic weapon to compete in the global market-place. Important results have been obtained, including computer integrated manufacturing (CIM), concurrent engineering, and enterprise re-engineering. The field is poised to tackle some fundamental barriers of integration and thereby effect a new quantum jump in overall productivity, where information will become a fourth basic factor of production along with land, labor and capital. Among the barriers are the lack of information technology enabling multiple systems operating concurrently over different geographical regions. This paper discusses a unique approach to the integration problem regarding information resources management, global query and concurrent systems administration. This approach is based on the metadatabase model which incorporates both data and knowledge in order to accomplish information integration across manufacturing functions. Basic concepts, methods and techniques have been developed for the approach and verified via a prototype metadatabase system. The system's primary components and major functionalities are discussed and illustrated in detail through the use of an extended example of a pilot manufacturing system comprising order processing, process design and shop floor control. It will also provide the reader with a simulated system demonstration.
This is a preview of subscription content, log in via an institution to check access.
Similar content being viewed by others
References
ANSI (American National Standards Institute) (1985) (Draft proposed) American National Standard Information Resource Dictionary System: Part 1 - core standard. ANSI X3H4, American National Standards Institute, New York.
Babin, G. (1993) Adaptiveness in information systems integration, Ph.D. Thesis, Decision Sciences and Engineering Systems, Rensselaer Polytechnic Institute, Troy, NY, USA.
Bouziane, M. (1991) Metadata modeling and management, PhD Thesis, Computer Science, Rensselaer Polytechnic Institute, Troy, NY, USA.
Cheung, W. (1991) The model-assisted global query system, PhD Thesis, Decision Sciences and Engineering Systems, Rensselaer Polytechnic Institute, Troy, NY, USA.
Chung, C. W. (1990) DATAPLEX: an access to heterogeneous distributed databases. Communications of the ACM, 33(1), 70–80.
Dolk, D. and Kirsch, R. II(1987) A relational information resource dictionary system. Communications of the ACM, 30(1), 48–61.
Dolk, D. and Kirsch, R. II (1988) A Technical Overview of the Information Resource Dictionary System (2nd edn), NBS Special Publication NBSIR 88–3700, National Bureau of Standards, Gaithersburg, MD.
Hsu, C. (1985) Structured database systems analysis and design through entity-relationship approach, in Proceedings of the 4th International Conference on Equity-Relationship Approach, IEEE Computer Society, Chicago, IL, pp. 56–63.
Hsu, C. and Babin, G. (1993) A rule-oriented concurrent architecture to effect adaptiveness for integrated manufacturing enterprises, in Proceedings of the IEPM '93 Conference, Brussels, Belgium, pp. 868–899.
Hsu, C. and Rattner, L. (1990) Information modeling for computerized manufacturing. IEEE Transactions on Systems, Man and Cybernetics, 20(4), 758–776.
Hsu, C. and Skevington, C. (1987) Integration of data and knowledge in manufacturing enterprises: a conceptual framework. Journal of Manufacturing Systems, 6(4), 277–285.
Hsu, C., Bouziane, M., Rattner, L. and Yee, L. (1991) Information resources management in heterogeneous, distributed environments: a metadatabase approach. IEEE Transactions on Software Engineering, June, 604–625.
Hsu, C., Babin, G., Bouziane, M., Cheung, W., Rattner, L. and Yee, L. (1992) Metadatabase modeling for enterprise information integration. Journal of Systems Integration, 2(1), 5–39.
Hsu, C. and Yee, L. (1993) Model-based visualization for enterprise information management, in Proceedings 4th Annual Conference on Artificial Intelligence, Simulation and Planning in High Antonomous Systems, IEEE Computer Society Press, Tucson, Arizona, pp. 324–329.
Hsu, C., Gerhardt, L., Spooner, D. and Rubenstein, A. (1993) Adaptive integrated manufacturing enterprises: new information technology for the next decade. IEEE Transactions on Systems, Man and Cybernetics, forthcoming.
Krishnamurty, V., Su, S. Y. W., Lam, H., Mitchell, M. and Barkmeyer, E. (1988) IMDAS, an integrated manufacturing data administration system. Data and Knowledge Engineering, 3(2), 109–131.
Landers, T. and Rosenberg, R. L. (1982) An overview of MULTIBASE, in Second Symposium on Distributed Database, North Holland, New York, pp. 311–336.
McLeod, D. (1990) Interbase: an approach to controlled sharing among autonomous, heterogeneous database systems. Data Engineering Bulletin, Fall, 4–9.
Rattner, L. (1990) Information requirements for integrated manufacturing planning and control: a theoretical model, PhD Thesis, Decision Sciences and Engineering Systems, Rensselaer Polytechnic Institute, Troy, NY, USA.
Reddy, M. P., Prasad, B. E. and Reddy, P. G. (1989) Query processing in heterogeneous distributed database management systems, in Integration of Information Systems: Bridging Heterogeneous Databases, Gupta, A. (ed.), IEEE Press, pp. 264–277.
Rem, S. (1991) Guest editor's introduction: heterogeneous distributed database systems. Computer, 24(12), 7–11.
Sheth, A. and Larson, J. (1990) Federated database systems for managing distributed, heterogeneous, and autnomous databases. ACM Computing Surveys, 22(3), 203–236.
Shipman, D. (1981) The functional data language DAPLEX. ACM Transactions on Database Systems, 6(1), pp. 140–193.
Smith, J. M., Bernstein, P. A., Dayal, U., Goodman, N., Landers, T., Lin, K. W. T. and Wong, E. (1981) MULTIBASE - integrating heterogeneous distributed data systems. AAFIPS Proceedings, 50, 487–499.
US Air Force(1983) Integrated Information Support System (IISS) Report, Integrated Computer Aided Manufacturing (ICAM), Materials Laboratory, Air Force Systems Command, Wright-Patterson Air Force Base, OH, February.
Wang, R. and Madnick, S. (1989) Facilitating connectivity in composite information systems. ACM Data Base, 20(3), 38–46.
Author information
Authors and Affiliations
Additional information
A preliminary version of this paper was presented to the Third International Conference on Computer Integrated Manufacturing, May 1992.
Rights and permissions
About this article
Cite this article
Hsu, C., Babin, G., Bouziane, M. et al. The metadatabase approach to integrating and managing manufacturing information systems. J Intell Manuf 5, 333–349 (1994). https://doi.org/10.1007/BF00127651
Issue Date:
DOI: https://doi.org/10.1007/BF00127651