Skip to main content
Log in

The metadatabase approach to integrating and managing manufacturing information systems

  • Papers
  • Published:
Journal of Intelligent Manufacturing Aims and scope Submit manuscript

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.

Access this article

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

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.

    Google Scholar 

  • Babin, G. (1993) Adaptiveness in information systems integration, Ph.D. Thesis, Decision Sciences and Engineering Systems, Rensselaer Polytechnic Institute, Troy, NY, USA.

    Google Scholar 

  • Bouziane, M. (1991) Metadata modeling and management, PhD Thesis, Computer Science, Rensselaer Polytechnic Institute, Troy, NY, USA.

    Google Scholar 

  • Cheung, W. (1991) The model-assisted global query system, PhD Thesis, Decision Sciences and Engineering Systems, Rensselaer Polytechnic Institute, Troy, NY, USA.

    Google Scholar 

  • Chung, C. W. (1990) DATAPLEX: an access to heterogeneous distributed databases. Communications of the ACM, 33(1), 70–80.

    Google Scholar 

  • Dolk, D. and Kirsch, R. II(1987) A relational information resource dictionary system. Communications of the ACM, 30(1), 48–61.

    Google Scholar 

  • 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.

    Google Scholar 

  • 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.

    Google Scholar 

  • 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.

    Google Scholar 

  • 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.

    Google Scholar 

  • 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.

    Google Scholar 

  • 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.

    Google Scholar 

  • 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.

    Google Scholar 

  • Landers, T. and Rosenberg, R. L. (1982) An overview of MULTIBASE, in Second Symposium on Distributed Database, North Holland, New York, pp. 311–336.

    Google Scholar 

  • 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.

    Google Scholar 

  • 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.

    Google Scholar 

  • Sheth, A. and Larson, J. (1990) Federated database systems for managing distributed, heterogeneous, and autnomous databases. ACM Computing Surveys, 22(3), 203–236.

    Google Scholar 

  • Shipman, D. (1981) The functional data language DAPLEX. ACM Transactions on Database Systems, 6(1), pp. 140–193.

    Google Scholar 

  • 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.

    Google Scholar 

  • 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.

    Google Scholar 

  • Wang, R. and Madnick, S. (1989) Facilitating connectivity in composite information systems. ACM Data Base, 20(3), 38–46.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Additional information

A preliminary version of this paper was presented to the Third International Conference on Computer Integrated Manufacturing, May 1992.

Rights and permissions

Reprints 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

Download citation

  • Issue Date:

  • DOI: https://doi.org/10.1007/BF00127651

Keywords

Navigation