Integration of database technology and multibody system analysis

University dissertation from Stockholm : Maskinkonstruktion

Abstract: The design process includes many different activities inwhich various computational mechanics tools are used forbehaviour modelling of mechanical systems and their buildingblocks, e.g. machine elements. These tools usually supportlarge and complex models and they produce large quantities ofdata with a high degree of complexity. In these situations,efficient data management and the ability to search and sharedata are important issues to achieve an efficient designprocess. Today, this ability is usually not supported by theindividual applications even though this probably would improveand facilitate the ability to search for data on a higher levelin the engineering information system.This work investigates the ability of searching andcomparing analysis data within behaviour models of technicalsystems as well as over the analysis results. This is done byinvestigating the potential benefits of integrating moderndatabase technology with a multibody system (MBS) analysissoftware in the same manner that has been successfully done forbusiness and administrative applications. This has resulted inan implemented pilot system, named MECHAMOS, that integratesthe main-memory resident object-relational database managementsystem (DBMS) AMOSwith the symbolic multibody system (MBS)software SOPHIA operating in MapleV. This provides MECHAMOSwith both symbolic and numeric mathematical capabilities forMBS analysis and data management capabilities to search andcompare engineering data in the database.The approach, making data managing tools available in acomputer aided engineering software, considerably improves theanalysis of technical systems. The analysis is brought to ahigher level through the available query language and thedesired data is specified, fairly intuitively, in a query. Whenthe query is processed, the DBMS knows how to retrieve andautomatically derive the required data. As shown in someexamples, the ability to search over stored and derived data inthe database is not restricted to a single MBS-model inMECHAMOS. Because of the implemented materialisation handling,it is also possible to search, combine, and compare data fromseveral simulation results which are based on several differentmodels in the database. This extends the ability to performoptimisation from a traditional parameter study to thepossibility to analyse and compare different technical conceptsthrough the query language and hereby retrieve those conceptsthat fulfil certain requirements. If submodel techniques aresupported, queries over a set of components in the databasewould automatically create, analyse and compare the possibleconcepts. This would assist the designer in choosing the bestcomponents for a design.