SpringerLink
Log in

Integrity constraints of manufacturing data bases

  • Published:
Engineering with Computers Aims and scope Submit manuscript

Abstract

Today's manufacturing cost reduction and competitiveness largely depends on the application of automated manufacturing. Automated manufacturing could be even more efficient if computerizations of the process is taken one step further—to the integration of the design and manufacturing processes by means of or through a well-structured data base. This paper refers to several important issues related to integrity constraints in relational data bases. The literature review provides a summary of what has been done in this area by other researchers. In addition, some of the concepts proposed, developed, and even implemented before are introduced. A brief look at the classification of integrity constraints is performed by examining the real world and engineering and manufacturing worlds. This classification is supported by various manufacturing examples for each type of integrity constraints. Further, we discuss the issues of how to express and manage integrity constraints in relational data bases with particular emphasis on manufacturing applications.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Subscribe and save

Springer+ Basic
EUR 32.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or Ebook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Price includes VAT (Germany)

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  1. Famili, A.; Vernadat, F.B. (1985) Integrity Constraints of Manufacturing Databases and Their Processing. NRCC Report ERB-988, National Research Council of Canada, Ottawa, Ontario

    Google Scholar 

  2. Lafue, G.M.E. (1982) Semantic integrity dependencies and delayed integrity checking. In: Proceedings of the 8th International Conference on Very Large Databases, pp. 292–299, Mexico City, Mexico

  3. Lafue, G.M.E. (1979) An approach to automatic maintenance of semantic integrity in large design databases. In: Proceedings of the National Computer Conference, pp. 713–716, New York

  4. Cholvy, L., et al. (1983) ROSALIE: A CAD object-oriented and rule-based system. In Information Processing (Ed. R.E.A. Mason) Amsterdam: North-Holland, pp. 501–505

    Google Scholar 

  5. Eastman, C.M.; Kutay, A.R. (1982) Transactions and Concurrency in Engineering Databases. Technical Report, Design Research Center, Carnegie-Mellon University, Pittsburgh, PA

    Google Scholar 

  6. Eastman, C.M.; Preiss, K. (1980) A review of solid shape modeling based on integrity verifications. Comput.-Aided Des. 16(2), 66–80

    Google Scholar 

  7. Parkash, N. et al. (1984) Specifying integrity constraints in a network DBMS. Comput. J. 27(3), 209–217

    Google Scholar 

  8. Bertino, E.; Apuzzo, D. (1984) Integrity aspects in database management systems. In IEEE Proceedings Trends and Applications, pp. 43–52, Gaithersburg, MD

  9. Fenves, S.J.; Rasdorf, W.J. (1982) Role of Database Management Systems in Structural Engineering. Technical Report DRC-12-13-82, Design Research Center, Carnegie-Mellon University, Pittsburgh, PA

    Google Scholar 

  10. Fenves, S.J.: Rasdorf, W.J. (1985) Treatment of engineering design constraints in a relational data base. Eng. Comput. 1(2), 27–37

    Google Scholar 

  11. Fenves, S.J. (1985) Representation and processing of engineering design constraints in a relational database. In: IEEE COMPINT 1985 Proceedings, pp. 343–347, Montreal, Canada

  12. Date, C.J. (1984) An Introduction to Database Systems, Vol. II. Reading, MA: Addison-Wesley

    Google Scholar 

  13. Date, C.J. (1982) An Introduction to Database Systems, 3rd ed, Reading, MA: Addison-Wesley

    Google Scholar 

  14. Badal, D.Z. (1984) Semantic integrity enforcement in centralized DBMS and distributed DBMS based on slow and fast networks. Info. Sys. 9(2), 121–138

    Google Scholar 

  15. Bernstein, P.A. et al. (1980) Fast maintenance of semantic integrity assertions using redundant aggregate data. In: Proceedings of the 6th International Conference on Very Large Data Bases, pp. 126–136, Montreal, Canada

  16. Cremers, A.B. et al. (1983) AIM, An integrity monitor for the database system ingres. In: Proceedings of the 9th International Conference on Very Large Databases, pp. 167–170, Florence, Italy

  17. Eastman, C.M.; Lafue, G.M.E. (1981) Semantic Integrity Transactions in Design Databases. File Structures and Data Bases of CAD. Amsterdam: North-Holland, pp. 45–57

    Google Scholar 

  18. Frost, R.A. et al. (1983) A step towards the automatic maintenance of semantic integrity of databases. Comput. J. 26(2), 124–133

    Google Scholar 

  19. Lilian, L.; Bahargava, B. (1984) A scheme for batch verification of integrity assertions in a database system. IEEE Trans. Softw. Eng. SE-10(6), 664–680

    Google Scholar 

  20. Ling, T.W. et al. (1984) A method to eliminate avoidable checking of integrity constraints. In: IEEE Proceedings Trends and Applications, pp. 60–68, Gaithersburg, MD

  21. Mylopoulos, J. et al. (1980) A language facility for designing database-intensive applications. ACM Trans. Database Syst. 5(2), 287–296

    Google Scholar 

  22. Neumann, T.; Hornung, C. (1982) Consistency and transactions in CAD databases. In Proceedings of the 8th International Conference on Very Large Data Bases, pp. 181–188, Mexico City, Mexico

  23. Stonebraker, M. (1975) Implementation of integrity constraints and views by query modification. ACM SIGMOD, pp. 65–78, San Jose, CA

  24. Weber, W. et al. (1983) Integrity checking in database systems. Inf. System. 8(2), 125–136

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Laboratory for Intelligent Systems, National Research Council, K1A 0R8, Ottawa, Ontario

    A. Familli & F. B. Vernadat

Authors
  1. A. Familli
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. F. B. Vernadat
    View author publications

    You can also search for this author in PubMed Google Scholar

Rights and permissions

Reprints and permissions

About this article

Cite this article

Familli, A., Vernadat, F.B. Integrity constraints of manufacturing data bases. Engineering with Computers 2, 41–52 (1987). https://doi.org/10.1007/BF01200176

Download citation

  • Issue Date:

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

Keywords

Search

Navigation