Database- and object-oriented product modeling in computer-aided design processes

• Autorzy: Marowski W.
• Języki publikacji: EN

Abstrakty

EN

Relational database applications are often used as kernels of computer-integrated environments for design processes. Those applications are currently developed in object-oriented programming environments and their codes are written in object programming languages. The digital product definition, created as the final result of a computer-aided design process, must be saved in the relational database and manipulated by the code of its application. Therefore it must be described both in terms of relational and object formalisms. The coupled relational and object models of the product structure, proposed in the paper, can be useful for developing relational database applications, which support the project documentation management in design processes. The logical structure of the relational model is described in terms of entities and relationships. Definitions of essential classes of the object model and their dependence on the database structure are also discussed. The both models have been used in the prototype database application developed in the Microsoft Access environment. Some issues concerning the concept of its user interface are described in the paper. It consists of two group of forms: data-bound and data-unbound ones, which refer to the relational and object model of the product structure, respectively. The use of application forms belonging to each group must comply with some consistency rules of the product definition, described briefly in the final part of the paper.

Słowa kluczowe

EN

relational database; engineer database; computer-aided design

PL

baza danych relacyjna; baza danych inżynierska; wspomaganie komputerowe; projektowanie

• Wydawca: Instytut Pojazdów Politechniki Warszawskiej
• Czasopismo: Zeszyty Naukowe Instytutu Pojazdów / Politechnika Warszawska
• Rocznik: 2010
• Tom: z. 4/80
• Strony: 43--59
• Opis fizyczny: Bibliogr. 12 poz., rys.

Twórcy

autor

Marowski W.

• Warsaw Uniwersity of Technology, Institute of Construction Machinery Engineering

Bibliografia

• [l] Tamine O., Dillmann R.: KaViDo - a web-based system for collaborative research and development processes, Computers in Industry, 2003, 52, pp. 29-45
• [2] Brown D., Leal D., McMahon Ch., Crossland R., Devlukia J.: A Web-enabled virtual repository for supporting distributed automotive component development, Advanced Engineering Informatics, 2004, 18, pp. 173-190
• [3] O'Donnell F. J., MacCallum K. J., Hogg T. D., Yu B.: Product structuring in a small manufacturing enterprise, Computers in Industry, 1996, 31, pp. 281-292
• [4] Zeng Y., Gu P.: A science-based approach to product design theory. Part I: Formulation and formalization of design process, Part II: Formulation of design requirements and products, Robotics and Computer-Integrated Manufacturing, 1999, 15, Issue 4, Part I: pp. 331-339, Part II: pp. 341-352
• [5] Chao P. Y., Chen T. T.: Analysis of assembly through product configuration, Computers in Industry, 2001, 44, pp. 189-203
• [6] Tay F. E. H., Gu J.: Product modeling for conceptual design support, Computers in Industry, 2002, pp. 143-155
• [7] Kasper R., Koch W.: Active product models for mechatronic systems, Proc. of ICED 99, Vol. 2, pp. 847-852, München 1999
• [8] Almefelt, L., Berglund F., Nilsson P., Malmqvist J.: Requirements management in practice: findings from empirical study in the automotive industry, Research in Engineering Design, 2006, 17, pp. 113-134
• [9] Forte S.: Stop Hacking, Start Mapping: Object Relational Mapping 101, www.telerik.com
• [10] Marowski W.: Identyfikacja i aplikacja modeli integracji danych produktu i procesu projektowego w środowisku relacyjnej bazy danych, WNT, Warszawa 2002 (in Polish)
• [11] Linkiewicz G., Marowski W., Pokojski J. [ed.].: Komputerowe wspomaganie projektowania w środowisku rozproszonym, WNT, Warszawa 2007 (in Polish)
• [12] Riordan R. M.: Designing Relational Database Systems, Microsoft Press, Redmond 1999 (Polish edition: Projektowanie systemów relacyjnych baz danych, RM Publishers, Warszawa 2000)