Database requirements of CIM applications

  • G. Kappel
  • S. Vieweg
Part of the Lecture Notes in Computer Science book series (LNCS, volume 973)


Changes in market and production profiles require a more flexible concept of manufacturing. Computer Integrated Manufacturing (CIM) describes an integrative concept for joining business and manufacturing islands. In this context database technology is the key technology for implementing the CIM philosophy. However, CIM applications are more complex and thus, more demanding than traditional database applications like business and administrative applications. In this chapter we systematically analyze the database requirements for CIM applications including business and manufacturing tasks. Special emphasis is given on integration requirements due to the distributed, partly isolated nature of CIM applications developed over the years. An illustrative sampling of current efforts in the database community to meet the challenge of nonstandard applications like CIM concludes this chapter.

Additional key words and phrases

extended relational database systems object-oriented database systems database requirements of CIM 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [Adelsberger92]
    H. Adelsberger et al.; The Concept of Knowledge-Based Leitstand — Summary of First Results; Proc. of the 8th CIM-Europe Annual Conference; C. O'Brien, P. MacConaill, and W. Van Puymbroeck (eds.); Springer Verlag; Birmingham, UK; 1992Google Scholar
  2. [Ahad92]
    R. Ahad, D. Dedo; OpenODB from Hewlett-Packard: a Commercial Object-Oriented Database Management System; Journal of Object-Oriented Programming (JOOP); Feb. 1992Google Scholar
  3. [Ahmed92]
    S. Ahmed, A. Wong, D. Sriram, R. Logcher; Object-oriented database management systems for engineering: A Comparison; Journal of Object-Oriented Programming (JOOP); Jun. 1992Google Scholar
  4. [Andrews91]
    T. Andrews, C. Harris, K. Sinkel; Ontos: A Persistent Database for C++; Object-Oriented Databases with Applications to CASE, Networks, and VLSI CAD; Prentice-Hall; in: [Gupta91]; 1991Google Scholar
  5. [Atkinson89]
    M. Atkinson, F. Bancilhon, D. DeWitt, K. Dittrich, D. Maier, S. Zdonik; The Object-Oriented Database System Manifesto; Proc. First Int. Conf. on Deductive and Object-Oriented Databases; Dec. 1989Google Scholar
  6. [Bancilhon89]
    F. Bancilhon; Query Languages for Object-Oriented Database Systems: Analysis and a Proposal; Proc. of the GI Conf. on Database Systems for Office, Engineering, and Scientific Applications; Springer IFB 204; Mar. 1989Google Scholar
  7. [Banerjee87]
    J. Banerjee, W. Kim, H. Kim, H. Korth; Semantics and implementation of schema evolution in object-oriented databases; SIGMOD Record, Vol. 16, No. 3; Dec. 1987Google Scholar
  8. [Barghouti91]
    N. Barghouti, G. Kaiser; Concurrency Control in Advanced Database Applications; ACM Computing Surveys, Vol. 23, No. 3; Sept. 1991Google Scholar
  9. [Batini92]
    C. Batini, C. Ceri, S. Navathe; Conceptual Database Design: An Entity-Relationship Approach, Benjamin/Cummings Publ.; 1992Google Scholar
  10. [Bedworth91]
    D. Bedworth, M. Henderson, P. Wolfe; Computer-Integrated Design and Manufacturing; Mechanical Engineering Series, McGraw-Hill NY; 1991Google Scholar
  11. [Bernstein87]
    P. Bernstein, V. Hadzilacos, N. Goodman; Concurrency Control and Recovery in Database Systems; Addison-Wesley, Reading MA; 1987Google Scholar
  12. [Bjørke92]
    Ø. Bjørke, O. Myklebust (eds.); IMPPACT — Integrated Modelling of Products and Processes using Advanced Computer Technologies; TAPIR Publishers; 1992Google Scholar
  13. [Butterworth91]
    P. Butterworth, A. Otis, J. Stein; The GemStone Object Database Management System; Communications of the ACM; Vol. 34, No. 10; Oct. 1991Google Scholar
  14. [Cattell91]
    R. Cattell; Object data management: object-oriented and extended database systems; Addison-Wesley, Reading MA; 1991Google Scholar
  15. [Cattell92]
    R. Cattell, J. Skeen; Object Operations Benchmark; ACM Transactions on Database Systems (TODS); Vol. 17, No. 1; 1992Google Scholar
  16. [Codd70]
    E. Codd; A relational model for large shared data banks; Communications of the ACM; Vol. 16; No. 6; 1970Google Scholar
  17. [Dayal88]
    U. Dayal et. al.; The HiPAC Project: Combining Active Databases and Timing Constraints; SIGMOD Record Vol. 17, No. 1; 1988Google Scholar
  18. [Deux91]
    O. Deux; The O2 System; Communications of the ACM; Vol. 34, No. 10; Oct. 1991Google Scholar
  19. [Dittrich90]
    K. Dittrich; Object-Oriented Database Systems: The Next Miles of the Marathon; Information Systems; Vol. 15, No. 1; 1990Google Scholar
  20. [Elmasri89]
    R. Elmasri, S. Navathe; Fundamentals of Database Systems; Benjamin/Cummings; Redwood City CA; 1989Google Scholar
  21. [Encarnaçao90]
    J. Encarnaçao, P. Lockemann; Engineering Databases, Connecting Islands of Automation Through Databases; Springer Verlag; 1990Google Scholar
  22. [Fishman89]
    D. Fishman et. al; Overview of the Iris DBMS; in: W. Kim, F. Lochovsky (eds.); Object-Oriented Concepts, Databases, and Applications; ACM Press; 1989Google Scholar
  23. [Garcia83]
    H. Garcia-Molina; Using Semantic Knowledge for Transaction Processing in a Distributed Database; ACM Transactions on Database Systems (TODS), Vol. 8, No. 2; Jun. 1983Google Scholar
  24. [Garza88]
    J. Garza, W. Kim; Transaction Management in an Object-Oriented Database System; Proc. of the ACM SIGMOD Conf.; 1988Google Scholar
  25. [Gupta91]
    R. Gupta, E. Horowitz (eds.); Object-Oriented Databases with Applications to CASE, Networks, and VLSI CAD; Prentice-Hall; 1991Google Scholar
  26. [Gray93]
    J. Gray, A. Reuter; Transaction Processing: Concepts and Techniques; Morgan Kaufmann; 1993Google Scholar
  27. [Hammer91]
    H. Hammer; CAM-Konzepte — am Beispiel flexibler Fertigungssysteme; in: CIM Handbuch; U. Geitner (ed.); Vieweg Verlag; 1991Google Scholar
  28. [Harrington73]
    J. Harrington; Computer Integrated Manufacturing; Krieger Publishing, Malabar Fla., 1973Google Scholar
  29. [Hars92]
    A. Hars et al.; Reference Models for Data Engineering in CIM; Proc. of the 8th CIM-Europe Annual Conference; C. O'Brien, P. MacConaill, and W. Van Puymbroeck (eds.); Springer Verlag; Birmingham, UK; 1992Google Scholar
  30. [Härder83]
    T. Härder, A. Reuter; Principles of Transaction-Oriented Database Recovery; ACM Computing Surveys, Vol. 14, No. 4; 1983Google Scholar
  31. [Itasca92]
    ITASCA Systems, Inc.; Technical Summary for Release 2.1; 1992Google Scholar
  32. [Joseph91]
    J. Joseph, S. Thatte, C. Thompson, D. Wells; Object-Oriented Databases: Design and Implementation; Proc. of the IEEE, Vol. 79, No. 1; Jan. 1991Google Scholar
  33. [Kappel93]
    G. Kappel, S. Rausch-Schott, W. Retschitzegger, S. Vieweg; TriGS — Making a Passive Object-Oriented Database System Active; accepted for publication in: Journal of Object-Oriented Programming (JOOP); 1993Google Scholar
  34. [Katz90]
    R. Katz; Toward a Unified Framework for Version Modeling in Engineering Databases; ACM Computing Surveys, Vol. 22, No. 4; Dec. 1990Google Scholar
  35. [Kemper93]
    A. Kemper, G. Moerkotte; Object-Oriented Information Management in Engineering Applications; Prentice-Hall; 1993Google Scholar
  36. [Ketabchi87]
    M. Ketabchi, V. Berzins; Modeling and Managing CAD Databases; IEEE Computer, Vol. 20, No. 2; Feb. 1987Google Scholar
  37. [Kim89]
    W. Kim, E. Bertino, J.F. Garza; Composite Objects Revisited; Proc. of the ACM SIGMOD Conf.; 1989Google Scholar
  38. [Kim90]
    W. Kim, N. Ballou, H. Chou, J. Garza, D. Woelk; Architecture of the ORION Next-Generation Database System; IEEE Transactions on Knowledge and Data Engineering; Vol. 2, No. 1; Mar. 1990Google Scholar
  39. [Lamb91]
    C. Lamb, G. Landis, J. Orenstein, D. Weinreb; The Object-Store Database System; Communications of the ACM; Vol. 34, No. 1; Oct. 1991Google Scholar
  40. [Lohman91]
    G. Lohman et al; Extension to Starburst: Objects, Types, Functions and Rules; Communications of the ACM, Vol. 34, No. 10; Oct. 1991Google Scholar
  41. [Melton93]
    J. Melton, A.R. Simon; Understanding the new SQL, Morgan Kaufmann; 1993Google Scholar
  42. [Nguyen89]
    G. Nguyen, D. Rieu; Schema evolution in object-oriented database systems; Data & Knowledge Engineering, Vol. 4, No. 1; Jul. 1989Google Scholar
  43. [Objectivity91]
    Objectivity, Inc.; Objectivity/DB System Overview; Version 1.2; Jan. 1991Google Scholar
  44. [Ovum91]
    J. Jeffcoate, C. Guilfoyle; Databases for Objects: The Market Opportunity; Ovum Ltd.; 1991Google Scholar
  45. [Öszu91]
    T. Özsu, P. Valduriez; Principles of Distributed Database Systems; Prentice-Hall International, Inc.; 1991Google Scholar
  46. [Rao91]
    M. Rao, J. Luxhoj; Integration framework for intelligent manufacturing processes; Journal of Intelligent Manufacturing; No. 3; 1991Google Scholar
  47. [Rumbaugh91]
    J. Rumbaugh, M. Blaha, W. Premerlani, F. Eddy, W. Lorensen; Object-Oriented Modelling and Design; Prentice-Hall; 1991Google Scholar
  48. [Scheer90]
    A. Scheer; Wirtschaftsinformatik; Springer Verlag; 1990Google Scholar
  49. [Scheer92]
    A. Scheer, A. Hars, Extending Data Modeling to Cover the Whole Enterprise; Communications of the ACM, Vol. 35, No. 9; 1992Google Scholar
  50. [Schenk90]
    D. Schenk: EXPRESS Language Reference Manual, ISO TC184/SC4/WG1 N466; 1990Google Scholar
  51. [Shasha92]
    D. Shasha; Database Tuning, A principled approach; Prentice-Hall; 1992Google Scholar
  52. [Sheth90]
    A. Sheth, J. Larson; Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases; ACM Computing Surveys; Vol. 22, No. 3; Sept. 1990Google Scholar
  53. [Sheth92]
    A. Sheth, H. Marcus; Schema Analysis and Integration: Methodology, Techniques, and Prototype Toolkit; Technical Memorandum TM-STS-019981/1, Bellcore; Mar. 1992Google Scholar
  54. [Skarra90]
    A. Skarra, S. Zdonik; Type Evolution in an Object-Oriented Database; in: A. Cardenas, D. McLeod (eds.); Research Foundations in object-oriented and semantic database systems; Data and Knowledge Base Systems, Prentice Hall; 1990Google Scholar
  55. [Soloviev92]
    V. Soloview; An Overview of Three Commercial Object-Oriented Database Management Systems: ONTOS, ObjectStore, and O2 SIGMOD Record, Vol. 21, No. 1; March 1992Google Scholar
  56. [Stankovic88]
    J. Stankovic; Real-Time Computing Systems: The Next Generation; in: J. Stankovic, K. Ramamritham (eds.); Hard Real-Time Systems; IEEE Computer Society Press; 1988Google Scholar
  57. [Stonebraker91]
    M. Stonebraker, G. Kemnitz; The Postgres Next-Generation Database Management System; Communications of the ACM, Vol. 34, No. 10; Oct. 1991Google Scholar
  58. [Tanenbaum89]
    A. Tanenbaum; Computer Networks; 2nd edition; Prentice-Hall; 1989Google Scholar
  59. [Thomas90]
    G. Thomas, G. Thompson, C. Chung, F. Carter, M. Templeton, S. Fox, B. Hartman; Heterogeneous Distributed Database Systems for Production Use; ACM Computing Surveys, Vol. 22, No. 3; Sept. 1990Google Scholar
  60. [Traiger82]
    T. Traiger, J. Gray, C. Galtieri, B. Lindsay; Transactions and Consistency in Distributed Database Systems; ACM Transactions on Database Systems (TODS), Vol. 7, No. 3; Sept. 1982Google Scholar
  61. [Trapp93]
    G. Trapp; The emerging STEP standard for production-model data exchange; IEEE Computer; Vol. 26, No. 2; Feb. 1993Google Scholar
  62. [Tsichritzis78]
    D. Tsichritzis, A. Klug; The ANSI/X3/SPARC DBMS Framework Report of the Study Group on Database Management Systems; Information Systems, Vol. 1; 1978Google Scholar
  63. [Ullman88]
    J. Ullman; Principles of Database and Knowledge-Base Systems; Vol. I; Computer Society Press, Inc.; 1988Google Scholar
  64. [Versant92]
    Versant Object Technology; System Reference Manual; Versant Version 1.7.3; Jan. 1992Google Scholar
  65. [Winslett92]
    M. Winslett, I. Chu; Database Management Systems for ECAD Applications: Architecture and Performance; NSF Design and Manufacturing Conf., Atlanta; 1992Google Scholar
  66. [Zicari91]
    R. Zicari; A Framework for Schema Updates in An Object-Oriented Database System; Proc. of the IEEE Data Engineering Conf.; 1991Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1995

Authors and Affiliations

  • G. Kappel
    • 2
  • S. Vieweg
    • 1
  1. 1.Institute of Applied Computer Science and Information Systems. Department of Information EngineeringUniversity of ViennaAustria
  2. 2.Institute of Computer Science. Department of Information SystemsUniversity of LinzAustria

Personalised recommendations