PSI - Issue 75

Sébastien Boudevin et al. / Procedia Structural Integrity 75 (2025) 72–84 Author name / Structural Integrity Procedia (2025)

79

8

Nowadays, context can be added for ground vehicles with CAN data, which describes all vehicle activity. Various database types exist to store such data and context. On one hand, SQL relational databases store data in structured tables with predefined schemas. They are known for their strong maturity, consistency, security and support for complex queries. On the other hand, NoSQL databases are designed to handle unstructured or semi-structured data. They are favoured for their high performance, horizontal scalability and ability to handle diverse data types, making them suitable for handling large volumes of data and high user loads. Aqira - the test data management software edited by HBK - uses both these database types to leverage the benefits of each technology. Aqira is a web based system that enables remote work by creating, sharing, and running engineering apps on indexed measurement test data. Once indexed, raw data is processed and normalized, cleaned and processed signals are indexed as well. This enables the user to make queries, choosing his or her data basket through interactive filters and slidebars like any consumer website, and to query on simulation scenarios, including or excluding certain conditions defined by tags (temperature, references, test conditions, etc.). The nCode Aqira infrastructure for big data testing features a web server, installed on the user's intranet, which links all the different aspects of processing, using engineering applications to automate and streamline the process: ✓ Data cleaning and merging, signal processing for useful metrics and statistics (nCode GlyphWorks) ✓ Index data on PostGreSQL database (Aqira) ✓ Request data (Aqira) ✓ Post-process and dashboard creation

5. Two use case application examples 5.1. Validation Profiles for an heat pump

This application case involves a heat pump located on top of a thermodynamic water heater. Components of the device must withstand vibrations and mechanical shocks throughout their lifetime. These dynamic stresses occur in the production plant during logistical phases, such as transportation and h andling, as well as at customer's home during compressor operating phases. Over time, vibration fatigue can lead to failure at critical points in the fluid circuit, potentially causing R290 hydrocarbon leaks with a risk of blast and fire (see Fig.3).

Fig. 3. Heat Pump 3D CAD view with vibration damage field on piping under APSD random fatigue calculation