<abstract xmlns="http://www.w3.org/1999/xhtml">

<p>As the simulation data of the Simufact Additive software was inconvenient to process, QT and structured query language (MySQL) database were used to develop the database to solve the processing of the simulation data. The GUI interface that has the functions of processing and saving the simulation data was designed. The interface developed by QT was used to start the Simufact Additive software, connect to the MySQL database and save the simulation data. The results showed that using MySQL as the management of simulation data has achieved better results in the post-processing of simulation data.</p>
</abstract>

As the simulation data of the Simufact Additive software was inconvenient to process, QT and structured query language (MySQL) database were used to develop the database to solve the processing of the simulation data. The GUI interface that has the functions of processing and saving the simulation data was designed. The interface developed by QT was used to start the Simufact Additive software, connect to the MySQL database and save the simulation data. The results showed that using MySQL as the management of simulation data has achieved better results in the post-processing of simulation data.


<div xmlns="http://www.w3.org/1999/xhtml">
<sec id="j_amns.2021.2.00042_s_001"><label>1</label><div>Introduction</div>
<p>Simufact Additive software is developed by MSC software company for additive manufacturing simulation, and its software interface is shown in <a ref-type="fig" href="#j_amns.2021.2.00042_fig_001">Figure 1</a>. The software provides a simple user interface that can help users to quickly establish the parts model of additive manufacturing and also support the simulation of the post-treatment process of additive manufacturing (such as heat treatment or hot isostatic pressing). The software can be used for numerical calculation of additive manufacturing process of wire or powder materials under laser, arc or electron beam heat source. Good results can also be obtained for SLM, direct metal sintering (DMLS), electron beam melting (EBM) or laser casting [<a ref-type="bibr" href="#j_amns.2021.2.00042_ref_001">1</a>].</p>
<figure id="j_amns.2021.2.00042_fig_001" position="float" fig-type="figure"><h2>Fig. 1</h2>
<figCaption><p>Interface of Simufact software.</p></figCaption>
<img xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="graphic/j_amns.2021.2.00042_fig_001.jpg" src="https://sciendo-parsed.s3.eu-central-1.amazonaws.com/6470a09471e4585e08aa1a55/j_amns.2021.2.00042_fig_001.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Date=20240728T040337Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=18000&amp;X-Amz-Credential=AKIA6AP2G7AKP25APDM2%2F20240728%2Feu-central-1%2Fs3%2Faws4_request&amp;X-Amz-Signature=93fd1b79ce350483daed2ee3c76b8ead249c76610aa824d65984eb2350205657" class="mw-100"/>
</figure>
<p>Simufact Additive software is a simulation software specially developed for the metal additive manufacturing process. It can evaluate the structure design, material selection, manufacturing parameters, stacking forming direction and support structure of the additive manufacturing parts, and carry out the combination of process parameters and design structure and optimization. When using a 3D printer to make a metal model, the 3D printing process can be simulated through the user interface and the simulation data can be saved in a data file, but it is not convenient to operate when the simulation data is processed in the later stage [<a ref-type="bibr" href="#j_amns.2021.2.00042_ref_002">2</a>]. Therefore, it is necessary to develop a processing system for Simufact Additive simulation data. In this paper, QT and MySQL databases are used to develop Simufact Additive simulation data processing. QT is a cross-platform C++ graphical user interface application-development framework developed by Qt Company in 1991. It can be used to develop GUI programs as well as non-GUI programs. MySQL is a relational database management system. Relational databases store data in different tables, thus increasing the speed of data access and flexibility [<a ref-type="bibr" href="#j_amns.2021.2.00042_ref_003">3</a>,<a ref-type="bibr" href="#j_amns.2021.2.00042_ref_004">4</a>,<a ref-type="bibr" href="#j_amns.2021.2.00042_ref_005">5</a>].</p>
</sec>
<sec id="j_amns.2021.2.00042_s_002"><label>2</label><div>Simufact Additive simulation data</div>
<p>The postprocessing function of Simufact can be displayed in many forms such as text files, pictures, animation, curves, etc. And it can be sliced to display various fields inside the workpiece. It can display material flow lines, variable point queries at any point and tracing of particle flow, and it allows multiple windows to display so that the results can be compared [<a ref-type="bibr" href="#j_amns.2021.2.00042_ref_006">6</a>].</p>
<p>When using Simufact Additive software for simulation, three files will be produced after the simulation is completed, namely Log file, Status file and Output file. The status data during the simulation process is saved in the Status file. This is a notepad file. The status data during the 3D printing simulation process is recorded in detail in the file, but it is not convenient for later data processing.</p>
<figure id="j_amns.2021.2.00042_fig_002" position="float" fig-type="figure"><h2>Fig. 2</h2>
<figCaption><p>Display of Simufact simulation results.</p></figCaption>
<img xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="graphic/j_amns.2021.2.00042_fig_002.jpg" src="https://sciendo-parsed.s3.eu-central-1.amazonaws.com/6470a09471e4585e08aa1a55/j_amns.2021.2.00042_fig_002.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Date=20240728T040337Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=18000&amp;X-Amz-Credential=AKIA6AP2G7AKP25APDM2%2F20240728%2Feu-central-1%2Fs3%2Faws4_request&amp;X-Amz-Signature=aca5433bdf0b81a0706d25fe0d2aeb1e005a428fc9fbc1df39c0f32a7aa61424" class="mw-100"/>
</figure>
<figure id="j_amns.2021.2.00042_fig_003" position="float" fig-type="figure"><h2>Fig. 3</h2>
<figCaption><p>Simulation output of Simufact Additive.</p></figCaption>
<img xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="graphic/j_amns.2021.2.00042_fig_003.jpg" src="https://sciendo-parsed.s3.eu-central-1.amazonaws.com/6470a09471e4585e08aa1a55/j_amns.2021.2.00042_fig_003.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Date=20240728T040337Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=17999&amp;X-Amz-Credential=AKIA6AP2G7AKP25APDM2%2F20240728%2Feu-central-1%2Fs3%2Faws4_request&amp;X-Amz-Signature=9fb6309cd4834dc36dd542c91c3d3d131060f76ccc918ed66e9c10f693d2c5d6" class="mw-100"/>
</figure>
</sec>
<sec id="j_amns.2021.2.00042_s_003"><label>3</label><div>MySQL database</div>
<sec id="j_amns.2021.2.00042_s_003_s_001"><label>3.1</label><div>Introduction to MySQL database</div>
<p>MySQL database is an open source relational database. It usually uses structured query language (SQL) to manage a variety of data or services. It has high performance, small size, portability and ease of use, which can satisfy different enterprises The business data storage requirements of the unit.</p>
<p>Similar to the conventional scripting languages, MySQL also has a set of rules for the use of characters, words and special symbols. MySQL completes the operation of the database by executing SQL scripts. The script consists of one or more MySQL statements (SQL statements + extended statements), and the script file extension is generally .sql when saving. Under the console, the MySQL client can also execute single-sentence statements without saving them as .sql files.</p>
<p>MySQL database has the advantages of rich functions, speed and security. MySQL supports most of the functions that a relational database should have – either directly or indirectly. Moreover, it also supports many security features and some of them are very advanced and built into MySQL. Abandoning certain standards allows MySQL to work very efficiently and simply, and therefore in a faster manner. The most important thing is MySQL can handle large amounts of data and be used on a large scale when needed. That is exactly what we need.</p>
</sec>
<sec id="j_amns.2021.2.00042_s_003_s_002"><label>3.2</label><div>Creating Simufact simulation database</div>
<p>After installing the MySQL database on the computer, create a database of Simufact simulation data and create a table in the Simufact database named “layerstatus (nu,case_name,case_nu,time,cyc,conv_r,conv_d,prg,pst,rst)” and “cuttingstatus (nu,case_name,time,cyc,conv_r,conv_d,prg,pst,rst)”.</p>
<figure id="j_amns.2021.2.00042_fig_004" position="float" fig-type="figure"><h2>Fig. 4</h2>
<figCaption><p>Table layerstatus.</p></figCaption>
<img xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="graphic/j_amns.2021.2.00042_fig_004.jpg" src="https://sciendo-parsed.s3.eu-central-1.amazonaws.com/6470a09471e4585e08aa1a55/j_amns.2021.2.00042_fig_004.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Date=20240728T040337Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=18000&amp;X-Amz-Credential=AKIA6AP2G7AKP25APDM2%2F20240728%2Feu-central-1%2Fs3%2Faws4_request&amp;X-Amz-Signature=565a9c57471accbdaa593cfeaf992e2922e5161f3ad5ea46de7eca4671fb8e3e" class="mw-100"/>
</figure>
<figure id="j_amns.2021.2.00042_fig_005" position="float" fig-type="figure"><h2>Fig. 5</h2>
<figCaption><p>Table cuttingstatus.</p></figCaption>
<img xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="graphic/j_amns.2021.2.00042_fig_005.jpg" src="https://sciendo-parsed.s3.eu-central-1.amazonaws.com/6470a09471e4585e08aa1a55/j_amns.2021.2.00042_fig_005.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Date=20240728T040337Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=18000&amp;X-Amz-Credential=AKIA6AP2G7AKP25APDM2%2F20240728%2Feu-central-1%2Fs3%2Faws4_request&amp;X-Amz-Signature=38d914eacbe3e083b21945716bfb0d709258994cccdda99cc463d82ffc951904" class="mw-100"/>
</figure>
</sec>
</sec>
<sec id="j_amns.2021.2.00042_s_004"><label>4</label><div>Operations on the database in QT</div>
<sec id="j_amns.2021.2.00042_s_004_s_001"><label>4.1</label><div>Introduction to QT</div>
<p>Qt is a cross-platform C++ application framework that supports Windows, Linux, Mac OS X, Android, iOS, Windows Phone, embedded systems, etc. In other words, Qt can support desktop application development, embedded development and mobile development at the same time, covering all existing mainstream platforms. You only need to write the code once and recompile it before publishing it to a different platform [<a ref-type="bibr" href="#j_amns.2021.2.00042_ref_007">7</a>].</p>
<p>Qt is not just a GUI library. In addition to creating beautiful interfaces, it also has many other components. For example, you no longer need to study STL, C++ &lt;string> header files, to find and parse XML, various third-party libraries for connecting to databases and Socket, and Qt have these built-in [<a ref-type="bibr" href="#j_amns.2021.2.00042_ref_008">8</a>].</p>
<p>The interface source code is separated from the user source code. Qt's strategy is to generate a corresponding source code if there is no interface. For example, there is an interface design file xps.ui that will parse the XML and generate a corresponding ui_xps.h file. You do not need this file. Modify, if you want to call the controls in the interface directly through Ui::XPSClass ui; this object definition is also written in ui_xps.h. That is, your business logic is isolated from the creation and setting of interface control objects [<a ref-type="bibr" href="#j_amns.2021.2.00042_ref_009">9</a>].</p>
</sec>
<sec id="j_amns.2021.2.00042_s_004_s_002"><label>4.2</label><div>Connect to MySQL database in QT</div>
<p>We have installed MySQL database outside of QT platform and then created data table structure and added table database through CMD command. This method is intuitive to operate the database table, but it needs to install the program.</p>
<p>SQL statements are supported in QT. There are two ways to create database tables: one is to use MySQL common lineclient to execute SQL statements; the other is to use SQL model class to provide MVC mode with QT, such as qsqlquerymodel and qsqltablemodel class for database operation, and the results can be displayed in the table [<a ref-type="bibr" href="#j_amns.2021.2.00042_ref_010">10</a>,<a ref-type="bibr" href="#j_amns.2021.2.00042_ref_011">11</a>,<a ref-type="bibr" href="#j_amns.2021.2.00042_ref_012">12</a>].</p>
<p>In order to deal with the simulation data of Simufact Additive software conveniently, we need to operate the database in MySQL in QT. We have already installed and configured this database. The next thing we need to do is to connect the database in QT. In order to achieve this goal, we write a program to connect the host, port number and name of the database in QT. Then enter the user name and password of the database to open the database. The process of connecting to the database is shown in <a ref-type="fig" href="#j_amns.2021.2.00042_fig_006">Figure 6</a>.</p>
<figure id="j_amns.2021.2.00042_fig_006" position="float" fig-type="figure"><h2>Fig. 6</h2>
<figCaption><p>QT connection to MySQL database process.</p></figCaption>
<img xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="graphic/j_amns.2021.2.00042_fig_006.jpg" src="https://sciendo-parsed.s3.eu-central-1.amazonaws.com/6470a09471e4585e08aa1a55/j_amns.2021.2.00042_fig_006.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Date=20240728T040337Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=18000&amp;X-Amz-Credential=AKIA6AP2G7AKP25APDM2%2F20240728%2Feu-central-1%2Fs3%2Faws4_request&amp;X-Amz-Signature=501a4a4200186cc696d93734c6c8335e3b7be8d51ecd87e40db07c70bf4e4404" class="mw-100"/>
</figure>
<p>Through the program design, after the connection is successful, a dialogue box for connecting to the database will pop up, as shown in <a ref-type="fig" href="#j_amns.2021.2.00042_fig_007">Figure 7</a>.</p>
<figure id="j_amns.2021.2.00042_fig_007" position="float" fig-type="figure"><h2>Fig. 7</h2>
<figCaption><p>Successful database connection.</p></figCaption>
<img xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="graphic/j_amns.2021.2.00042_fig_007.jpg" src="https://sciendo-parsed.s3.eu-central-1.amazonaws.com/6470a09471e4585e08aa1a55/j_amns.2021.2.00042_fig_007.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Date=20240728T040337Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=18000&amp;X-Amz-Credential=AKIA6AP2G7AKP25APDM2%2F20240728%2Feu-central-1%2Fs3%2Faws4_request&amp;X-Amz-Signature=85a9a0551f666339ce24c4697c91f031f645f5bd5ec8eb3737b76cffea99100e" class="mw-100"/>
</figure>
</sec>
<sec id="j_amns.2021.2.00042_s_004_s_003"><label>4.3</label><div>Processing of simulation data in QT</div>
<p>Before saving the simulation data in the database, the program developed by QT needs to process the data in the data file simulated by the Simufact Additive software, delete irrelevant information in the file, and leave only one space between the data in the notepad file in order to save in the database. The data in the status data file is shown in <a ref-type="fig" href="#j_amns.2021.2.00042_fig_008">Figure 8</a>.</p>
<figure id="j_amns.2021.2.00042_fig_008" position="float" fig-type="figure"><h2>Fig. 8</h2>
<figCaption><p>Raw data in the status file.</p></figCaption>
<img xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="graphic/j_amns.2021.2.00042_fig_008.jpg" src="https://sciendo-parsed.s3.eu-central-1.amazonaws.com/6470a09471e4585e08aa1a55/j_amns.2021.2.00042_fig_008.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Date=20240728T040337Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=18000&amp;X-Amz-Credential=AKIA6AP2G7AKP25APDM2%2F20240728%2Feu-central-1%2Fs3%2Faws4_request&amp;X-Amz-Signature=65e2146c312d1fc85e9f47983c0385f30b2ba61c14e10be88ca99a4dd8bf2091" class="mw-100"/>
</figure>
<p>Use the readLine() statement in QT to read the simulation data in the interface developed by QT. During the reading process, the blanks in the file are processed. The processing statement data=data.append(in.readLine().simplified()).append("\n") displays the read data in the window developed by QT, as shown in <a ref-type="fig" href="#j_amns.2021.2.00042_fig_009">Figure 9</a>, deletes the invalid data in the file in the window interface and saves it in the newly created status data file, as shown in <a ref-type="fig" href="#j_amns.2021.2.00042_fig_010">Figure 10</a>.</p>
<figure id="j_amns.2021.2.00042_fig_009" position="float" fig-type="figure"><h2>Fig. 9</h2>
<figCaption><p>QT reads the middle data of the status file.</p></figCaption>
<img xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="graphic/j_amns.2021.2.00042_fig_009.jpg" src="https://sciendo-parsed.s3.eu-central-1.amazonaws.com/6470a09471e4585e08aa1a55/j_amns.2021.2.00042_fig_009.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Date=20240728T040337Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=18000&amp;X-Amz-Credential=AKIA6AP2G7AKP25APDM2%2F20240728%2Feu-central-1%2Fs3%2Faws4_request&amp;X-Amz-Signature=835190263518e7cc4277fe881aaac66b3f55e5dcca8fc0b6afd726c4f386670d" class="mw-100"/>
</figure>
<figure id="j_amns.2021.2.00042_fig_010" position="float" fig-type="figure"><h2>Fig. 10</h2>
<figCaption><p>Data after QT processing.</p></figCaption>
<img xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="graphic/j_amns.2021.2.00042_fig_010.jpg" src="https://sciendo-parsed.s3.eu-central-1.amazonaws.com/6470a09471e4585e08aa1a55/j_amns.2021.2.00042_fig_010.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Date=20240728T040337Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=18000&amp;X-Amz-Credential=AKIA6AP2G7AKP25APDM2%2F20240728%2Feu-central-1%2Fs3%2Faws4_request&amp;X-Amz-Signature=21d287fc5593690d15c4fe9b7f8923a79815b4a2a82b302c0a9b89c2a62c99cc" class="mw-100"/>
</figure>
<p>Use the QsqlQuery class to provide SQL statement operations and save the newly created status data file in a table created in the MySQL database.</p>
<p>QSqlQuery query;
<list list-type="simple">
<list-item><p>query.exec("load data local infile ‘d:/layerdata.txt’ into table layerstatus’</p></list-item>
<list-item><p>"character set Utf8 fields terminated by ‘”’</p></list-item>
<list-item><p>"(nu,case_name,case_nu,time,cyc,conv_r,conv_d,prg,pst,rst)");</p></list-item></list></p>
<p>Use MySQL commands to display database table data as shown in <a ref-type="fig" href="#j_amns.2021.2.00042_fig_011">Figure 11</a>.</p>
<figure id="j_amns.2021.2.00042_fig_011" position="float" fig-type="figure"><h2>Fig. 11</h2>
<figCaption><p>The database table data.</p></figCaption>
<img xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="graphic/j_amns.2021.2.00042_fig_011.jpg" src="https://sciendo-parsed.s3.eu-central-1.amazonaws.com/6470a09471e4585e08aa1a55/j_amns.2021.2.00042_fig_011.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&amp;X-Amz-Date=20240728T040337Z&amp;X-Amz-SignedHeaders=host&amp;X-Amz-Expires=17999&amp;X-Amz-Credential=AKIA6AP2G7AKP25APDM2%2F20240728%2Feu-central-1%2Fs3%2Faws4_request&amp;X-Amz-Signature=3675401a9bc999040d201b856ec9a816889c8c0d68583dfaad4b176f353f0fe8" class="mw-100"/>
</figure>
</sec>
</sec>
<sec id="j_amns.2021.2.00042_s_005"><label>5</label><div>Conclusions</div>
<p>As the Simufact Additive software simulation data is inconvenient to process, this design uses QT and MySQL to realise the development of the database, which solves the storage function of the simulation data obtained in the Simufact Additive software simulation process in the MySQL database. The connection with the database is realised in QT, the SQL statement is used to create the table, and the SQL statement operation is provided through the QsqlQuery class to save the data in the database, which is convenient for processing the data in the database.</p>
</sec>
</div>

Research on Simufact simulation data processing system based on QT and MySQL

Applied Mathematics and Nonlinear Sciences

This work is licensed under the Creative Commons Attribution 4.0 International License.

{"article-title":"Research on Simufact simulation data processing system based on QT and MySQL"}

As the simulation data of the Simufact Additive software was inconvenient to process, QT and structured query language (MySQL) database were used to develop...

Research on Simufact simulation data processing system based on QT and MySQL

Online veröffentlicht: 10. Nov. 2021

Seitenbereich: 291 - 298

Eingereicht: 25. Feb. 2021

Akzeptiert: 22. Juli 2021

DOI: https://doi.org/10.2478/amns.2021.2.00042

Schlüsselwörter
QT, MySQL, Simufact Additive

© 2021 Liang Zhao et al., published by Sciendo

This work is licensed under the Creative Commons Attribution 4.0 International License.

Research on Simufact simulation data processing system based on QT and MySQL

Online veröffentlicht: 10. Nov. 2021

Seitenbereich: 291 - 298

Eingereicht: 25. Feb. 2021

Akzeptiert: 22. Juli 2021

DOI: https://doi.org/10.2478/amns.2021.2.00042

SchlüsselwörterQT, MySQL, Simufact Additive

© 2021 Liang Zhao et al., published by Sciendo

This work is licensed under the Creative Commons Attribution 4.0 International License.

Schlüsselwörter
QT, MySQL, Simufact Additive