A CAD/CAM Database Management System and Its Query Language

  • Y. C. Lee
  • K. S. Fu
Part of the Management and Information Systems book series (MIS)


In general, functions performed during a design/manufacturing cycle include sales and marketing, product design and analysis, production planning and control, manufacturing, quality control, as well as shipping and inventory control.“) These functions apparently have to share a large amount of data that are collected from many different sources. As a consequence, a centralized database is needed in order to prevent data from being repeatedly or inconsistently stored. However, a database composed of nothing but data files with different formats can never be adequate in supporting all these design/manufacturing functions owing to the expensive efforts required by data preparation and the programming of the interfaces between file formats. Therefore, the prevailing database management techniques, which have been successfully used in business, are possibly of essential importance for such a database to be accurate, useful, and convenient.


Generic Scheme Query Language Mechanical Part Database Management System Speed Feed 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    M. P. Groover, Automation, Production Systems, and Computer-Aided Manufacturing, Prentice-Hall, Englewood Cliffs, New Jersey, 1980.Google Scholar
  2. 2.
    J. D. Ullman, Principles of Database Systems, Computer Science Press, Rockville, Maryland, 1980.Google Scholar
  3. 3.
    E. F. Conn, Relational database: A practical foundation for productivity, Commun. ACM 25, (2), 109–117 (1982).CrossRefGoogle Scholar
  4. 4.
    S. A. Borkin, Data Models: A Semantic Approach for Database Systems, Mit Press, Cambridge, Massachusetts, 1982.Google Scholar
  5. 5.
    P. P. Chen, The entity-relationship model-Toward a unified view of data, ACM Trans. Database Syst. 1 (1), 9–36 (1976).CrossRefGoogle Scholar
  6. 6.
    N. RoussorouLos and R. T. Yen, An adaptable methodology for database design, Computer 17 (5), 64–80 (1984).Google Scholar
  7. 7.
    J. M. Smith and D. C. P. Smith, Database abstractions: Aggregation and generalization, ACM Trans. Database Syst. 2 (2) 105–133 (1977).CrossRefGoogle Scholar
  8. 8.
    P. Naur (Ed.), Revised report on the algorithmic language Algol 60, Commun. ACM 6(1), 1–17 (1963).Google Scholar
  9. 9.
    Y. C. Lee and K. S. Fu, A Csg based Dbms for Cad/Cam and its supporting query language, Proc. ACM-Ieee Sigmod 83 (Engineering Databases), San Jose, California, May 23–26, 1983, pp. 123–130.Google Scholar
  10. 10.
    A. A. G. Requicha, Representations for rigid solids: Theory, methods, and systems, Comput. Surv. 12 (4), 437–464 (1980).CrossRefGoogle Scholar
  11. 11.
    M. M. Astrahan et al.System R: Relational approach to database management Acm Trans. Database Syst. 1(6) 93–133 (1976).Google Scholar
  12. D. D. Chamberlin et al.,Sequel 2: A unified approach to data definition, manipulation, and control, IBMJ. Res. Dev.,20(6), 560–575 (1976).Google Scholar
  13. 13.
    D. D. Chamberlin et al.A history and evaluation of system R Commun. Acm 24(10), 632–646 (1981).Google Scholar
  14. 14.
    S. S. Yau and P. C. Grabow, A model for representing programs using hierarchical graphs, IEEE Trans. Software Eng., SE-7(6), 556–574 (1981).Google Scholar
  15. 15.
    A. V. Aho and J. D. Ullman, The Theory of Parsing, Translation, and Compiling, Prentice-Hall, Englewood Cliffs, New Jersey, 1972.Google Scholar
  16. 16.
    W. Beeby, The future of integrated Cad/Cam systems: The Boeing perspective Comput. Graph. Appt. 2(1), 51–56 (1982).Google Scholar
  17. 17.
    M. A. Wesley, Construction and use of geometric models, in Computer Aided Design, Modeling, Systems Engineering, CAD-Systems, J. Encarnacao (Ed.), Springer Verlag, New York, 1980, pp. 79–136.CrossRefGoogle Scholar
  18. 18.
    J. W. Boyse and J. E. Gilchrist, Gmsolid: Interactive modeling for design and analysis of solids Comput. Graph. Appt. 2(2) 27–40 (1982).Google Scholar
  19. 19.
    C. M. Brown, Padl-2: A technical summary Comput. Graph. Appi. 2(2), 69–84 (1982).Google Scholar
  20. 20.
    A. A. G. Requicha and H. B. Voelcker, Solid modeling: A historical summary and contemporary assessment, Comput. Graph. Appi. 2 (2), 9–24 (1982).CrossRefGoogle Scholar
  21. Metcut Research Associates Inc. Machining Data HandbookCincinnati, Ohio, 1966.Google Scholar
  22. 22.
    R. J. Tersine, Principles of Inventory and Materials Management, Second Edition, North-Holland, New York, 1982.Google Scholar
  23. 23.
    S. D. Roth, Ray casting for modeling solids, Comput. Graph. Image Process. 18, 109–144 (1982).CrossRefGoogle Scholar

Copyright information

© Springer Science+Business Media New York 1985

Authors and Affiliations

  • Y. C. Lee
    • 1
    • 2
  • K. S. Fu
    • 1
  1. 1.School of Electrical EngineeringPurdue UniversityWest LafayetteUSA
  2. 2.Department of Electrical Engineering and Computer ScienceUniversity of MichiganAnn ArborUSA

Personalised recommendations