Database and graphical objects in engineering design

• Autorzy: Sokas A.

Warianty tytułu

PL

Baza danych i obiekty graficzne w projektowaniu inżynierskim

• Języki publikacji: EN

Abstrakty

EN

This paper introduces graphics programming in the Computer Aided Design environment. Using Visual Basic for Applications programming language methods, algorithm sand procedures the following design problems can be solved: attaching information from data base to a graphical object being drawn, reading information from certain graphical objects of a drawing and collecting, storing, presenting this information in database formats, carrying mathematical operations with read information. The algorithm has been formed to attach database record information to graphical object which gives the procedures how to : select one graphical object record in the database, create extended data of new graphical object, draw programming graphical object depending on extended data and scale in the drawing. The algorithm has been created to read the information from graphical objects and to collect extended data in the database records: select graphical objects in the drawing, take the first object, verify whether an object has extended data and collect extended data in the database record. The following phenomena are presented: procedure fragments and results dependent on selected record in the database of graphical object parameters; creation of extended data for new graphical object ;and information transfer to another database. The following questions have been answered how the prepared procedures work to collect drawing information in the data base with different number of graphical objects and with and without sorting procedure. The example of a facade drawing and database with doors information with program written in Visual Basic for Applications language has been given. The general purpose of this paper is to contribute to a debate about the possibility of Visual Basic for Applications graphics programming.

PL

Praca dotyczy oprogramowania grafiki inżynierskiej w środowisku CAD. Używając języka Visual Basic for Applications (VBA) opracowano metody, algorytmy i procedury do rozwiązywania następujących problemów: przywiązanie informacji z bazy danych do narysowanego obiektu graficznego; odczytanie informacji z obiektów graficznych narysowanych, zachowanych w bibliotece; prezentacja tych informacji w różnych formatach danych; wykonanie operacji matematycznych na odczytanych danych. W pracy zamieszczono fragmenty procedur realizujących powyższe procesy oraz przykład rysowania fasady budynku z wykorzystaniem języka VBA.

Słowa kluczowe

EN

extended data; graphics programming; Visual Basic for Applications

PL

dane rozszerzające; programowanie graficzne; Visual Basic for Applications

• Wydawca: Polskie Towarzystwo Geometrii i Grafiki Inżynierskiej
• Czasopismo: Journal Biuletyn of Polish Society for Geometry and Engineering Graphics
• Rocznik: 2005
• Tom: Vol. 15
• Strony: 67--74
• Opis fizyczny: Bibliogr. 23 poz.

Twórcy

autor

Sokas A.

• Vilnius Gediminas Technical University, Sauletekioal. 11, LT10223 Vilnius, Lithuania

Bibliografia

• [1] Kunigahalli R., Russell J. S.: Framework for development of CAD / CAC systems. Automation in Construction, Vol. 3, No 3, 1995, p. 327-340.
• [2] Kim I., Liebich T., Maver T.: Managing design data in a integrated CAAD environment: a pro-duct model approach. Automation in Construction, Vol. 7, No 1, 1997, p.35-53.
• [3] Khemlani L., Timerman A., Benne B., Kalay Y. E.: Intelligent representation for computer-aided building design. Automation in Construction, Vol. 8, No 1, 1998, p. 49-71.
• [4] Karpova T.: Database: models, designs, realization. Sankt-Peterburg "Piter" 2002, 304 p. (in Russian).
• [5] Anumba C. J.: Data structures and DBMS for computer-aided design systems. Advances in Engineering Software, No 25, 1996, p. 123-129.
• [6] Codd E. F.: A relational model of data for large shared data banks. Communications of the ACM (CACM), No 13(6), 1970, p. 377-387.
• [7] Sampaio A. Z.: Geometric modelling of box girder desk for integrated bridge graphical system. Automation in Construction, Vol. 12, No 1, 2003, p. 55-66.
• [8] Miles J. C., Gray W. A., Carnduff T.W., Santoyridis I., Faulconbridge A.: Versioning and configuration management in design using CAD and complex wrapped objects. Artificial Intelligence in Engineering, Vol. 14, No 3, 2000, p. 249-260.
• [9] Čiupaila L.: Applied graphics in building engineering. Vilnius "Technika" 2002, 312 p.(in Lithuanian).
• [10] Cottingham M.: Mastering AutoCAD VBA. "SYBEX" 2001, 656 p.
• [11] Sokas A.: Engineering graphics and Visual Basic. Engineering graphics BALTGRAF-6.Proceedings of the Sixth International Conference, Riga RTU 2002, p. 82-87.
• [12] Sokas A.: Graphical objects and information in engineering design. Biuletyn Polskiego Towarzystwa Geometrii i Grafiki Inžynierskiej, Zeszyt 13, 2003, str. 54-56. [13] Sokas A.: Automatized formation of specifications in engineering drawings. The Journal of Polish Society for Geometry and Engineering graphics, Vol. 14, 2004, p. 58-63.
• [14] Sokas A., VilkevičV.: Drawing and data exchange technology in engineering design. Engineering Graphics BALTGRAF-7. Proceedings of the Seventh International Conference, Vilnius "Technika", 2004, p. 104-110
• [15] Reed P.: Using ODBC to Access Nontabular Data. DBMSand Internet Systems, Vol. 9, No 4, 1996 (http://www.dbmsmag.com/9604d54.html).
• [16] Hadikusumo B. H. W., Rowlinson S.: Integration of virtually real construction model and design-for-safety-process database. Automation in Construction, Vol. 11, No 5, 2002, p. 501-509.
• [17] North K.: Programming with OLE and ActiveX. DBMSand Internet Systems. Vol. 9, No 12, 1996 (http://www.dbmsmag.com/9611d14.html).
• [18] Dawood N., Sriprasert E., Mallasi Z., Hobbs B.: Development of an integrated information resource base for 4D/VR construction processes simulation. Automation in Construction, Vol. 12, No 1, 2002, p. 123-131.
• [19] Mazurin A., Mazurina C.: ActiveX for AutoCAD R14: a practical guide. Objects CAD and graphics, No 5, 1998, p. 92-96 (in Russian).
• [20] Lalani S., Chandak R.: ActiveX programmer's library. Minsk "Popuri" 2000, 624 p.(in Russian).
• [21] Gunderloy M.: Visual Basic. Developer's Guide to ADO. San Francisco "SYBEX" 2000, 336 p.
• [22] Chau K. W., Cao Y., Anson M., Zhang J.: Application of data warehouse and Decision Support System in construction management. Automation in Construction, Vol. 12, No 2, 2002, p. 213-224.
• [23] Park J. H., Storch R. L.: Pipe-routing algorithm development: case study of a ship engine room design. Expert Systems with Applications, Vol. 23, No 3, 2002, p. 299-309.